database.py

from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.ext.asyncio import AsyncSession, create_async_engine
from sqlalchemy.orm import sessionmaker

# Definindo a classe Base
Base = declarative_base()

# Configuração do motor (engine) assíncrono do SQLAlchemy
DATABASE_URL = "sqlite+aiosqlite:///./app.db"

engine = create_async_engine(
    DATABASE_URL, 
    future=True, 
    echo=True
)

# Sessão assíncrona
async_session = sessionmaker(
    engine, 
    class_=AsyncSession, 
    expire_on_commit=False
)