Newer
Older
gnexus-book / server / app / storage / db.py
from __future__ import annotations

from functools import lru_cache

from sqlalchemy import Engine, create_engine
from sqlalchemy.orm import Session, sessionmaker

from ..config import Settings


class DatabaseError(RuntimeError):
    pass


@lru_cache(maxsize=8)
def _engine_for_url(url: str) -> Engine:
    return create_engine(url, pool_pre_ping=True, future=True)


class Database:
    def __init__(self, url: str) -> None:
        self.url = url
        self.engine = _engine_for_url(url)
        self.session_factory = sessionmaker(bind=self.engine, expire_on_commit=False, future=True)

    @classmethod
    def from_settings(cls, settings: Settings) -> "Database":
        if not settings.database_url:
            raise DatabaseError(
                "GNEXUS_BOOK_DATABASE_URL is required when storage backend is 'db'"
            )
        return cls(settings.database_url)

    def session(self) -> Session:
        return self.session_factory()

    def ping(self) -> None:
        from sqlalchemy import text

        with self.engine.connect() as connection:
            connection.execute(text("SELECT 1"))