Sha256: ac1ed1e7f8f7fb860542ca0e984410ebf3c758b4f6e4acf7fb7f41512a7b1c57

Contents?: true

Size: 677 Bytes

Versions: 107

Compression:

Stored size: 677 Bytes

Contents

class AddUniqueIndexOnNumberToSpreeStockTransfer < ActiveRecord::Migration[5.0]
  def change
    unless index_exists?(:spree_stock_transfers, :number, unique: true)
      numbers = Spree::StockTransfer.group(:number).having('sum(1) > 1').pluck(:number)
      transfers = Spree::StockTransfer.where(number: numbers)

      transfers.find_each do |transfer|
        transfer.number = transfer.class.number_generator.method(:generate_permalink).call(transfer.class)
        transfer.save
      end

      remove_index :spree_stock_transfers, :number if index_exists?(:spree_stock_transfers, :number)
      add_index :spree_stock_transfers, :number, unique: true
    end
  end
end

Version data entries

107 entries across 107 versions & 1 rubygems

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