[object Object]

← back to Japan Enrich

japan: fix loader wrapper — manifest to staging/ (not db/), resolve DATABASE_URL by searching real project .env files for a dw_unified DSN (fixes ENOENT + missing .env path)

6961b03f28f3c4de832b349bc99121376d5be9e0 · 2026-07-06 17:24:53 -0700 · Steve

Files touched

Diff

commit 6961b03f28f3c4de832b349bc99121376d5be9e0
Author: Steve <steve@designerwallcoverings.com>
Date:   Mon Jul 6 17:24:53 2026 -0700

    japan: fix loader wrapper — manifest to staging/ (not db/), resolve DATABASE_URL by searching real project .env files for a dw_unified DSN (fixes ENOENT + missing .env path)
---
 scripts/load-lines-remote.sh | 17 ++++++++++++++---
 1 file changed, 14 insertions(+), 3 deletions(-)

diff --git a/scripts/load-lines-remote.sh b/scripts/load-lines-remote.sh
index b9e3b74..7918cf5 100644
--- a/scripts/load-lines-remote.sh
+++ b/scripts/load-lines-remote.sh
@@ -4,8 +4,19 @@
 # keep_offline via vendor_never_on_shopify). Idempotent. NO Shopify publish.
 # Run under Steve:  bash ~/Projects/japan-enrich/scripts/load-lines-remote.sh
 set -euo pipefail
-rsync -avz ~/Projects/japan-enrich/db/ ~/Projects/japan-enrich/staging/onboarding-manifest.json \
-  root@45.61.58.125:/root/Projects/japan-staging-viewer/db/
+
+# db scripts → db/ ; manifest → staging/ (the loader reads ../staging/onboarding-manifest.json)
+rsync -avz ~/Projects/japan-enrich/db/ root@45.61.58.125:/root/Projects/japan-staging-viewer/db/
+rsync -avz ~/Projects/japan-enrich/staging/onboarding-manifest.json \
+  root@45.61.58.125:/root/Projects/japan-staging-viewer/staging/onboarding-manifest.json
+
 ssh root@45.61.58.125 'cd /root/Projects/japan-staging-viewer && npm i pg -s && \
-  export DATABASE_URL=$(grep -m1 "^DATABASE_URL=" /root/Projects/Designer-Wallcoverings/.env | cut -d= -f2-) && \
+  DATABASE_URL=""; \
+  for f in $(grep -rl "^DATABASE_URL=.*dw_unified" /root/Projects/*/.env /root/Projects/*/*/.env /root/.env 2>/dev/null); do \
+    v=$(grep -m1 "^DATABASE_URL=" "$f" | cut -d= -f2- | tr -d "\"'"); \
+    [ -n "$v" ] && { DATABASE_URL="$v"; echo "DSN from $f"; break; }; \
+  done; \
+  [ -z "$DATABASE_URL" ] && DATABASE_URL="postgresql:///dw_unified"; \
+  export DATABASE_URL; \
+  psql "$DATABASE_URL" -Atc "select current_database()" && \
   node db/load-distributor-lines.js'

← d08e031 japan: wrapper scripts for the 3 Steve-gated steps — create-  ·  back to Japan Enrich  ·  japan: loader wrapper uses quoted heredoc (fixes quote-strip 329275d →