SystemPropertyDataWithReferences

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

Bases: TableRow

SystemPropertyDataID: int | None
PropertyValue: str | None
Weight: int | None
UISourceID: int | None
ProductTypeID: int | None
ProductID: int | None
GroupID: int | None
HADE_ID: int | None
PropertyID: int | None
Property: Any | None
UISource: Any | None
ProductType: Any | None
Product: Any | None
Group: Any | None
HADE: Any | None
class q2_sdk.hq.db.system_property_data_with_references.SystemPropertyDataWithReferences(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 = 'SystemPropertyDataWithReferences'
REPRESENTATION_ROW_CLASS

alias of SystemPropertyDataWithReferencesRow

async get(system_property_data_id=None, property_id=None, property_name=None, product_id=None, product_type_id=None, hade_id=None, serialize_for_cli=False)[source]
Return type:

list[SystemPropertyDataWithReferencesRow]

async add(property_name, property_value, ui_source_id=None, product_type_id=None, product_id=None, group_id=None, hade_id=None)[source]

Insert new system property data using individual parameters. This matches the dbo.sdk_InsertSystemPropertyDataWithReferences stored procedure.

Return type:

Any

async update(system_property_data_id, property_name, property_value, ui_source_id=None, product_type_id=None, product_id=None, group_id=None, hade_id=None)[source]

Update an existing system property data record using individual parameters. This matches the dbo.sdk_UpdateSystemPropertyDataWithReferences stored procedure.

Return type:

Any