Files
mtusi2026lab6-fork/app/core/database.py
2026-11-22 19:55:50 +03:00

62 lines
1.8 KiB
Python

from contextlib import nullcontext
from sqlalchemy.pool import AsyncAdaptedQueuePool
from sqlalchemy.ext.asyncio import (
AsyncEngine,
AsyncSession,
async_sessionmaker,
create_async_engine,
)
from app.core.config import Settings
class ObservedPool(AsyncAdaptedQueuePool):
telemetry = None
waiting = 0
def __init__(self, *args, pool_size, max_overflow, **kwargs):
self.capacity = (
pool_size + max_overflow if pool_size and max_overflow >= 0 else None
)
super().__init__(
*args, pool_size=pool_size, max_overflow=max_overflow, **kwargs
)
def _do_get(self):
waiting = self.capacity is not None and self.checkedout() >= self.capacity
self.waiting += int(waiting)
try:
return super()._do_get()
finally:
self.waiting -= int(waiting)
def connect(self):
with (
self.telemetry.span("postgres.checkout")
if self.telemetry
else nullcontext()
):
return super().connect()
def create_db_engine(settings: Settings) -> AsyncEngine:
return create_async_engine(
settings.get_database_url(),
poolclass=ObservedPool,
pool_size=settings.db_pool_size,
max_overflow=settings.db_max_overflow,
pool_timeout=settings.db_pool_timeout_seconds,
pool_pre_ping=True,
connect_args={
"timeout": settings.db_connect_timeout_seconds,
"server_settings": {
"statement_timeout": str(settings.db_statement_timeout_ms)
},
},
)
def create_session_factory(engine: AsyncEngine) -> async_sessionmaker[AsyncSession]:
return async_sessionmaker(bind=engine, expire_on_commit=False, autoflush=False)