#!/usr/bin/env bash
# api/.env içindeki DB_* ile mysql çalıştırır (manuel sorgular için).
# Kullanım: ./scripts/mysql-with-env.sh faunamix -e "SELECT 1"
# veya:       ./scripts/mysql-with-env.sh faunamix < database/foo.sql
set -euo pipefail

ROOT="$(cd "$(dirname "$0")/.." && pwd)"
ENV_FILE="$ROOT/api/.env"

if [[ ! -f "$ENV_FILE" ]]; then
  echo "Eksik: $ENV_FILE — örnek: cp api/env.example api/.env && düzenleyin" >&2
  exit 1
fi

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

DB_HOST="${DB_HOST:-127.0.0.1}"
DB_PORT="${DB_PORT:-3306}"
DB_NAME="${DB_NAME:-faunamix}"

MYSQL_ARGS=( -h"$DB_HOST" -P"$DB_PORT" --protocol=TCP -u"$DB_USER" --default-character-set=utf8mb4 )
if [[ -n "${DB_PASS:-}" ]]; then
  MYSQL_ARGS+=( -p"$DB_PASS" )
fi

exec mysql "${MYSQL_ARGS[@]}" "$DB_NAME" "$@"