Contents

class UpdateShipmentStateForCanceledOrders < ActiveRecord::Migration[4.2]
  def up
    shipments = Spree::Shipment.joins(:order).
      where("spree_orders.state = 'canceled'")
    case Spree::Shipment.connection.adapter_name
    when "SQLite3"
      shipments.update_all("state = 'cancelled'")
    when "MySQL" || "PostgreSQL"
      shipments.update_all("spree_shipments.state = 'cancelled'")
    end
  end

  def down
  end
end

Version data entries

141 entries across 141 versions & 2 rubygems

Version	Path
spree_core-4.0.9	db/migrate/20130328130308_update_shipment_state_for_canceled_orders.rb
spree_core-4.1.15	db/migrate/20130328130308_update_shipment_state_for_canceled_orders.rb
spree_core-4.2.7	db/migrate/20130328130308_update_shipment_state_for_canceled_orders.rb
spree_core-4.3.3	db/migrate/20130328130308_update_shipment_state_for_canceled_orders.rb
spree_core-4.2.6	db/migrate/20130328130308_update_shipment_state_for_canceled_orders.rb
spree_core-4.3.2	db/migrate/20130328130308_update_shipment_state_for_canceled_orders.rb
spree_core-4.3.1	db/migrate/20130328130308_update_shipment_state_for_canceled_orders.rb
spree_core-4.3.0	db/migrate/20130328130308_update_shipment_state_for_canceled_orders.rb
spree_core-4.3.0.rc3	db/migrate/20130328130308_update_shipment_state_for_canceled_orders.rb
spree_core-4.3.0.rc2	db/migrate/20130328130308_update_shipment_state_for_canceled_orders.rb
spree_core-4.3.0.rc1	db/migrate/20130328130308_update_shipment_state_for_canceled_orders.rb
spree_core-4.2.5	db/migrate/20130328130308_update_shipment_state_for_canceled_orders.rb
spree_core-4.1.14	db/migrate/20130328130308_update_shipment_state_for_canceled_orders.rb
spree_core-4.0.8	db/migrate/20130328130308_update_shipment_state_for_canceled_orders.rb
spree_core-4.2.4	db/migrate/20130328130308_update_shipment_state_for_canceled_orders.rb
spree_core-3.7.14.1	db/migrate/20130328130308_update_shipment_state_for_canceled_orders.rb
spree_core-4.2.3.1	db/migrate/20130328130308_update_shipment_state_for_canceled_orders.rb
spree_core-4.1.13.1	db/migrate/20130328130308_update_shipment_state_for_canceled_orders.rb
spree_core-4.0.7.1	db/migrate/20130328130308_update_shipment_state_for_canceled_orders.rb
spree_core-4.2.3	db/migrate/20130328130308_update_shipment_state_for_canceled_orders.rb