[object Object]

← back to Designerwallcoverings

TK-11522: refresh reconcile to 5 residual edges after concurrent partial fix

02de45b649275e6f1c9ba9e6a5db2d53abe4878e · 2026-09-12 20:23:56 -0700 · Steve Abrams

A concurrent actor reconciled 7 of 12 rows with valid equivalents (verified
live 200). Refreshed apply.sql/rollback.sql to target ONLY the residual 5
(innovations login_url + 4 dead private-label NXDOMAINs -> NULL), guarded on
current values so it can't clobber the concurrent work. Dry-run: 5/5 matched.
Still GATED (classifier blocks agent dw_unified writes) -> Steve ! paste.

Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
Claude-Session: https://claude.ai/code/session_01PPZaNx6iLG5WJuPWQsqZiY

Files touched

Diff

commit 02de45b649275e6f1c9ba9e6a5db2d53abe4878e
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Sat Sep 12 20:23:56 2026 -0700

    TK-11522: refresh reconcile to 5 residual edges after concurrent partial fix
    
    A concurrent actor reconciled 7 of 12 rows with valid equivalents (verified
    live 200). Refreshed apply.sql/rollback.sql to target ONLY the residual 5
    (innovations login_url + 4 dead private-label NXDOMAINs -> NULL), guarded on
    current values so it can't clobber the concurrent work. Dry-run: 5/5 matched.
    Still GATED (classifier blocks agent dw_unified writes) -> Steve ! paste.
    
    Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
    Claude-Session: https://claude.ai/code/session_01PPZaNx6iLG5WJuPWQsqZiY
---
 scripts/tk11522-url-rot/.ts                        |  1 +
 scripts/tk11522-url-rot/.ts2                       |  1 +
 .../RESTOREMAP-residual-20260913T032254Z.txt       |  5 +++
 scripts/tk11522-url-rot/apply.sql                  | 51 ++++++++--------------
 scripts/tk11522-url-rot/rollback.sql               | 24 ++++------
 5 files changed, 33 insertions(+), 49 deletions(-)

diff --git a/scripts/tk11522-url-rot/.ts b/scripts/tk11522-url-rot/.ts
new file mode 100644
index 0000000..5ceec18
--- /dev/null
+++ b/scripts/tk11522-url-rot/.ts
@@ -0,0 +1 @@
+20260913T030819Z
diff --git a/scripts/tk11522-url-rot/.ts2 b/scripts/tk11522-url-rot/.ts2
new file mode 100644
index 0000000..129e9fa
--- /dev/null
+++ b/scripts/tk11522-url-rot/.ts2
@@ -0,0 +1 @@
+20260913T032254Z
diff --git a/scripts/tk11522-url-rot/RESTOREMAP-residual-20260913T032254Z.txt b/scripts/tk11522-url-rot/RESTOREMAP-residual-20260913T032254Z.txt
new file mode 100644
index 0000000..3bcbe75
--- /dev/null
+++ b/scripts/tk11522-url-rot/RESTOREMAP-residual-20260913T032254Z.txt
@@ -0,0 +1,5 @@
+bespoke|<NULL>|https://bfrdesignstudio.com
+british_walls|<NULL>|https://www.britishwalls.com
+innovations|https://innovationsusa.com|https://www.innovationsusa.com
+leed_walls|<NULL>|https://www.leedwalls.com
+surface_stick|<NULL>|https://www.surfacestick.com
diff --git a/scripts/tk11522-url-rot/apply.sql b/scripts/tk11522-url-rot/apply.sql
index b071d61..32698ca 100644
--- a/scripts/tk11522-url-rot/apply.sql
+++ b/scripts/tk11522-url-rot/apply.sql
@@ -1,46 +1,31 @@
 -- TK-11522 vendor_registry URL-rot reconcile — APPLY (GATED: Mac2-canonical dw_unified write)
--- Author: worker-w15  |  Reversible via rollback.sql (from RESTOREMAP-*.txt)
--- Every UPDATE is GUARDED on the exact old value: idempotent, and cannot clobber a
--- concurrent/newer fix (e.g. the way `hollywood` was already corrected out-of-band).
--- Corrections derived from our OWN scraper product_url ground-truth + live-verified 200.
--- Run:  PGHOST=/tmp psql -d dw_unified -v ON_ERROR_STOP=1 -f apply.sql
+-- Author: worker-w15  |  Reversible via rollback.sql (from RESTOREMAP-residual-*.txt)
+-- REFRESHED 2026-09-12: a concurrent actor already reconciled 7 of the original 12 edges with
+-- valid equivalents (armani.com/armani-casa, quadrillefabrics.com, sandersondesigngroup.com,
+-- zoffany.sandersondesigngroup.com, designs.cowtan.com x2, thibautdesign.com — all live 200).
+-- This now targets ONLY the 5 RESIDUAL still-broken items, guarded on their CURRENT values so it
+-- cannot clobber the concurrent work. Run:
+--   PGHOST=/tmp psql -d dw_unified -v ON_ERROR_STOP=1 -f apply.sql
 BEGIN;
 
--- A. Confident domain corrections (scraper product_url host, live 200) -----------------
-UPDATE vendor_registry SET website_url='https://www.thibautdesign.com',        updated_at=now()
-  WHERE vendor_code='anna_french'    AND website_url='https://www.thibautdesign.com/anna-french';
-UPDATE vendor_registry SET website_url='https://www.armanicasa-wallcoverings.com', updated_at=now()
-  WHERE vendor_code='armani_casa'    AND website_url='https://www.armanicasa.com';
-UPDATE vendor_registry SET website_url='https://quadrillefabrics.com',          updated_at=now()
-  WHERE vendor_code='china_seas'     AND website_url='https://www.chinaseas.com';
-UPDATE vendor_registry SET website_url='https://designs.cowtan.com',            updated_at=now()
-  WHERE vendor_code='colefax_fowler' AND website_url='https://www.colefaxfowler.com';
-UPDATE vendor_registry SET website_url='https://designs.cowtan.com',            updated_at=now()
-  WHERE vendor_code='cowtan_tout'    AND website_url='https://www.cowtantout.com';
-UPDATE vendor_registry SET login_url='https://www.innovationsusa.com',
-                           website_url='https://www.innovationsusa.com',        updated_at=now()
-  WHERE vendor_code='innovations'    AND website_url='https://innovationsusa.com';
-UPDATE vendor_registry SET website_url='https://www.sanderson.design',          updated_at=now()
-  WHERE vendor_code='william_morris' AND website_url='https://www.williammorris.com';
-UPDATE vendor_registry SET website_url='https://www.zoffany.design',            updated_at=now()
-  WHERE vendor_code='zoffany'        AND website_url='https://www.zoffany.com';
+-- (1) innovations login_url still points at the cert-mismatch host (website_url already fixed to www) --
+UPDATE vendor_registry SET login_url='https://www.innovationsusa.com', updated_at=now()
+  WHERE vendor_code='innovations' AND login_url='https://innovationsusa.com';
 
--- B. Dead private-label / house domains -> NULL (products sell only on our own store;
---    a dead NXDOMAIN pointer is worse than NULL — NULL = correctly "no external edge") --
+-- (2) Dead private-label / house NXDOMAINs -> NULL (products sell only on our own store;
+--     a dead pointer is worse than NULL). ALTERNATIVE: set to https://www.designerwallcoverings.com --
 UPDATE vendor_registry SET website_url=NULL, updated_at=now()
-  WHERE vendor_code='bespoke'        AND website_url='https://bfrdesignstudio.com';
+  WHERE vendor_code='bespoke'       AND website_url='https://bfrdesignstudio.com';
 UPDATE vendor_registry SET website_url=NULL, updated_at=now()
-  WHERE vendor_code='british_walls'  AND website_url='https://www.britishwalls.com';
+  WHERE vendor_code='british_walls' AND website_url='https://www.britishwalls.com';
 UPDATE vendor_registry SET website_url=NULL, updated_at=now()
-  WHERE vendor_code='leed_walls'     AND website_url='https://www.leedwalls.com';
+  WHERE vendor_code='leed_walls'    AND website_url='https://www.leedwalls.com';
 UPDATE vendor_registry SET website_url=NULL, updated_at=now()
-  WHERE vendor_code='surface_stick'  AND website_url='https://www.surfacestick.com';
+  WHERE vendor_code='surface_stick' AND website_url='https://www.surfacestick.com';
 
--- Read-back (independent verification, not the UPDATE row count) -------------------------
+-- Read-back (independent verification) --------------------------------------------------
 SELECT vendor_code, login_url, website_url FROM vendor_registry
-  WHERE vendor_code IN ('anna_french','armani_casa','china_seas','colefax_fowler',
-        'cowtan_tout','innovations','william_morris','zoffany',
-        'bespoke','british_walls','leed_walls','surface_stick')
+  WHERE vendor_code IN ('innovations','bespoke','british_walls','leed_walls','surface_stick')
   ORDER BY vendor_code;
 
 COMMIT;
diff --git a/scripts/tk11522-url-rot/rollback.sql b/scripts/tk11522-url-rot/rollback.sql
index 9201959..7592c6a 100644
--- a/scripts/tk11522-url-rot/rollback.sql
+++ b/scripts/tk11522-url-rot/rollback.sql
@@ -1,18 +1,10 @@
--- TK-11522 vendor_registry URL-rot reconcile — ROLLBACK (restores exact pre-apply values)
--- Source of truth: RESTOREMAP-20260913T030819Z.txt (captured read-only before apply).
--- Run:  PGHOST=/tmp psql -d dw_unified -v ON_ERROR_STOP=1 -f rollback.sql
+-- TK-11522 residual reconcile — ROLLBACK (restores exact pre-apply values)
+-- Run: PGHOST=/tmp psql -d dw_unified -v ON_ERROR_STOP=1 -f rollback.sql
 BEGIN;
-UPDATE vendor_registry SET website_url='https://www.thibautdesign.com/anna-french', updated_at=now() WHERE vendor_code='anna_french';
-UPDATE vendor_registry SET website_url='https://www.armanicasa.com',                updated_at=now() WHERE vendor_code='armani_casa';
-UPDATE vendor_registry SET website_url='https://www.chinaseas.com',                 updated_at=now() WHERE vendor_code='china_seas';
-UPDATE vendor_registry SET website_url='https://www.colefaxfowler.com',             updated_at=now() WHERE vendor_code='colefax_fowler';
-UPDATE vendor_registry SET website_url='https://www.cowtantout.com',                updated_at=now() WHERE vendor_code='cowtan_tout';
-UPDATE vendor_registry SET login_url='https://innovationsusa.com', website_url='https://innovationsusa.com', updated_at=now() WHERE vendor_code='innovations';
-UPDATE vendor_registry SET website_url='https://www.williammorris.com',             updated_at=now() WHERE vendor_code='william_morris';
-UPDATE vendor_registry SET website_url='https://www.zoffany.com',                   updated_at=now() WHERE vendor_code='zoffany';
-UPDATE vendor_registry SET website_url='https://bfrdesignstudio.com',               updated_at=now() WHERE vendor_code='bespoke';
-UPDATE vendor_registry SET website_url='https://www.britishwalls.com',              updated_at=now() WHERE vendor_code='british_walls';
-UPDATE vendor_registry SET website_url='https://www.leedwalls.com',                 updated_at=now() WHERE vendor_code='leed_walls';
-UPDATE vendor_registry SET website_url='https://www.surfacestick.com',              updated_at=now() WHERE vendor_code='surface_stick';
-SELECT vendor_code, login_url, website_url FROM vendor_registry WHERE vendor_code IN ('anna_french','armani_casa','china_seas','colefax_fowler','cowtan_tout','innovations','william_morris','zoffany','bespoke','british_walls','leed_walls','surface_stick') ORDER BY vendor_code;
+UPDATE vendor_registry SET login_url='https://innovationsusa.com', updated_at=now() WHERE vendor_code='innovations';
+UPDATE vendor_registry SET website_url='https://bfrdesignstudio.com',  updated_at=now() WHERE vendor_code='bespoke';
+UPDATE vendor_registry SET website_url='https://www.britishwalls.com', updated_at=now() WHERE vendor_code='british_walls';
+UPDATE vendor_registry SET website_url='https://www.leedwalls.com',    updated_at=now() WHERE vendor_code='leed_walls';
+UPDATE vendor_registry SET website_url='https://www.surfacestick.com', updated_at=now() WHERE vendor_code='surface_stick';
+SELECT vendor_code, login_url, website_url FROM vendor_registry WHERE vendor_code IN ('innovations','bespoke','british_walls','leed_walls','surface_stick') ORDER BY vendor_code;
 COMMIT;

← ba0d292 TK-11552: gitignore local backup of aged info@ reply drafts  ·  back to Designerwallcoverings  ·  auto-data-snapshot: 2026-09-12T21:34:07 (1 data files) — scr 3c9b11f →