Stefan Wrobel swrobel

## spree_1.3.3_to_2.0.4.md

      
              1 file
            
          
              2 forks
            
          
              11 comments
            
          
              6 stars
            
          
                swrobel
                / spree_1.3.3_to_2.0.4.md
            
            
              Last active
              December 18, 2018 16:48
            
              
                HOWTO: Upgrade Spree 1.3.3 to 2.0.4
              
          
    HOWTO: Upgrade Spree 1.3.3 to 2.0.4

These steps were sufficient to upgrade Cult Cosmetics to Spree 2.0.4 from 1.3.3. Here are some details on our environment.

We only have single-variant products
We are not making use of stock locations (single warehouse)
Frontend entirely overridden w/ custom bootstrap layout
Braintree gateway
Rails 3.2.14
Upgraded from Ruby 1.9.3-p448 to 2.0.0-p247 in the process (no issues)


## spree2_orders_by_product.sql
SELECT p.id,
sum(quantity) AS num_sold
FROM spree_orders o
JOIN spree_line_items li ON o.ID = li.order_id
JOIN spree_variants v ON li.variant_id = v.id
JOIN spree_stock_items i ON v.id = i.variant_id
JOIN spree_products p ON v.product_id = p.id
WHERE o.state = 'complete'
GROUP BY p.id

## _toggle_macbook_wifi_when_ethernet_conected.md

      
              3 files
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                swrobel
                / _toggle_macbook_wifi_when_ethernet_conected.md
            
            
              Last active
              December 16, 2015 22:08
            
              
                Toggle airport depending on wired network status. Works on Retina Macbooks using thunderbolt ethernet adapter (en3). Airport should be en0.
              
          
sudo mv toggleAirport.sh /Library/Scripts/
sudo chmod 755 /Library/Scripts/toggleAirport.sh
sudo mv com.mine.toggleairport.plist /System/Library/LaunchAgents/
sudo chown root:wheel  /System/Library/LaunchAgents/com.mine.toggleairport.plist
sudo launchctl load /System/Library/LaunchAgents/com.mine.toggleairport.plist

The script should run on startup and give you growl notifications when airport status is changed if you have GrowlNotify installed
Credit to www.georges.nu/blog/2011/06/how-to-automatically-turn-off-airport-when-ethernet-is-plugged-in/

  
## responsive-mixin.scss
$phone: '(max-width: 480px)';
$tablet-portrait: '(max-width: 767px)';
$tablet-landscape-desktop: '(min-width: 768px) and (max-width: 979px)';
$large-desktop: '(min-width: 1200px)';
$non-retina: 'screen and (-webkit-max-device-pixel-ratio: 1)';
$retina: 'screen and (-webkit-min-device-pixel-ratio: 2)';

@mixin respond-to($media) {
  @media #{$media} {
    @content;

## Mou Twilight+.txt
editor
foreground: F8F8F8
background: 141414
caret: A7A7A7

editor-selection
background: 33363a

COMMENT
foreground: 5F5A60

## copy_db.sql
DELIMITER $$
DROP PROCEDURE IF EXISTS `CopyDB` $$
CREATE PROCEDURE `CopyDB` (sourceDB VARCHAR(64),targetDB VARCHAR(64))
TheStoredProcedure:BEGIN

    DECLARE found_count,ndx,ndx_last INT;
    DECLARE sqlcmd VARCHAR(1024);

    SELECT COUNT(1) INTO found_count
    FROM information_schema.tables

## gemfile_changelog.rb
#!/usr/bin/env ruby


def changelog_for_gem(gem)
  changelogs = `bundle exec gem contents #{gem}`.lines.grep(/history|changelog|news/i)
  if changelogs.empty?
    puts "No changelog found for gem #{gem}"

    return nil
  end
	SELECT p.id,
	sum(quantity) AS num_sold
	FROM spree_orders o
	JOIN spree_line_items li ON o.ID = li.order_id
	JOIN spree_variants v ON li.variant_id = v.id
	JOIN spree_stock_items i ON v.id = i.variant_id
	JOIN spree_products p ON v.product_id = p.id
	WHERE o.state = 'complete'
	GROUP BY p.id
	$phone: '(max-width: 480px)';
	$tablet-portrait: '(max-width: 767px)';
	$tablet-landscape-desktop: '(min-width: 768px) and (max-width: 979px)';
	$large-desktop: '(min-width: 1200px)';
	$non-retina: 'screen and (-webkit-max-device-pixel-ratio: 1)';
	$retina: 'screen and (-webkit-min-device-pixel-ratio: 2)';

	@mixin respond-to($media) {
	@media #{$media} {
	@content;
	editor
	foreground: F8F8F8
	background: 141414
	caret: A7A7A7

	editor-selection
	background: 33363a

	COMMENT
	foreground: 5F5A60
	DELIMITER $$
	DROP PROCEDURE IF EXISTS `CopyDB` $$
	CREATE PROCEDURE `CopyDB` (sourceDB VARCHAR(64),targetDB VARCHAR(64))
	TheStoredProcedure:BEGIN

	DECLARE found_count,ndx,ndx_last INT;
	DECLARE sqlcmd VARCHAR(1024);

	SELECT COUNT(1) INTO found_count
	FROM information_schema.tables
	#!/usr/bin/env ruby


	def changelog_for_gem(gem)
	changelogs = `bundle exec gem contents #{gem}`.lines.grep(/history\|changelog\|news/i)
	if changelogs.empty?
	puts "No changelog found for gem #{gem}"

	return nil
	end