# Convert each side's median-run recording to a labelled, real-time PDF-panel capture.
import json,pathlib,statistics,subprocess,shutil,zipfile
from PIL import Image
root=pathlib.Path(__file__).parent
with zipfile.ZipFile(root/'runs.zip') as archive:
 for entry in archive.infolist():
  target=root/'runs'/entry.filename.replace('\\','/')
  target.parent.mkdir(parents=True,exist_ok=True)
  if not entry.is_dir(): target.write_bytes(archive.read(entry))
rows=json.loads((root/'all-results.json').read_text(encoding='utf-8-sig'))
for side,sha in [('base','834eb51301'),('head','abdcc82bcb')]:
 row=sorted([r for r in rows if r['measurement']['side']==side],key=lambda r:r['measurement']['clickToPaintMs'])[2];r=row['measurement'];folder=root/'runs'/row['directory'];vid=next(folder.glob('*.webm'))
 start=max(0,r['videoClickOffsetMs']/1000-2.5);duration=r['clickToPaintMs']/1000+4.5
 filters=f"crop=540:900:900:0,pad=540:980:0:80:color=0x10151e,drawtext=fontfile=/usr/share/fonts/truetype/dejavu/DejaVuSansMono.ttf:text='{side.upper()} {sha} - {r['clickToPaintMs']/1000:.3f} s to paint':x=12:y=12:fontsize=16:fontcolor=white,drawtext=fontfile=/usr/share/fonts/truetype/dejavu/DejaVuSansMono.ttf:text='5 Mbps / 120 ms - Windows Server 2025':x=12:y=43:fontsize=16:fontcolor=white"
 subprocess.run(['ffmpeg','-hide_banner','-loglevel','error','-ss',str(start),'-i',str(vid),'-t',str(duration),'-vf',filters,'-c:v','libx264','-preset','fast','-crf','20','-pix_fmt','yuv420p','-an','-y',str(root/f'{side}.mp4')],check=True)
 Image.open(folder/'painted.png').crop((900,0,1440,900)).save(root/f'{side}-pdf-panel.png')
 subprocess.run(['ffmpeg','-hide_banner','-loglevel','error','-i',str(root/f'{side}.mp4'),'-vf','fps=1/4,scale=270:-1,tile=4x2','-frames:v','1','-y',str(root/f'{side}-filmstrip.jpg')],check=True)
 print(side,'median run',r['run'],'video trimmed at',start,'s; duration',duration,'s')
