vens_prod_cleanup_output.txt

gistfile1.txt

irb(main):017:0> spr.delete_all
  Report::SalesPerformanceSummary Update All (3.2ms)  UPDATE "report_sales_performance_summaries" SET "deleted_at" = '2019-07-22 21:14:40.641294' WHERE "report_sales_performance_summaries"."deleted_at" IS NULL AND "report_sales_performance_summaries"."sales_id" IN ($1, $2, $3, $4, $5)  [["sales_id", 68], ["sales_id", 31], ["sales_id", 45], ["sales_id", 67], ["sales_id", 59]]
=> 24
irb(main):018:0> dos.delete_all
  Report::DailyOrderSummary Update All (2.7ms)  UPDATE "report_daily_order_summaries" SET "deleted_at" = '2019-07-22 21:14:47.907106' WHERE "report_daily_order_summaries"."deleted_at" IS NULL AND "report_daily_order_summaries"."store_id" IN ($1, $2)  [["store_id", 30], ["store_id", 24]]
=> 36
irb(main):019:0> auths.delete_all
  UserAuthorization Update All (3.4ms)  UPDATE "user_authorizations" SET "deleted_at" = '2019-07-22 21:14:51.600360' WHERE "user_authorizations"."deleted_at" IS NULL AND "user_authorizations"."user_id" IN ($1, $2, $3, $4, $5)  [["user_id", 68], ["user_id", 31], ["user_id", 45], ["user_id", 67], ["user_id", 59]]
=> 68
irb(main):020:0> conf.delete_all
  CustomerConfiguration Update All (2.3ms)  UPDATE "customer_configurations" SET "deleted_at" = '2019-07-22 21:14:56.566356' WHERE "customer_configurations"."deleted_at" IS NULL AND "customer_configurations"."store_id" IN ($1, $2)  [["store_id", 30], ["store_id", 24]]
=> 2
irb(main):021:0> sba.delete_all
  StoreBankAccount Destroy (1.9ms)  DELETE FROM "store_bank_accounts" WHERE "store_bank_accounts"."store_id" IN ($1, $2)  [["store_id", 30], ["store_id", 24]]
=> 4
irb(main):022:0> spm.delete_all
  StorePaymentMethod Destroy (1.6ms)  DELETE FROM "store_payment_methods" WHERE "store_payment_methods"."store_id" IN ($1, $2)  [["store_id", 30], ["store_id", 24]]
=> 8
irb(main):023:0> invoices.delete_all
  Invoice Update All (0.5ms)  UPDATE "invoices" SET "deleted_at" = '2019-07-22 21:15:09.487871' WHERE "invoices"."deleted_at" IS NULL AND 1=0
=> 0
irb(main):024:0> ois.delete_all
  OrderItem Update All (22.9ms)  UPDATE "order_items" SET "deleted_at" = '2019-07-22 21:15:13.765817' WHERE "order_items"."deleted_at" IS NULL AND "order_items"."order_id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105)  [["order_id", 5690], ["order_id", 5691], ["order_id", 1885], ["order_id", 1886], ["order_id", 2515], ["order_id", 2709], ["order_id", 2712], ["order_id", 5353], ["order_id", 1887], ["order_id", 2445], ["order_id", 2368], ["order_id", 3812], ["order_id", 4961], ["order_id", 4962], ["order_id", 2418], ["order_id", 2543], ["order_id", 2711], ["order_id", 2662], ["order_id", 3791], ["order_id", 2733], ["order_id", 3992], ["order_id", 5519], ["order_id", 5291], ["order_id", 5011], ["order_id", 5289], ["order_id", 2708], ["order_id", 5299], ["order_id", 5295], ["order_id", 5297], ["order_id", 2710], ["order_id", 2713], ["order_id", 2367], ["order_id", 4578], ["order_id", 4579], ["order_id", 3798], ["order_id", 3800], ["order_id", 2444], ["order_id", 4581], ["order_id", 2369], ["order_id", 4401], ["order_id", 4402], ["order_id", 4738], ["order_id", 4414], ["order_id", 4416], ["order_id", 4415], ["order_id", 4422], ["order_id", 4423], ["order_id", 3818], ["order_id", 4429], ["order_id", 4430], ["order_id", 4431], ["order_id", 4432], ["order_id", 4762], ["order_id", 4433], ["order_id", 4435], ["order_id", 4437], ["order_id", 4439], ["order_id", 5095], ["order_id", 3801], ["order_id", 3797], ["order_id", 3795], ["order_id", 3792], ["order_id", 3819], ["order_id", 4448], ["order_id", 4449], ["order_id", 4452], ["order_id", 4451], ["order_id", 4447], ["order_id", 4450], ["order_id", 4453], ["order_id", 4454], ["order_id", 4455], ["order_id", 4457], ["order_id", 4456], ["order_id", 4462], ["order_id", 4460], ["order_id", 4458], ["order_id", 2707], ["order_id", 4461], ["order_id", 4459], ["order_id", 3964], ["order_id", 3986], ["order_id", 3993], ["order_id", 5117], ["order_id", 5118], ["order_id", 5119], ["order_id", 4811], ["order_id", 203], ["order_id", 206], ["order_id", 2419], ["order_id", 2544], ["order_id", 2726], ["order_id", 2714], ["order_id", 2736], ["order_id", 2737], ["order_id", 3811], ["order_id", 3994], ["order_id", 5352], ["order_id", 5420], ["order_id", 5284], ["order_id", 5520], ["order_id", 5290], ["order_id", 5288], ["order_id", 5298], ["order_id", 5296]]
=> 267
irb(main):025:0> orders.delete_all
  Order Update All (14.3ms)  UPDATE "orders" SET "deleted_at" = '2019-07-22 21:15:50.116101' WHERE "orders"."deleted_at" IS NULL AND "orders"."store_id" IN ($1, $2)  [["store_id", 30], ["store_id", 24]]
=> 105
irb(main):026:0> customers.delete_all
  Customer Update All (2.1ms)  UPDATE "customers" SET "deleted_at" = '2019-07-22 21:15:54.881660' WHERE "customers"."deleted_at" IS NULL AND "customers"."store_id" IN ($1, $2)  [["store_id", 30], ["store_id", 24]]
=> 10
irb(main):027:0> staffs.delete_all
  Staff Update All (1.2ms)  UPDATE "staffs" SET "deleted_at" = '2019-07-22 21:15:59.077101' WHERE "staffs"."deleted_at" IS NULL AND "staffs"."id" IN (SELECT "users"."id" FROM "users" WHERE "users"."deleted_at" IS NULL AND "users"."default_store_id" IN ($1, $2) AND "users"."authorizable_type" = $3 AND "users"."authorizable_id" IN ($4, $5, $6, $7, $8))  [["default_store_id", 30], ["default_store_id", 24], ["authorizable_type", "Staff"], ["authorizable_id", 68], ["authorizable_id", 31], ["authorizable_id", 45], ["authorizable_id", 67], ["authorizable_id", 59]]
=> 0
irb(main):028:0> users.delete_all
  User Update All (2.8ms)  UPDATE "users" SET "deleted_at" = '2019-07-22 21:16:20.205477' WHERE "users"."deleted_at" IS NULL AND "users"."default_store_id" IN ($1, $2)  [["default_store_id", 30], ["default_store_id", 24]]
=> 5
irb(main):029:0> stores.delete_all
  Store Update All (2.1ms)  UPDATE "stores" SET "deleted_at" = '2019-07-22 21:16:26.907967' WHERE "stores"."deleted_at" IS NULL AND "stores"."id" IN ($1, $2)  [["id", 30], ["id", 24]]
=> 2
irb(main):030:0> RakeHelper.paranoias.each { |m| (m.constantize).only_deleted.delete_all! }
  User Destroy (2.0ms)  DELETE FROM "users" WHERE "users"."deleted_at" IS NOT NULL
  Staff Destroy (1.6ms)  DELETE FROM "staffs" WHERE "staffs"."deleted_at" IS NOT NULL
  Customer Destroy (1.8ms)  DELETE FROM "customers" WHERE "customers"."deleted_at" IS NOT NULL
  Address Destroy (2.7ms)  DELETE FROM "addresses" WHERE "addresses"."deleted_at" IS NOT NULL
  Supplier Destroy (1.6ms)  DELETE FROM "suppliers" WHERE "suppliers"."deleted_at" IS NOT NULL
  Store Destroy (1.2ms)  DELETE FROM "stores" WHERE "stores"."deleted_at" IS NOT NULL
  Item Destroy (2.5ms)  DELETE FROM "items" WHERE "items"."deleted_at" IS NOT NULL
  ItemColor Destroy (0.6ms)  DELETE FROM "item_colors" WHERE "item_colors"."deleted_at" IS NOT NULL
  ItemSize Destroy (0.7ms)  DELETE FROM "item_sizes" WHERE "item_sizes"."deleted_at" IS NOT NULL
  ItemVariant Destroy (6.4ms)  DELETE FROM "item_variants" WHERE "item_variants"."deleted_at" IS NOT NULL
  Procurement Destroy (1.7ms)  DELETE FROM "procurements" WHERE "procurements"."deleted_at" IS NOT NULL
  ProcurementItem Destroy (2.5ms)  DELETE FROM "procurement_items" WHERE "procurement_items"."deleted_at" IS NOT NULL
  Order Destroy (4.6ms)  DELETE FROM "orders" WHERE "orders"."deleted_at" IS NOT NULL
  OrderItem Destroy (8.4ms)  DELETE FROM "order_items" WHERE "order_items"."deleted_at" IS NOT NULL
  CustomerPrice Destroy (4.5ms)  DELETE FROM "customer_prices" WHERE "customer_prices"."deleted_at" IS NOT NULL
  Invoice Destroy (2.0ms)  DELETE FROM "invoices" WHERE "invoices"."deleted_at" IS NOT NULL
  Shipment Destroy (3.3ms)  DELETE FROM "shipments" WHERE "shipments"."deleted_at" IS NOT NULL
  UserAuthorization Destroy (1.9ms)  DELETE FROM "user_authorizations" WHERE "user_authorizations"."deleted_at" IS NOT NULL
  SablonColor Destroy (1.7ms)  DELETE FROM "sablon_colors" WHERE "sablon_colors"."deleted_at" IS NOT NULL
  PaymentMethod Destroy (0.9ms)  DELETE FROM "payment_methods" WHERE "payment_methods"."deleted_at" IS NOT NULL
  ShipmentFee Destroy (0.7ms)  DELETE FROM "shipment_fees" WHERE "shipment_fees"."deleted_at" IS NOT NULL
  Report::DailyOrderSummary Destroy (2.3ms)  DELETE FROM "report_daily_order_summaries" WHERE "report_daily_order_summaries"."deleted_at" IS NOT NULL
  Report::SalesPerformanceSummary Destroy (2.8ms)  DELETE FROM "report_sales_performance_summaries" WHERE "report_sales_performance_summaries"."deleted_at" IS NOT NULL
  BankAccount Destroy (1.6ms)  DELETE FROM "bank_accounts" WHERE "bank_accounts"."deleted_at" IS NOT NULL
  CustomerConfiguration Destroy (1.5ms)  DELETE FROM "customer_configurations" WHERE "customer_configurations"."deleted_at" IS NOT NULL
  ReturnedOrder Destroy (0.9ms)  DELETE FROM "returned_orders" WHERE "returned_orders"."deleted_at" IS NOT NULL
  ReturnedOrderItem Destroy (0.7ms)  DELETE FROM "returned_order_items" WHERE "returned_order_items"."deleted_at" IS NOT NULL
  ReturnedProcurement Destroy (0.8ms)  DELETE FROM "returned_procurements" WHERE "returned_procurements"."deleted_at" IS NOT NULL
  ReturnedProcurementItem Destroy (0.8ms)  DELETE FROM "returned_procurement_items" WHERE "returned_procurement_items"."deleted_at" IS NOT NULL
=> ["User", "Staff", "Customer", "Address", "Supplier", "Store", "Item", "ItemColor", "ItemSize", "ItemVariant", "Procurement", "ProcurementItem", "Order", "OrderItem", "CustomerPrice", "Invoice", "Shipment", "UserAuthorization", "SablonColor", "PaymentMethod", "ShipmentFee", "Report::DailyOrderSummary", "Report::SalesPerformanceSummary", "BankAccount", "CustomerConfiguration", "ReturnedOrder", "ReturnedOrderItem", "ReturnedProcurement", "ReturnedProcurementItem"]
puts trash.inspect
{"User"=>0, "Staff"=>0, "Customer"=>0, "Address"=>0, "Supplier"=>0, "Store"=>0, "Item"=>0, "ItemColor"=>0, "ItemSize"=>0, "ItemVariant"=>0, "Procurement"=>0, "ProcurementItem"=>0, "Order"=>0, "OrderItem"=>0, "CustomerPrice"=>0, "Invoice"=>0, "Shipment"=>0, "UserAuthorization"=>0, "SablonColor"=>0, "PaymentMethod"=>0, "ShipmentFee"=>0, "Report::DailyOrderSummary"=>0, "Report::SalesPerformanceSummary"=>0, "BankAccount"=>0, "CustomerConfiguration"=>0, "ReturnedOrder"=>0, "ReturnedOrderItem"=>0, "ReturnedProcurement"=>0, "ReturnedProcurementItem"=>0}
shp = Shipment.with_deleted.map { |s| [s.id, s.order.present?] }.to_h
irb(main):046:0> shpids = shp.select { |k, v|  !v }.map { |k, v| k}.uniq
=> [117, 110, 127, 129, 560, 561, 571, 568, 569, 570, 572, 573, 574, 575, 577, 578, 579, 580, 581, 582, 583, 584, 585, 586, 587, 588, 589, 590, 591, 592, 606, 607, 608, 653, 696, 735, 914]
irb(main):047:0> Shipment.with_deleted.where(id: shpids).delete_all!
  Shipment Destroy (2.0ms)  DELETE FROM "shipments" WHERE "shipments"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37)  [["id", 117], ["id", 110], ["id", 127], ["id", 129], ["id", 560], ["id", 561], ["id", 571], ["id", 568], ["id", 569], ["id", 570], ["id", 572], ["id", 573], ["id", 574], ["id", 575], ["id", 577], ["id", 578], ["id", 579], ["id", 580], ["id", 581], ["id", 582], ["id", 583], ["id", 584], ["id", 585], ["id", 586], ["id", 587], ["id", 588], ["id", 589], ["id", 590], ["id", 591], ["id", 592], ["id", 606], ["id", 607], ["id", 608], ["id", 653], ["id", 696], ["id", 735], ["id", 914]]
=> 37
irb(main):042:0> addr = Address.all.map { |ad| [ad.id, ad.addressable.present? ] }.to_h
irb(main):043:0> addids = addr.select { |k, v| !v }.map { |k, v| k }.uniq
=> [56, 67, 69, 38, 119, 70, 112, 115, 116, 117, 118, 120, 121, 122, 123, 124, 125, 126, 127, 142, 143, 144, 163, 165, 166, 168, 171, 186, 187, 189, 190, 191, 192, 193, 194, 195, 197, 198, 199, 226, 235, 263, 394]
irb(main):044:0> Address.where(id: addids).delete_all
  Address Update All (25.8ms)  UPDATE "addresses" SET "deleted_at" = '2019-07-23 05:34:19.389020' WHERE "addresses"."deleted_at" IS NULL AND "addresses"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43)  [["id", 56], ["id", 67], ["id", 69], ["id", 38], ["id", 119], ["id", 70], ["id", 112], ["id", 115], ["id", 116], ["id", 117], ["id", 118], ["id", 120], ["id", 121], ["id", 122], ["id", 123], ["id", 124], ["id", 125], ["id", 126], ["id", 127], ["id", 142], ["id", 143], ["id", 144], ["id", 163], ["id", 165], ["id", 166], ["id", 168], ["id", 171], ["id", 186], ["id", 187], ["id", 189], ["id", 190], ["id", 191], ["id", 192], ["id", 193], ["id", 194], ["id", 195], ["id", 197], ["id", 198], ["id", 199], ["id", 226], ["id", 235], ["id", 263], ["id", 394]]
=> 43