Sha256: c79f18470fb6397fef7c835a4dfc552edb74af0081df73db8c4bf27d87012a92
Contents?: true
Size: 1 KB
Versions: 21
Compression:
Stored size: 1 KB
Contents
class IncreaseScaleOnPreTaxAmounts < ActiveRecord::Migration[4.2]
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
21 entries across 21 versions & 1 rubygems