import sqlite3,json,sys
from pathlib import Path
checkout=Path(sys.argv[1]); side=sys.argv[2]; out=Path(sys.argv[3])
c=sqlite3.connect('file:'+str(checkout/'.t3/userdata/statev2.sqlite')+'?mode=ro',uri=True)
def rows(table): return [json.loads(r[0]) for r in c.execute('select payload_json from '+table)]
turns=rows('orchestration_v2_projection_provider_turns')
items=rows('orchestration_v2_projection_turn_items')
result={'side':side,'commit':sys.argv[4], 'method':'Real development server, fresh isolated home; ACP subprocess fixtures configured as source=local; read-only capture of persisted projection records.'}
result['glm']=[{'status':x['status'],'turnTokenUsage':x.get('turnTokenUsage')} for x in turns if 'provider-instance%3Aglm%3A' in x['id']]
result['droid']=[{'type':x['type'],'status':x['status'],**{k:x[k] for k in ['questions','answers','text'] if k in x}} for x in items if 'provider-instance%3Adroid%3A' in (x.get('providerTurnId') or '')]
result['vibe']=[{'type':x['type'],'status':x['status'],**{k:x[k] for k in ['title','failure','detail','text'] if k in x}} for x in items if 'provider-instance%3Avibe-acp%3A' in (x.get('providerTurnId') or '')]
out.write_text(json.dumps(result,indent=2)+'\n')
print(out.name)
