snapshot: prefix-match generators to end recurring allowlist-gap bug

4c2836c6df41becba564716812d2828aa79c1c80 · 2026-05-26 10:42:19 -0700 · Steve Abrams

The exact-match generator IN() list silently dropped every new fix/variant
generator (gemini-2.5-flash-image-smart-fix/-luxe-v2/-bg-swap/-regen-reverse,
replicate-sdxl-inspired, pil-fix-design, pil-opacity-snap) from designs.json
until hand-added — the dated comments show this recurring repeatedly. Switched
to prefix families (replicate%, gemini-2.5-flash-image%, pil-%, comfy, flux)
so current+future variants ride along; non-design generators (stub) stay out.
Recovered 1,513 gate-clean published designs into the snapshot (12,160→13,673).

Files touched

M scripts/refresh_designs_snapshot.py

Diff

commit 4c2836c6df41becba564716812d2828aa79c1c80
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Tue May 26 10:42:19 2026 -0700

    snapshot: prefix-match generators to end recurring allowlist-gap bug
    
    The exact-match generator IN() list silently dropped every new fix/variant
    generator (gemini-2.5-flash-image-smart-fix/-luxe-v2/-bg-swap/-regen-reverse,
    replicate-sdxl-inspired, pil-fix-design, pil-opacity-snap) from designs.json
    until hand-added — the dated comments show this recurring repeatedly. Switched
    to prefix families (replicate%, gemini-2.5-flash-image%, pil-%, comfy, flux)
    so current+future variants ride along; non-design generators (stub) stay out.
    Recovered 1,513 gate-clean published designs into the snapshot (12,160→13,673).
---
 scripts/refresh_designs_snapshot.py | 12 +++++++++++-
 1 file changed, 11 insertions(+), 1 deletion(-)

diff --git a/scripts/refresh_designs_snapshot.py b/scripts/refresh_designs_snapshot.py
index 7fe56d5..900c2f1 100644
--- a/scripts/refresh_designs_snapshot.py
+++ b/scripts/refresh_designs_snapshot.py
@@ -91,7 +91,17 @@ rows = psql_json(
     # fliepaper-bugs Gemini remakes land in the snapshot. Same allowlist-gap class
     # as the earlier '-edit' fix; only is_published rows display, so the 57 unpublished
     # remakes stay hidden while Steve's approved PASS + cabinet murals go live.
-    "FROM spoon_all_designs WHERE generator IN ('replicate','gemini-2.5-flash-image-edit','gemini-2.5-flash-image','comfy','pil-mid-heal','pil-edge-heal') ORDER BY id) t;"
+    # 2026-05-26 — switched from an exact-match IN() list to prefix matching to END
+    # the recurring "allowlist gap" bug (see the dated patch comments above: every new
+    # fix/variant generator — gemini-2.5-flash-image-smart-fix / -luxe-v2 / -bg-swap /
+    # -regen-reverse, replicate-sdxl-inspired, pil-fix-design, pil-opacity-snap — was
+    # silently dropped from the snapshot until someone added it by hand). Prefix families
+    # cover all current + future variants; 'stub' and other non-design generators stay out.
+    # Public /api/designs still filters on is_published, so this only widens what's eligible.
+    "FROM spoon_all_designs WHERE ("
+    "generator LIKE 'replicate%' OR generator LIKE 'gemini-2.5-flash-image%' "
+    "OR generator LIKE 'pil-%' OR generator IN ('comfy','flux')"
+    ") ORDER BY id) t;"
 )
 
 import re as _re

← e91c2ad refresh_designs_snapshot: catastrophe guard against sparse-P · back to Wallco Ai · deploy: add step 2c to ship guarded refresh_designs_snapshot 7d8a4d5 →