auto-data-snapshot: 2026-09-09T21:13:05 (2 data files) — data/d3b-heldreview-ledger.json data/d3b-heldreview-rollback.sql

6feb3733cc282af10bdad5cdf458eb03f0377c78 · 2026-09-09 21:13:06 -0700 · auto-commit-fleet

Files touched

M data/d3b-heldreview-ledger.json
A data/d3b-heldreview-rollback.sql

Diff

commit 6feb3733cc282af10bdad5cdf458eb03f0377c78
Author: auto-commit-fleet <steve@designerwallcoverings.com>
Date:   Wed Sep 9 21:13:06 2026 -0700

    auto-data-snapshot: 2026-09-09T21:13:05 (2 data files) — data/d3b-heldreview-ledger.json data/d3b-heldreview-rollback.sql
---
 data/d3b-heldreview-ledger.json  | 4 ++--
 data/d3b-heldreview-rollback.sql | 4 ++++
 2 files changed, 6 insertions(+), 2 deletions(-)

diff --git a/data/d3b-heldreview-ledger.json b/data/d3b-heldreview-ledger.json
index a67d542..5d3656f 100644
--- a/data/d3b-heldreview-ledger.json
+++ b/data/d3b-heldreview-ledger.json
@@ -1,9 +1,9 @@
 {
   "agent": "vp-dw-commerce",
   "ticket": "TK-11331",
-  "action": "d3b-heldreview-stage: staged 79 held Momentum->Hollywood extend/disambiguate colorways into momentum_colorways (Mac2-canonical staging). 43 STAGE-NEW (clean extends of already-staged patterns) + 36 DISAMBIGUATE (new colorways of the trailing-space collision patterns Rectangular Louvre/Vault/Vertex 9/16, staged under the canonical staged spelling so they join the existing group instead of forking a whitespace-variant) + 0 DROP-DUP in the 79. Collision patterns Cavern II / Rectangular Hatch 9/16 / Rectangular Linear 9/16 held OUT (all feed colorways already staged). ids 61900-61978. dw_sku NULL (assign-sku FROZEN), hw_price=list*1.448, cost=list*0.80, sub_category Acoustic Panel for 78 acoustic rows, image_url NULL (Needs-Image at go-live). NO Shopify/publish.",
+  "action": "d3b-heldreview-stage: staged 79 held Momentum->Hollywood extend/disambiguate colorways into momentum_colorways (Mac2-canonical staging). 43 STAGE-NEW (clean extends of already-staged patterns) + 36 DISAMBIGUATE (new colorways of the trailing-space collision patterns Rectangular Louvre/Vault/Vertex 9/16, staged under the canonical staged spelling so they join the existing group instead of forking a whitespace-variant) + 0 DROP in the 79. Collision patterns Cavern II / Rectangular Hatch 9/16 / Rectangular Linear 9/16 held OUT (all feed colorways already staged). ids 61900-61978. dw_sku NULL (assign-sku FROZEN), hw_price=list*1.448, cost=list*0.80, sub_category Acoustic Panel for 78 acoustic rows, image_url NULL (Needs-Image at go-live). NO Shopify/publish.",
   "blast_radius": 79,
-  "undo_cmd": "NODE_PATH=/Users/macstudio3/Projects/reidwitlin-landing/node_modules node /Users/macstudio3/Projects/tk-11331-exec/d3b_heldreview_rollback.mjs --apply",
+  "undo_cmd": "psql -h /tmp dw_unified -f /Users/macstudio3/Projects/tk-11331-exec/data/d3b-heldreview-rollback.sql",
   "verify": "psql -h /tmp dw_unified -tAc \"SELECT count(*) FROM momentum_colorways WHERE id BETWEEN 61900 AND 61978\"  # 79 now, 0 after undo",
   "restore_file": "/Users/macstudio3/Projects/tk-11331-exec/data/d3b-heldreview-stage-restore.jsonl"
 }
diff --git a/data/d3b-heldreview-rollback.sql b/data/d3b-heldreview-rollback.sql
new file mode 100644
index 0000000..dad0c15
--- /dev/null
+++ b/data/d3b-heldreview-rollback.sql
@@ -0,0 +1,4 @@
+-- TK-11331 D3b-heldreview ROLLBACK — undo the d3b-heldreview-stage op (79 rows, ids 61900-61978).
+-- Run:  psql -h /tmp dw_unified -f data/d3b-heldreview-rollback.sql
+\set ON_ERROR_STOP on
+DELETE FROM momentum_colorways WHERE id BETWEEN 61900 AND 61978;

← 4461985 auto-data-snapshot: 2026-09-09T20:39:48 (9 data files) — dat · back to Tk 11331 Exec · TK-11331 D3b-heldreview: classify + stage 79 held Momentum c b68d5f9 →