列表
通过列查询多条记录
select_models
from typing import Sequence
from sqlalchemy_crud_plus import CRUDPlus
from sqlalchemy import DeclarativeBase as Base
from sqlalchemy.ext.asyncio import AsyncSession
class ModelIns(Base):
# your sqlalchemy model
pass
class CRUDIns(CRUDPlus[ModelIns]):
async def create(self, db: AsyncSession) -> Sequence[ModelIns]:
return await self.select_models(db)
API¶
async def select_models(
self,
session: AsyncSession,
*whereclause: ColumnExpressionArgument[bool],
**kwargs,
) -> Sequence[Row[Any] | RowMapping | Any]:
Parameters:
Name | Type | Description | Default |
---|---|---|---|
session | AsyncSession | 数据库会话 | 必填 |
*whereclause | ColumnExpressionArgument[bool] |
等同于 SQLAlchemy where | |
**kwargs | 条件过滤,将创建条件查询 SQL |
Returns:
Type | Description |
---|---|
Sequence[Row[Any] |RowMapping |Any] |
模型实例序列 |