credmark.cmf.model.ledger.LedgerQueryTrace

class LedgerQueryTrace(**kwargs)[source]

Bases: TraceTable, LedgerQuery

Methods

`as_`
`describe`
`field`
`select`	Query data from the table.

Attributes

`BLOCK_HASH`
`BLOCK_NUMBER`
`BLOCK_TIMESTAMP`
`CALL_TYPE`
`ERROR`
`FROM_ADDRESS`
`GAS`
`INPUT`
`OUTPUT`
`REWARD_TYPE`
`STATUS`
`TO_ADDRESS`
`TRACE_ADDRESS`
`TRACE_ID`
`TRACE_TYPE`
`TRANSACTION_HASH`
`TRANSACTION_INDEX`
`TYPE_MAPPER`
`VALUE`
`alias`
`bigint_cols`
`colnames`	Return the set of column names in the table.
`columns`	Return the set of column names for the table.
`table_key`

property colnames: List[str]: Return the set of column names in the table. They can be used in the query.

property columns: List[str]

Return the set of column names for the table. They will be used in the database.

For contract ledger tables, the set will include all contract-specific columns.

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, omit_group_by_columns=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]) –
omit_group_by_columns (Optional[bool]) –

Return type

LedgerModelOutput