#!/usr/bin/env bash
set -euo pipefail
for db in /opt/struktur/hermes-carlo/data/kanban.db.backup_pre_session_lifecycle_20260717T170559Z /opt/struktur/hermes-carlo/data/kanban.db.backup_1780321076; do
  echo "==== $db"
  stat -c '%n %s %U:%G %y' "$db"
  sqlite3 -readonly "$db" "select status,count(*) from tasks group by status order by status;" || true
done
echo HASHES
sha256sum /opt/struktur/hermes-carlo/data/kanban.db /opt/struktur/hermes-carlo/data/kanban.db.backup_pre_kanban_xfer_20260605_175846 /opt/struktur/hermes-carlo/data/kanban.db.backup_pre_strategic_status_fix_20260606_082503 /opt/struktur/hermes-carlo/data/kanban.db.backup_pre_session_lifecycle_20260717T170559Z