TODO: log prompt-vs-image PG promotion + deploy (local+prod migrated, 0-row backfill, learn wired, live smoke green)

be40974e64b6b229623b00024e3814eae9d1eb49 · 2026-06-01 12:48:12 -0700 · Steve Abrams

Files touched

M TODO.md

Diff

commit be40974e64b6b229623b00024e3814eae9d1eb49
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Mon Jun 1 12:48:12 2026 -0700

    TODO: log prompt-vs-image PG promotion + deploy (local+prod migrated, 0-row backfill, learn wired, live smoke green)
---
 TODO.md | 7 +++++++
 1 file changed, 7 insertions(+)

diff --git a/TODO.md b/TODO.md
index b514c35..1961e51 100644
--- a/TODO.md
+++ b/TODO.md
@@ -4,6 +4,13 @@ Surfaced to CNCP at http://localhost:3333 (via /api/tasks reading this file).
 Format — `## Section` headers + `- [ ] task` / `- [x] done`. CNCP picks
 up unchecked rows automatically.
 
+## Prompt-vs-image rating (2026-06-01, Steve-approved both gated steps)
+- [x] Migration: user_prompt_match (smallint) + user_prompt_verdict (text) + user_prompt_rated_at (timestamptz). LOCAL via CREATE OR REPLACE VIEW (spoon_all_designs is a view over all_designs locally); PROD via ALTER TABLE spoon_all_designs (it's a real table on prod — topology drift). Both applied + verified.
+- [x] prompt-rate API: PG is source of truth (list reads cols; POST writes PG-first strict, merge-from-PG, then JSONL audit append). is_published never touched (verified live before=after).
+- [x] Backfill JSONL→PG (scripts/backfill_prompt_match.js): 0 rows applied — ledger was empty (no ratings recorded yet).
+- [x] learn_from_votes.js reads user_prompt_match: excludes verdict='reject' / match<=2 from the learned recipe; adds (match-3)*0.2 rank bonus (NULL→neutral).
+- [x] Deployed via ./deploy-kamatera.sh. Live smoke: /designs?sort=color & ?sort=style = 200; /admin/prompt-vs-image gated 404 (no auth) / 200 (admin); prompt-rate/list returns real prompts + new cols, no 500.
+
 ## 2026-05-30 session — CURRENT
 
 - [x] **ROOM MOCKUPS at scale — SHIPPED LIVE, FREE.** Re-rendered 4,763 published-without-room designs with the FREE local PIL compositor (`scripts/pil-room-composite.py`, full-bleed quad onto `_template_blank_living_room.png` + perspective warp + light blend) — 21 min, **$0** (vs ~$750 Gemini cloud, Steve vetoed). Rsynced 5 GB → prod `data/rooms`, inserted 284 new `wallco_rooms` rows (other ~4,479 already had rows w/ stale `room_mockups` → PNG overwrite auto-updated). Verified 8 designs across ID range live (PNG 200, 1 deduped room). Graphic-designer + UX agents drove QA (full-bleed, no white-frame, no blob).

← f339c7f migration(prod): additive ALTER TABLE spoon_all_designs for · back to Wallco Ai · fix: settlement post-gen vision used retired gemini-2.0-flas 7153551 →