Sha256: 94ff5d28f8b9404c1a37692817341f8c295fb69a0a8b1d38d03047babf152361

Contents?: true

Size: 771 Bytes

Versions: 8

Compression:

Stored size: 771 Bytes

Contents

# This migration comes from spree (originally 20170320145518)
class AddUniqueIndexOnNumberToSpreeReimbursements < ActiveRecord::Migration[5.0]
  def change
    unless index_exists?(:spree_reimbursements, :number, unique: true)
      numbers = Spree::Reimbursement.group(:number).having('sum(1) > 1').pluck(:number)
      reimbursements = Spree::Reimbursement.where(number: numbers)

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

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

Version data entries

8 entries across 8 versions & 2 rubygems

Version Path
spree_purchase_order-3.7.0 spec/dummy/db/migrate/20191113195948_add_unique_index_on_number_to_spree_reimbursements.spree.rb
spree_billing_sisow-0.9.2 spec/dummy/db/migrate/20190729091889_add_unique_index_on_number_to_spree_reimbursements.spree.rb
spree_billing_sisow-0.9.1 spec/dummy/db/migrate/20190729091889_add_unique_index_on_number_to_spree_reimbursements.spree.rb
spree_purchase_order-3.6.0 spec/dummy/db/migrate/20180516191813_add_unique_index_on_number_to_spree_reimbursements.spree.rb
spree_purchase_order-3.5.0 spec/dummy/db/migrate/20180516191813_add_unique_index_on_number_to_spree_reimbursements.spree.rb
spree_purchase_order-3.5.0.rc1 spec/dummy/db/migrate/20180516191813_add_unique_index_on_number_to_spree_reimbursements.spree.rb
spree_purchase_order-3.4.0 spec/dummy/db/migrate/20180516191813_add_unique_index_on_number_to_spree_reimbursements.spree.rb
spree_purchase_order-3.3.0 spec/dummy/db/migrate/20180516191813_add_unique_index_on_number_to_spree_reimbursements.spree.rb