#!/usr/bin/env bash
set -euo pipefail
umask 077
: "${MYSQL_DEFAULTS_FILE:?Path to a protected mysql defaults file is required}"
: "${BACKUP_DIR:?Use a private encrypted backup volume outside the application/public directory}"
: "${DB_DATABASE:?Database name required}"
[[ "$DB_DATABASE" =~ ^[a-zA-Z0-9_]+$ ]] || { echo 'Invalid database name' >&2; exit 1; }
cd "$(dirname "$0")/.."
root=$(pwd -P)
mkdir -p "$BACKUP_DIR"
backup_root=$(cd "$BACKUP_DIR" && pwd -P)
case "$backup_root/" in "$root/"*) echo 'Backup target must be outside the application tree' >&2; exit 1;; esac
backup_name="house-$(date -u +%Y%m%dT%H%M%SZ)-$$"
working=$(mktemp -d "$backup_root/.house-backup.XXXXXX")
trap 'rm -rf "$working"' EXIT
"${MYSQLDUMP_BIN:-mysqldump}" --defaults-extra-file="$MYSQL_DEFAULTS_FILE" --single-transaction --quick --no-tablespaces --set-gtid-purged=OFF "$DB_DATABASE" | gzip > "$working/database.sql.gz"
tar -czf "$working/private-files.tar.gz" -C storage/app private
(cd "$working" && shasum -a 256 database.sql.gz private-files.tar.gz > SHA256SUMS)
mv "$working" "$backup_root/$backup_name"
trap - EXIT
printf 'Backup completed: %s\n' "$backup_root/$backup_name"
