[object Object]

← back to Japan Enrich

japan: loader wrapper uses quoted heredoc (fixes quote-stripping syntax error); auto-resolves dw_unified DSN + verifies db before load

329275dcb5cae2fe132725b8fade68003cd1715b · 2026-07-06 17:25:33 -0700 · Steve

Files touched

Diff

commit 329275dcb5cae2fe132725b8fade68003cd1715b
Author: Steve <steve@designerwallcoverings.com>
Date:   Mon Jul 6 17:25:33 2026 -0700

    japan: loader wrapper uses quoted heredoc (fixes quote-stripping syntax error); auto-resolves dw_unified DSN + verifies db before load
---
 scripts/load-lines-remote.sh | 24 ++++++++++++++----------
 1 file changed, 14 insertions(+), 10 deletions(-)

diff --git a/scripts/load-lines-remote.sh b/scripts/load-lines-remote.sh
index 7918cf5..0b8f44d 100644
--- a/scripts/load-lines-remote.sh
+++ b/scripts/load-lines-remote.sh
@@ -10,13 +10,17 @@ rsync -avz ~/Projects/japan-enrich/db/ root@45.61.58.125:/root/Projects/japan-st
 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 && \
-  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'
+ssh root@45.61.58.125 bash -s <<'REMOTE'
+set -e
+cd /root/Projects/japan-staging-viewer
+npm i pg -s
+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 resolved from $f"; break; }
+done
+[ -z "$DATABASE_URL" ] && DATABASE_URL="postgresql:///dw_unified"
+export DATABASE_URL
+echo "db check:"; psql "$DATABASE_URL" -Atc "select current_database()"
+node db/load-distributor-lines.js
+REMOTE

← 6961b03 japan: fix loader wrapper — manifest to staging/ (not db/),  ·  back to Japan Enrich  ·  japan: loader prefers dw_admin (owner) DSN so ALTER TABLE us e82b903 →