import sqlite3, json
db = sqlite3.connect("/var/lib/friend/friend.db")
db.row_factory = sqlite3.Row
cur = db.cursor()
cid = "5263f883-fc50-4920-b592-42fec4c26ced"
rows = cur.execute("SELECT sequence, node_type, role, content FROM chain_nodes WHERE chain_id=? ORDER BY sequence", (cid,)).fetchall()
print("total nodes:", len(rows))
for r in rows:
    c = r["content"] or ""
    if isinstance(c, str) and c[:1] in "{[":
        try:
            obj = json.loads(c)
            c = obj.get("text") or "".join(p.get("text","") for p in (obj.get("parts") or []) if isinstance(p,dict)) or str(obj)[:60]
        except Exception: pass
    c = str(c).replace("\n"," ")[:70]
    print(r["sequence"], r["node_type"], r["role"], "|", c)