Skip to content

列表

通过列查询多条记录

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] 模型实例序列