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

# ==============================================================================
# Telegram Multi-Tenant SaaS — Production Database Restore Script
# Verifies SHA-256 checksum and restores into a target database.
# ==============================================================================

if [ "$#" -lt 1 ]; then
  echo "Usage: $0 <path_to_backup.sql.gz> [target_database_name]"
  exit 1
fi

BACKUP_FILE="$1"
TARGET_DB="${2:-telegram_saas}"
DB_USER="${POSTGRES_USER:-telegram_saas}"
DB_HOST="${POSTGRES_HOST:-localhost}"
DB_PORT="${POSTGRES_PORT:-5432}"

if [ ! -f "${BACKUP_FILE}" ]; then
  echo "Error: Backup file '${BACKUP_FILE}' does not exist."
  exit 1
fi

# 1. Verify SHA-256 Checksum if companion .sha256 file exists
CHECKSUM_FILE="${BACKUP_FILE}.sha256"
if [ -f "${CHECKSUM_FILE}" ]; then
  echo "[$(date -u)] Verifying SHA-256 checksum..."
  (cd "$(dirname "${BACKUP_FILE}")" && sha256sum -c "$(basename "${CHECKSUM_FILE}")")
  echo "[$(date -u)] SHA-256 Checksum verified OK."
else
  echo "[$(date -u)] Warning: No companion .sha256 file found. Proceeding with restore..."
fi

# 2. Check if target database exists, create if missing
export PGPASSWORD="${POSTGRES_PASSWORD:-saas_secret_password_2026}"
DB_EXISTS=$(psql -h "${DB_HOST}" -p "${DB_PORT}" -U "${DB_USER}" -tAc "SELECT 1 FROM pg_database WHERE datname='${TARGET_DB}'" template1 || true)

if [ "${DB_EXISTS}" != "1" ]; then
  echo "[$(date -u)] Creating target database '${TARGET_DB}'..."
  createdb -h "${DB_HOST}" -p "${DB_PORT}" -U "${DB_USER}" "${TARGET_DB}"
fi

# 3. Restore via gunzip and psql
echo "[$(date -u)] Restoring '${BACKUP_FILE}' into '${TARGET_DB}'..."
gunzip -c "${BACKUP_FILE}" | psql -h "${DB_HOST}" -p "${DB_PORT}" -U "${DB_USER}" -d "${TARGET_DB}" -v ON_ERROR_STOP=1 > /dev/null

echo "[$(date -u)] Database restore into '${TARGET_DB}' completed successfully."
