Module trase.tools.pcs.commodities.codes.retrieve

Functions

def find_commodity_by_code(code_value: str, code_name: str = 'HS6', cur=None) ‑> int

Find commodity id from commodity code name and commodity code value.

code_name – commodity code name code_value – commodity code value

Keyword arguments: cur – Trase database connection object

def get_all_commodity_codes(commodity_id: int, cur=None) ‑> Tuple[int, List[str]]

def get_commodity_code_data(commodity_code_id: int, cur=None) ‑> Tuple[str, str]

Return name and reference for commodity code id.

commodity_code_id – 'commodity_codes.id' in Trase database

Keyword arguments: cur – Trase database cursor object

def get_commodity_code_id(commodity_code_name: str, cur=None) ‑> int

Return commodity code id from commodity code name.

commodity_code_name – 'commodity_codes.name' in Trase database

Keyword arguments: cur – Trase database cursor object

def get_commodity_codes(commodity_id: int, commodity_code_id: int, cur=None) ‑> Dict[str, int]

Return dictionary of {"commodity code" : commodity id}

commodity_id – 'commodities.id' in Trase database.