#!/usr/bin/env bash
set -euo pipefail

SCRIPT_DIR="$(cd "$(dirname "${BASH_SOURCE[0]}")" && pwd)"
PACKAGE_ROOT="$(cd "$SCRIPT_DIR/.." && pwd)"
source "$SCRIPT_DIR/lib/common.sh"

PROJECT_ENV=""
SECRETS_ENV=""
APPROVAL_FILE=""
APPLY=0
while [ "$#" -gt 0 ]; do
  case "$1" in
    --project-env) PROJECT_ENV="$2"; shift 2 ;;
    --secrets-env) SECRETS_ENV="$2"; shift 2 ;;
    --approval-file) APPROVAL_FILE="$2"; shift 2 ;;
    --apply) APPLY=1; shift ;;
    *) die "unknown argument: $1" ;;
  esac
done

[ -n "$PROJECT_ENV" ] || die "--project-env is required"
[ -n "$SECRETS_ENV" ] || die "--secrets-env is required"
load_env_file "$PROJECT_ENV"
assert_no_placeholders "$PROJECT_ENV"
require_secret_permissions "$SECRETS_ENV"
assert_no_placeholders "$SECRETS_ENV"

[[ "$MYSQL_APP_USER" =~ ^[A-Za-z0-9_.-]+$ ]] || die "invalid MYSQL_APP_USER"
case "$MYSQL_APP_HOST" in
  localhost|127.0.0.1) ;;
  *) die "single-host V1 only allows a local MySQL application account" ;;
esac

log "PLAN create Store/AI databases and least-scope local application account"
log "PLAN existing accounts are not rotated or overwritten"

[ "$APPLY" -eq 1 ] || {
  log "SHADOW_ONLY: MySQL databases and accounts unchanged"
  exit 0
}

[ -n "$APPROVAL_FILE" ] || die "--approval-file is required with --apply"
require_apply_authorization "initialize-mysql-account" "$APPROVAL_FILE" "$TARGET_HOST_REF"
load_env_file "$SECRETS_ENV"
require_cmd mysql
require_cmd python3

EXISTING_ACCOUNT="$(
  MYSQL_PWD="$MYSQL_ADMIN_PASSWORD" mysql \
    --batch --skip-column-names \
    --host="$MYSQL_HOST" --port="$MYSQL_PORT" --user="$MYSQL_ADMIN_USER" \
    --execute="SELECT COUNT(*) FROM mysql.user WHERE User='${MYSQL_APP_USER}' AND Host='${MYSQL_APP_HOST}';"
)"
[ "$EXISTING_ACCOUNT" = "0" ] ||
  die "application account already exists; use a separate authorized rotation procedure"

TMP_SQL="$(mktemp)"
trap 'rm -f "$TMP_SQL"' EXIT
python3 "$PACKAGE_ROOT/tools/render_mysql_init_sql.py" \
  --project-env "$PROJECT_ENV" \
  --secrets-env "$SECRETS_ENV" \
  --output "$TMP_SQL"

MYSQL_PWD="$MYSQL_ADMIN_PASSWORD" mysql \
  --host="$MYSQL_HOST" --port="$MYSQL_PORT" --user="$MYSQL_ADMIN_USER" < "$TMP_SQL"
log "MYSQL_ACCOUNT_INITIALIZED user=$MYSQL_APP_USER host=$MYSQL_APP_HOST databases=$STORE_DB_NAME,$AI_API_DB_NAME"