Publish 19 clean aztec-kilim designs live (ids 54417-54436, ex 54419 seam-fail)

c334676d70efca4c23a1c3b205c1fdc4de86baab · 2026-05-29 17:19:25 -0700 · Steve

Force-publish SQL (settlement override + curator-force-publish tag) flipped
is_published on the 19 in all_designs + spoon_all_designs on Mac2 and prod PG;
rebuilt designs.json snapshot; shipped via deploy-kamatera.sh. Live grid shows
exactly 19, 54419 stays unpublished/404.

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

Files touched

A scripts/force-publish-aztec-kilim.sql

Diff

commit c334676d70efca4c23a1c3b205c1fdc4de86baab
Author: Steve <steve@designerwallcoverings.com>
Date:   Fri May 29 17:19:25 2026 -0700

    Publish 19 clean aztec-kilim designs live (ids 54417-54436, ex 54419 seam-fail)
    
    Force-publish SQL (settlement override + curator-force-publish tag) flipped
    is_published on the 19 in all_designs + spoon_all_designs on Mac2 and prod PG;
    rebuilt designs.json snapshot; shipped via deploy-kamatera.sh. Live grid shows
    exactly 19, 54419 stays unpublished/404.
    
    Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
---
 scripts/force-publish-aztec-kilim.sql | 27 +++++++++++++++++++++++++++
 1 file changed, 27 insertions(+)

diff --git a/scripts/force-publish-aztec-kilim.sql b/scripts/force-publish-aztec-kilim.sql
new file mode 100644
index 0000000..90132f8
--- /dev/null
+++ b/scripts/force-publish-aztec-kilim.sql
@@ -0,0 +1,27 @@
+-- Force-publish 19 clean Aztec/kilim designs LIVE (Steve explicit approval 2026-05-29: "publish all 19 clean").
+-- Scope is EXACTLY these 19 ids AND category='aztec-kilim'. id 54419 (seam-fail) is intentionally EXCLUDED.
+-- 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 the snapshot builder 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,
+    user_removed    = FALSE,
+    needs_fixing_at = NULL,
+    tags = array_remove(array_remove(COALESCE(tags, ARRAY[]::text[]), 'needs-fixing'), 'digital-file')
+           || ARRAY['curator-force-publish']::text[]
+WHERE id IN (54417,54418,54420,54421,54422,54423,54424,54425,54426,54427,54428,54429,54430,54431,54432,54433,54434,54435,54436)
+  AND category = 'aztec-kilim';
+
+UPDATE spoon_all_designs SET
+    is_published = TRUE,
+    user_removed = FALSE,
+    tags = COALESCE(tags, ARRAY[]::text[]) || ARRAY['curator-force-publish']::text[]
+WHERE id IN (54417,54418,54420,54421,54422,54423,54424,54425,54426,54427,54428,54429,54430,54431,54432,54433,54434,54435,54436)
+  AND category = 'aztec-kilim';
+
+COMMIT;

← cf8fd5d elements bake — recover 4 truncated Round-1 PNGs via targete · back to Wallco Ai · colorways: add admin Publish/Unpublish endpoints for promote a730f34 →