import json,sqlite3,sys,datetime,pathlib
home=pathlib.Path('.t3/scenarios/userdata')
c=sqlite3.connect('file:'+str(home/'statev2.sqlite')+'?mode=ro',uri=True)
events=[]
for at,kind,raw in c.execute("select occurred_at,event_type,payload_json from orchestration_events where event_type in ('thread.pull-request-synced','thread.pull-request-link-updated','run.updated') order by sequence"):
    p=json.loads(raw)
    if kind=='run.updated':
        events.append({'at':at,'kind':kind,'ordinal':p.get('ordinal'),'status':p.get('status')})
        continue
    links=p.get('pullRequests',[]) if kind=='thread.pull-request-synced' else [p]
    for link in links:
        watch=link.get('watch')
        if watch:
            events.append({'at':at,'kind':kind,'checksState':(link.get('snapshot') or {}).get('checksState'),'watch':{k:watch.get(k) for k in ['checksPending','awaitingBaseline','failedChecks','wakes']}})
spans=[]
for line in (home/'logs/server.trace.ndjson').read_text().splitlines():
    s=json.loads(line)
    if s.get('name') in ['PullRequestsToolkit.setWatching','PullRequestWatchReactor.readOnChange','PullRequestWatchReactor.record','PullRequestWatchReactor.sweep']:
        spans.append({k:s[k] for k in ['name','startTimeUnixNano','endTimeUnixNano','durationMs','exit'] if k in s})
result={'events':events,'spans':spans}
pathlib.Path(sys.argv[1]).write_text(json.dumps(result,indent=2))
print('Saved sanitized runtime transcript,',len(events),'events and',len(spans),'spans')
