#!/usr/bin/env bash
# ITSG AI - deployment script
set -euo pipefail

SCRIPT_DIR="$(cd "$(dirname "${BASH_SOURCE[0]}")" && pwd)"
SQL_FILE="$SCRIPT_DIR/itsg_ai_install.sql"
PROJECT_SRC="$SCRIPT_DIR/itsg-ai"
TARGET_DIR="${TARGET_DIR:-/var/www/itsg-ai}"

DB_HOST="${DB_HOST:-}"
DB_USER="${DB_USER:-}"
DB_PASS="${DB_PASS:-}"
DB_NAME="${DB_NAME:-itsg_ai}"

[ -z "$DB_HOST" ] && read -rp "DB Host [127.0.0.1]: " DB_HOST && DB_HOST="${DB_HOST:-127.0.0.1}"
[ -z "$DB_USER" ] && read -rp "DB User [root]: " DB_USER && DB_USER="${DB_USER:-root}"
[ -z "$DB_PASS" ] && read -rsp "DB Password: " DB_PASS && echo
[ -z "$DB_NAME" ] && DB_NAME="itsg_ai"

command -v mariadb >/dev/null 2>&1 || command -v mysql >/dev/null 2>&1 || { echo "mariadb/mysql client not found"; exit 1; }
CLIENT="$(command -v mariadb || command -v mysql)"

[ -f "$SQL_FILE" ] || { echo "SQL file not found: $SQL_FILE"; exit 1; }

echo "==> Importing $SQL_FILE into $DB_NAME on $DB_HOST ..."
MYSQL_PWD="$DB_PASS" "$CLIENT" -h "$DB_HOST" -u "$DB_USER" --default-character-set=utf8mb4 < "$SQL_FILE"
echo "==> Database imported successfully."

echo "==> Copying project files to $TARGET_DIR ..."
mkdir -p "$TARGET_DIR"
cp -r "$PROJECT_SRC/." "$TARGET_DIR/"
echo "==> Copy done."

echo "==> Deployment finished."
echo "Admin login: itsg.groups@gmail.com (password set by AdminSeeder - change it immediately!)"