#!/usr/bin/env python3
"""최소 검증판 갤러리 — 샷 6장 + 참조·배경·도면."""
import html
import json
import os
from pathlib import Path
import psycopg2
ROOT = Path("/Users/manta/Documents/Projects/TheRoad-I1")
OUT = ROOT / "artifact" / "20260824_minimal_e2e_scenario" / "index.html"
ST = json.loads((ROOT / "scratchpad" / "minimal_e2e_state.json").read_text())
EID, PID = ST["episode_id"], ST["project_id"]
conn = psycopg2.connect(host="localhost", user="theroad", password="theroad_dev_2026",
dbname="theroad")
cur = conn.cursor()
cur.execute("""
SELECT ia.asset_type, ia.file_path, ss.scene_index, ss.shot_index,
ec.name, ec.entity_type
FROM image_asset ia
LEFT JOIN scene_still ss ON ss.id = ia.still_id
LEFT JOIN entity_canon ec ON ec.id = ia.entity_id
WHERE ia.episode_id = %s
ORDER BY ia.asset_type, ss.scene_index NULLS LAST, ss.shot_index NULLS LAST,
ec.entity_type NULLS LAST, ec.name NULLS LAST
""", (EID,))
rows = cur.fetchall()
cur.execute("""SELECT step_id, status, applicable_count, completed_count, failed_count
FROM step_run WHERE episode_id=%s ORDER BY created_at""", (EID,))
steps = cur.fetchall()
conn.close()
scenario = (ROOT / "artifact" / "20260824_minimal_e2e_scenario" / "골목끝.txt").read_text()
groups: dict[str, list] = {}
for t, fp, sc, sh, nm, et in rows:
groups.setdefault(t, []).append((fp, sc, sh, nm, et))
TITLES = {
"scene": "샷 이미지 — 최종 결과",
"reference": "인물·소품 참조",
"generated": "엔티티 T2I",
"chain_bg": "배경 (실내 체인)",
"bgfirst_bg": "배경 (샷별)",
"place_canon": "실외 장소 캐논",
"conti_light": "콘티",
"lane_marker_map": "차선 마커 맵",
"lane_storyboard_sketch": "차선 스토리보드",
"floor_plan": "실내 도면",
}
ORDER = ["scene", "conti_light", "floor_plan", "chain_bg", "bgfirst_bg",
"place_canon", "lane_marker_map", "lane_storyboard_sketch",
"reference", "generated"]
def rel(fp: str) -> str:
return "../../" + fp.lstrip("/")
def label(sc, sh, nm, et):
if sc is not None:
return f"씬 {sc} · 샷 {sh}"
if nm:
return f"{nm} {et or ''}"
return ""
parts = []
for t in ORDER + [k for k in groups if k not in ORDER]:
items = groups.get(t)
if not items:
continue
parts.append(f'
{html.escape(TITLES.get(t, t))} '
f'{len(items)}장
')
for fp, sc, sh, nm, et in items:
parts.append(
f''
f''
f'{label(sc, sh, nm, et)}')
parts.append("
")
ok = sum(1 for s in steps if s[1] == "completed")
na = sum(1 for s in steps if s[1] == "not_applicable")
zero = [s[0] for s in steps if (s[2] or 0) == 0]
step_rows = "".join(
f"
{html.escape(sid)}
"
f"
{st}
{c}/{a or 0}
{f}
"
for sid, st, a, c, f in steps)
OUT.write_text(f"""
골목 끝 — 최소 검증판