Newer
Older
gnexus-book / scripts / cutover-db.sh
@Eugene Sukhodolskiy Eugene Sukhodolskiy 9 hours ago 1 KB feat(scripts): assign owner during cutover
#!/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."