#!/usr/bin/env bash
set -Eeuo pipefail

APP_ENV="${1:-/var/www/html/smart/.env}"
MYSQL_CNF="$(mktemp /run/smartplus-mysql.XXXXXX.cnf)"
trap 'rm -f "$MYSQL_CNF"' EXIT
chmod 600 "$MYSQL_CNF"

env_value() {
    grep -E "^$1=" "$APP_ENV" | cut -d= -f2- | tr -d '\r'
}

cat > "$MYSQL_CNF" <<EOF
[client]
host=$(env_value DB_HOST)
port=$(env_value DB_PORT)
user=$(env_value DB_USERNAME)
password=$(env_value DB_PASSWORD)
EOF

mysql --defaults-extra-file="$MYSQL_CNF" -NBe \
  "SELECT SCHEMA_NAME FROM information_schema.SCHEMATA ORDER BY SCHEMA_NAME"

echo '--- smart database sizes (MiB) ---'
mysql --defaults-extra-file="$MYSQL_CNF" -NBe \
  "SELECT table_schema, ROUND(SUM(data_length+index_length)/1024/1024,1) FROM information_schema.tables WHERE table_schema LIKE 'smart%' GROUP BY table_schema ORDER BY table_schema"