Contents

class IncreaseScaleOnPreTaxAmounts < ActiveRecord::Migration
  def change
    # set pre_tax_amount on shipments to discounted_amount - included_tax_total
    # so that the null: false option on the shipment pre_tax_amount doesn't generate
    # errors.
    #
    execute(<<-SQL)
      UPDATE spree_shipments
      SET pre_tax_amount = (cost + promo_total) - included_tax_total
      WHERE pre_tax_amount IS NULL;
    SQL

    # set pre_tax_amount on line_items to discounted_amount - included_tax_total
    # so that the null: false option on the line_item pre_tax_amount doesn't generate
    # errors.
    #
    execute(<<-SQL)
      UPDATE spree_line_items
      SET pre_tax_amount = (price * quantity + promo_total) - included_tax_total
      WHERE pre_tax_amount IS NULL;
    SQL

    change_column :spree_line_items, :pre_tax_amount, :decimal, precision: 12, scale: 4, default: 0.0, null: false
    change_column :spree_shipments, :pre_tax_amount, :decimal, precision: 12, scale: 4, default: 0.0, null: false
  end
end

Version data entries

18 entries across 18 versions & 1 rubygems

Version	Path
solidus_core-1.4.2	db/migrate/20150609093816_increase_scale_on_pre_tax_amounts.rb
solidus_core-1.3.2	db/migrate/20150609093816_increase_scale_on_pre_tax_amounts.rb
solidus_core-1.2.3	db/migrate/20150609093816_increase_scale_on_pre_tax_amounts.rb
solidus_core-1.4.1	db/migrate/20150609093816_increase_scale_on_pre_tax_amounts.rb
solidus_core-1.4.0	db/migrate/20150609093816_increase_scale_on_pre_tax_amounts.rb
solidus_core-1.4.0.rc1	db/migrate/20150609093816_increase_scale_on_pre_tax_amounts.rb
solidus_core-1.4.0.beta1	db/migrate/20150609093816_increase_scale_on_pre_tax_amounts.rb
solidus_core-1.3.1	db/migrate/20150609093816_increase_scale_on_pre_tax_amounts.rb
solidus_core-1.3.0	db/migrate/20150609093816_increase_scale_on_pre_tax_amounts.rb
solidus_core-1.3.0.rc2	db/migrate/20150609093816_increase_scale_on_pre_tax_amounts.rb
solidus_core-1.3.0.rc1	db/migrate/20150609093816_increase_scale_on_pre_tax_amounts.rb
solidus_core-1.3.0.beta1	db/migrate/20150609093816_increase_scale_on_pre_tax_amounts.rb
solidus_core-1.2.2	db/migrate/20150609093816_increase_scale_on_pre_tax_amounts.rb
solidus_core-1.2.1	db/migrate/20150609093816_increase_scale_on_pre_tax_amounts.rb
solidus_core-1.2.0	db/migrate/20150609093816_increase_scale_on_pre_tax_amounts.rb
solidus_core-1.2.0.rc2	db/migrate/20150609093816_increase_scale_on_pre_tax_amounts.rb
solidus_core-1.2.0.rc1	db/migrate/20150609093816_increase_scale_on_pre_tax_amounts.rb
solidus_core-1.2.0.beta1	db/migrate/20150609093816_increase_scale_on_pre_tax_amounts.rb