Skip to content

Instantly share code, notes, and snippets.

Avatar

Stefan Wrobel swrobel

View GitHub Profile
@swrobel
swrobel / spree2_orders_by_product.sql
Last active Dec 21, 2015
Number of orders by product in Spree 2.0+
View 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
@swrobel
swrobel / _toggle_macbook_wifi_when_ethernet_conected.md
Last active Dec 16, 2015
Toggle airport depending on wired network status. Works on Retina Macbooks using thunderbolt ethernet adapter (en3). Airport should be en0.
View _toggle_macbook_wifi_when_ethernet_conected.md
  1. sudo mv toggleAirport.sh /Library/Scripts/
  2. sudo chmod 755 /Library/Scripts/toggleAirport.sh
  3. sudo mv com.mine.toggleairport.plist /System/Library/LaunchAgents/
  4. sudo chown root:wheel /System/Library/LaunchAgents/com.mine.toggleairport.plist
  5. 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/

View 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;
View Mou Twilight+.txt
editor
foreground: F8F8F8
background: 141414
caret: A7A7A7
editor-selection
background: 33363a
COMMENT
foreground: 5F5A60
@swrobel
swrobel / copy_db.sql
Created Mar 23, 2012
MySQL script to copy from one database to another in pure SQL
View 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
@swrobel
swrobel / gemfile_changelog.rb
Created Mar 23, 2012
Get Changelogs for outdated gems in Gemfile
View 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