Contents

class AddIndexOnPrototypeToSpreeOptionTypePrototype < ActiveRecord::Migration[5.0]
  def change
    duplicates = Spree::OptionTypePrototype.group(:prototype_id, :option_type_id).having('sum(1) > 1').size

    duplicates.each do |f|
      prototype_id, option_type_id = f.first
      count = f.last - 1 # we want to leave one record
      otp = Spree::OptionTypePrototype.where(prototype_id: prototype_id, option_type_id: option_type_id).last(count)
      otp.map(&:destroy)
    end

    if index_exists? :spree_option_type_prototypes, [:prototype_id, :option_type_id]
      remove_index :spree_option_type_prototypes, [:prototype_id, :option_type_id]
      add_index :spree_option_type_prototypes, [:prototype_id, :option_type_id], unique: true, name: 'spree_option_type_prototypes_prototype_id_option_type_id'
    end

    add_index :spree_option_type_prototypes, :prototype_id
  end
end

Version data entries

107 entries across 107 versions & 1 rubygems

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