#!/bin/bash
# ============================================================
# E2E Test Database Reset Script
# ============================================================

set -e

# Default values
MYSQL_HOST="${MYSQL_HOST:-192.168.16.251}"
MYSQL_USER="${MYSQL_USER:-cfc}"
MYSQL_PASS="${MYSQL_PASS:-cfc@123}"
MYSQL_DB="${MYSQL_DB:-cfc}"

# Resolve script directory
SCRIPT_DIR="$(cd "$(dirname "${BASH_SOURCE[0]}")" && pwd)"
SEED_FILE="${SCRIPT_DIR}/seed-data.sql"

echo "============================================================"
echo "E2E Database Reset"
echo "============================================================"
echo "Host: ${MYSQL_HOST}"
echo "User: ${MYSQL_USER}"
echo "Database: ${MYSQL_DB}"
echo "Seed file: ${SEED_FILE}"
echo "============================================================"

# Check if seed file exists
if [ ! -f "${SEED_FILE}" ]; then
    echo "[ERROR] Seed file not found: ${SEED_FILE}"
    exit 1
fi

# Execute seed data
echo "[INFO] Executing seed data..."
mysql -h "${MYSQL_HOST}" -u "${MYSQL_USER}" -p"${MYSQL_PASS}" "${MYSQL_DB}" < "${SEED_FILE}"

if [ $? -eq 0 ]; then
    echo "[SUCCESS] Seed data executed successfully"
else
    echo "[ERROR] Failed to execute seed data"
    exit 1
fi

echo "============================================================"
echo "E2E Database Reset Complete"
echo "============================================================"