#!/usr/bin/env bash
# Deploys the KORZILLA.Admin backend on prod:
#   checks -> DB backup -> checkout -> pnpm install -> prisma generate -> migrations -> build
#   -> systemctl restart -> health check.
# If the build or the health check fails, code, dist and node_modules are rolled back and the
# service is restarted on the previous version. Applied migrations are NOT rolled back:
# restore the DB from the backup printed below if needed.
#
# Usage (as root):
#   deploy-backend.sh                 deploy origin/main
#   deploy-backend.sh <git-ref>       deploy a branch/tag/commit (detached HEAD)
#   DRY_RUN=1 deploy-backend.sh       show what would be deployed, change nothing
#   FORCE=1 deploy-backend.sh         redeploy even if already on the target commit
set -Eeuo pipefail

APP=/home/adminapp/web/admin.korzilla.ru/apps/backend
SERVICE=korzilla-admin-backend
BACKUP_DIR=/root/backups/korzilla-admin
BACKUPS_TO_KEEP=10
HEALTH_URL=http://127.0.0.1:4000/api/sessions # 401 without a session cookie = app is up
HEALTH_EXPECTED=401
MIN_FREE_GB=2
export PATH=/root/.nvm/versions/node/v20.19.5/bin:$PATH
export COREPACK_ENABLE_DOWNLOAD_PROMPT=0

REF=${1:-origin/main}
DRY_RUN=${DRY_RUN:-0}
FORCE=${FORCE:-0}

log() { printf '\n[%s] %s\n' "$(date +%H:%M:%S)" "$*"; }
die() { echo "ERROR: $*" >&2; exit 1; }

exec 9>/var/lock/korzilla-admin-backend-deploy.lock
flock -n 9 || die "another backend deploy is running"

cd "$APP"

log "Checks"
[ -z "$(git status --porcelain --untracked-files=no)" ] || { git status --short; die "uncommitted changes in $APP"; }
free_gb=$(df -BG --output=avail / | tail -1 | tr -dc 0-9)
[ "$free_gb" -ge "$MIN_FREE_GB" ] || die "only ${free_gb}G free on /, need ${MIN_FREE_GB}G"
echo "free on /: ${free_gb}G"
DATABASE_URL=$(grep -E '^DATABASE_URL=' .env | cut -d= -f2- | sed -E 's/^["'\'']|["'\'']$//g')
[ -n "$DATABASE_URL" ] || die "DATABASE_URL not found in .env"
export DATABASE_URL

git fetch -q origin </dev/null
PREV=$(git rev-parse HEAD)
NEXT=$(git rev-parse "$REF^{commit}")
echo "current: $(git log -1 --format='%h %ad %s' --date=short "$PREV")"
echo "target:  $(git log -1 --format='%h %ad %s' --date=short "$NEXT")  ($REF)"
if [ "$PREV" = "$NEXT" ] && [ "$FORCE" != 1 ]; then
  echo "Already on target, nothing to deploy (FORCE=1 to redeploy)"
  exit 0
fi
echo "--- commits:"; git log --oneline "$PREV..$NEXT"
echo "--- changed files:"; git diff --stat "$PREV" "$NEXT" | tail -30
LOCK_CHANGED=0
git diff --quiet "$PREV" "$NEXT" -- package.json pnpm-lock.yaml || LOCK_CHANGED=1
echo "dependencies changed: $([ $LOCK_CHANGED = 1 ] && echo yes || echo no)"
echo "--- new migrations:"; git diff --name-only --diff-filter=A "$PREV" "$NEXT" -- prisma/migrations | grep migration.sql || echo "none"

HAS_MIGRATIONS_TABLE=$(psql "$DATABASE_URL" -tAc "select to_regclass('public._prisma_migrations') is not null" </dev/null)
echo "_prisma_migrations table: $HAS_MIGRATIONS_TABLE$([ "$HAS_MIGRATIONS_TABLE" = t ] || echo ' -> will baseline if schema matches')"
echo "DB server: $(psql "$DATABASE_URL" -tAc 'show server_version' </dev/null), pg_dump: $(pg_dump --version | awk '{print $3}')"

if [ "$DRY_RUN" = 1 ]; then
  log "DRY_RUN: nothing changed"
  exit 0
fi

log "DB backup"
mkdir -p "$BACKUP_DIR"
chmod 700 "$BACKUP_DIR"
BACKUP_FILE="$BACKUP_DIR/$(date +%F_%H%M%S)_$(git rev-parse --short "$PREV").dump"
pg_dump --format=custom --file="$BACKUP_FILE" "$DATABASE_URL"
chmod 600 "$BACKUP_FILE"
echo "backup: $BACKUP_FILE ($(du -h "$BACKUP_FILE" | cut -f1))"
ls -1t "$BACKUP_DIR"/*.dump | tail -n +$((BACKUPS_TO_KEEP + 1)) | xargs -r rm -f

ROLLBACK_ARMED=0
rollback() {
  [ "$ROLLBACK_ARMED" = 1 ] || return 0
  ROLLBACK_ARMED=0
  set +e
  log "ROLLBACK to $(git rev-parse --short "$PREV")"
  git checkout -q --detach "$PREV"
  if [ -d dist.prev ]; then rm -rf dist && mv dist.prev dist; fi
  if [ "$LOCK_CHANGED" = 1 ]; then pnpm install --frozen-lockfile; fi
  pnpm prisma generate
  systemctl restart "$SERVICE"
  echo "Rolled back to $(git rev-parse --short HEAD) (detached). The next deploy returns to main."
  echo "DB was NOT rolled back. Backup taken before this deploy: $BACKUP_FILE"
}
# EXIT (not ERR) so that explicit `die` after checkout also rolls back
trap 'rc=$?; if [ "$rc" -ne 0 ]; then echo "FAILED (exit $rc)" >&2; rollback; fi' EXIT

log "Checkout"
ROLLBACK_ARMED=1
if [ "$REF" = origin/main ]; then
  git checkout -q main
  git merge -q --ff-only origin/main
else
  git checkout -q --detach "$NEXT"
fi
echo "HEAD: $(git log -1 --format='%h %s')"

log "Dependencies"
if [ "$LOCK_CHANGED" = 1 ] || [ "$FORCE" = 1 ]; then
  pnpm install --frozen-lockfile
else
  echo "package.json / pnpm-lock.yaml unchanged, skipping pnpm install"
fi
pnpm prisma generate

log "Migrations"
if [ "$HAS_MIGRATIONS_TABLE" != t ]; then
  # The DB was built with `prisma db push` and has no migration history. Baseline it,
  # but only if its schema exactly matches schema.prisma (i.e. all migrations are in effect).
  if pnpm -s prisma migrate diff --from-config-datasource --to-schema prisma/schema.prisma --exit-code >/dev/null; then
    for dir in prisma/migrations/*/; do
      pnpm -s prisma migrate resolve --applied "$(basename "$dir")"
    done
  else
    pnpm -s prisma migrate diff --from-config-datasource --to-schema prisma/schema.prisma --script || true
    die "DB has no _prisma_migrations and differs from schema.prisma (diff above): baseline it manually"
  fi
fi
pnpm prisma migrate deploy

log "Build"
rm -rf dist.prev
cp -a dist dist.prev
pnpm build

log "Restart $SERVICE"
systemctl restart "$SERVICE"
code=000
for _ in $(seq 1 30); do
  sleep 2
  code=$(curl -s -o /dev/null -w '%{http_code}' "$HEALTH_URL" || true)
  [ "$code" = "$HEALTH_EXPECTED" ] && break
done
if [ "$code" != "$HEALTH_EXPECTED" ]; then
  journalctl -u "$SERVICE" -n 40 --no-pager | cut -c1-240
  die "health check failed: $HEALTH_URL -> $code, expected $HEALTH_EXPECTED"
fi
ROLLBACK_ARMED=0
rm -rf dist.prev

log "OK: backend $(git log -1 --format='%h %s') is up ($HEALTH_URL -> $code)"
pnpm -s prisma migrate status | tail -1
echo "backup: $BACKUP_FILE"
