chore: macstudio3 migration — reconcile from mac2 + repoint paths (stevestudio2→macstudio3, node/npm/npx→/opt/homebrew)

d892fdb1eccdbe2da49eedeaf92e985d98513862 · 2026-07-03 08:08:12 -0700 · Steve

Files touched

M enrich.py
M gen_update_sql.py
M scrape_captions.py

Diff

commit d892fdb1eccdbe2da49eedeaf92e985d98513862
Author: Steve <steve@designerwallcoverings.com>
Date:   Fri Jul 3 08:08:12 2026 -0700

    chore: macstudio3 migration — reconcile from mac2 + repoint paths (stevestudio2→macstudio3, node/npm/npx→/opt/homebrew)
---
 enrich.py          | 6 +++---
 gen_update_sql.py  | 4 ++--
 scrape_captions.py | 2 +-
 3 files changed, 6 insertions(+), 6 deletions(-)

diff --git a/enrich.py b/enrich.py
index 29a82a0..818de8a 100644
--- a/enrich.py
+++ b/enrich.py
@@ -9,9 +9,9 @@ cross-attribution is refused.
 Output cols: url, old_credit, new_credit, new_richness, + sub-fields, source."""
 import json, re, csv
 
-WL = "/Users/stevestudio2/QuadrilleRoomSettings-needs-credit.csv"
-OUT = "/Users/stevestudio2/QuadrilleRoomSettings-credit-enriched.csv"
-CAPS = "/Users/stevestudio2/Projects/quadrille-room-credit-enrich/data/image_captions.json"
+WL = "/Users/macstudio3/QuadrilleRoomSettings-needs-credit.csv"
+OUT = "/Users/macstudio3/QuadrilleRoomSettings-credit-enriched.csv"
+CAPS = "/Users/macstudio3/Projects/quadrille-room-credit-enrich/data/image_captions.json"
 
 # publication token (underscored) -> display name. Longest-key-first matching.
 PUBS = {
diff --git a/gen_update_sql.py b/gen_update_sql.py
index e32932e..71cad1e 100644
--- a/gen_update_sql.py
+++ b/gen_update_sql.py
@@ -5,7 +5,7 @@ updates ONLY credit/richness/designer/photographer/publication/date inside the
 existing object. Wrapped BEGIN ... (counts) ... ROLLBACK by default."""
 import csv, json
 
-ROWS = [r for r in csv.DictReader(open('/Users/stevestudio2/QuadrilleRoomSettings-credit-enriched.csv'))
+ROWS = [r for r in csv.DictReader(open('/Users/macstudio3/QuadrilleRoomSettings-credit-enriched.csv'))
         if r['source'] == 'filename-reparse']
 
 
@@ -87,5 +87,5 @@ WHERE obj->>'credit' = e.credit LIMIT 8;""")
 lines.append("")
 lines.append("ROLLBACK;  -- DRY RUN. Change to COMMIT; once counts verified.")
 
-open('/Users/stevestudio2/Projects/quadrille-room-credit-enrich/data/update_credit.sql', 'w').write('\n'.join(lines))
+open('/Users/macstudio3/Projects/quadrille-room-credit-enrich/data/update_credit.sql', 'w').write('\n'.join(lines))
 print(f"wrote data/update_credit.sql ({len(ROWS)} enrich rows)")
diff --git a/scrape_captions.py b/scrape_captions.py
index b7a1e15..40ede6c 100644
--- a/scrape_captions.py
+++ b/scrape_captions.py
@@ -8,7 +8,7 @@ import urllib.request
 
 BASE = "https://www.quadrillefabrics.com"
 UA = "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36"
-OUT = "/Users/stevestudio2/Projects/quadrille-room-credit-enrich/data"
+OUT = "/Users/macstudio3/Projects/quadrille-room-credit-enrich/data"
 urls = [u.strip() for u in open(f"{OUT}/detail_urls.txt") if u.strip()]
 
 S3 = "quadrillefabrics.s3.us-east-2.amazonaws.com/Editorial-Images/"

← 14df518 Add gated jsonb update SQL (BEGIN/ROLLBACK dry-run + COMMITT · back to Quadrille Room Credit Enrich · (newest)