"""Read only the synthetic reproduction database; print retry/run outcome events.
Usage: python3 summarize.py /path/to/checkouts/own/statev2.sqlite
"""
import sqlite3,json,sys
c=sqlite3.connect('file:'+sys.argv[1]+'?mode=ro',uri=True)
for ts,kind,raw in c.execute("select occurred_at,event_type,payload_json from orchestration_events order by sequence"):
    d=json.loads(raw)
    if kind=='turn-item.updated' and d.get('type')=='error':
        print(json.dumps({'time':ts,'event':kind,'title':d.get('title'),'status':d.get('status'),'failure':d.get('failure'),'retry':d.get('retry')}))
    elif kind in ['run.updated','provider-turn.updated']:
        print(json.dumps({'time':ts,'event':kind,'status':d.get('status')}))