credmark.cmf.types.ledger_query.LedgerQuery

class LedgerQuery(**kwargs)

Bases: LedgerQueryBase

Methods

field
select	Query data from the table.

select(columns=None, joins=None, where=None, group_by=None, order_by=None, limit=None, offset=None, aggregates=None, having=None, bigint_cols=None, analytics_mode=None)

Query data from the table.

Parameters

• columns (Optional[Union[list[str], list[credmark.cmf.types.ledger.ColumnField]]]) –

• joins (Optional[list[Union[tuple[credmark.cmf.types.ledger.JoinType, credmark.cmf.types.ledger.LedgerTable, str], tuple[credmark.cmf.types.ledger.LedgerTable, str], tuple[credmark.cmf.types.ledger.JoinType, credmark.cmf.types.ledger.LedgerTable, credmark.cmf.types.ledger.ColumnField], tuple[credmark.cmf.types.ledger.LedgerTable, credmark.cmf.types.ledger.ColumnField]]]]) –

• where (Optional[str]) –

• group_by (Optional[Union[list[str], list[credmark.cmf.types.ledger.ColumnField]]]) –

• order_by (Optional[Union[str, ColumnField]]) –

• limit (Optional[int]) –

• offset (Optional[int]) –

• aggregates (Optional[list[tuple[str, str]]]) –

• having (Optional[str]) –

• bigint_cols (Optional[list[str]]) –

• analytics_mode (Optional[bool]) –

Return type

LedgerModelOutput