#318 Upgrading to Rails 3.2

source 'http://rubygems.org'

gem 'rails', '3.2.0'

gem 'sqlite3'

# Gems used only for assets and not required
# in production environments by default.
group :assets do
  gem 'sass-rails', "  ~> 3.2.3"
  gem 'coffee-rails', "~> 3.2.1"
  gem 'uglifier', '>=1.0.3'
end

gem 'jquery-rails'

# Raise exception on mass assignment protection for Active Record models
config.active_record.mass_assignment_sanitizer = :strict

# Log the query plan for queries taking more than this (works
# with SQLite, MySQL, and PostgreSQL)
config.active_record.auto_explain_threshold_in_seconds = 0.5

# Allow pass debug_assets=true as a query parameter to load pages with unpackaged assets
config.assets.allow_debugging = true

1.9.2-p290 :001 > Product.order(:name).explain
  Product Load (0.6ms)  SELECT "products".* FROM "products" ORDER BY name
  EXPLAIN (0.1ms)  EXPLAIN QUERY PLAN SELECT "products".* FROM "products" ORDER BY name
 => "EXPLAIN for: SELECT \"products\".* FROM \"products\"  ORDER BY name\n0|0|0|SCAN TABLE products (~1000000 rows)\n0|0|0|USE TEMP B-TREE FOR ORDER BY\n"

1.9.2-p290 :002 > puts _
EXPLAIN for: SELECT "products".* FROM "products"  ORDER BY name
0|0|0|SCAN TABLE products (~1000000 rows)
0|0|0|USE TEMP B-TREE FOR ORDER BY

1.9.2-p290 :003 > ActiveRecord::Base.silence_auto_explain { Product.order(:name) }

1.9.2-p290 :005 > Product.pluck(:name)
   (0.2ms)  SELECT name FROM "products" 
 => ["Settlers of Catan", "Flux Capacitor", "Technodrome", "Agricola", "Millennium Falcon", "Ryan's Cheesecake", "Answer to Everything"]

1.9.2-p290 :007 > Product.pluck(:id)
   (0.2ms)  SELECT id FROM "products" 
 => [1, 2, 3, 4, 5, 6, 7]

1.9.2-p290 :009 > Product.select(:name).uniq
  Product Load (0.3ms)  SELECT DISTINCT name FROM "products" 
 => [#<Product name: "Agricola">, #<Product name: "Answer to Everything">, #<Product name: "Flux Capacitor">, #<Product name: "Millennium Falcon">, #<Product name: "Ryan's Cheesecake">, #<Product name: "Settlers of Catan">, #<Product name: "Technodrome">]

1.9.2-p290 :010 > Product.where(name: "Foo").first_or_create!

1.9.2-p290 :011 > Product.where(name: "Foo").first_or_create!(price: 5)

1.9.2-p290 :007 > "Product".safe_constantize
 => Product(id: integer, name: string, price: decimal, description: text, discontinued: boolean, created_at: datetime, updated_at: datetime)

$ rails g model product_variation product_id:integer:index name 'price:decimal{7,2}'

class CreateProductVariations < ActiveRecord::Migration
  def change
    create_table :product_variations do |t|
      t.integer :product_id
      t.string :name
          t.decimal :price, :precision => 7, :scale => 2

      t.timestamps
    end
    add_index :product_variations, :product_id
  end
end

$ echo -d postgresql -T > ~/.railsrc

$ rails new blog
Using -d postgresql -T from /Users/eifion/.railsrc 

class ProductVariation < ActiveRecord::Base
  store :properties, accessors: [:colour, :size]
end

$ rails g migration add_properties_to_product_variations properties:text

Loading development environment (Rails 3.2.0)
1.9.2-p290 :001 > p = ProductVariation.new(colour: 'blue', size: 3)
 => #<ProductVariation id: nil, product_id: nil, name: nil, price: nil, created_at: nil, updated_at: nil, properties: {:colour=>"blue", :size=>3}>

1.9.2-p290 :003 > p.colour
 => "blue"

1.9.2-p290 :004 > p.properties[:colour]
 => "blue" 

config.log_tags = [:uuid, :remote_ip]

[ab939dfca5d57843ea4c695cab6f721d] [127.0.0.1] 

Started GET "/" for 127.0.0.1 at 2012-01-27 21:52:58 +0000
[ab939dfca5d57843ea4c695cab6f721d] [127.0.0.1] Processing by ProductsController#index as HTML
[ab939dfca5d57843ea4c695cab6f721d] [127.0.0.1]   Product Load (0.3ms)  SELECT "products".* FROM "products" 
[ab939dfca5d57843ea4c695cab6f721d] [127.0.0.1]   Rendered products/index.html.erb within layouts/application (22.0ms)
[ab939dfca5d57843ea4c695cab6f721d] [127.0.0.1] Completed 200 OK in 81ms (Views: 73.1ms | ActiveRecord: 0.3ms)
[98eec5f8976586c1165b981797086b6a] [127.0.0.1]