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