[object Object]

← back to Designerwallcoverings

Collapse tautological try/catch pg require to plain require('pg') in 5 scripts

5efaa448022efb00d064f447f96789a00b959eed · 2026-09-22 14:51:37 -0700 · steve

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

Files touched

Diff

commit 5efaa448022efb00d064f447f96789a00b959eed
Author: steve <steve@designerwallcoverings.com>
Date:   Tue Sep 22 14:51:37 2026 -0700

    Collapse tautological try/catch pg require to plain require('pg') in 5 scripts
    
    Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
    Claude-Session: https://claude.ai/code/session_01DP24DdLpG6PHXgmjr47TVb
---
 scripts/innovations-image-audit/audit.mjs                  | 2 +-
 scripts/innovations-mfr-reconcile/archive-discontinued.mjs | 2 +-
 scripts/innovations-mfr-reconcile/reconcile.mjs            | 2 +-
 scripts/title-campaign/build-titles.mjs                    | 2 +-
 scripts/true-sku-leak-scrub/scrub-true-sku.mjs             | 4 +---
 5 files changed, 5 insertions(+), 7 deletions(-)

diff --git a/scripts/innovations-image-audit/audit.mjs b/scripts/innovations-image-audit/audit.mjs
index b55599e..9eecd60 100644
--- a/scripts/innovations-image-audit/audit.mjs
+++ b/scripts/innovations-image-audit/audit.mjs
@@ -70,7 +70,7 @@ async function classify(url) {
 
 function loadProducts() {
   const require = createRequire(import.meta.url);
-  let pg; try { pg = require('pg'); } catch { pg = require('/Users/macstudio3/Projects/Designer-Wallcoverings/node_modules/pg'); }
+  const pg = require('pg');
   return pg;
 }
 
diff --git a/scripts/innovations-mfr-reconcile/archive-discontinued.mjs b/scripts/innovations-mfr-reconcile/archive-discontinued.mjs
index 1bec872..6042f41 100644
--- a/scripts/innovations-mfr-reconcile/archive-discontinued.mjs
+++ b/scripts/innovations-mfr-reconcile/archive-discontinued.mjs
@@ -49,7 +49,7 @@ async function main() {
   if (!CONFIRMED) { console.error('\n⛔ --execute refused: set SCRUB_CONFIRM=I-AM-STEVE (Steve only).'); process.exit(2); }
 
   const require = createRequire(import.meta.url);
-  let pg; try { pg = require('pg'); } catch { pg = require('/Users/macstudio3/Projects/Designer-Wallcoverings/node_modules/pg'); }
+  const pg = require('pg');
   const pool = new pg.Pool({ connectionString: process.env.DATABASE_URL || 'postgresql:///dw_unified?host=/tmp' });
   const log = join(process.env.HOME, '.claude/yolo-queue/restore-maps/innovations-archive-discontinued.jsonl');
   let ok = 0, skipped = 0; const errs = [];
diff --git a/scripts/innovations-mfr-reconcile/reconcile.mjs b/scripts/innovations-mfr-reconcile/reconcile.mjs
index 5e9e2e5..fadd301 100644
--- a/scripts/innovations-mfr-reconcile/reconcile.mjs
+++ b/scripts/innovations-mfr-reconcile/reconcile.mjs
@@ -33,7 +33,7 @@ async function fetchText(url) {
 
 async function main() {
   const require = createRequire(import.meta.url);
-  let pg; try { pg = require('pg'); } catch { pg = require('/Users/macstudio3/Projects/Designer-Wallcoverings/node_modules/pg'); }
+  const pg = require('pg');
   const pool = new pg.Pool({ connectionString: process.env.DATABASE_URL || 'postgresql:///dw_unified?host=/tmp' });
   const { rows: prods } = await pool.query(
     `SELECT handle, dw_sku, title, image_url, shopify_id,
diff --git a/scripts/title-campaign/build-titles.mjs b/scripts/title-campaign/build-titles.mjs
index 6244277..8c436b2 100644
--- a/scripts/title-campaign/build-titles.mjs
+++ b/scripts/title-campaign/build-titles.mjs
@@ -229,7 +229,7 @@ if (!CONFIRMED) { console.error(`\n⛔ --execute refused: set SCRUB_CONFIRM=I-AM
 
 // ===== GATED WRITE PATH (only reached on --execute + SCRUB_CONFIRM=I-AM-STEVE) ==========
 const require = createRequire(import.meta.url);
-let pg; try { pg = require('pg'); } catch { pg = require('/Users/macstudio3/Projects/Designer-Wallcoverings/node_modules/pg'); }
+const pg = require('pg');
 const pool = new pg.Pool({ connectionString: DB });
 const restoreLog = join(process.env.HOME, `.claude/yolo-queue/restore-maps/title-campaign-${SLUG}-${new Date().toISOString().slice(0, 10)}.jsonl`);
 const MUT = `mutation($input:ProductInput!){ productUpdate(input:$input){ product{ id title } userErrors{ field message } } }`;
diff --git a/scripts/true-sku-leak-scrub/scrub-true-sku.mjs b/scripts/true-sku-leak-scrub/scrub-true-sku.mjs
index d7cbf5d..24e991b 100644
--- a/scripts/true-sku-leak-scrub/scrub-true-sku.mjs
+++ b/scripts/true-sku-leak-scrub/scrub-true-sku.mjs
@@ -185,9 +185,7 @@ async function main() {
   const DIRECT = process.argv.includes('--direct');
   // pg resolved lazily (house scripts run with it on the path); dry-run never needs it.
   const require = createRequire(import.meta.url);
-  let pg;
-  try { pg = require('pg'); }
-  catch { pg = require('/Users/macstudio3/Projects/Designer-Wallcoverings/node_modules/pg'); }
+  const pg = require('pg');
   const pool = new pg.Pool({ connectionString: process.env.DATABASE_URL || 'postgresql:///dw_unified?host=/tmp' });
   const restoreDir = join(HOME, '.claude/yolo-queue/restore-maps');
   mkdirSync(restoreDir, { recursive: true });

← f0f90e1 Make inventory-stamp-guard.mjs shim portable (TK-11786 revie  ·  back to Designerwallcoverings  ·  Fix Innovations over-archive: classify unloaded-pattern SKUs 43488cd →