Sha256: 16cf8d69bd0c76b592bf8aa715892736972dd4d9cba1bd3f3e500246fd6a7b5c
Contents?: true
Size: 842 Bytes
Versions: 21
Compression:
Stored size: 842 Bytes
Contents
class CreateStockItemStockLocationIdVariantIdCoalesceDeletedAtUniqueIndex < ActiveRecord::Migration[5.2]
def change
remove_index :spree_stock_items, name: :stock_item_by_loc_var_id_deleted_at
reversible do |dir|
dir.up do
execute <<-SQL
CREATE UNIQUE INDEX stock_item_by_loc_var_id_deleted_at
ON spree_stock_items(
stock_location_id,
variant_id,
(COALESCE(deleted_at, CAST('1970-01-01' AS #{deleted_at_data_type})))
);
SQL
end
dir.down do
remove_index :spree_stock_items, name: :stock_item_by_loc_var_id_deleted_at
end
end
end
private
def deleted_at_data_type
case ActiveRecord::Base.connection.adapter_name
when 'Mysql2'
'DATETIME'
when 'PostgreSQL'
'TIMESTAMP'
end
end
end
Version data entries
21 entries across 21 versions & 1 rubygems