Contents

class SplitPricesFromVariants < ActiveRecord::Migration
  def up
    create_table :spree_prices do |t|
      t.integer :variant_id, :null => false
      t.decimal :amount, :precision => 8, :scale => 2, :null => false
      t.string :currency
    end

    Spree::Variant.all.each do |variant|
      Spree::Price.create!(
        :variant_id => variant.id,
        :amount => variant.price,
        :currency => Spree::Config[:currency]
      )
    end

    remove_column :spree_variants, :price
  end

  def down
    add_column :spree_variants, :price, :decimal, :after => :sku, :scale => 8, :precision => 2

    Spree::Variant.all.each do |variant|
      variant.price = variant.default_price.amount
      variant.save!
    end

    drop_table :spree_prices
  end
end

Version data entries

4 entries across 4 versions & 2 rubygems

Version	Path
spree_core-1.3.0	db/migrate/20121031162139_split_prices_from_variants.rb
spree_core-1.3.0.rc2	db/migrate/20121031162139_split_prices_from_variants.rb
dup_spree_core-1.3.0.rc1	db/migrate/20121031162139_split_prices_from_variants.rb
spree_core-1.3.0.rc1	db/migrate/20121031162139_split_prices_from_variants.rb