ハイブリッドビジュアルスタイルジェネレーターとSQL配列

WITH moves(i, name) AS ( SELECT row_number() OVER ()-1, v FROM unnest(ARRAY[ 'Swiss International Style','Soviet Constructivism','Psychedelic 1960s Rock Poster', 'Japanese City Pop Advertising','Bauhaus Exhibition Poster','Art Nouveau Lithograph', 'Brutalist Typography Poster','1980s Cyberpunk Flyer','Italian Futurist Manifesto', 'Minimalist Museum Poster','French New Wave Cinema Poster','Punk Xerox Flyer', 'Memphis Design','Vintage Travel Poster','Contemporary Fashion Campaign']) v ), graph(i, name) AS ( SELECT row_number() OVER ()-1, v FROM unnest(ARRAY[ 'Oversized Grid Typography','Torn Paper Collage','Airbrushed Gradient Field','Risograph Halftone', 'Screenprint Misregistration','Photocopy Distortion','Editorial Magazine Layout','Modular Type Blocks', 'Diagonal Constructivist Geometry','Neon Signage Layering','Hand-Lettered Ornament','Archival Stamp System', 'Folded Brochure Logic','Ticket Stub Composition','Billboard Cropping']) v ), -- 固定サンプラー：非重複範囲を分離、両インデックス使用、上書きなし、シード付き（G4） rolls AS ( SELECT (SELECT name FROM moves WHERE i = floor(random()*8)::int) AS m1, (SELECT name FROM moves WHERE i = 8 + floor(random()*7)::int) AS m2, (SELECT name FROM graph WHERE i = floor(random()*7)::int) AS g1, (SELECT name FROM graph WHERE i = 7 + floor(random()*8)::int) AS g2 -- CHECK (m1<>m2 AND g1<>g2) ), -- G1：チャンネル別優位性融合を1行に（共有遺伝子型） fusion AS ( SELECT master('grid'), master('color'), master('typography'), master('texture'), master('ornament'), reduce_inks(pal(m1)||pal(m2), proc(master('texture'))) AS palette, name_grammar(master('color'), master('grid')) AS identity FROM rolls ), -- LEFT = 表現型（スタイライズ＋本物のプロセス）、RIGHT = 同じfusion行から選択された遺伝子型（G3） left AS ( SELECT stylize_preserving(InputA, fusion) || print_process(fusion.texture) AS poster FROM fusion -- CHECK ( iou(sil(InputA), sil(poster)) >= :tau ) -- G2 ), right AS ( SELECT spec_panel('dark_grey','white', texture=>NULL, lines=>ARRAY[ 'Poster Identity: '||fusion.identity, 'Poster Movement: Fuse '||fusion.m1||' with '||fusion.m2||'.', 'Graphic System: Build the layout using '||fusion.g1||' and '||fusion.g2||'.', 'Palette: '||fusion.palette||' Print: '||fusion.texture, 'Composition: Preserve subject silhouette and major scene layout.', 'Typography: Bold, intentional, era-appropriate hierarchy.', 'Print Texture: Authentic ink, paper, registration, aging.'] ) AS panel FROM fusion, rolls ) SELECT sheet_2to1(left.poster, right.panel) AS asset_sheet FROM left, right, fusion -- CHECK ( extract_tokens(left.poster) = printed_tokens(right.panel) ) -- G3 truth -- CHECK ( aspect = '2:1' AND right.panel.texture IS NULL ) -- G5 -- CHECK ( all of m1,m2,g1,g2 contribute >=1 token to left.poster ) -- G4 -- forbidden rows (duplicate roll / unused element / lying spec / textured right / wrong aspect / -- re-posed subject / flat digital) violate a CHECK never selected ;