Skip to content

主键

通过主键删除单条记录

delete_model
from sqlalchemy_crud_plus import CRUDPlus

from sqlalchemy import Mapped, mapped_column
from sqlalchemy import DeclarativeBase as Base
from sqlalchemy.ext.asyncio import AsyncSession


class ModelIns(Base):
    # define your primary_key
    primary_key: Mapped[int] = mapped_column(primary_key=True, index=True, autoincrement=True)


class CRUDIns(CRUDPlus[ModelIns]):
    async def delete(self, db: AsyncSession, pk: int) -> int:
        return await self.delete_model(db, pk)

API

async def delete_model(
    self,
    session: AsyncSession,
    pk: int,
    flush: bool = False,
    commit: bool = False,
) -> int:

Parameters:

Name Type Description Default
session AsyncSession 数据库会话 必填
pk int 主键 必填
flush bool 冲洗 False
commit bool 提交 False

Returns:

Type Description
int 删除数量