from PIL import Image,ImageDraw,ImageFont
from pathlib import Path
import json, statistics
p=Path(__file__).parent
rows=[json.loads(x) for x in (p/'output.txt').read_text().splitlines() if x.startswith('{')]
font=ImageFont.truetype('/usr/share/fonts/truetype/dejavu/DejaVuSansMono.ttf',19)
small=ImageFont.truetype('/usr/share/fonts/truetype/dejavu/DejaVuSansMono.ttf',16)
for side,sha in [('before','d6e574f7db'),('after','090953238a')]:
 lines=[side.upper()+' | '+sha,'Linux x86_64 | Node CLI | fresh schema 96','7 runs per condition; all timings in ms','Lock: separate SQLite connection, BEGIN IMMEDIATE','', 'REAL CLI: auth session list']
 for surface in ['CLI','runMigrations']:
  if surface!='CLI': lines+=['','REAL runMigrations() (in-process duration)']
  for mode in ['unlocked','release-at-2s','held-through-return']:
   group=[r for r in rows if (r['side'],r['surface'],r['mode'])==(side,surface,mode)]
   v=[r['ms'] for r in group]
   lines += [mode, '  runs: '+', '.join(f'{x:.2f}' for x in v), f'  median {statistics.median(v):.2f}; range {min(v):.2f}-{max(v):.2f}', '  '+group[0]['outcome'].replace('{"_id":"Result","_tag":"Success","value":[]}','executed=[]')]
 im=Image.new('RGB',(1120,100+len(lines)*29),'#111827');d=ImageDraw.Draw(im)
 for i,line in enumerate(lines): d.text((26,24+i*29),line,font=small if len(line)>85 else font,fill='#e5e7eb')
 im.save(p/(side+'.png'))
