SystemPropertyData

class q2_sdk.hq.db.system_property_data.ZoneContext(zone_id=None)[source]

Bases: object

If there is a zone context at all, even with null zone_id, the response will include zone data

zone_id: Optional[int] = None
static from_zone_id(zone_id)[source]
Return type:

ZoneContext

async static from_group_id(group_id)[source]
Return type:

ZoneContext

class q2_sdk.hq.db.system_property_data.SystemPropertyDataRow(element, row_class=None, rename_fields=None)[source]

Bases: TableRow

Data from the Q2_SystemPropertyData table

SystemPropertyDataID: int
PropertyID: int
PropertyValue: str
PropertyName: str
PropertyLongName: str
PropertyDataType: str
Weight: int
UISourceID: int
ProductTypeID: int
ProductID: int
GroupID: int
HADE_ID: int
class q2_sdk.hq.db.system_property_data.ZonedSystemPropertyDataRow(element, row_class=None, rename_fields=None)[source]

Bases: TableRow

Data from the Q2_ZoneSystemPropertyData table

ZoneSystemPropertyDataID: int
SystemPropertyDataID: int
ZoneId: int
PropertyID: int
PropertyValue: str
PropertyName: str
PropertyLongName: str
PropertyDataType: str
Weight: int
UISourceID: int
ProductTypeID: int
ProductID: int
GroupID: int
HADE_ID: int
class q2_sdk.hq.db.system_property_data.SystemPropertyData(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)

GET_BY_NAME_KEY = 'PropertyName'
NAME = 'SystemPropertyData'
REPRESENTATION_ROW_CLASS

alias of SystemPropertyDataRow

add_arguments(parser)[source]

Hook for subclassed DbObjects to add custom arguments.

async get(name=None, group_id=None, hade_id=None, return_count=10, no_trunc=False, strict=False, zone_context=None, serialize_for_cli=False, **kwargs)[source]
Return type:

List[SystemPropertyDataRow]

async get_by_id(property_id, serialize_for_cli=False)[source]
async update(property_name, property_value, group_id=None)[source]
async add(property_name, property_value, product_type_name=None, serialize_for_cli=False)[source]
exception q2_sdk.hq.db.system_property_data.ZoneNotFoundError[source]

Bases: Exception

No zone found