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

import os

import pytest
from sqlalchemy import create_engine, text

from app.config import Settings
from app.storage.db import Database
from app.storage.importer import import_file_repository
from app.storage.models import Base

TEST_DATABASE_URL = os.environ.get(
    "GNEXUS_BOOK_TEST_DATABASE_URL",
    "postgresql+psycopg://gmikcon@127.0.0.1:5433/gnexus_book_test",
)


@pytest.fixture(scope="session")
def database_url() -> str:
    engine = create_engine(TEST_DATABASE_URL)
    try:
        with engine.connect() as connection:
            connection.execute(text("SELECT 1"))
    except Exception as exc:  # pragma: no cover - depends on local environment
        pytest.skip(f"PostgreSQL test database is unavailable: {exc}")
    finally:
        engine.dispose()
    return TEST_DATABASE_URL


@pytest.fixture()
def database(database_url: str) -> Database:
    engine = create_engine(database_url)
    Base.metadata.drop_all(engine)
    Base.metadata.create_all(engine)

    db = Database(database_url)
    try:
        yield db
    finally:
        Base.metadata.drop_all(engine)
        engine.dispose()


@pytest.fixture()
def imported(database: Database) -> tuple[Settings, Database]:
    settings = Settings(storage_backend="db", database_url=database.url)
    report = import_file_repository(settings, database, replace=True)
    assert report.documents > 0
    assert report.inventory_items > 0
    return settings, database