#!/usr/bin/env bash
set -euo pipefail
python3 - <<'PY'
import sqlite3
paths=['/opt/struktur/hermes-carlo/data/kanban.db','/opt/struktur/hermes-carlo/data/kanban.db.backup_1780321076','/opt/struktur/hermes-carlo/data/kanban.db.backup_pre_session_lifecycle_20260717T170559Z']
sets=[]
for p in paths:
    c=sqlite3.connect('file:'+p+'?mode=ro',uri=True)
    rows=c.execute('select id,title,status from tasks').fetchall()
    sets.append({r[0]:r for r in rows})
    print(p, 'cards=',len(rows), 'unique_ids=',len(set(r[0] for r in rows)))
print('current_vs_june_overlap',len(set(sets[0]) & set(sets[1])))
print('current_vs_july_overlap',len(set(sets[0]) & set(sets[2])))
print('june_only',len(set(sets[1])-set(sets[0])))
print('july_only',len(set(sets[2])-set(sets[0])))
PY