VendorPropertyData

class q2_sdk.hq.db.vendor_property_data.VendorPropertyDataParams(property_name, vendor_id, property_value=None, zone_id=None, group_id=None, customer_id=None, user_id=None, user_role_id=None, product_type_id=None, product_id=None, host_account_id=None)[source]

Bases: object

VendorPropertyDataParams(property_name: str, vendor_id: int, property_value: Optional[str] = None, zone_id: Optional[int] = None, group_id: Optional[int] = None, customer_id: Optional[int] = None, user_id: Optional[int] = None, user_role_id: Optional[int] = None, product_type_id: Optional[int] = None, product_id: Optional[int] = None, host_account_id: Optional[int] = None)

property_name: str
vendor_id: int
property_value: Optional[str] = None
zone_id: Optional[int] = None
group_id: Optional[int] = None
customer_id: Optional[int] = None
user_id: Optional[int] = None
user_role_id: Optional[int] = None
product_type_id: Optional[int] = None
product_id: Optional[int] = None
host_account_id: Optional[int] = None
class q2_sdk.hq.db.vendor_property_data.VendorPropertyDataRow(element, row_class=None, rename_fields=None)[source]

Bases: TableRow

VendorPropertyID: IntElement = 'VendorPropertyID'
VendorPropertyElementID: IntElement = 'VendorPropertyElementID'
PropertyValue: StringElement = 'PropertyValue'
VendorID: IntElement = 'VendorID'
VendorPropertyName: StringElement = 'VendorPropertyName'
VendorName: StringElement = 'VendorName'
DataType: StringElement = 'DataType'
ZoneID: IntElement = 'ZoneID'
GroupID: IntElement = 'GroupID'
CustomerID: IntElement = 'CustomerID'
UserID: IntElement = 'UserID'
UserRoleID: IntElement = 'UserRoleID'
ProductTypeID: IntElement = 'ProductTypeID'
ProductID: IntElement = 'ProductID'
HostAccountID: IntElement = 'HostAccountID'
Weight: IntElement = 'Weight'
class q2_sdk.hq.db.vendor_property_data.VendorPropertyHostAccountDataRow(element, row_class=None, rename_fields=None)[source]

Bases: TableRow

HostAccountID: IntElement = 'HostAccountID'
PropertyValue: StringElement = 'PropertyValue'
async q2_sdk.hq.db.vendor_property_data.common_params(vendor_property_data_params, params)[source]
class q2_sdk.hq.db.vendor_property_data.HostAccountDataParams(HostAccountID, ProductID=None, ProductTypeID=None, UserID=None, UserRoleID=None, CustomerID=None, GroupID=None, ZoneID=None)[source]

Bases: object

HostAccountDataParams(HostAccountID: int, ProductID: Optional[int] = None, ProductTypeID: Optional[int] = None, UserID: Optional[int] = None, UserRoleID: Optional[int] = None, CustomerID: Optional[int] = None, GroupID: Optional[int] = None, ZoneID: Optional[int] = None)

HostAccountID: int
ProductID: Optional[int] = None
ProductTypeID: Optional[int] = None
UserID: Optional[int] = None
UserRoleID: Optional[int] = None
CustomerID: Optional[int] = None
GroupID: Optional[int] = None
ZoneID: Optional[int] = None
class q2_sdk.hq.db.vendor_property_data.VendorPropertyData(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 = 'VendorPropertyData'
REPRESENTATION_ROW_CLASS

alias of VendorPropertyDataRow

add_arguments(parser)[source]

Hook for subclassed DbObjects to add custom arguments.

async static common_params(vendor_property_data_params, params)[source]
async get_by_host_account_batch(property_name, vendor_id, host_account_data, serialize_for_cli=False)[source]
Return type:

[<class ‘q2_sdk.hq.db.vendor_property_data.VendorPropertyHostAccountDataRow’>]

async update(vendor_property_id, property_value)[source]
Return type:

list[VendorPropertyDataRow]

async get(vendor_property_data_params, serialize_for_cli=False)[source]
Return type:

[<class ‘q2_sdk.hq.db.vendor_property_data.VendorPropertyDataRow’>]

async add(vendor_property_data_params)[source]
async delete(vendor_property_id)[source]