#!/usr/bin/env bash
set -u
for db in /opt/struktur/hermes-werkstandard/data/state.db /opt/struktur/hermes-werkstandard/data/kanban.db; do
  echo "DB=$db"
  sqlite3 "file:$db?mode=ro" "select 'sessions',count(*) from sessions;" 2>/dev/null || true
  sqlite3 "file:$db?mode=ro" "select 'messages',count(*) from messages;" 2>/dev/null || true
  sqlite3 "file:$db?mode=ro" "select 'tasks',count(*) from tasks;" 2>/dev/null || true
  sqlite3 "file:$db?mode=ro" "select 'comments',count(*) from task_comments;" 2>/dev/null || true
  sqlite3 "file:$db?mode=ro" "select 'events',count(*) from task_events;" 2>/dev/null || true
  sqlite3 "file:$db?mode=ro" "select 'attachments',count(*) from task_attachments;" 2>/dev/null || true
  sqlite3 "file:$db?mode=ro" "select 'runs',count(*) from task_runs;" 2>/dev/null || true
  sqlite3 "file:$db?mode=ro" "select 'min_created',min(created_at) from sessions;" 2>/dev/null || true
  sqlite3 "file:$db?mode=ro" "select 'max_created',max(created_at) from sessions;" 2>/dev/null || true
  sqlite3 "file:$db?mode=ro" "select 'min_message',min(created_at) from messages;" 2>/dev/null || true
  sqlite3 "file:$db?mode=ro" "select 'max_message',max(created_at) from messages;" 2>/dev/null || true
done
echo 'TOPDIRS'
du -sh /opt/struktur/hermes-werkstandard/data/* 2>/dev/null | sort -h
echo 'COUNTS'
find /opt/struktur/hermes-werkstandard/data -type f | wc -l
find /opt/struktur/hermes-werkstandard/data -type d | wc -l
echo 'DATES'
find /opt/struktur/hermes-werkstandard -type f -printf '%T@ %p\n' 2>/dev/null | sort -n | head -1
find /opt/struktur/hermes-werkstandard -type f -printf '%T@ %p\n' 2>/dev/null | sort -n | tail -1