#!/usr/bin/env bash
set -euo pipefail
ROOT="$(cd "$(dirname "${BASH_SOURCE[0]}")/.." && pwd)"
cd "$ROOT"
FILE="${1:?Usage: scripts/docker-restore.sh /path/to/backup.sql.gz}"
test -s "$FILE"
echo "WARNING: this overwrites database objects/data in the configured HMIS database."
read -r -p "Type RESTORE to continue: " CONFIRM
[[ "$CONFIRM" == "RESTORE" ]] || { echo "Cancelled."; exit 1; }
gzip -dc "$FILE" | docker compose exec -T mysql sh -c 'MYSQL_PWD="$MYSQL_PASSWORD" mysql -u"$MYSQL_USER" "$MYSQL_DATABASE"'
echo "Restore stream completed. Verify application data and audit records."
