INNER CODE UNIT · Python
one_or_none_filtered_by
c0sogi/LLMChat · app/database/schemas/__init__.py:129
async def one_or_none_filtered_by(
cls: Type[TableGeneric], session: AsyncSession | None = None, **kwargs: Any
) -> Optional[TableGeneric]:
stmt: Select[tuple] = select(cls).filter_by(**kwargs)
return await db.scalars__one_or_none(stmt=stmt, session=session)
@classmethod
async def fetchall_filtered(
cls: Type[TableGeneric],
*criteria: _ColumnExpressionArgument[bool],
session: AsyncSession | None = None,
) -> list[TableGeneric]:
stmt: Select[tuple] = select(cls).filter(*criteria)
return await db.scalars__fetchall(stmt=stmt, session=session)
@classmethod
async def one_filtered(
cls: Type[TableGeneric],