#!/usr/bin/env bash
set -euo pipefail
ROOT="$(cd "$(dirname "${BASH_SOURCE[0]}")/.." && pwd)"
cd "$ROOT"
if [[ "${CONFIRM_DESTRUCTIVE_RESTORE:-}" != "YES" ]]; then
  echo "Refusing restore. Set CONFIRM_DESTRUCTIVE_RESTORE=YES after confirming the target database." >&2
  exit 1
fi
DB_BACKUP="${1:-}"
STORAGE_BACKUP="${2:-}"
[[ -s "$DB_BACKUP" && -s "$STORAGE_BACKUP" ]] || { echo "Usage: CONFIRM_DESTRUCTIVE_RESTORE=YES scripts/restore.sh DB.sql.gz.enc storage.tar.gz.enc" >&2; exit 1; }
command -v docker >/dev/null 2>&1 || { echo "Docker is required." >&2; exit 1; }
command -v openssl >/dev/null 2>&1 || { echo "OpenSSL is required." >&2; exit 1; }
if [[ -z "${BACKUP_ENCRYPTION_PASSPHRASE:-}" ]]; then
  read -rsp "Backup decryption passphrase: " BACKUP_ENCRYPTION_PASSPHRASE
  echo
fi
export BACKUP_ENCRYPTION_PASSPHRASE
[[ ${#BACKUP_ENCRYPTION_PASSPHRASE} -ge 20 ]] || { echo "Backup passphrase is too short." >&2; exit 1; }
# Verify decryption and compressed stream integrity before entering maintenance mode.
openssl enc -d -aes-256-cbc -pbkdf2 -iter 250000 -pass env:BACKUP_ENCRYPTION_PASSPHRASE -in "$DB_BACKUP" | gzip -t
openssl enc -d -aes-256-cbc -pbkdf2 -iter 250000 -pass env:BACKUP_ENCRYPTION_PASSPHRASE -in "$STORAGE_BACKUP" | tar -tzf - >/dev/null
docker compose exec -T app php artisan down --retry=60
cleanup(){ docker compose exec -T app php artisan up >/dev/null 2>&1 || true; }
trap cleanup EXIT
echo "Importing encrypted database backup into the configured database..."
openssl enc -d -aes-256-cbc -pbkdf2 -iter 250000 -pass env:BACKUP_ENCRYPTION_PASSPHRASE -in "$DB_BACKUP" \
  | gzip -dc \
  | docker compose exec -T mysql sh -c 'exec mysql -u"$MYSQL_USER" -p"$MYSQL_PASSWORD" "$MYSQL_DATABASE"'
echo "Restoring encrypted storage/app..."
docker compose exec -T app sh -c 'rm -rf /var/www/html/storage/app/*'
openssl enc -d -aes-256-cbc -pbkdf2 -iter 250000 -pass env:BACKUP_ENCRYPTION_PASSPHRASE -in "$STORAGE_BACKUP" \
  | docker compose exec -T app tar -xzf - -C /var/www/html
docker compose exec -T app php artisan optimize:clear
echo "Restore completed. Validate data, storage, permissions, application and audit trails before reopening."
