import json, sqlite3
from pathlib import Path
config = json.loads(Path(".proof-config.json").read_text())
db = sqlite3.connect("file:" + config["database"] + "?mode=ro", uri=True)
row = db.execute("select payload_json from orchestration_v2_projection_provider_threads where thread_id=?", (config["thread"],)).fetchone()
provider = json.loads(row[0])
native = provider["nativeThreadRef"]["nativeId"]
files = list((Path.home()/".claude"/"projects").glob("*/"+native+".jsonl"))
records = [json.loads(line) for line in files[0].read_text().splitlines()]
titles = [r["customTitle"] for r in records if r.get("type")=="custom-title"]
print("Commit:", config["commit"][:10])
print("Native Claude session:", native)
print("Custom-title records:", len(titles))
print("Latest native title:", titles[-1])
for r in records:
    if r.get("type")=="assistant":
        for c in r.get("message",{}).get("content",[]):
            if c.get("type")=="text" and c.get("text") in ["ALPHA","BRAVO","CHARLIE","DELTA","ECHO"]:
                print("Native assistant:", c["text"])