"""SQLAlchemy 基类与会话工厂。""" from __future__ import annotations from collections.abc import AsyncIterator from sqlalchemy import MetaData from sqlalchemy.ext.asyncio import AsyncSession, async_sessionmaker, create_async_engine from sqlalchemy.orm import DeclarativeBase from app.core.config import settings NAMING_CONVENTION = { "ix": "ix_%(column_0_label)s", "uq": "uq_%(table_name)s_%(column_0_name)s", "ck": "ck_%(table_name)s_%(constraint_name)s", "fk": "fk_%(table_name)s_%(column_0_name)s_%(referred_table_name)s", "pk": "pk_%(table_name)s", } class Base(DeclarativeBase): metadata = MetaData(naming_convention=NAMING_CONVENTION) engine = create_async_engine( settings.database_url, pool_pre_ping=True, pool_size=5, max_overflow=5, pool_timeout=5, # 数据库不可达时快速失败,避免登录等请求一直挂起直到浏览器超时。 connect_args={"timeout": 5, "command_timeout": 15}, echo=False, ) SessionLocal = async_sessionmaker(engine, class_=AsyncSession, expire_on_commit=False) async def get_session() -> AsyncIterator[AsyncSession]: async with SessionLocal() as session: yield session async def dispose_engine() -> None: await engine.dispose()