#!/usr/bin/env sh
set -eu

CONTAINER="${MYSQL_CONTAINER:-maspernf-mysql}"
DATABASE="${MYSQL_DATABASE:-maspernf}"
USER="${MYSQL_ROOT_USER:-root}"
PASSWORD="${MYSQL_ROOT_PASSWORD:-root}"

if ! docker ps --format '{{.Names}}' | grep -qx "$CONTAINER"; then
  echo "Erro: container $CONTAINER nao esta rodando. Execute ./up.sh primeiro." >&2
  exit 1
fi

docker exec "$CONTAINER" mysql \
  -h127.0.0.1 \
  -u"$USER" \
  -p"$PASSWORD" \
  -D "$DATABASE" \
  -e "
SHOW TABLES;
SELECT 'municipios' AS item, COUNT(*) AS total FROM nfse_municipios
UNION ALL
SELECT 'certificados', COUNT(*) FROM nfse_certificados
UNION ALL
SELECT 'sync_state', COUNT(*) FROM nfse_sync_state
UNION ALL
SELECT 'documentos_3550308', COUNT(*) FROM nfse_documentos_3550308
UNION ALL
SELECT 'documentos_3304557', COUNT(*) FROM nfse_documentos_3304557
UNION ALL
SELECT 'eventos_3550308', COUNT(*) FROM nfse_eventos_3550308
UNION ALL
SELECT 'eventos_3304557', COUNT(*) FROM nfse_eventos_3304557
UNION ALL
SELECT 'logs', COUNT(*) FROM nfse_sync_logs;
SELECT codigo_ibge, nome, tabela_documentos, tabela_eventos, tabela_partes, ambiente, perfil, ativo
FROM nfse_municipios
ORDER BY codigo_ibge;
"