Host Account

class q2_sdk.hq.db.host_account.HostAccountRow(element, row_class=None, rename_fields=None)

Bases: TableRow

HostAccountID: int

AccountNumberInternal: str

AccountNumberExternal: str

ProductID: int

ProductName: str

ProductNickName: str

AccountDesc: str

CIFInternal: str

CIFExternal: str

DefaultPwd: str

DataAsOfDate: str

BranchID: int

SkipBalanceCheck: bool

ABA: str

IsExternalAccount: bool

AccountInfo: str

LastStatusChange: str

AccountStatusID: int

LastHistoryDate: str

class q2_sdk.hq.db.host_account.HostAccountCustomerRow(element, row_class=None, rename_fields=None)

Bases: TableRow

CustomerID: int

UserID: int

HostAccountID: int

AccountNumberInternal: str

AccountNumberExternal: str

ProductID: int

ProductName: str

AccountDesc: str

CIFInternal: str

CIFExternal: str

DataAsOfDate: str

ProductTypeName: str

ABA: str

IsExternalAccount: bool

class q2_sdk.hq.db.host_account.HostAccountCustomerWithProductRow(element, row_class=None, rename_fields=None)

Bases: TableRow

CustomerID: int

HostAccountID: int

ProductName: str

ProductID: int

AccountStatus: str

class q2_sdk.hq.db.host_account.UpdateAccountRightsParameters(hostAccountId, userId, can_view, can_deposit, can_withdraw)

Bases: object

UpdateAccountRightsParameters(hostAccountId: int, userId: int, can_view: bool, can_deposit: bool, can_withdraw: bool)

hostAccountId: int

userId: int

can_view: bool

can_deposit: bool

can_withdraw: bool

calculate_access()

Return type:

int

build_sql_parameters()

class q2_sdk.hq.db.host_account.ProductChangeParameters(host_account_id, old_product_id, new_product_id)

Bases: object

ProductChangeParameters(host_account_id: int, old_product_id: int, new_product_id: int)

host_account_id: int

old_product_id: int

new_product_id: int

build_xml_node()

enum q2_sdk.hq.db.host_account.ProductChangeStatus(value)

Bases: Enum

Valid values are as follows:

Ok = <ProductChangeStatus.Ok: 'OK'>

AllRecordsSkipped = <ProductChangeStatus.AllRecordsSkipped: 'AllRecordsSkipped'>

PartialUpdate = <ProductChangeStatus.PartialUpdate: 'PartialUpdate'>

class q2_sdk.hq.db.host_account.ProductChangeResults(result, successful_accounts, skipped_accounts)

Bases: object

ProductChangeResults(result: q2_sdk.hq.db.host_account.ProductChangeStatus, successful_accounts: list, skipped_accounts: list)

result: ProductChangeStatus

successful_accounts: list

skipped_accounts: list

class q2_sdk.hq.db.host_account.HostAccount(logger, hq_credentials=None, ret_table_obj=None)

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)

REPRESENTATION_ROW_CLASS

alias of HostAccountRow

add_arguments(parser)

Hook for subclassed DbObjects to add custom arguments.

async check_adapter_mode()

Note: this only works in the dev environment

async update_to_batch()

Note: this only works in the dev environment

async get_by_id(host_account_id, serialize_for_cli=False)

Return type:

HostAccountRow

async create(account_internal, account_external, product_id, cif, account_description, is_external=False)

Note: this only works in the dev environment

Return type:

list[HostAccountRow]

async search_by_external_number(external_account_number)

Return type:

list[HostAccountRow]

async search_by_internal_number(internal_account_number)

Return type:

list[HostAccountRow]

async update_account_rights(parameters)

Update the account rights for an account linked to a user. This only works for accounts explicitly linked to the user, and will not work for accounts linked by a cif.

async get_customer_host_accounts(customer_ids)

Retrieves multiple accounts associated to the customers in the list. For DB performance reason, the customer id list should be limited to 20

Parameters:

customer_ids (list[int]) – list of Q2_Customer.CustomerID <= 20

Return type:

list[HostAccountCustomerRow]

async get_accounts_by_product(group_id, product_id=None)

Searches a group of customers for accounts with a specific product id

Parameters:

• group_id (int) – Group to search [Q2_Group.GroupID]

• product_id (Optional[int]) – Product ID of the target product [Q2_Product.ProductID]

Return type:

list[HostAccountCustomerWithProductRow]

async change_account_product(account_changes)

Changes the product of a list of accounts :type account_changes: list[ProductChangeParameters] :param account_changes: list of ProductChangeParameters objects. :rtype: ProductChangeResults :return: ProductChangeResults object