#!/bin/bash

# Wait for MySQL to become available
echo "Waiting for MySQL to become healthy..."
until mysql -h "localhost" -u"$MYSQL_USER" -p"$MYSQL_PASSWORD" -e "SHOW DATABASES;" &>/dev/null; do
    echo "Waiting for MySQL..."
    sleep 2
done

echo "MySQL is up and running!"

# Run the initial common setup (always executed)
echo "Running 01-init.sql"
mysql -u$MYSQL_USER -p$MYSQL_PASSWORD $MYSQL_DATABASE < /docker-entrypoint-initdb.d/01-init.sql

echo "Running 02-seed_common_data.sql"
mysql -u$MYSQL_USER -p$MYSQL_PASSWORD $MYSQL_DATABASE < /docker-entrypoint-initdb.d/02-seed_common_data.sql

# Check the environment variable and execute environment-specific scripts
if [ "$ENVIRONMENT" != "production" ]; then
    echo "Running 03-seed_router_data_qa.sql for QA (non-production)"
    mysql -u$MYSQL_USER -p$MYSQL_PASSWORD $MYSQL_DATABASE < /docker-entrypoint-initdb.d/03-seed_router_data_qa.sql
else
    echo "Production environment detected. Skipping seeding data for QA (non-production)."
fi