| CREATE VIEW product_stats AS | |
| SELECT organization_id, | |
| SUM(CASE WHEN status = 'active' THEN 1 END) active_count, | |
| SUM(CASE WHEN status = 'inactive' THEN 1 END) inactive_count | |
| FROM products | |
| GROUP BY organization_id |
| /** | |
| * Multipromise | |
| * | |
| * A jQuery.Deferred() - like promise implementation | |
| * that supports adding multiple child promises to it. | |
| * done / fail callbacks will trigger multiple times as child promises are resolved / rejected | |
| * Useful for streaming promise-based data flows | |
| * | |
| * Example | |
| * |
| <html> | |
| <head> | |
| <title>Mixpanel AMD Example - Sync</title> | |
| <script type="text/javascript" src="http://requirejs.org/docs/release/2.1.8/minified/require.js"></script> | |
| <script type="text/javascript"> | |
| requirejs.config({ | |
| paths : { 'mixpanel': "//cdn.mxpnl.com/libs/mixpanel-2.2.min" }, | |
| shim: { | |
| 'mixpanel': { | |
| deps: ['mixpanel-preinit'], |
We don't want to polute the repository with a .gitignore file... so you must add common OS files to your Global .gitignore. If you don't already have a global .gitignore then follow the instructions below (from: http://help.github.com/ignore-files/) or skip to the next section.
cd ~
touch .gitignore_global
mate .gitignore_global
| #!/bin/bash | |
| # Download all VMWare Fusion machines from Modern.IE Website to test your Website/Web Application in Microsoft Internet Explorer on Mac OSX. All VM's and other VM's for Windows and Linux and other Virtual Manager's such as VirtualBox can be found at http://modern.ie/ | |
| # Don't have cURL or want to learn more, visit http://curl.haxx.se/.. are you really a Developer? First part of that sentence comes from the MS site. | |
| read -p "--> Downloading Internet Explorer 6-10 on Windows XP/7/8 Appliances for VMWare Fusion. Large downloads ahead. (Press Enter to continue)." | |
| echo "--> Download Internet Explorer 6 on Microsoft Windows XP Appliance for VMWare Fusion." | |
| curl --progress-bar -O "http://virtualization.modern.ie/vhd/IEKitV1_Final/VMWare_Fusion/IE6_XP/IE6.XP.For.MacVMware.sfx" | |
| echo "--> Download Internet Explorer 8 on Microsoft Windows XP Appliance for VMWare Fusion." |
| # RSpec 2.0 syntax Cheet Sheet by http://ApproachE.com | |
| # defining spec within a module will automatically pick Player::MovieList as a 'subject' (see below) | |
| module Player | |
| describe MovieList, "with optional description" do | |
| it "is pending example, so that you can write ones quickly" | |
| it "is already working example that we want to suspend from failing temporarily" do | |
| pending("working on another feature that temporarily breaks this one") |
| <IfModule mod_rewrite.c> | |
| RewriteEngine On | |
| RewriteCond %{HTTP_USER_AGENT} !(Chrome\/[0-8]|Android\s[0-3])\. | |
| RewriteCond %{HTTP_USER_AGENT} Chrome [OR] | |
| RewriteCond %{HTTP_ACCEPT} image/webp | |
| RewriteCond %{DOCUMENT_ROOT}/$1.webp -f | |
| RewriteRule (.+)\.(jpe?g|png)$ $1.webp [T=image/webp,E=accept:1] | |
| </IfModule> | |
| <IfModule mod_headers.c> |
| heroku pgbackups:capture | |
| curl -o latest.dump `heroku pgbackups:url` | |
| pg_restore --verbose --clean --no-acl --no-owner -h localhost \ | |
| -U `whoami` -d `ruby -e "require 'yaml' ; File.open( 'config/database.yml' ) { |file| puts YAML::load(file)['development']['database'] }"` latest.dump | |
| rm latest.dump | |
| # Set the number of connections AR pool | |
| # | |
| # place in an initializer such as: config/connection_pool.rb | |
| Rails.application.config.after_initialize do | |
| ActiveRecord::Base.connection_pool.disconnect! | |
| ActiveSupport.on_load(:active_record) do | |
| config = Rails.application.config.database_configuration[Rails.env] | |
| config['pool'] = ENV['DB_POOL'] || 6 |
| require 'thread' | |
| require 'facebook_oauth' | |
| require 'launchy' | |
| require 'sinatra/base' | |
| callback_uri = URI.parse('http://localhost:6789/') | |
| fb_client = FacebookOAuth::Client.new( | |
| :application_id => 'XXXXXXXXXXXX', | |
| :application_secret => 'XXXXXXXXXXXXXXXXXXXXXXXX', |