from __future__ import annotations from typing import TYPE_CHECKING, Sequence from sqlalchemy import select from sqlalchemy.orm import DeclarativeBase, Mapped, mapped_column from litestar import Litestar, post from litestar.di import NamedDependency from litestar.plugins.sqlalchemy import SQLAlchemyPlugin, SQLAlchemySyncConfig if TYPE_CHECKING: from sqlalchemy.orm import Session class Base(DeclarativeBase): ... class TodoItem(Base): __tablename__ = "todo_item" title: Mapped[str] = mapped_column(primary_key=True) done: Mapped[bool] @post("/", sync_to_thread=True) def add_item(data: TodoItem, db_session: NamedDependency[Session]) -> Sequence[TodoItem]: with db_session.begin(): db_session.add(data) return db_session.execute(select(TodoItem)).scalars().all() config = SQLAlchemySyncConfig(connection_string="sqlite:///todo_sync.sqlite", create_all=True, metadata=Base.metadata) plugin = SQLAlchemyPlugin(config=config) app = Litestar(route_handlers=[add_item], plugins=[plugin])