File size: 681 Bytes
0ff2e07 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 | from collections.abc import AsyncGenerator
from sqlalchemy.ext.asyncio import create_async_engine
from sqlmodel import SQLModel
from sqlmodel.ext.asyncio.session import AsyncSession
from backend.config import settings
engine = create_async_engine(
settings.database_url,
echo=settings.debug,
future=True,
)
async def init_db() -> None:
"""Create all database tables."""
async with engine.begin() as conn:
await conn.run_sync(SQLModel.metadata.create_all)
async def get_session() -> AsyncGenerator[AsyncSession, None]:
"""Dependency for getting async database sessions."""
async with AsyncSession(engine) as session:
yield session
|