unis_hrms/app/db/session.py

30 lines
834 B
Python

"""Async engine / session management."""
from __future__ import annotations
from collections.abc import AsyncIterator
from pathlib import Path
from sqlalchemy.ext.asyncio import AsyncSession, async_sessionmaker, create_async_engine
from ..core.config import settings
if settings.is_sqlite:
db_file = Path(settings.database_url.split("///")[-1]).expanduser()
db_file.parent.mkdir(parents=True, exist_ok=True)
engine = create_async_engine(
settings.database_url,
echo=False,
future=True,
pool_pre_ping=True,
**({"connect_args": {"check_same_thread": False}} if settings.is_sqlite else {}),
)
SessionFactory = async_sessionmaker(engine, expire_on_commit=False, autoflush=False)
async def get_session() -> AsyncIterator[AsyncSession]:
async with SessionFactory() as session:
yield session