#!/usr/bin/env bash
# Production vitrin seed — database/optional_vitrin_production_seed.sql
# Purge sonrası aynı oturumda çalıştırın.
#   FAUNAMIX_ENV_FILE=api/.env.railway ./scripts/run-vitrin-production-seed.sh
set -euo pipefail

ROOT="$(cd "$(dirname "$0")/.." && pwd)"
ENV_FILE="${FAUNAMIX_ENV_FILE:-$ROOT/api/.env}"
SQL_FILE="$ROOT/database/optional_vitrin_production_seed.sql"

if [[ ! -f "$ENV_FILE" ]]; then
  echo "Env dosyası yok: $ENV_FILE" >&2
  exit 1
fi
if [[ ! -f "$SQL_FILE" ]]; then
  echo "SQL dosyası yok: $SQL_FILE" >&2
  exit 1
fi

set -a
# shellcheck disable=SC1090
source "$ENV_FILE"
set +a

: "${DB_HOST:?DB_HOST}"
: "${DB_USER:?DB_USER}"
: "${DB_PASS:?DB_PASS}"
: "${DB_NAME:?DB_NAME}"

echo "==> Hedef: $DB_NAME @ $DB_HOST:${DB_PORT:-3306}"
echo "==> Production vitrin seed uygulanıyor..."

mysql --connect-timeout=30 \
  -h "$DB_HOST" -P "${DB_PORT:-3306}" -u "$DB_USER" -p"$DB_PASS" --protocol=TCP "$DB_NAME" \
  --init-command="SET SESSION net_read_timeout=600; SET SESSION net_write_timeout=600;" \
  < "$SQL_FILE"

echo "==> Route sync..."
FAUNAMIX_ENV_FILE="$ENV_FILE" php "$ROOT/scripts/sync-vitrin-routes-cli.php"

echo "==> Tamam. Doğrulama:"
echo "  FAUNAMIX_ENV_FILE=$ENV_FILE php scripts/verify-catalog-launch-ready.php"
echo "  FAUNAMIX_SITE_URL=https://www.faunamix.com ./scripts/run-iyzico-preapply-gate.sh"