import json, pathlib, sqlite3, sys
app = pathlib.Path(sys.argv[1])
connection = sqlite3.connect((app / '.t3/capture-final/userdata/statev2.sqlite').as_uri() + '?mode=ro', uri=True)
rows = connection.execute("select payload_json from orchestration_v2_projection_messages where json_extract(payload_json,'$.text')='Follow up without a mention'").fetchall()
for (payload,) in rows:
 message = json.loads(payload)
 print(json.dumps({'savedText': message['text'], 'savedContextRecords': [{'kind':record['kind'], 'title':record.get('title',record.get('label'))} for record in message.get('context',{}).get('records',[])]}, indent=2))
