#!/bin/bash
set -euo pipefail
cd "$(dirname "$0")/.."
REPO_ROOT="$(pwd)"
SERVER_DIR="$REPO_ROOT/server"
if [ -z "${GNEXUS_BOOK_DATABASE_URL:-}" ]; then
echo "GNEXUS_BOOK_DATABASE_URL is required" >&2
exit 2
fi
export GNEXUS_BOOK_DATABASE_URL
REPLACE_FLAG="${1:-}"
if [ -n "$REPLACE_FLAG" ] && [ "$REPLACE_FLAG" != "--replace" ]; then
echo "Usage: $0 [--replace]" >&2
echo " --replace clears the target database before importing" >&2
exit 2
fi
REPORT="${GNEXUS_BOOK_MIGRATION_REPORT:-$HOME/backup/gnexus-book/migration-report-$(date +%Y-%m-%d_%H%M%S).json}"
cd "$SERVER_DIR"
.venv/bin/alembic upgrade head
ARGS=(.venv/bin/python -m app.storage.cli migrate --manifest "$REPORT")
if [ "$REPLACE_FLAG" = "--replace" ]; then
ARGS+=(--replace)
fi
"${ARGS[@]}"
if [ -n "${GNEXUS_BOOK_OWNER_JSON:-}" ]; then
echo "==> Assigning current data to the owner from $GNEXUS_BOOK_OWNER_JSON"
(cd "$SERVER_DIR" && .venv/bin/python -m app.storage.cli assign-owner \
--user-json "$GNEXUS_BOOK_OWNER_JSON")
fi
"$REPO_ROOT/scripts/backup-db.sh"
echo
echo "Migration verified. Report: $REPORT"
echo "Database dumps are on the configured off-host backup target."
echo
echo "To activate database mode, set on the service:"
echo " GNEXUS_BOOK_STORAGE_BACKEND=db"
echo " GNEXUS_BOOK_DATABASE_URL=$GNEXUS_BOOK_DATABASE_URL"
echo "and restart gnexus-book-backend and gnexus-book-mcp."
echo
echo "Rollback: set GNEXUS_BOOK_STORAGE_BACKEND=file and restart."
echo "The Git checkout is untouched by this script."