Sha256: 303906ffb35e86b6baeab73548354e097c46328b42976279f40f518fadd3de97
Contents?: true
Size: 1007 Bytes
Versions: 14
Compression:
Stored size: 1007 Bytes
Contents
# This migration comes from spree (originally 20131211192741)
class UniqueShippingMethodCategories < ActiveRecord::Migration
def change
klass = Spree::ShippingMethodCategory
columns = %w[shipping_category_id shipping_method_id]
say "Find duplicate #{klass} records"
duplicates = klass.
select((columns + %w[COUNT(*)]).join(',')).
group(columns.join(',')).
having('COUNT(*) > 1').
map { |row| row.attributes.slice(*columns) }
say "Delete all but the oldest duplicate #{klass} record"
duplicates.each do |conditions|
klass.where(conditions).order(:created_at).drop(1).each(&:destroy)
end
say "Add unique index to #{klass.table_name} for #{columns.inspect}"
add_index klass.table_name, columns, unique: true, name: 'unique_spree_shipping_method_categories'
say "Remove redundant simple index on #{klass.table_name}"
remove_index klass.table_name, name: 'index_spree_shipping_method_categories_on_shipping_category_id'
end
end
Version data entries
14 entries across 14 versions & 7 rubygems