publish 36 reviewed HC drunk-animals keepers live (settlement-safe per-id, human-reviewed 2026-06-01)

5196d88c8fb98771d18fb9f8a3258add41c79262 · 2026-06-01 07:47:21 -0700 · Steve Abrams

Files touched

A scripts/publish-hc-reviewed-20260601.sql

Diff

commit 5196d88c8fb98771d18fb9f8a3258add41c79262
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Mon Jun 1 07:47:21 2026 -0700

    publish 36 reviewed HC drunk-animals keepers live (settlement-safe per-id, human-reviewed 2026-06-01)
---
 scripts/publish-hc-reviewed-20260601.sql | 47 ++++++++++++++++++++++++++++++++
 1 file changed, 47 insertions(+)

diff --git a/scripts/publish-hc-reviewed-20260601.sql b/scripts/publish-hc-reviewed-20260601.sql
new file mode 100644
index 0000000..735bd0b
--- /dev/null
+++ b/scripts/publish-hc-reviewed-20260601.sql
@@ -0,0 +1,47 @@
+-- Publish reviewed HC drunk-animals keepers (2026-06-01 human-in-the-loop, curator stopped).
+-- Per-id settlement isolation: the settlement_publish_check() trigger fires on the
+-- false->true flip; a prohibited-class row RAISEs and is SKIPPED (NOTICE), not aborting the batch.
+-- NO settlement.allow_override is set — the trigger remains the legal gate.
+DO $$
+DECLARE r record; ok int := 0; skip int := 0;
+BEGIN
+  FOR r IN
+    SELECT id FROM all_designs
+    WHERE 'overnight-review'=ANY(tags) AND is_published=FALSE AND 'overnight-hc'=ANY(tags)
+    ORDER BY id
+  LOOP
+    BEGIN
+      UPDATE all_designs SET is_published=TRUE, web_viewer=TRUE,
+        tags = array_remove(array_remove(array_remove(COALESCE(tags,'{}'),'overnight-review'),'overnight-hc'),'curator-force-publish')
+               || ARRAY['reviewed-keep-live','curator-force-publish']::text[]
+        WHERE id=r.id;
+      ok := ok + 1;
+    EXCEPTION WHEN OTHERS THEN
+      RAISE NOTICE 'SKIP % (settlement/err): %', r.id, SQLERRM;
+      skip := skip + 1;
+    END;
+  END LOOP;
+  RAISE NOTICE 'all_designs published=% skipped=%', ok, skip;
+END $$;
+
+-- Mirror to spoon_all_designs (snapshot source). Same per-id isolation in case it carries the trigger.
+DO $$
+DECLARE r record; ok int := 0; skip int := 0;
+BEGIN
+  FOR r IN
+    SELECT id FROM all_designs WHERE 'reviewed-keep-live'=ANY(tags) AND is_published=TRUE
+    AND id IN (SELECT id FROM spoon_all_designs)
+  LOOP
+    BEGIN
+      UPDATE spoon_all_designs SET is_published=TRUE,
+        tags = array_remove(array_remove(array_remove(COALESCE(tags,'{}'),'overnight-review'),'overnight-hc'),'curator-force-publish')
+               || ARRAY['reviewed-keep-live','curator-force-publish']::text[]
+        WHERE id=r.id;
+      ok := ok + 1;
+    EXCEPTION WHEN OTHERS THEN
+      RAISE NOTICE 'SKIP spoon % : %', r.id, SQLERRM;
+      skip := skip + 1;
+    END;
+  END LOOP;
+  RAISE NOTICE 'spoon_all_designs published=% skipped=%', ok, skip;
+END $$;

← 1c8294c TODO: mark BLEED_GHOST triage done (7875 cohort, 850 contrad · back to Wallco Ai · generator_tick: retry psql on boot-race PG-socket-not-ready 6250128 →