Address

class q2_sdk.hq.db.address.AddressRow(element, row_class=None, rename_fields=None)

Bases: TableRow

AddressID: int

StreetAddress1: str

StreetAddress2: str

City: str

State: str

PostalCode: str

CustomerID: int

AddressType: int

UserID: int

CountryID: int

IsInternational: bool

Province: str

IsoCodeA2: str

IsoCodeA3: str

CountryName: str

class q2_sdk.hq.db.address.Address(logger, hq_credentials=None, ret_table_obj=None)

Bases: DbObject

Allows for additional address details given an address ID. Usually used in conjunction with a Default Address ID from a User query.

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 AddressRow

add_arguments(parser)

Hook for subclassed DbObjects to add custom arguments.

async get(address_id, serialize_for_cli=False)

Return type:

list[AddressRow]

async get_by_login(login_name, serialize_for_cli=False)

Return type:

list[AddressRow]

async create(address_object, user_id=None, customer_id=None)

Creates an address in the database. State should be a two character state code if country is USA, otherwise a province

async delete(address_id, online_user, online_session, time_occurred=None)

Deletes an address in the Q2_Address table. The User ID is required in the OnlineUser parameter in order to check the default address id on the Q2_User table before deletion. The deletion is audited :type address_id: int :param address_id: The id of the address to delete :type online_user: OnlineUser :param online_user: An OnlineUser object with the user id populated at the minimum :type online_session: OnlineSession :param online_session: An OnlineSession object used for auditing :type time_occurred: Optional[str] :param time_occurred: The ISO format timestamp of the deletion time.