auto-save: 2026-07-14T08:29:59 (1 files) — cadence/york-cadence.mjs

58207a77c09e60b47bfebde05adbf7878a05f1df · 2026-07-14 08:30:03 -0700 · Steve Abrams

Files touched

M cadence/york-cadence.mjs

Diff

commit 58207a77c09e60b47bfebde05adbf7878a05f1df
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Tue Jul 14 08:30:03 2026 -0700

    auto-save: 2026-07-14T08:29:59 (1 files) — cadence/york-cadence.mjs
---
 cadence/york-cadence.mjs | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/cadence/york-cadence.mjs b/cadence/york-cadence.mjs
index 3f00321..7efd101 100644
--- a/cadence/york-cadence.mjs
+++ b/cadence/york-cadence.mjs
@@ -15,12 +15,12 @@ const ROOT=process.env.HOME+'/Projects/york-reprice-2026-08';
 const SHOP='designer-laboratory-sandbox.myshopify.com',VER='2024-10';
 const TOKEN=(fs.readFileSync(process.env.HOME+'/Projects/secrets-manager/.env','utf8').match(/^SHOPIFY_ADMIN_TOKEN=(.+)$/m)||[])[1]?.trim();
 const URL=`https://${SHOP}/admin/api/${VER}/graphql.json`;
-const PG='PGPASSWORD=DW2024SecurePass /opt/homebrew/opt/postgresql@14/bin/psql -h 127.0.0.1 -U dw_admin -d dw_unified -tA -F\'\x1f\' -c';
+const PG='PGPASSWORD=DW2024! /opt/homebrew/opt/postgresql@14/bin/psql -h 127.0.0.1 -U dw_admin -d dw_unified -tA -F\'\x1f\' -c';
 // multi-line SQL breaks `psql -c "<sql>"` ("invalid command \n") — the onboardCand query is
 // multi-line and was silently throwing into a catch{}, falsely returning onboardReady=0 for
 // MONTHS. Route every query through a temp .sql file + `-f` so multi-line SQL is safe.
 // (All cadence queries concat_ws(chr(31),…) into ONE column, so -F is unnecessary.)
-const q=sql=>{fs.writeFileSync('/tmp/_yc_q.sql',sql);return execSync(`PGPASSWORD=DW2024SecurePass /opt/homebrew/opt/postgresql@14/bin/psql -h 127.0.0.1 -U dw_admin -d dw_unified -tA -f /tmp/_yc_q.sql`,{encoding:'utf8'}).trim();};
+const q=sql=>{fs.writeFileSync('/tmp/_yc_q.sql',sql);return execSync(`PGPASSWORD=DW2024! /opt/homebrew/opt/postgresql@14/bin/psql -h 127.0.0.1 -U dw_admin -d dw_unified -tA -f /tmp/_yc_q.sql`,{encoding:'utf8'}).trim();};
 const sleep=ms=>new Promise(r=>setTimeout(r,ms));
 const gql=async(query,v)=>{for(let a=0;a<8;a++){let j;try{const r=await fetch(URL,{method:'POST',headers:{'X-Shopify-Access-Token':TOKEN,'Content-Type':'application/json'},body:JSON.stringify({query,variables:v})});j=await r.json();}catch(e){await sleep(1500*(a+1));continue;}if(j.errors){if(JSON.stringify(j.errors).includes('THROTTLED')){await sleep(2000*(a+1));continue;}throw new Error(JSON.stringify(j.errors));}const t=j.extensions?.cost?.throttleStatus;if(t&&t.currentlyAvailable<300)await sleep(1500);return j.data;}throw new Error('retries');};
 const norm=s=>String(s||'').toUpperCase().trim();

← a192374 Fix York auto-onboard silent failure: use process.execPath n · back to York Reprice 2026 08 · York publish on a weekly cadence (100/wk) instead of big-ban a3b8a4f →