#!/bin/bash
# fixture DB에 덤프 적용하는 스크립트
# Usage: pnpm seed

load_dotenv() {
  if [ -f "$1" ]; then
    set -a
    source "$1"
    set +a
  fi
}

load_dotenv .env
load_dotenv .env.test
load_dotenv .env.local

set -e # 에러 발생 시 즉시 중단

BASE_NAME=$(echo "${PROJECT_NAME:-sonamu}" | tr '[:upper:]' '[:lower:]' | sed -E 's/[^a-z0-9]+/_/g; s/^_+//; s/_+$//')
SOURCE_DB="${SONAMU_DB_NAME:-${BASE_NAME}_test}"
FIXTURE_DB="${SONAMU_DB_FIXTURE_NAME:-${BASE_NAME}_fixture}"
DUMP_FILE="database/dumps/${SOURCE_DB}_latest.sql"

# DB 설정 (환경변수 또는 기본값)
DB_HOST="${SONAMU_DB_FIXTURE_HOST:-${SONAMU_DB_HOST:-0.0.0.0}}"
DB_PORT="${SONAMU_DB_FIXTURE_PORT:-${SONAMU_DB_PORT:-5432}}"
DB_USER="${SONAMU_DB_FIXTURE_USER:-${SONAMU_DB_USER:-postgres}}"

# PostgreSQL 패스워드 환경변수 설정
export PGPASSWORD="${SONAMU_DB_FIXTURE_PASSWORD:-${SONAMU_DB_PASSWORD}}"

if [ ! -f "${DUMP_FILE}" ]; then
  echo "❌ Dump file not found: ${DUMP_FILE}"
  echo "💡 Run 'pnpm dump' first!"
  unset PGPASSWORD
  exit 1
fi

echo "📥 Seeding ${FIXTURE_DB} from ${DUMP_FILE}..."
echo "🔗 Target: ${DB_USER}@${DB_HOST}:${DB_PORT}"

# 1. fixture DB 초기화
echo "🗑️  Recreating ${FIXTURE_DB}..."
psql \
  -h "${DB_HOST}" \
  -p "${DB_PORT}" \
  -U "${DB_USER}" \
  -d postgres \
  -c "SELECT pg_terminate_backend(pg_stat_activity.pid)
  FROM pg_stat_activity
  WHERE datname = '${FIXTURE_DB}'
    AND pid <> pg_backend_pid();" \
  -c "DROP DATABASE IF EXISTS \"${FIXTURE_DB}\";" \
  -c "CREATE DATABASE \"${FIXTURE_DB}\";"

# 2. 덤프 적용
echo "📝 Applying dump file to ${FIXTURE_DB}..."
psql \
  -h "${DB_HOST}" \
  -p "${DB_PORT}" \
  -U "${DB_USER}" \
  -d "${FIXTURE_DB}" \
  -f "${DUMP_FILE}"

# 환경변수 정리
unset PGPASSWORD

echo "✅ Dump applied to ${FIXTURE_DB}"
echo "🎉 Seed completed!"
echo ""
echo "💡 Next step: pnpm sonamu fixture sync"