Contents

class ChargeRefactoring < ActiveRecord::Migration
  
  # Hack to prevent issues with legacy migrations
  class Order < ActiveRecord::Base
    has_one :checkout
  end
  
  def self.up
    add_column :orders, :completed_at, :timestamp
    Order.reset_column_information   
    Order.all.each {|o| o.update_attribute(:completed_at, o.checkout && o.checkout.read_attribute(:completed_at)) }
    remove_column :checkouts, :completed_at
    
    change_column :adjustments, :amount, :decimal, :null => true, :default => nil, :precision => 8, :scale => 2
    Adjustment.update_all "type = secondary_type"
    Adjustment.update_all "type = 'CouponCredit'", "type = 'Credit'"
    remove_column :adjustments, :secondary_type
  end

  def self.down
    add_column :checkouts, :completed_at, :timestamp
    Checkout.reset_column_information
    Checkout.all.each{|c| c.update_attribute(:completed_at, c.order && c.order.completed_at)}
    remove_column :orders, :completed_at

    add_column :adjustments, :secondary_type, :string
    Adjustment.update_all "secondary_type = type"
    Adjustment.update_all "type = 'Charge'", "type like '%Charge'"
    Adjustment.update_all "type = 'Credit'", "type like '%Credit'"
    change_column :adjustments, :amount, :decimal, :null => false, :default => 0, :precision => 8, :scale => 2
  end
end

Version data entries

9 entries across 9 versions & 2 rubygems

Version	Path
spree-0.11.4	db/migrate/20091021133257_charge_refactoring.rb
spree-0.11.3	db/migrate/20091021133257_charge_refactoring.rb
spree-0.11.2	db/migrate/20091021133257_charge_refactoring.rb
spree-0.11.1	db/migrate/20091021133257_charge_refactoring.rb
spree_core-0.30.0.beta1	lib/generators/templates/db/migrate/20091021133257_charge_refactoring.rb
spree-0.11.0	db/migrate/20091021133257_charge_refactoring.rb
spree-0.10.2	db/migrate/20091021133257_charge_refactoring.rb
spree-0.10.1	db/migrate/20091021133257_charge_refactoring.rb
spree-0.10.0	db/migrate/20091021133257_charge_refactoring.rb