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

# Creates all tables and loads the Dosa Station starter data into a fresh MySQL database.

ROOT_DIR="$(cd "$(dirname "${BASH_SOURCE[0]}")/.." && pwd)"
source "$ROOT_DIR/server/load-env.sh"
load_server_env "$ROOT_DIR"

: "${DB_HOST:?DB_HOST is required}"
: "${DB_PORT:=3306}"
: "${DB_USER:?DB_USER is required}"
: "${DB_PASSWORD:?DB_PASSWORD is required}"
: "${DB_NAME:?DB_NAME is required}"

MYSQL_CMD=(mysql -h "$DB_HOST" -P "$DB_PORT" -u "$DB_USER" "-p$DB_PASSWORD" "$DB_NAME")

echo "Creating Dosa Station tables on $DB_HOST:$DB_PORT/$DB_NAME ..."
"${MYSQL_CMD[@]}" < "$ROOT_DIR/server/schema.sql"

echo "Loading Dosa Station seed data ..."
"${MYSQL_CMD[@]}" < "$ROOT_DIR/server/seed.sql"

echo "Dosa Station database setup complete."