#!/usr/bin/env bash
# CI / yerel integration test için minimal şema.
set -euo pipefail

ROOT="$(cd "$(dirname "$0")/.." && pwd)"
DB_HOST="${DB_HOST:-127.0.0.1}"
DB_PORT="${DB_PORT:-3306}"
DB_NAME="${DB_NAME:-faunamix_test}"
DB_USER="${DB_USER:-root}"
DB_PASS="${DB_PASS:-}"

mysql_args=(--host="$DB_HOST" --port="$DB_PORT" --protocol=TCP --user="$DB_USER" --default-character-set=utf8mb4)
if [[ -n "$DB_PASS" ]]; then
  export MYSQL_PWD="$DB_PASS"
fi

run_sql_file() {
  local file="$1"
  echo "[ci-db] $(basename "$file")"
  mysql "${mysql_args[@]}" "$DB_NAME" <"$file"
}

echo "[ci-db] Veritabani: $DB_NAME @ $DB_HOST:$DB_PORT"
mysql "${mysql_args[@]}" -e "CREATE DATABASE IF NOT EXISTS \`$DB_NAME\` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;"

SQL_FILES=(
  "$ROOT/database/schema.sql"
  "$ROOT/database/admin_auth.sql"
  "$ROOT/database/migration_ecommerce.sql"
  "$ROOT/database/migration_shop_sessions.sql"
  "$ROOT/database/migration_commerce_facets_wishlist_customers.sql"
  "$ROOT/database/migration_commerce_checkout_legal_related_variants.sql"
  "$ROOT/database/migration_product_management.sql"
  "$ROOT/database/migration_rum_web_vitals_events.sql"
  "$ROOT/database/migration_rum_rollup_daily.sql"
)

for f in "${SQL_FILES[@]}"; do
  if [[ -f "$f" ]]; then
    run_sql_file "$f"
  else
    echo "[ci-db] atlandi (yok): $f" >&2
  fi
done

echo "[ci-db] Bootstrap tamam"