#!/usr/bin/env bash
# =============================================================================
# Arilix (production) -> ohmu (test): www_arilix andmebaasi + Drupali HTML
# Välja arvatud settings.php (ohmu oma jääb alles)
# Käivita root õigustega: sudo bash sync_from_arilix.sh
# =============================================================================
set -e

ARILIX="root@100.74.36.86"
ARILIX_MARIADB_PASS="JnBWLj921al3LXeQWAEA"
OHMU_MARIADB_PASS="ai_root_pass_2026"
ARILIX_HTML="/opt/drupal/bussikeskus/html"
OHMU_HTML="/var/lib/docker/volumes/drupal_bussikeskus-html/_data"

echo "=== $(date): Alustan sünkroonimist ==="

# 1. MariaDB: dump arilixist ja import ohmu-sse
echo "[1/3] MariaDB: dump arilix www_arilix -> ohmu mariadb ..."
ssh "$ARILIX" "docker exec mysqldb mariadb-dump -u root -p\"$ARILIX_MARIADB_PASS\" --single-transaction www_arilix" \
  | docker exec -i mariadb mariadb -u root -p"$OHMU_MARIADB_PASS" www_arilix 2>/dev/null
echo "  DB sünkroonitud."

# 2. Rsync Drupali HTML (v.a settings.php)
echo "[2/3] Rsync: arilix HTML -> ohmu (v.a settings.php) ..."
rsync -av --delete --exclude="settings.php" -e "ssh" \
  "$ARILIX:$ARILIX_HTML/" \
  "$OHMU_HTML/"
echo "  HTML sünkroonitud."

# 3. Tühjenda Drupali puhver
echo "[3/3] Drupali puhvri tühjendamine..."
docker exec drupal_bussikeskus sh -c "rm -rf /var/www/html/sites/default/files/cache/*" 2>/dev/null || true
echo "  Puhver tühjendatud."

echo ""
echo "=== $(date): Sünkroonimine valmis ==="