#!/usr/bin/env bash
# Aplica migrations/001_initial.sql no banco leadb2b_app.
# Requer cliente mysql e variáveis APP_DB_* ou STATS_DB_* no .env.
set -euo pipefail
cd "$(dirname "$0")/.."
if [ -f .env ]; then set -a; source .env; set +a; fi
HOST="${APP_DB_HOST:-${STATS_DB_HOST:-}}"
USER="${APP_DB_USER:-${STATS_DB_USER:-}}"
PASS="${APP_DB_PASS:-${STATS_DB_PASS:-}}"
PORT="${APP_DB_PORT:-${STATS_DB_PORT:-3306}}"
if [ -z "$HOST" ] || [ -z "$USER" ]; then
  echo "Defina APP_DB_HOST/APP_DB_USER ou STATS_DB_* no .env" >&2
  exit 1
fi
mysql -h "$HOST" -P "$PORT" -u "$USER" -p"$PASS" < migrations/001_initial.sql
echo "Migration aplicada."