Contents

# This migration comes from spree (originally 20170119122701)
class AddOriginalReturnItemIdToSpreeInventoryUnits < ActiveRecord::Migration[5.0]
  def up
    add_reference :spree_inventory_units, :original_return_item, references: :spree_return_items, index: true

    Spree::InventoryUnit.reset_column_information

    Spree::ReturnItem.where.not(exchange_inventory_unit_id: nil).find_each do |return_item|
      if (inventory_unit = Spree::InventoryUnit.find_by(id: return_item.exchange_inventory_unit_id)).present?
        inventory_unit.update_column(:original_return_item_id, return_item.id)
      end
    end

    remove_column :spree_return_items, :exchange_inventory_unit_id
  end

  def down
    add_reference :spree_return_items, :exchange_inventory_unit, references: :spree_inventory_units, index: true

    Spree::InventoryUnit.reset_column_information

    Spree::InventoryUnit.where.not(original_return_item_id: nil).find_each do |inventory_unit|
      if (return_item = Spree::ReturnItem.find_by(id: inventory_unit.original_return_item_id)).present?
        return_item.update_column(:exchange_inventory_unit_id, inventory_unit.id)
      end
    end

    remove_reference :spree_inventory_units, :original_return_item
  end
end

Version data entries

8 entries across 8 versions & 2 rubygems

Version	Path
spree_purchase_order-3.7.0	spec/dummy/db/migrate/20191113195941_add_original_return_item_id_to_spree_inventory_units.spree.rb
spree_billing_sisow-0.9.2	spec/dummy/db/migrate/20190729091882_add_original_return_item_id_to_spree_inventory_units.spree.rb
spree_billing_sisow-0.9.1	spec/dummy/db/migrate/20190729091882_add_original_return_item_id_to_spree_inventory_units.spree.rb
spree_purchase_order-3.6.0	spec/dummy/db/migrate/20180516191806_add_original_return_item_id_to_spree_inventory_units.spree.rb
spree_purchase_order-3.5.0	spec/dummy/db/migrate/20180516191806_add_original_return_item_id_to_spree_inventory_units.spree.rb
spree_purchase_order-3.5.0.rc1	spec/dummy/db/migrate/20180516191806_add_original_return_item_id_to_spree_inventory_units.spree.rb
spree_purchase_order-3.4.0	spec/dummy/db/migrate/20180516191806_add_original_return_item_id_to_spree_inventory_units.spree.rb
spree_purchase_order-3.3.0	spec/dummy/db/migrate/20180516191806_add_original_return_item_id_to_spree_inventory_units.spree.rb