Module trase.tools.pcs.commodities.insert

Functions

def add_factor_to_commodity_equivalence_group(commodity_equivalence_factor_id, commodity_equivalence_group_id, autocommit=True, cnx=None, cur=None)

.

def insert_commodity(commodity_names, unit, commodity_codes=None, parent_id=None, autocommit=True, cnx=None, cur=None)

Insert commodity into database.

:param commodity_names: list of commodity names; first name is default name :type commodity_names: list[str] :param commodity_codes: list of (code_id, code_value) tuples :type commodity_codes: tuple[int, str] :param int parent_id: parent commodity id, use None for raw commodity :param cnx: Database connection object :type cnx: psycopg2.extensions.connection or pcs.connect.loggingConnection :param cur: Database cursor object :type cur: psycopg2.extensions.cursor or pcs.connect.loggingCursor :return: commodity id :rtype: int

def insert_commodity_code(commodity_code_name, description, autocommit=True, cnx=None, cur=None)

Insert commodity code into database.

commodity_code_name – commodity code name

Keyword arguments: ref_id – 'commodity_code_refs.id' in Trase database cnx – Trase database connection object cur – Trase database cursor object

def insert_commodity_code_value(commodity_id, code_id, code_value, autocommit=True, cnx=None, cur=None)

Insert commodity code value into database.

commodity_id – 'commodities.id' in Trase database code_id – 'commodity_codes.id' in Trase database code_value – code value

Keyword arguments: cnx – Trase database connection object cur – Trase database cursor object

def insert_commodity_equivalent(commodity_id, eq_factor, ref_id, node_id=None, time=None, autocommit=True, cnx=None, cur=None)

Insert raw commodity equivalence factor.

commodity_id – 'commodities.id' in Trase database eq_factor – raw commodity equivalence factor ref_id – 'commodity_equivalence_refs.id' in Trase database

Keyword arguments: node_id – 'nodes.id' in Trase database for place-specific factor time – time for time-specific factor cnx – Trase database connection object cur – Trase database cursor object

def insert_commodity_name(commodity_id, name, default, autocommit=True, cnx=None, cur=None)

Insert commodity name into database.

commodity_id – 'commodities.id' in Trase database name – commodity name default – name is default commodity name

Keyword arguments: cnx – Trase database connection object cur – Trase database cursor object