from __future__ import annotations
import os
import pytest
from sqlalchemy import create_engine, text
from app.config import Settings, get_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(autouse=True)
def _clear_settings_cache() -> None:
get_settings.cache_clear()
yield
get_settings.cache_clear()
@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
def _reset_schema(engine) -> None:
Base.metadata.drop_all(engine)
with engine.begin() as connection:
# The fixture bypasses Alembic; clear its marker so `alembic upgrade head`
# can rebuild a freshly emptied test database.
connection.execute(text("DROP TABLE IF EXISTS alembic_version"))
Base.metadata.create_all(engine)
@pytest.fixture()
def database(database_url: str) -> Database:
engine = create_engine(database_url)
_reset_schema(engine)
db = Database(database_url)
try:
yield db
finally:
Base.metadata.drop_all(engine)
with engine.begin() as connection:
connection.execute(text("DROP TABLE IF EXISTS alembic_version"))
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