← back to Wallco Ai
fliepaper-bugs: DB seed — mp_collections row + fliepaper_bugs_cells (36 cells)
4bc156134f4376db11e2af255d33d832e148d283 · 2026-05-13 16:48:00 -0700 · Steve
Files touched
A sql/fliepaper-bugs-seed.sql
Diff
commit 4bc156134f4376db11e2af255d33d832e148d283
Author: Steve <steve@designerwallcoverings.com>
Date: Wed May 13 16:48:00 2026 -0700
fliepaper-bugs: DB seed — mp_collections row + fliepaper_bugs_cells (36 cells)
---
sql/fliepaper-bugs-seed.sql | 95 +++++++++++++++++++++++++++++++++++++++++++++
1 file changed, 95 insertions(+)
diff --git a/sql/fliepaper-bugs-seed.sql b/sql/fliepaper-bugs-seed.sql
new file mode 100644
index 0000000..631d39b
--- /dev/null
+++ b/sql/fliepaper-bugs-seed.sql
@@ -0,0 +1,95 @@
+-- fliepaper-bugs collection seed
+-- 6 luxury insect patterns × 6 Gucci-coord colorways = 36 cells.
+-- Container only — yolo-runner inserts spoon_all_designs rows as art lands.
+-- Steve-owned, brand_reference=Gucci, NEVER touch Shopify from this seed.
+
+BEGIN;
+
+-- ── 1. Wallco House designer (Steve's in-house designer used for owned-by-steve collections).
+INSERT INTO mp_designer_profiles (display_name, slug, studio_name, bio, is_claimed, is_verified, is_founding, status, commission_rate)
+SELECT 'Wallco House', 'wallco-house',
+ 'Wallco House Studio',
+ 'Wallco-owned editorial collections. Designed in-house, generated via proprietary Wallco AI design system.',
+ TRUE, TRUE, TRUE, 'approved', 0.00
+ WHERE NOT EXISTS (SELECT 1 FROM mp_designer_profiles WHERE slug='wallco-house');
+
+-- ── 2. Collection container.
+INSERT INTO mp_collections (designer_id, title, slug, description, status, featured)
+SELECT d.id,
+ 'Fliepaper Bugs — Gucci Resort Edition',
+ 'fliepaper-bugs',
+ 'Six luxury insect wallcoverings — scarab, luna moth, dragonfly, stag beetle, honeybee, firefly — in six Gucci-resort colorways. 36 SKUs, Steve-owned, brand_reference Gucci. Patterns generated through Wallco AI.',
+ 'published', TRUE
+ FROM mp_designer_profiles d
+ WHERE d.slug='wallco-house'
+ AND NOT EXISTS (SELECT 1 FROM mp_collections WHERE slug='fliepaper-bugs');
+
+-- ── 3. Cell tracking table. One row per pattern×colorway = 36 rows.
+-- Status drives the admin grid and the placeholder-vs-real swap on the public page.
+-- design_id (when set) FK-links to spoon_all_designs.id once art lands; nullable while PENDING.
+CREATE TABLE IF NOT EXISTS fliepaper_bugs_cells (
+ id bigserial PRIMARY KEY,
+ collection_slug text NOT NULL DEFAULT 'fliepaper-bugs',
+ pattern_slug text NOT NULL,
+ pattern_name text NOT NULL,
+ bug text NOT NULL,
+ scale text NOT NULL,
+ composition text NOT NULL,
+ colorway_slug text NOT NULL,
+ colorway_name text NOT NULL,
+ colorway_hex text NOT NULL,
+ colorway_role text NOT NULL,
+ gucci_ref text NOT NULL,
+ status text NOT NULL DEFAULT 'PENDING'
+ CHECK (status IN ('PENDING','GENERATED','SETTLEMENT_BLOCKED','FAILED')),
+ design_id bigint REFERENCES spoon_all_designs(id) ON DELETE SET NULL,
+ thumbnail_url text,
+ last_error text,
+ regen_count integer NOT NULL DEFAULT 0,
+ generated_at timestamptz,
+ settlement_verdict jsonb,
+ owned_by_steve boolean NOT NULL DEFAULT TRUE,
+ brand_reference text NOT NULL DEFAULT 'Gucci',
+ created_at timestamptz NOT NULL DEFAULT now(),
+ updated_at timestamptz NOT NULL DEFAULT now(),
+ UNIQUE (collection_slug, pattern_slug, colorway_slug)
+);
+
+CREATE INDEX IF NOT EXISTS idx_fliepaper_status ON fliepaper_bugs_cells(status);
+CREATE INDEX IF NOT EXISTS idx_fliepaper_collection ON fliepaper_bugs_cells(collection_slug);
+CREATE INDEX IF NOT EXISTS idx_fliepaper_design ON fliepaper_bugs_cells(design_id);
+
+-- ── 4. Seed 36 cells (idempotent via UNIQUE).
+-- 6 patterns × 6 colorways. Patterns and palette from data/fliepaper-bugs/spec.json.
+WITH patterns(slug, name, bug, scale, composition) AS (VALUES
+ ('scarab-reverie', 'Scarab Reverie', 'scarab beetle','medium-trellis', 'Diamond trellis with iridescent gilt scarab beetles at every ogival intersection; jade ground, metallic gilt finish, GG Supreme Egyptian register'),
+ ('luna-moth-nocturne', 'Luna Moth Nocturne', 'luna moth', 'large-statement', 'Oversized luna moths in full wingspan, wings watercolor-layered celadon-to-cream-to-blush, midnight ground, botanical frond negative-space fill, Cole & Son Fornasetti register'),
+ ('dragonfly-lacquer', 'Dragonfly Lacquer', 'dragonfly', 'small-allover', 'Densely tossed dragonflies at 45° angles, lacquer-glossed bodies, stained-glass cell wings, Meiji japonisme meets Gucci Resort SS2019'),
+ ('stag-beetle-cabinet', 'Stag Beetle Cabinet', 'stag beetle', 'large-statement', 'Wunderkammer natural-history-plate composition, monumental stag beetle centered on papyrus cream, symmetrical botanical specimens flanking, engraved-illustration linework, Schumacher Audubon register'),
+ ('bee-damask', 'Bee Damask', 'honeybee', 'medium-trellis', 'Napoleonic bee as ogival damask medallion fill, honeycomb geometry as lattice spine, reads formal damask at distance, reveals entomology on close inspection'),
+ ('firefly-nocturne', 'Firefly Nocturne', 'firefly', 'medium-trellis', 'Fireflies as luminous hand-painted gold-leaf dots in loose trellis rhythm on deep navy, bioluminescent trail accents, Schumacher Nuit de Feu register')
+),
+palette(slug, name, hex, role, gucci_ref) AS (VALUES
+ ('emerald-marmont', 'Emerald Marmont', '#0F4F38', 'ground', 'GG Marmont velvet emerald'),
+ ('papyrus-archive', 'Papyrus Archive', '#EDE0C4', 'ground/figure', 'GG Supreme canvas natural'),
+ ('midnight-flora', 'Midnight Flora', '#1A1F3C', 'ground', 'Gucci FW2020 velvet midnight navy'),
+ ('antique-horsebit', 'Antique Horsebit', '#B8914A', 'accent/figure', 'Horsebit hardware antique gold'),
+ ('deep-plum-dionysus', 'Deep Plum Dionysus', '#3D1F52', 'ground/figure', 'Dionysus suede deep violet'),
+ ('oxblood-flora', 'Oxblood Flora', '#6B1F1F', 'figure/accent', 'Gucci signature red leather SS2018')
+)
+INSERT INTO fliepaper_bugs_cells (
+ collection_slug, pattern_slug, pattern_name, bug, scale, composition,
+ colorway_slug, colorway_name, colorway_hex, colorway_role, gucci_ref
+)
+SELECT 'fliepaper-bugs', p.slug, p.name, p.bug, p.scale, p.composition,
+ c.slug, c.name, c.hex, c.role, c.gucci_ref
+ FROM patterns p CROSS JOIN palette c
+ON CONFLICT (collection_slug, pattern_slug, colorway_slug) DO NOTHING;
+
+COMMIT;
+
+-- Sanity:
+SELECT COUNT(*) AS cells, COUNT(DISTINCT pattern_slug) AS patterns,
+ COUNT(DISTINCT colorway_slug) AS colorways
+ FROM fliepaper_bugs_cells
+ WHERE collection_slug='fliepaper-bugs';
← e916bd4 wallco: gucci brand-reference viewer + fliepaper-bugs spec.j
·
back to Wallco Ai
·
fliepaper-bugs: collection page + admin grid HTML (placehold 8e4960d →