HostTransactionHistory

class q2_sdk.hq.db.host_transaction_history.HostTransactionHistoryRow(element, row_class=None, rename_fields=None)[source]

Bases: TableRow

TransactionID: int

HostAccountID: int

PostDate: str

HostTranNumber: str

HostTranCode: str

InsertDate: str

HostPostDate: str

RunningBalance: float

TxnAmount: float

CheckNumber: str

class q2_sdk.hq.db.host_transaction_history.HostTransactionHistory(logger, hq_credentials=None, ret_table_obj=None)[source]

Bases: DbObject

Programmatic access to the Q2 database. Not as flexible as a true ORM, but takes the guesswork out of database schemas and ensures safety in the transactions.

Parameters:

logger – Reference to calling request’s logger (self.logger in your extension)
hq_credentials (Optional[HqCredentials]) – HQ Connectivity Information (Defaults to settings file)
ret_table_obj (Optional[bool]) – Flag to return list of LXML elements if False or TableRow objects from DB calls if True (Defaults to settings file)

NAME = 'HostTransactionHistory'

REPRESENTATION_ROW_CLASS: alias of HostTransactionHistoryRow

add_arguments(parser)[source]: Hook for subclassed DbObjects to add custom arguments.

async get(transaction_id, serialize_for_cli=False)[source]

Return type:: List[HostTransactionHistoryRow]

async normalize_sandbox_postdates()[source]