Source code for q2_sdk.hq.db.subsidiary

from argparse import _SubParsersAction
from functools import partial
from typing import List

from q2_sdk.core.dynamic_imports import (
    api_ExecuteStoredProcedure as ExecuteStoredProcedure,
)
from q2_sdk.hq.table_row import TableRow

from .db_object import DbObject


[docs] class SubsidiaryRow(TableRow): UserID: int SubsidiaryID: int CustomerID: int DisplayName: str AchName: str AchTaxId: int WireName: str AddressID: int CreatedAt: str CreatedByUserLogonID: int CreatedbyAdminUserLogonID: int
[docs] class Subsidiary(DbObject): GET_BY_NAME_KEY = "DisplayName" NAME = "Subsidiary" REPRESENTATION_ROW_CLASS = SubsidiaryRow
[docs] def add_arguments(self, parser: _SubParsersAction): subparser = parser.add_parser("get_subsidiaries") subparser.set_defaults(parser="get") subparser.set_defaults(func=partial(self.get, serialize_for_cli=True)) subparser.add_argument("customer_id", help="Q2_Customer.CustomerID")
[docs] async def get( self, customer_id: int, serialize_for_cli=False ) -> List[SubsidiaryRow]: response = await self.call_hq( "sdk_GetSubsidiary", ExecuteStoredProcedure.SqlParameters([ ExecuteStoredProcedure.SqlParam( ExecuteStoredProcedure.DataType.Int, "customer_id", customer_id ) ]), ) if serialize_for_cli: columns = ["SubsidiaryID", "CustomerID", "DisplayName"] response = self.serialize_for_cli(response, columns) return response