Sha256: 921d64cb5b66b0fe65209640ae5bcfe87b0dc68d34c55c01e7af82a4920a7dc9
Contents?: true
Size: 565 Bytes
Versions: 7
Compression:
Stored size: 565 Bytes
Contents
# This migration comes from spree (originally 20101026184746)
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
7 entries across 7 versions & 2 rubygems