import sqlite3, json
con = sqlite3.connect("/var/lib/friend/friend.db")
cur = con.cursor()
cur.execute("SELECT sequence, content FROM chain_nodes WHERE node_type='transmission' ORDER BY sequence DESC LIMIT 3")
for seq, content in cur.fetchall():
    try:
        d = json.loads(content)
        print("seq=", seq, "keys=", list(d.keys()) if isinstance(d, dict) else type(d))
        print("  ", str(content)[:300])
    except Exception as e:
        print("seq=", seq, "raw:", str(content)[:200])