Contents

class PopulateLegacyShipmentState < ActiveRecord::Migration
  def up
    shipments = select_all "SELECT * FROM shipments"
    shipments.each do |shipment|
      if shipment['shipped_at']
        execute "UPDATE shipments SET state = 'shipped'"
      else
        execute "UPDATE shipments SET state = 'pending'"
      end
    end
  end

  def down
  end
end

Version data entries

35 entries across 35 versions & 3 rubygems

Version	Path
spree_core-1.1.0	db/migrate/20091214183826_populate_legacy_shipment_state.rb
spree_core-1.0.4	db/migrate/20091214183826_populate_legacy_shipment_state.rb
spree_core-1.1.0.rc2	db/migrate/20091214183826_populate_legacy_shipment_state.rb
spree_core-1.1.0.rc1	db/migrate/20091214183826_populate_legacy_shipment_state.rb
spree_pag_seguro-1.0.3	spec/dummy/db/migrate/20120301154068_populate_legacy_shipment_state.rb
spree_pag_seguro-1.0.2	spec/dummy/db/migrate/20120301154068_populate_legacy_shipment_state.rb
spree_core-1.0.3	db/migrate/20091214183826_populate_legacy_shipment_state.rb
spree_core-1.0.2	db/migrate/20091214183826_populate_legacy_shipment_state.rb
spree_core-1.0.1	db/migrate/20091214183826_populate_legacy_shipment_state.rb
spree_flat_in_range-0.1.0	spec/dummy/db/migrate/20120218160375_populate_legacy_shipment_state.rb
spree_core-1.0.0	db/migrate/20091214183826_populate_legacy_shipment_state.rb
spree_core-1.0.0.rc4	db/migrate/20091214183826_populate_legacy_shipment_state.rb
spree_core-1.0.0.rc3	db/migrate/20091214183826_populate_legacy_shipment_state.rb
spree_core-1.0.0.rc2	db/migrate/20091214183826_populate_legacy_shipment_state.rb
spree_core-1.0.0.rc1	db/migrate/20091214183826_populate_legacy_shipment_state.rb