Newer
Older
gnexus-book / server / tests / test_migrations.py
from __future__ import annotations

import uuid
from pathlib import Path

import pytest
from alembic import command
from alembic.config import Config
from sqlalchemy import create_engine, inspect, text


@pytest.fixture()
def temporary_database_url(database_url: str) -> str:
    engine = create_engine(database_url, isolation_level="AUTOCOMMIT")
    name = f"gnexus_book_migration_{uuid.uuid4().hex[:8]}"
    with engine.connect() as connection:
        connection.execute(text(f'CREATE DATABASE "{name}"'))
    url = database_url.rsplit("/", 1)[0] + "/" + name
    try:
        yield url
    finally:
        with engine.connect() as connection:
            connection.execute(text(f'DROP DATABASE IF EXISTS "{name}" WITH (FORCE)'))
        engine.dispose()


def test_alembic_upgrade_creates_schema(
    temporary_database_url: str, monkeypatch: pytest.MonkeyPatch
) -> None:
    monkeypatch.setenv("GNEXUS_BOOK_DATABASE_URL", temporary_database_url)
    config = Config(str(Path(__file__).resolve().parents[1] / "alembic.ini"))
    config.set_main_option("sqlalchemy.url", temporary_database_url)

    command.upgrade(config, "head")

    engine = create_engine(temporary_database_url)
    try:
        tables = set(inspect(engine).get_table_names())
    finally:
        engine.dispose()

    assert {
        "alembic_version",
        "documents",
        "doc_versions",
        "inventory_items",
        "changesets",
        "users",
    } <= tables