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

DB_USER="${1:-admin}"
PKG="$(cd "$(dirname "${BASH_SOURCE[0]}")" && pwd)"

echo "YachtMemory Derived Layer - Phase 1"
echo "DB user: ${DB_USER}"
echo
echo "SilentMessDB wird nicht verändert."
echo

echo "Preflight"
TARGET_EXISTS="$(mysql -N -B -u "${DB_USER}" -p -e "
SELECT COUNT(*)
FROM information_schema.tables
WHERE table_schema='yachtmemory_derived'
  AND table_name='anchorages';
")"

if [[ "${TARGET_EXISTS}" != "0" ]]; then
    TARGET_ROWS="$(mysql -N -B -u "${DB_USER}" -p -e "
SELECT COUNT(*) FROM yachtmemory_derived.anchorages;
")"

    if [[ "${TARGET_ROWS}" != "0" ]]; then
        echo "FEHLER: yachtmemory_derived.anchorages enthält bereits ${TARGET_ROWS} Datensätze." >&2
        echo "Abbruch ohne Änderung." >&2
        exit 1
    fi
fi

echo
echo "1/3 Schema anlegen"
mysql -u "${DB_USER}" -p < "${PKG}/database/01_create_schema.sql"

echo
echo "2/3 Silent-Sea-Ankerplätze kopieren"
mysql -u "${DB_USER}" -p < "${PKG}/database/02_copy_silent_sea.sql"

echo
echo "3/3 Exakte Vergleichsprüfung"
mysql -u "${DB_USER}" -p < "${PKG}/database/03_verify.sql"

echo
echo "Phase 1 abgeschlossen."
echo "SilentMessDB wurde nicht verändert."