auto-save: 2026-07-30T15:49:17 (1 files) — verify-urlgap.js

0bbfc4d4ead2b26c23ab0c6b942dcf1518c93b63 · 2026-07-30 15:49:19 -0700 · Steve Abrams

Files touched

A verify-urlgap.js

Diff

commit 0bbfc4d4ead2b26c23ab0c6b942dcf1518c93b63
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Thu Jul 30 15:49:19 2026 -0700

    auto-save: 2026-07-30T15:49:17 (1 files) — verify-urlgap.js
---
 verify-urlgap.js | 27 +++++++++++++++++++++++++++
 1 file changed, 27 insertions(+)

diff --git a/verify-urlgap.js b/verify-urlgap.js
new file mode 100644
index 0000000..c67533b
--- /dev/null
+++ b/verify-urlgap.js
@@ -0,0 +1,27 @@
+// VERIFY Cody's URL-gap claim: do 'done' products' body_html (or metafields)
+// hard-reference the now-deleted original image URL? Read-only.
+import fs from 'fs';
+import pg from 'pg';
+const SHOP='designer-laboratory-sandbox.myshopify.com';
+const ATOK=fs.readFileSync('/Users/macstudio3/Projects/secrets-manager/.env','utf8').split('\n').find(l=>l.startsWith('SHOPIFY_ADMIN_TOKEN=')).split('=').slice(1).join('=').replace(/["' ]/g,'');
+const sleep=ms=>new Promise(r=>setTimeout(r,ms));
+async function get(p){const r=await fetch(`https://${SHOP}/admin/api/2024-10/${p}`,{headers:{'X-Shopify-Access-Token':ATOK}});await sleep(120);return r.json();}
+const db=new pg.Client({host:'/tmp',database:'dw_unified'}); await db.connect();
+const {rows}=await db.query("SELECT product_id, orig_src FROM img_shrink_ledger WHERE state='done' AND orig_src IS NOT NULL ORDER BY id DESC LIMIT 40");
+let hard=0, checked=0, mfHard=0;
+for(const r of rows){
+  // stem = the CDN filename without path/query/size-suffix/ext
+  const stem=(r.orig_src.split('?')[0].split('/').pop()||'').replace(/\.(jpe?g|png|webp)$/i,'').replace(/_\d+x\d*$/,'');
+  if(!stem) continue;
+  const pj=await get(`products/${r.product_id}.json?fields=body_html`);
+  const bh=pj.product?.body_html||'';
+  checked++;
+  if(bh.toLowerCase().includes(stem.toLowerCase())){ hard++; console.log(`  HARDREF body_html product ${r.product_id} → "${stem}"`); }
+  // metafields (raw-url storage)
+  const mf=await get(`products/${r.product_id}/metafields.json`);
+  const blob=JSON.stringify(mf.metafields||[]).toLowerCase();
+  if(blob.includes(stem.toLowerCase())){ mfHard++; console.log(`  HARDREF metafield product ${r.product_id} → "${stem}"`); }
+}
+console.log(`\nRESULT: checked ${checked} done-products | body_html hardrefs=${hard} | metafield hardrefs=${mfHard}`);
+console.log(hard+mfHard===0 ? 'VERDICT: URL-gap NOT reproduced — descriptions/metafields do NOT embed the product\'s own image CDN URL. Cody\'s risk is PHANTOM for DW → drop.' : 'VERDICT: URL-gap REAL — need orig_src→new_src rewrite for the affected fields.');
+await db.end();

← 8cd54cf auto-save: 2026-07-30T08:46:20 (2 files) — files-biggest.md · back to Dw Image Shrink · TK-10048 COMPLETE: ~33GB reclaimed (6893 imgs + 61 vids), 40 2305bbf →