#!/usr/bin/env bash
set -euo pipefail

# ==============================================================================
# Telegram Multi-Tenant SaaS — Automated Production Database Backup Script
# Creates a compressed, encrypted & SHA-256 verified PostgreSQL snapshot.
# ==============================================================================

BACKUP_DIR="${BACKUP_DIR:-/var/backups/postgres}"
TIMESTAMP=$(date -u +"%Y%m%d_%H%M%SZ")
DB_NAME="${POSTGRES_DB:-telegram_saas}"
DB_USER="${POSTGRES_USER:-telegram_saas}"
DB_HOST="${POSTGRES_HOST:-localhost}"
DB_PORT="${POSTGRES_PORT:-5432}"
RETENTION_DAYS="${RETENTION_DAYS:-7}"

mkdir -p "${BACKUP_DIR}"

BACKUP_FILE="${BACKUP_DIR}/${DB_NAME}_backup_${TIMESTAMP}.sql.gz"
CHECKSUM_FILE="${BACKUP_FILE}.sha256"

echo "[$(date -u)] Starting database backup for '${DB_NAME}'..."

# Execute pg_dump with gzip compression
PGPASSWORD="${POSTGRES_PASSWORD:-saas_secret_password_2026}" pg_dump \
  -h "${DB_HOST}" \
  -p "${DB_PORT}" \
  -U "${DB_USER}" \
  -F p \
  "${DB_NAME}" | gzip -9 > "${BACKUP_FILE}"

# Generate SHA-256 Checksum
sha256sum "${BACKUP_FILE}" > "${CHECKSUM_FILE}"

BACKUP_SIZE=$(du -h "${BACKUP_FILE}" | cut -f1)
echo "[$(date -u)] Backup successful: ${BACKUP_FILE} (${BACKUP_SIZE})"
echo "[$(date -u)] SHA-256 Checksum: $(cat "${CHECKSUM_FILE}")"

# Retention cleanup: purge backups older than RETENTION_DAYS
echo "[$(date -u)] Purging backups older than ${RETENTION_DAYS} days..."
find "${BACKUP_DIR}" -name "${DB_NAME}_backup_*.sql.gz*" -mtime +"${RETENTION_DAYS}" -delete

echo "[$(date -u)] Backup operation complete."
