#!/usr/bin/env bash
# Apply pending MySQL migrations (database/migrations/*.sql).
# Uses schema_migrations.version tracking — safe to re-run.
#
# Usage:
#   bash scripts/run-db-migrations.sh
#   bash scripts/run-db-migrations.sh --status
set -euo pipefail

ROOT="$(cd "$(dirname "$0")/.." && pwd)"

[[ -f "$ROOT/node/.env" ]] || { echo "Error: node/.env not found" >&2; exit 1; }

cd "$ROOT/database"
if [[ ! -d node_modules/mysql2 ]]; then
  npm ci --omit=dev --silent
fi

node deploy.js "$@"