Sha256: bb8094466a628f82ddff8a40f9610046d7c85b62fa5e61f48fca5b6d9bd15ff4

Contents?: true

Size: 1012 Bytes

Versions: 9

Compression:

Stored size: 1012 Bytes

Contents

# This migration comes from spree (originally 20131211192741)
class UniqueShippingMethodCategories < ActiveRecord::Migration[4.2]
  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

9 entries across 9 versions & 2 rubygems

Version Path
spree_purchase_order-3.7.0 spec/dummy/db/migrate/20191113195821_unique_shipping_method_categories.spree.rb
spree_billing_sisow-0.9.2 spec/dummy/db/migrate/20190729091762_unique_shipping_method_categories.spree.rb
spree_billing_sisow-0.9.1 spec/dummy/db/migrate/20190729091762_unique_shipping_method_categories.spree.rb
spree_purchase_order-3.6.0 spec/dummy/db/migrate/20180516181950_unique_shipping_method_categories.spree.rb
spree_purchase_order-3.5.0 spec/dummy/db/migrate/20180516181950_unique_shipping_method_categories.spree.rb
spree_purchase_order-3.5.0.rc1 spec/dummy/db/migrate/20180516181950_unique_shipping_method_categories.spree.rb
spree_purchase_order-3.4.0 spec/dummy/db/migrate/20180516181950_unique_shipping_method_categories.spree.rb
spree_purchase_order-3.3.0 spec/dummy/db/migrate/20180516181950_unique_shipping_method_categories.spree.rb
spree_purchase_order-3.2.0 spec/dummy/db/migrate/20180516181950_unique_shipping_method_categories.spree.rb