import sqlite3
conn = sqlite3.connect('/opt/friend-cluster/data/friend-cluster-v1.db')
cur = conn.cursor()
# newest decommission command per instance
cur.execute("""SELECT instance_id, id, status, started_at, completed_at, substr(result,1,80) FROM commands
WHERE action='instance.decommission' AND created_at > '2026-08-23T09:10' ORDER BY rowid""")
rows = cur.fetchall()
for r in rows:
    print(r)
print("--- instances still existing ---")
ids = ['friend-fada02e6','friend-33953b97','friend-cf8a5bba','friend-24654384','friend-c2c95ebc','friend-6368a2e7','friend-58aedcb6','friend-7013d01f','friend-c7c66057','friend-c2ffba03','friend-2d8eba0b','friend-dc86d8f3','friend-b45a4c1b']
left = 0
for iid in ids:
    cur.execute("SELECT id FROM friend_instances WHERE id=?", (iid,))
    if cur.fetchone():
        left += 1
print("remaining:", left, "of", len(ids))
conn.close()