import json,sqlite3,sys
from pathlib import Path
checkout,thread=sys.argv[1:3]
db=sqlite3.connect('file:'+str(Path(checkout)/'.t3/userdata/statev2.sqlite')+'?mode=ro',uri=True)
def rows(table):
 return [json.loads(r[0]) for r in db.execute('select payload_json from '+table+' where thread_id=?',(thread,))]
runs=rows('orchestration_v2_projection_runs')
result={'runCount':len(runs),'restartContinuations':sum('restartContinuationOfRunId' in r for r in runs),'runs':[{'ordinal':r['ordinal'],'status':r['status'],'requestedAt':r['requestedAt'],'completedAt':r.get('completedAt'),'lostBackgroundWork':r.get('restartCancelledBackgroundWork',[])} for r in runs]}
print(json.dumps(result,indent=2))
