py4ai.data.layer.sqlalchemy.criteria module

Module for SQL Alchemy query implementations.

class py4ai.data.layer.sqlalchemy.criteria.SqlAlchemySearchCriteria(query: Optional[Union[BinaryExpression, BooleanClauseList, bool]] = None)

Bases: SearchCriteria[Union[BinaryExpression, BooleanClauseList, bool]]

Base Query Implementation for SQL Alchemy.

Return instance of SQL Alchemy Query.

Parameters

query – SqlAlchemyQuery using either binary expressions or boolean clause lists

static empty() → SqlAlchemySearchCriteria

Return an empty query, i.e. a query including all items.

Returns

empty query

property query: BinaryExpression

Return the underlying query as SQL Alchemy object.

Returns

underlying query as SQL Alchemy object