主键
通过主键删除单条记录
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 | 删除数量 |