Contents

class SetShipmentTotalForUsersUpgrading < ActiveRecord::Migration
  def up
    # NOTE You might not need this at all unless you're upgrading from Spree 2.1.x
    # or below. For those upgrading this should populate the Order#shipment_total
    # for legacy orders
    execute <<-EOS.squish
      UPDATE spree_orders
      SET shipment_total =
        COALESCE(
          (
            SELECT SUM(spree_shipments.cost)
            FROM spree_shipments
            WHERE spree_shipments.order_id = spree_orders.id
          ),
          0
        )
      WHERE
        spree_orders.completed_at IS NOT NULL
        AND spree_orders.shipment_total = 0
    EOS
  end
end

Version data entries

5 entries across 5 versions & 1 rubygems

Version	Path
solidus_core-1.4.2	db/migrate/20140601011216_set_shipment_total_for_users_upgrading.rb
solidus_core-1.4.1	db/migrate/20140601011216_set_shipment_total_for_users_upgrading.rb
solidus_core-1.4.0	db/migrate/20140601011216_set_shipment_total_for_users_upgrading.rb
solidus_core-1.4.0.rc1	db/migrate/20140601011216_set_shipment_total_for_users_upgrading.rb
solidus_core-1.4.0.beta1	db/migrate/20140601011216_set_shipment_total_for_users_upgrading.rb