from __future__ import annotations from sqlalchemy import event from sqlalchemy.ext.asyncio import AsyncEngine, AsyncSession, async_sessionmaker, create_async_engine from sqlalchemy.orm import DeclarativeBase from ..observability import get_metrics class Base(DeclarativeBase): pass def create_engine(url: str) -> AsyncEngine: engine = create_async_engine( url, pool_size=5, max_overflow=5, pool_timeout=5, pool_pre_ping=True, connect_args={'server_settings': {'statement_timeout': '5000'}}, ) instruments = get_metrics() attributes = {'pool.name': 'postgres'} def update_pool_metrics(*_args) -> None: pool = engine.sync_engine.pool instruments.db_pool_used.set(float(pool.checkedout()), attributes) waiting = len(getattr(getattr(pool, '_pool', None), '_getters', ())) instruments.db_pool_waiting.set(float(waiting), attributes) event.listen(engine.sync_engine, 'checkout', update_pool_metrics) event.listen(engine.sync_engine, 'checkin', update_pool_metrics) instruments.db_pool_used.set(0, attributes) instruments.db_pool_waiting.set(0, attributes) return engine def create_session_factory(engine: AsyncEngine) -> async_sessionmaker[AsyncSession]: return async_sessionmaker(engine, expire_on_commit=False)