#!/bin/sh
set -eu

BACKUP_SQL="${1:-}"
UPLOADS_TAR="${2:-}"
UPLOAD_DIR="${UPLOAD_DIR:-./storage/uploads}"
DATABASE_URL_VALUE="${DATABASE_URL:-}"

if [ -z "$DATABASE_URL_VALUE" ]; then
  echo "DATABASE_URL nao configurada." >&2
  exit 1
fi

if [ -z "$BACKUP_SQL" ] || [ ! -f "$BACKUP_SQL" ]; then
  echo "Informe o arquivo SQL do backup: sh scripts/restore.sh backups/db-YYYY.sql [uploads.tar.gz]" >&2
  exit 1
fi

psql "$DATABASE_URL_VALUE" < "$BACKUP_SQL"

if [ -n "$UPLOADS_TAR" ]; then
  mkdir -p "$UPLOAD_DIR"
  tar -xzf "$UPLOADS_TAR" -C "$UPLOAD_DIR"
fi

echo "Restauracao concluida."