30 lines
834 B
Python
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
|