Skip to content

Instantly share code, notes, and snippets.

@BDQ
Last active December 15, 2015 18:19
Show Gist options
  • Save BDQ/5303243 to your computer and use it in GitHub Desktop.
Save BDQ/5303243 to your computer and use it in GitHub Desktop.
line_item.destroy with after_commit callback
(0.1ms) begin transaction
Spree::Adjustment Load (0.1ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 9 AND "spree_adjustments"."adjustable_type" = 'Spree::LineItem'
Spree::Order Load (0.1ms) SELECT "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."id" = 3 LIMIT 1
Spree::InventoryUnit Load (0.1ms) SELECT "spree_inventory_units".* FROM "spree_inventory_units" WHERE "spree_inventory_units"."order_id" = 3
SQL (0.3ms) DELETE FROM "spree_line_items" WHERE "spree_line_items"."id" = ? [["id", 9]]
(1.1ms) commit transaction
Spree::Adjustment Load (0.1ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 3 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."originator_type" = 'Spree::TaxRate' AND "spree_adjustments"."adjustable_type" = 'Spree::Order' ORDER BY created_at ASC
Spree::LineItem Load (0.1ms) SELECT "spree_line_items".* FROM "spree_line_items" WHERE "spree_line_items"."order_id" = 3 ORDER BY created_at ASC
Spree::Zone Load (0.1ms) SELECT "spree_zones".* FROM "spree_zones" ORDER BY zone_members_count, created_at
Spree::ZoneMember Load (0.2ms) SELECT "spree_zone_members".* FROM "spree_zone_members" WHERE "spree_zone_members"."zone_id" IN (2, 1)
Spree::Zone Load (0.1ms) SELECT "spree_zones".* FROM "spree_zones" WHERE "spree_zones"."default_tax" = 't' LIMIT 1
Spree::Payment Load (0.1ms) SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = 3 AND "spree_payments"."state" = 'completed'
Spree::Adjustment Load (0.1ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 3 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."eligible" = 't' ORDER BY created_at ASC
Spree::Payment Load (0.1ms) SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = 3
(0.0ms) begin transaction
SQL (0.3ms) INSERT INTO "spree_state_changes" ("created_at", "name", "next_state", "previous_state", "stateful_id", "stateful_type", "updated_at", "user_id") VALUES (?, ?, ?, ?, ?, ?, ?, ?) [["created_at", Wed, 03 Apr 2013 17:18:49 UTC +00:00], ["name", "payment"], ["next_state", "balance_due"], ["previous_state", "balance_due"], ["stateful_id", 3], ["stateful_type", "Spree::Order"], ["updated_at", Wed, 03 Apr 2013 17:18:49 UTC +00:00], ["user_id", nil]]
(22.5ms) commit transaction
Spree::Shipment Load (0.2ms) SELECT "spree_shipments".* FROM "spree_shipments" WHERE "spree_shipments"."order_id" = 3
(0.1ms) SELECT COUNT(*) FROM "spree_inventory_units" WHERE "spree_inventory_units"."order_id" = 3 AND "spree_inventory_units"."state" = 'backordered'
(0.1ms) SELECT "spree_shipments"."state" FROM "spree_shipments" WHERE "spree_shipments"."order_id" = 3
(0.0ms) begin transaction
SQL (0.4ms) INSERT INTO "spree_state_changes" ("created_at", "name", "next_state", "previous_state", "stateful_id", "stateful_type", "updated_at", "user_id") VALUES (?, ?, ?, ?, ?, ?, ?, ?) [["created_at", Wed, 03 Apr 2013 17:18:49 UTC +00:00], ["name", "shipment"], ["next_state", nil], ["previous_state", nil], ["stateful_id", 3], ["stateful_type", "Spree::Order"], ["updated_at", Wed, 03 Apr 2013 17:18:49 UTC +00:00], ["user_id", nil]]
(2.7ms) commit transaction
Spree::Adjustment Load (0.1ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 3 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' ORDER BY created_at ASC
Spree::Adjustment Load (0.1ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 3 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."originator_type" = 'Spree::PromotionAction' AND "spree_adjustments"."eligible" = 't' ORDER BY created_at ASC
Spree::Payment Load (0.1ms) SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = 3 AND "spree_payments"."state" = 'completed'
Spree::Adjustment Load (0.1ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = 3 AND "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."eligible" = 't' ORDER BY created_at ASC
SQL (1.5ms) UPDATE "spree_orders" SET "payment_state" = 'balance_due', "shipment_state" = NULL, "item_total" = 0.0, "adjustment_total" = 0.0, "payment_total" = 0.0, "total" = 0.0 WHERE "spree_orders"."id" = 3
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment