#!/usr/bin/env bash
# Deploy database migrations to the remote MySQL server.
# Uses Node.js deploy.js (reads credentials from ../node/.env)

set -euo pipefail

SCRIPT_DIR="$(cd "$(dirname "${BASH_SOURCE[0]}")" && pwd)"
cd "$SCRIPT_DIR"

if [ ! -f "../node/.env" ]; then
  echo "Error: ../node/.env not found. Create it with DB_HOST, DB_USER, DB_PASSWORD, DB_NAME."
  exit 1
fi

if [ ! -d "node_modules" ]; then
  echo "Installing dependencies..."
  npm install
fi

case "${1:-deploy}" in
  deploy)
    npm run deploy
    ;;
  status)
    npm run status
    ;;
  verify)
    npm run verify
    ;;
  *)
    echo "Usage: ./deploy.sh [deploy|status|verify]"
    exit 1
    ;;
esac