stage orphan-reclaim SQL for seeds 1703852405 + 1320598381 (classifier-gated, Steve runs)

1d38efd6b2da52fbb94b80908730d8b592ff1266 · 2026-06-09 12:15:11 -0700 · Steve Abrams

Files touched

A scripts/orphan-reclaim-20260609.sql

Diff

commit 1d38efd6b2da52fbb94b80908730d8b592ff1266
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Tue Jun 9 12:15:11 2026 -0700

    stage orphan-reclaim SQL for seeds 1703852405 + 1320598381 (classifier-gated, Steve runs)
---
 scripts/orphan-reclaim-20260609.sql | 38 +++++++++++++++++++++++++++++++++++++
 1 file changed, 38 insertions(+)

diff --git a/scripts/orphan-reclaim-20260609.sql b/scripts/orphan-reclaim-20260609.sql
new file mode 100644
index 0000000..033a8b5
--- /dev/null
+++ b/scripts/orphan-reclaim-20260609.sql
@@ -0,0 +1,38 @@
+-- Orphan reclaim, Steve-approved 2026-06-09 ("go").
+-- Stages 2 visually-clean gate-orphans as is_published=FALSE rows so they enter
+-- the normal curator + settlement flow. NO auto-publish. The settlement insert
+-- trigger still rules on INSERT (fail-closed — a rejection here is the gate's answer).
+-- Skipped deliberately: seed 2120808514 (patch-compositing defect), seed
+-- 638119258 (garbled AI text on the beverage can) — both correctly rejected.
+-- Run: cd ~/Projects/wallco-ai && set -a && . ./.env && set +a && psql "$DATABASE_URL" -f scripts/orphan-reclaim-20260609.sql
+
+BEGIN;
+
+WITH ins AS (
+  INSERT INTO all_designs (brand, kind, width_in, height_in, generator, prompt, seed, local_path, category, is_published, notes)
+  VALUES ('wallco.ai','seamless_tile',24,24,'comfy',
+    'Formal heritage damask, flowing white scroll foliage on black ground (reconstructed — orphan reclaim; original prompt from damask-loop batch-4 2026-06-04)',
+    1703852405,
+    '/Users/stevestudio2/Projects/wallco-ai/data/generated/1780592743886_1703852405.png',
+    'damask', FALSE,
+    'orphan-reclaim 2026-06-09: generated Jun 4 batch-4, gate-rejected at gen time (strict seamless tolerance), visually clean — staged for curator review. Steve-approved reclaim.')
+  RETURNING id
+)
+UPDATE all_designs SET image_url = '/designs/img/by-id/' || ins.id FROM ins WHERE all_designs.id = ins.id;
+
+WITH ins AS (
+  INSERT INTO all_designs (brand, kind, width_in, height_in, generator, prompt, seed, local_path, category, is_published, notes)
+  VALUES ('wallco.ai','seamless_tile',24,24,'comfy',
+    'Drunk animals line: sloth sipping a tropical cocktail inside a stemmed glass, tonal sepia screen-print (reconstructed — orphan reclaim; tick run 2026-06-03 11:22)',
+    1320598381,
+    '/Users/stevestudio2/Projects/wallco-ai/data/generated/1780510863396_1320598381.png',
+    'drunk-animals', FALSE,
+    'orphan-reclaim 2026-06-09: generated Jun 3, pipeline died before insert (timeout/gate), visually clean — staged for curator review. Steve-approved reclaim.')
+  RETURNING id
+)
+UPDATE all_designs SET image_url = '/designs/img/by-id/' || ins.id FROM ins WHERE all_designs.id = ins.id;
+
+COMMIT;
+
+-- verify:
+-- SELECT id, seed, category, is_published, image_url FROM all_designs WHERE seed IN (1703852405,1320598381);

← 8ccb0d0 drunk tick: raise generator timeout 4->12 min — 4 min SIGTER · back to Wallco Ai · Harden refresh_designs_snapshot.py summary print against Non ff8c30c →