Sha256: 364ff167cf008e484f108f6317023b2d28b20e70d117d0087acf1d2bf91d13b9
Contents?: true
Size: 503 Bytes
Versions: 35
Compression:
Stored size: 503 Bytes
Contents
class DeleteInProgressOrders < ActiveRecord::Migration
def up
execute("DELETE FROM orders WHERE orders.state = 'in_progress'")
delete_orphans('adjustments')
delete_orphans('checkouts')
delete_orphans('shipments')
delete_orphans('payments')
delete_orphans('line_items')
delete_orphans('inventory_units')
end
def down
end
private
def delete_orphans(table_name)
execute "DELETE FROM #{table_name} WHERE order_id NOT IN (SELECT id FROM orders)"
end
end
Version data entries
35 entries across 35 versions & 3 rubygems