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"))