import json
import sqlite3
import sys

connection = sqlite3.connect('file:' + sys.argv[1] + '?mode=ro', uri=True)
result = {}
for table, key in [('subagents', 'tasks'), ('context_transfers', 'transfers'), ('messages', 'messages'), ('runs', 'runs')]:
    result[key] = [
        {key: value[key] for key in ['status', 'type', 'result', 'delegatedCompletion', 'ordinal', 'role'] if key in value}
        for row in connection.execute('select payload_json from orchestration_v2_projection_' + table)
        for value in [json.loads(row[0])]
    ]
print(json.dumps(result, indent=2))
