#!/usr/bin/env bash
set -euo pipefail
ROOT="$(cd "$(dirname "${BASH_SOURCE[0]}")/.." && pwd)"
cd "$ROOT"
: "${DB_DATABASE:?Set DB_DATABASE in .env}"
: "${DB_USERNAME:?Set DB_USERNAME in .env}"
: "${DB_PASSWORD:?Set DB_PASSWORD in .env}"
: "${BACKUP_DIR:=/var/backups/ojodu-hmis}"
mkdir -p "$BACKUP_DIR"
chmod 700 "$BACKUP_DIR"
STAMP="$(date -u +%Y%m%dT%H%M%SZ)"
umask 077
docker compose exec -T mysql sh -c 'MYSQL_PWD="$MYSQL_PASSWORD" mysqldump --single-transaction --routines --triggers -u"$MYSQL_USER" "$MYSQL_DATABASE"' \
  | gzip > "$BACKUP_DIR/${DB_DATABASE}_${STAMP}.sql.gz"
test -s "$BACKUP_DIR/${DB_DATABASE}_${STAMP}.sql.gz"
echo "Database backup created: $BACKUP_DIR/${DB_DATABASE}_${STAMP}.sql.gz"
echo "Copy this file to encrypted off-site storage and test restoration regularly."
