"""
def esc(x) -> str:
return H.escape(str(x if x is not None else ""))
def q(sql: str) -> list[list[str]]:
out = subprocess.run(
["psql", "-h", "localhost", "-U", "theroad", "-d", "theroad",
"-t", "-A", "-F", "\x1f", "-c", sql],
env={"PGPASSWORD": "theroad_dev_2026", "PATH": "/usr/local/bin:/opt/homebrew/bin:/usr/bin:/bin"},
capture_output=True, text=True, check=True)
return [line.split("\x1f") for line in out.stdout.splitlines() if line]
def main() -> None:
rows = q(
"SELECT scene_index, shot_index, coalesce(beat_title,''),"
" coalesce(shot_description,''), coalesce(selected_variant,'')"
f" FROM scene_still WHERE episode_id='{EPI}' AND is_selected=true"
" ORDER BY scene_index, shot_index;")
shots = defaultdict(list)
for si, shi, beat, desc, var in rows:
shots[int(si)].append((int(shi), beat, desc, var))
segs = {s["scene_index"]: s for s in
(json.loads(CP_SAVE.read_text("utf-8")).get("data") or {})
.get("segments", [])}
# 선정 롤(A/B)은 DB selected_variant 가 비어 있어 recipe records 에서
recs = json.loads((ROOT / "projects" / PROJ / "images" / EPI / "scene"
/ "recipe" / "records.json").read_text("utf-8"))
sel_of = {k: v.get("selected") for k, v in recs.items()
if "::" not in k and isinstance(v, dict)}
body = []
for si in sorted(shots):
seg = segs.get(si) or {}
heading = (seg.get("heading") or f"S#{si}.").strip()
title = re.sub(r"^S#\d+\.\s*", "", heading)
text = (seg.get("text") or "").strip()
cnt = len(shots[si])
cells = []
for shi, beat, desc, var in shots[si]:
tag = f"S{si}sh{shi}"
sel = var or sel_of.get(tag) or ""
sel_txt = f" · 선정 롤 {esc(sel)}" if sel else ""
cells.append(
f"
"
f"