[object Object]

← back to Wallco Ai

yolo loop tick 3: room-coverage + dup-image scan

2dd2cbf48caf8547acb45d3166b107a2475b67a5 · 2026-06-02 11:58:35 -0700 · Steve Abrams

1377 published designs w/ 0 rooms (free local PIL gen staged), 1880 orphan rooms
(destructive cleanup staged), 0 duplicate image_url among published. Both writes
staged not applied (bulk).

Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>

Files touched

Diff

commit 2dd2cbf48caf8547acb45d3166b107a2475b67a5
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Tue Jun 2 11:58:35 2026 -0700

    yolo loop tick 3: room-coverage + dup-image scan
    
    1377 published designs w/ 0 rooms (free local PIL gen staged), 1880 orphan rooms
    (destructive cleanup staged), 0 duplicate image_url among published. Both writes
    staged not applied (bulk).
    
    Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
---
 yolo-queue/AUDIT-2026-06-02.md | 28 ++++++++++++++++++++++++++++
 1 file changed, 28 insertions(+)

diff --git a/yolo-queue/AUDIT-2026-06-02.md b/yolo-queue/AUDIT-2026-06-02.md
index 5cc6e13..71e8187 100644
--- a/yolo-queue/AUDIT-2026-06-02.md
+++ b/yolo-queue/AUDIT-2026-06-02.md
@@ -71,3 +71,31 @@ designer-bugs, archive, inspired. Eyeball /admin/design-curator per category bef
 deciding kind — don't bulk-flip blind.
 
 L · NULL/blank kind on published rows: **0** ✓
+
+---
+## Tick 3 (added 2026-06-02) — room coverage + duplicate-image scan
+
+### P · 🟡 1,377 published designs have ZERO room mockups (PDP UX gap)
+Their PDP shows no room context. Room-gen is FREE + LOCAL (PIL composite, ~$0,
+~3.75/s) per Steve's hard rule — NOT the $750 Gemini cloud path. Bulk write
+(1,377 inserts + PNGs) so staged, not auto-run.
+```bash
+# free/local, ~6 min for 1377; pilot 50 first then full:
+python3 scripts/gen_bare_rooms.py --limit 50      # pilot
+python3 scripts/gen_bare_rooms.py --all           # then full
+# rooms read live from wallco_rooms (dual-path resolver) — no snapshot rebuild needed,
+# but deploy to ship the PNGs: ./deploy-kamatera.sh
+```
+
+### O · 🟢 1,880 orphan rooms (rooms whose design is now unpublished/deleted)
+Dead rows + dead PNGs on disk. Harmless (orphans just sit; resolver only reads
+rooms for published designs) but reclaimable disk. Cleanup = DELETE = destructive
+→ Steve-gated, NOT auto-run. Optional housekeeping:
+```sql
+-- review first; reversible only via re-gen:
+DELETE FROM wallco_rooms r USING all_designs d
+ WHERE r.design_id=d.id AND COALESCE(d.is_published,false)=false;
+-- (also rm the orphaned data/rooms/design_<id>_*.png after)
+```
+
+### Q · ✓ Duplicate image_url among published: 0 — clean.

← 85b6407 yolo-backlog: T3 done — N3 joint-fix-gallery density+persist  ·  back to Wallco Ai  ·  front page: remove dead Big-Red chat widget (localhost:9935 624b2ee →