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