"""Read-only session audit. Snapshot before forking; audit after the follow-up finishes.
Usage: python3 audit-sessions.py snapshot WORKTREE SOURCE_THREAD SNAPSHOT
       python3 audit-sessions.py audit WORKTREE FORK_THREAD SNAPSHOT
Snapshot contains local paths: keep it private. Audit stdout contains synthetic messages only.
"""
import hashlib
import json
from pathlib import Path
import sqlite3
import sys


def digest(path):
    return hashlib.sha256(Path(path).read_bytes()).hexdigest()


def entries(path):
    return [json.loads(line) for line in Path(path).read_text().splitlines()]


def messages(path):
    result = []
    for entry in entries(path):
        message = entry.get('message', {})
        if message.get('role') not in ('user', 'assistant'):
            continue
        content = message.get('content', [])
        text = content if isinstance(content, str) else ''.join(c.get('text', '') for c in content if c.get('type') == 'text')
        if text.startswith('Context handoff ('):
            text = '[portable context handoff]'
        result.append({'id': entry['id'], 'role': message['role'], 'text': text})
    return result


mode, worktree, thread, snapshot = sys.argv[1:]
connection = sqlite3.connect('file:' + str(Path(worktree) / '.t3/userdata/statev2.sqlite') + '?mode=ro', uri=True)
provider_thread = json.loads(connection.execute('select payload_json from orchestration_v2_projection_provider_threads where thread_id=?', (thread,)).fetchone()[0])
current = Path(provider_thread['nativeThreadRef']['nativeId'])
if mode == 'snapshot':
    original = entries(current)[0]['parentSession']
    state = {'original': original, 'newer': str(current), 'sha256': digest(original), 'newerSha256': digest(current), 'filesBeforeFork': [str(p) for p in current.parent.glob('*.jsonl')]}
    Path(snapshot).write_text(json.dumps(state, indent=2))
else:
    state = json.loads(Path(snapshot).read_text())
    original = Path(state['original'])
    newer = Path(state['newer'])
    candidates = sorted(p for p in newer.parent.glob('*.jsonl') if str(p) not in state['filesBeforeFork'])
    related = {str(original), str(newer), str(current)}
    for _ in candidates:
        related.update(str(p) for p in candidates if entries(p)[0].get('parentSession') in related)
    files = [p for p in candidates if str(p) in related]
    names = {str(original): 'original', str(newer): 'newer'}
    names.update({str(p): 'created-' + str(i + 1) for i, p in enumerate(files)})
    def session(path):
        header = entries(path)[0]
        return {'session': names[str(path)], 'parent': names.get(header.get('parentSession'), 'none' if not header.get('parentSession') else 'other'), 'messages': messages(path)}
    original_messages = messages(original)
    final_messages = messages(current)
    turns = [json.loads(row[0]) for row in connection.execute('select payload_json from orchestration_v2_projection_provider_turns where thread_id=? order by ordinal', (state.get('thread', ''),))]
    report = {
        'originalUnchanged': digest(original) == state['sha256'],
        'newerUnchanged': digest(newer) == state['newerSha256'],
        'original': session(original), 'newer': session(newer),
        'createdSessionCount': len(files), 'createdSessions': [session(p) for p in files],
        'finalForkSession': names[str(current)],
        'originalAlphaUserIdPreserved': any(m['id'] == original_messages[0]['id'] for m in final_messages),
        'originalAlphaAssistantIdPreserved': any(m['id'] == original_messages[1]['id'] for m in final_messages),
        'portableHandoff': any(m['text'] == '[portable context handoff]' for m in final_messages),
        'laterWordsInFinalFork': [word for word in ('BRAVO', 'CHARLIE') if any(word in m['text'] for m in final_messages)],
    }
    print(json.dumps(report, indent=2))
