auto-save: 2026-07-14T08:29:59 (2 files) — archive_no_sheet_match.py fix_dwkk_misclassified.py

11edf5c7a111b3ee287941e65d76d3e2a3f1e174 · 2026-07-14 08:30:02 -0700 · Steve Abrams

Files touched

M archive_no_sheet_match.py
M fix_dwkk_misclassified.py

Diff

commit 11edf5c7a111b3ee287941e65d76d3e2a3f1e174
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Tue Jul 14 08:30:02 2026 -0700

    auto-save: 2026-07-14T08:29:59 (2 files) — archive_no_sheet_match.py fix_dwkk_misclassified.py
---
 archive_no_sheet_match.py | 2 +-
 fix_dwkk_misclassified.py | 2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/archive_no_sheet_match.py b/archive_no_sheet_match.py
index 1e1a302..0c4a627 100644
--- a/archive_no_sheet_match.py
+++ b/archive_no_sheet_match.py
@@ -32,7 +32,7 @@ print(f'no_sheet_match DWKKs: {len(no_match)}')
 # Bulk lookup catalog mfr_sku for all these
 sku_in = "','".join(no_match)
 r = subprocess.run(fx.SSH + [
-    f"PGPASSWORD=DW2024SecurePass psql -h 127.0.0.1 -U dw_admin -d dw_unified --csv -t -c "
+    f"PGPASSWORD=DW2024! psql -h 127.0.0.1 -U dw_admin -d dw_unified --csv -t -c "
     f"\"SELECT dw_sku, mfr_sku, shopify_product_id FROM kravet_catalog WHERE dw_sku IN ('{sku_in}')\""
 ], capture_output=True, text=True, check=True)
 import io
diff --git a/fix_dwkk_misclassified.py b/fix_dwkk_misclassified.py
index dfbe664..6c174d9 100644
--- a/fix_dwkk_misclassified.py
+++ b/fix_dwkk_misclassified.py
@@ -45,7 +45,7 @@ def gql(query, variables=None):
 
 def pg_exec(sql):
     subprocess.run(SSH + [
-        f"PGPASSWORD=DW2024SecurePass psql -h 127.0.0.1 -U dw_admin -d dw_unified -c \"{sql}\""
+        f"PGPASSWORD=DW2024! psql -h 127.0.0.1 -U dw_admin -d dw_unified -c \"{sql}\""
     ], check=True, capture_output=True)

← d3fd36d chore: macstudio3 migration — reconcile from mac2 + repoint · back to Kravet Fabric Fix 2026 04 23 · Strip hardcoded Shopify API tokens from source (env-first); f79b135 →