import json, pathlib, re, sqlite3, sys
checkout = pathlib.Path(sys.argv[1]).resolve()
workspace = pathlib.Path(sys.argv[2]).resolve()
side = sys.argv[3]
root = checkout / '.t3/userdata/providers/antigravity'
records = []
for profile in root.iterdir():
    for database in (profile / 'antigravity-acp/conversations').glob('*.db'):
        db = sqlite3.connect(f'file:{database}?mode=ro', uri=True)
        steps = db.execute('select idx, step_type, step_payload from steps order by idx').fetchall()
        for idx, kind, payload in steps:
            if kind != 14 or not payload:
                continue
            match = re.search(rb'<user_request>(.*?)</user_request>', payload, re.S)
            if not match or not any(name in match[1] for name in [b'$zebra-ritual', b'$otter-handshake']):
                continue
            request = match[1].decode().strip()
            request = request.replace(str(workspace), '<project>').replace(str(profile), '<instance-profile>')
            records.append({'user_request': request, 'native_tool_execution_steps': sum(k == 132 for _, k, _ in steps)})
cache = json.loads((checkout / '.t3/caches/antigravity.json').read_text())
print(json.dumps({'side': side, 'commit': __import__('subprocess').check_output(['git','-C',str(checkout),'rev-parse','HEAD'],text=True).strip(), 'source': 'Read-only extraction of user_request from Antigravity native conversation SQLite step_payload; only absolute project/profile paths replaced with placeholders.', 'runtime_version': cache['version'], 'auth': cache['auth'], 'native_slash_commands': [x['name'] for x in cache['slashCommands'] if x['name'] in ['zebra-ritual','otter-handshake']], 'turns': sorted(records, key=lambda x:x['user_request'])}, indent=2))
