Force-publish 190 clean drunk-animals from 5/29 to live (Steve approval: clean-only, excluded 32 user_removed)

167dee0183a30274be7d2f08e9bebb84eb5741c3 · 2026-05-30 12:29:36 -0700 · Steve Abrams

Files touched

A scripts/force-publish-drunk-animals-0529.sql

Diff

commit 167dee0183a30274be7d2f08e9bebb84eb5741c3
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Sat May 30 12:29:36 2026 -0700

    Force-publish 190 clean drunk-animals from 5/29 to live (Steve approval: clean-only, excluded 32 user_removed)
---
 scripts/force-publish-drunk-animals-0529.sql | 34 ++++++++++++++++++++++++++++
 1 file changed, 34 insertions(+)

diff --git a/scripts/force-publish-drunk-animals-0529.sql b/scripts/force-publish-drunk-animals-0529.sql
new file mode 100644
index 0000000..4ef3c16
--- /dev/null
+++ b/scripts/force-publish-drunk-animals-0529.sql
@@ -0,0 +1,34 @@
+-- Force-publish the 190 CLEAN drunk-animals designs created 2026-05-29 (Steve explicit approval
+-- 2026-05-30: "publish all skus from 5/29" → chose "the 190 clean only").
+-- Scope is EXACTLY: created 2026-05-29, category='drunk-animals', currently unpublished,
+-- NOT user_removed, NOT needs-fixing. The 32 user_removed (30 also needs-fixing) are INTENTIONALLY
+-- EXCLUDED (Steve declined the resurrection). SET LOCAL settlement.allow_override bypasses the PG
+-- settlement_publish_check() trigger that would otherwise silently no-op the is_published flip.
+-- Writes BOTH all_designs (curator state) and spoon_all_designs (the table refresh_designs_snapshot.py
+-- reads → the live catalog). The curator-force-publish tag exempts the rows from server.js
+-- loadDesigns() passesAestheticGate() drop at snapshot load.
+BEGIN;
+SET LOCAL settlement.allow_override = 'true';
+
+UPDATE all_designs SET
+    is_published = TRUE,
+    web_viewer   = TRUE,
+    tags = COALESCE(tags, ARRAY[]::text[]) || ARRAY['curator-force-publish']::text[],
+    notes = COALESCE(notes,'') || ' | curator-force-publish drunk-animals 5/29 (Steve 2026-05-30)'
+WHERE created_at::date = '2026-05-29'
+  AND category = 'drunk-animals'
+  AND is_published = FALSE
+  AND user_removed = FALSE
+  AND needs_fixing_at IS NULL;
+
+UPDATE spoon_all_designs s SET
+    is_published = TRUE,
+    user_removed = FALSE,
+    tags = COALESCE(s.tags, ARRAY[]::text[]) || ARRAY['curator-force-publish']::text[]
+FROM all_designs a
+WHERE s.id = a.id
+  AND a.created_at::date = '2026-05-29'
+  AND a.category = 'drunk-animals'
+  AND 'curator-force-publish' = ANY(a.tags);
+
+COMMIT;

← c0ef0e8 security-monitor.sh: add cron + service-unit drift checks · back to Wallco Ai · Fix /designs grid: accept ?category= as alias for ?cat= b47680d →