Sha256: c1cefcd4a502ab15206af59307da5fa24e0b7adb57067cc039bc484e14198e88
Contents?: true
Size: 600 Bytes
Versions: 107
Compression:
Stored size: 600 Bytes
Contents
class AddIndexToRoleUsers < ActiveRecord::Migration[5.0]
def change
duplicates = Spree::RoleUser.group(:role_id, :user_id).having('sum(1) > 1').size
duplicates.each do |f|
role_id, user_id = f.first
count = f.last - 1 # we want to leave one record
roles = Spree::RoleUser.where(role_id: role_id, user_id: user_id).last(count)
roles.map(&:destroy)
end
if index_exists? :spree_role_users, [:role_id, :user_id]
remove_index :spree_role_users, [:role_id, :user_id]
add_index :spree_role_users, [:role_id, :user_id], unique: true
end
end
end
Version data entries
107 entries across 107 versions & 1 rubygems