Auto-finalize: rebuild house.json snapshot + restart :9943 when QH enrichment completes (surfaces ai descriptions + color filter)

0bdd1efa75b591d17d762f9cf74e67077d2a9a8e · 2026-06-23 16:47:14 -0700 · steve

Files touched

A scripts/finalize-on-enrich.sh

Diff

commit 0bdd1efa75b591d17d762f9cf74e67077d2a9a8e
Author: steve <steve@designerwallcoverings.com>
Date:   Tue Jun 23 16:47:14 2026 -0700

    Auto-finalize: rebuild house.json snapshot + restart :9943 when QH enrichment completes (surfaces ai descriptions + color filter)
---
 scripts/finalize-on-enrich.sh | 27 +++++++++++++++++++++++++++
 1 file changed, 27 insertions(+)

diff --git a/scripts/finalize-on-enrich.sh b/scripts/finalize-on-enrich.sh
new file mode 100755
index 0000000..7b01479
--- /dev/null
+++ b/scripts/finalize-on-enrich.sh
@@ -0,0 +1,27 @@
+#!/bin/bash
+# Auto-finalize: wait for QH enrichment to reach target, then rebuild the
+# microsite snapshot (descriptions + color buckets) and restart the :9943 server.
+cd "$(dirname "$0")/.." || exit 1
+PSQL=/opt/homebrew/opt/postgresql@14/bin/psql
+TARGET=1900
+LOG=scripts/finalize.log
+count() { $PSQL -d dw_unified -tA -c "select count(*) filter (where ai_tags is not null and ai_tags::text not in ('','[]','null')) from quadrille_house_catalog;" 2>/dev/null; }
+echo "$(date) finalize waiting; at $(count)/1942" >> "$LOG"
+while :; do
+  c=$(count)
+  [ "${c:-0}" -ge "$TARGET" ] && break
+  sleep 120
+done
+echo "$(date) enrichment reached $c — rebuilding snapshot" >> "$LOG"
+node scripts/build-house.js >> "$LOG" 2>&1
+node scripts/build-lookbook.js >> "$LOG" 2>&1 || true
+# restart bare-node server on :9943
+OLD=$(lsof -ti :9943 2>/dev/null)
+[ -n "$OLD" ] && kill "$OLD" 2>/dev/null
+sleep 2
+nohup node server.js >> scripts/server.log 2>&1 &
+echo "$!" > scripts/server.pid
+sleep 3
+code=$(curl -s -o /dev/null -w "%{http_code}" --max-time 8 http://127.0.0.1:9943/ 2>/dev/null)
+desc=$($PSQL -d dw_unified -tA -c "select count(*) from quadrille_house_catalog where coalesce(ai_description,description,'')<>'';" 2>/dev/null)
+echo "$(date) DONE — server HTTP $code, snapshot has $desc enriched descriptions, server pid $(cat scripts/server.pid)" >> "$LOG"

← 3c37dd6 auto-save: 2026-06-23T16:22:58 (1 files) — pdp-adras-preview · back to Quadrille House Site · auto-save: 2026-06-23T16:53:06 (5 files) — public/index.html 82db62b →