Sql = ''' SELECT DISTINCT f.id FROM tbl_flows f INNER JOIN tbl_exchanges e ON f.id = e.f_flow WHERE f.flow_type = 'ELEMENTARY_FLOW' ''' def collect_ids( r): Global db # collect the IDs of the used elementary flows # via an SQL query ids = set() util import Categories # set the path to the resulting CSV file here CSV_FILE = 'C:/Users/ms/Desktop/used_elem_flows.csv' def main(): database import FlowDao, NativeSql from org. getForName( 'Europe EI 99 E/E '))įor i in provider. withCosts = True method_dao = ImpactMethodDao( db) # load the product system db_dir = File( 'C:/Users/Besitzer/openLCA-data-1.4/databases/openlca_lcia_methods_1_5_5') matrix import NwSetTable if _name_ = '_main_': results import ContributionResultProvider from org. math import CalculationSetup, SystemCalculator from org. database import ProductSystemDao, Entit圜ache,\ close() Using the formula interpreterįrom java. Provider = ContributionResultProvider( result, e_cache) # calculation setup = CalculationSetup( system)Ĭalculator = SystemCalculator( m_cache, solver) # caches, native lib., solver m_cache = MatrixCache. # load the product system db_dir = File( 'C:/Users/Besitzer/openLCA-data-1.4/databases/ei_3_3_apos_dbv4')
results import ContributionResultProvider if _name_ = '_main_':
database import ProductSystemDao, Entit圜ache from org.