Home

---

Documentation: https://fastapi-practices.github.io/sqlalchemy-crud-plus

Source Code: https://github.com/fastapi-practices/sqlalchemy-crud-plus

---

Installing

pippdmuv

pip install sqlalchemy-crud-plus

pdm add sqlalchemy-crud-plus

uv add sqlalchemy-crud-plus

示例

api.pymodel.pyschema.py crud.pyservice.py

from typing import Annotated

from fastapi import APIRouter

router = APIRouter()


@router.get('/{pk}', summary="获取实例")
async def get_ins(pk: Annotated[int, Path(...)]) -> InsParam:
    ins = await ins_service.get_ins()
    return InsParam(ins)

from sqlalchemy.orm import declarative_base

Base = declarative_base()


class ModelIns(Base):
    # sqlalchemy model
    pass

from pydantic import BaseModel


class InsParam(BaseModel):
    # field
    pass

from sqlalchemy.ext.asyncio import AsyncSession

from sqlalchemy_crud_plus import CRUDPlus


# 在使用 IDE 时，传入类参数，将获得更友好的键入提示
class CRUDIns(CRUDPlus[ModelIns]):
    async def get(self, db: AsyncSession, pk: int) -> ModelIns:
        return await self.select_model(db, pk)

ins_dao: CRUDIns = CRUDIns(ModelIns)

class InsService:
    async def get_ins():
        async with async_db_session(pk: int) as db:
            ins = ins_dao.get(db, pk)

ins_service = InsService()

互动

TG / Discord

赞助

如果此项目能够帮助到你，你可以赞助作者一些咖啡豆表示鼓励：Sponsor