INNER CODE UNIT · Python

fetchall_filtered_by

c0sogi/LLMChat · app/database/schemas/__init__.py:108

    async def fetchall_filtered_by(
        cls: Type[TableGeneric], session: AsyncSession | None = None, **kwargs: Any
    ) -> list[TableGeneric]:
        stmt: Select[tuple] = select(cls).filter_by(**kwargs)
        return await db.scalars__fetchall(stmt=stmt, session=session)

    @classmethod
    async def one_filtered_by(
        cls: Type[TableGeneric], session: AsyncSession | None = None, **kwargs: Any
    ) -> TableGeneric:
        stmt: Select[tuple] = select(cls).filter_by(**kwargs)
        return await db.scalars__one(stmt=stmt, session=session)

    @classmethod
    async def first_filtered_by(
        cls: Type[TableGeneric], session: AsyncSession | None = None, **kwargs: Any
    ) -> TableGeneric:
        stmt: Select[tuple] = select(cls).filter_by(**kwargs)

View source record →