TK-10001 go-live: activate+ingest mi-homes(25)+smith-douglas(25) to local DB; document MI_STATE=texas footgun + deploy hardening

303b860f368eaaa9b9f75505c78b12a04a6e508a · 2026-08-11 13:45:49 -0700 · Steve

Files touched

M collectors/BUILDERS.md

Diff

commit 303b860f368eaaa9b9f75505c78b12a04a6e508a
Author: Steve <steve@designerwallcoverings.com>
Date:   Tue Aug 11 13:45:49 2026 -0700

    TK-10001 go-live: activate+ingest mi-homes(25)+smith-douglas(25) to local DB; document MI_STATE=texas footgun + deploy hardening
---
 collectors/BUILDERS.md | 20 ++++++++++++++++++++
 1 file changed, 20 insertions(+)

diff --git a/collectors/BUILDERS.md b/collectors/BUILDERS.md
index 05b67617..054115d8 100644
--- a/collectors/BUILDERS.md
+++ b/collectors/BUILDERS.md
@@ -168,3 +168,23 @@ has either a built adapter OR a documented-deferral RECON.md:**
 reference + mi-homes + smith-douglas). Whole workspace typecheck exit 0 / 0 TS errors; workers + collector
 tests green. **Go-live (activate + deploy + ingest to Kamatera) stays Steve-gated** — this pass is
 build-out engineering only.
+
+---
+
+# 2026-08-11 (GO-LIVE) — mi-homes + smith-douglas activated + ingested (Steve-approved)
+
+Steve approved full go-live. Both new adapters activated (`SourceRegistry.active=true`) and ingested
+into the Mac2-local DB via the real pipeline, 0 rejected / 0 errors:
+- **mi-homes-site**: 25 pages → 50 staged → **25 published homes** (92% price, 100% beds/sqft, 25 distinct addr). TX sample $429k–$462k.
+- **smith-douglas-site**: 25 pages → **25 published homes** (48% price = honest "Contact For Pricing" nulls, 100% sqft, 25 distinct addr).
+
+**FOOTGUN (fixed):** M/I Homes URLs use the FULL state name — `MI_STATE=texas`, NOT `MI_STATE=tx`
+(a `tx` filter matches `/new-homes/tx/` which doesn't exist → 0 pages). Use the full state word.
+
+**Deploy hardening (deploy-kamatera.sh):** added a pre-drop `pg_dump` backup (aborts if the dump is
+suspiciously small) + `WORKER_HEALTH_PORT=9966` in the remote `.env` (worker was defaulting to 9976,
+colliding with the admin app). Also fixed `apps/workers` `pipeline`/`verify` scripts to load the root
+`.env` via `tsx --env-file` (was failing with "DATABASE_URL not found" on manual runs).
+
+**Remaining:** re-run `deploy-kamatera.sh` to mirror the +50 homes up to Kamatera (safely re-backs-up
+before the DROP). Kamatera deploy already ran once with the pre-2-builder catalog (69,939 homes live).

← 4ee4bf92 TK-10001: pipeline/verify scripts load root .env via tsx --e · back to Homesonspec · TK-10001: deploy-kamatera.sh frees :9975/:9976 from orphaned be9e4af2 →