import json, sqlite3, pathlib, sys
import argparse
parser=argparse.ArgumentParser()
parser.add_argument('--side',required=True,choices=['before','after'])
parser.add_argument('--transcript',required=True,type=pathlib.Path)
parser.add_argument('--database',required=True,type=pathlib.Path)
parser.add_argument('--output-dir',required=True,type=pathlib.Path)
args=parser.parse_args()
side=args.side
root=args.output_dir
root.mkdir(parents=True,exist_ok=True)
transcript=args.transcript
session=transcript.stem
db=sqlite3.connect(f'file:{args.database}?mode=ro',uri=True)
items=[]
for line in transcript.read_text().splitlines():
 d=json.loads(line)
 if d.get('type') in ('user','assistant'):
  content=d.get('message',{}).get('content','')
  if isinstance(content,list): content='\n'.join(c.get('text','') for c in content if c.get('type')=='text')
  if content: items.append({'role':d['type'],'text':content})
providers=[json.loads(r[0]) for r in db.execute('select payload_json from orchestration_v2_projection_provider_threads')]
matching=[p for p in providers if (p.get('nativeThreadRef') or {}).get('nativeId')==session]
handoffs=[{'strategy':r[0],'status':r[1]} for r in db.execute('select strategy,status from orchestration_v2_projection_context_handoffs')]
result={'side':side,'commit':'5552f0aa74b1cdc0606b86374d4312c42e3b117a' if side=='before' else '9af32f53831959df52221739e88699799aa04707','sameNativeSession':bool(matching),'handoffs':handoffs,'nativeMessages':items,'originalPromptOccurrences':sum(i['text'].count('Remember the code word PELICAN. Reply only OK.') for i in items if i['role']=='user')}
(root/f'{side}-runtime.json').write_text(json.dumps(result,indent=2)+'\n')
lines=[f"{side.upper()} - {result['commit'][:10]}",'Real T3 web app + Claude Haiku 5.5; fresh app database',f"Resumed original native session: {bool(matching)}",f"Context handoffs: {json.dumps(handoffs)}",f"Original prompt occurrences in native user messages: {result['originalPromptOccurrences']}",'','Native transcript (message text only):']
for idx,item in enumerate(items,1):
 lines += [f"\n{idx}. {item['role'].upper()}",item['text']]
(root/f'{side}-runtime.txt').write_text('\n'.join(lines)+'\n')
print('\n'.join(lines))
