#!/bin/bash
set -euo pipefail

SCRIPT_DIR="$(cd "$(dirname "$0")" && pwd)"
PROJECT_DIR="$(dirname "$SCRIPT_DIR")"

export $(grep -v '^#' "$PROJECT_DIR/.env.db" | xargs)

cd "$PROJECT_DIR"

DATE_TIME=$(date +%Y%m%d%H%M)
DUMP_FILE="${PROJECT_DIR}/${MARIADB_DATABASE}-${DATE_TIME}.sql"

echo "Dumping ${MARIADB_DATABASE} database..."
docker compose exec -T db mariadb-dump -u root -p"${MARIADB_ROOT_PASSWORD}" "${MARIADB_DATABASE}" > "$DUMP_FILE"

echo "Compressing ${DUMP_FILE}..."
gzip "$DUMP_FILE"

echo "Done: ${DUMP_FILE}.gz"