#!/usr/bin/env bash
# run_migrations.sh
# Ejecuta las migraciones SQL en la base de datos indicada.

set -euo pipefail

DB_HOST=${1:-${DB_HOST:-localhost}}
DB_USER=${2:-${DB_USER:-root}}
DB_PASS=${3:-${DB_PASS:-}}
DB_NAME=${4:-${DB_NAME:-consultarutdb}}

SQL_DIR="$(dirname "$0")"

echo "Host: $DB_HOST | User: $DB_USER | DB: $DB_NAME"

if ! command -v mysql >/dev/null 2>&1; then
  echo "mysql client no encontrado. Instala mysql-client o usa otro método." >&2
  exit 1
fi

echo "Ejecutando: 001_create_password_resets_table.sql"
mysql -h "$DB_HOST" -u "$DB_USER" -p"$DB_PASS" "$DB_NAME" < "$SQL_DIR/001_create_password_resets_table.sql"

echo "Mostrando CREATE TABLEs (por verificación):"
mysql -h "$DB_HOST" -u "$DB_USER" -p"$DB_PASS" -D "$DB_NAME" -e "$(cat "$SQL_DIR/check_tables.sql")"

echo "Listo."