#!/bin/bash
set -e

DUMP_FILE="./docker/db/init/00-azure-db-dump.sql"

# Load env vars
if [ -f ".env.local" ]; then
  set -o allexport
  source .env.local
  set +o allexport
else
  echo ".env.local file not found!"
  exit 1
fi

echo "Dumping Azure DB '$AZURE_STAGING_DB_NAME' to $DUMP_FILE ..."
mysqldump -h "$AZURE_STAGING_DB_HOST" -u "$AZURE_STAGING_DB_USERNAME" -p"$AZURE_STAGING_DB_PASSWORD" "$AZURE_STAGING_DB_NAME" > "$DUMP_FILE" 2>/dev/null

echo "Recreating only the database container..."

# Stop and remove only the DB container and volume
docker compose stop database
docker compose rm -f database
docker volume rm $(docker volume ls -qf name=foxorders_database_data || true)

# Recreate DB container only
docker compose up -d database

echo "Database sync complete."