Contents

class RenameChargesToAdjustments < ActiveRecord::Migration
  def self.up
    rename_table :charges, :adjustments
    add_column   :adjustments, :secondary_type, :string

    execute 'UPDATE adjustments SET secondary_type = type;'
    execute "UPDATE adjustments SET type='Charge' WHERE type LIKE '%Charge';"

    rename_column :orders, :charge_total, :adjustment_total
    rename_column :adjustments, :charge_source_id, :adjustment_base_id
    rename_column :adjustments, :charge_source_type, :adjustment_base_type
  end

  def self.down
    rename_column :adjustments, :adjustment_base_id, :charge_source_id 
    rename_column :adjustments, :adjustment_base_type, :charge_source_type

    rename_column :orders, :adjustment_total, :charge_total
    execute 'UPDATE adjustments SET type = secondary_type;'

    rename_table :adjustments, :charges
    remove_column :adjustments, :secondary_type
  end
end

Version data entries

6 entries across 6 versions & 2 rubygems

Version	Path
spree-enriquez-0.9.4	db/migrate/20090806063212_rename_charges_to_adjustments.rb
spree-0.9.4	db/migrate/20090806063212_rename_charges_to_adjustments.rb
spree-0.9.3	db/migrate/20090806063212_rename_charges_to_adjustments.rb
spree-0.9.2	db/migrate/20090806063212_rename_charges_to_adjustments.rb
spree-0.9.1	db/migrate/20090806063212_rename_charges_to_adjustments.rb
spree-0.9.0	db/migrate/20090806063212_rename_charges_to_adjustments.rb