Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance. Project price only 1 $
You can buy this project and download/modify it how often you want.
package org.openlca.io.ecospold2.input;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.HashMap;
import java.util.HashSet;
import java.util.Set;
import org.openlca.core.database.IDatabase;
import org.openlca.core.database.NativeSql;
import org.openlca.core.model.UncertaintyType;
import org.openlca.util.Strings;
/**
* In ecoinvent 3.x, a waste flow is an intermediate exchange with a negative
* amount and an opposite direction than the real flow (i.e. it is an output of
* a waste treatment processes and an input of a waste producing processes).
* Thus, product flows (intermediate exchanges) that have only negative values
* can be identified as waste flows (there may also flows with negative and
* positive values occur as a result of an allocation or system expansion model
* but it is not that easy to decide whether these are waste flows). This class
* provides functions to map such negative-only flows to waste flows and waste
* flows back to negative-only products by switching the amount values and
* flow directions accordingly.
*/
public class WasteFlows {
private final IDatabase db;
private WasteFlows(IDatabase db) {
this.db = db;
}
/**
* Maps negative-only product flows to waste flows.
*/
public static void map(IDatabase db) {
WasteFlows w = new WasteFlows(db);
Set products = w.getFlows("PRODUCT_FLOW");
Set wastes = w.identifyWasteFlows(products);
w.changeFlowType(wastes, "WASTE_FLOW");
w.invertExchanges(wastes);
db.getEntityFactory().getCache().evictAll();
}
public static void unmap(IDatabase db) {
WasteFlows w = new WasteFlows(db);
Set wastes = w.getFlows("WASTE_FLOW");
w.changeFlowType(wastes, "PRODUCT_FLOW");
w.invertExchanges(wastes);
db.getEntityFactory().getCache().evictAll();
}
/**
* Returns the IDs of all flows in the database with the given type.
*/
private Set getFlows(String type) {
String sql = "SELECT id FROM tbl_flows WHERE flow_type = '" + type + "'";
HashSet ids = new HashSet<>();
try {
NativeSql.on(db).query(sql, r -> {
ids.add(r.getLong(1));
return true;
});
} catch (Exception e) {
throw new RuntimeException(
"failed to query product IDs: " + sql, e);
}
return ids;
}
/**
* Returns the IDs of the given product flows that we can identify as waste
* flows, i.e. they have always negative values.
*/
private Set identifyWasteFlows(Set products) {
String sql = "SELECT f_flow, resulting_amount_value FROM tbl_exchanges";
HashMap allNegs = new HashMap<>();
try {
NativeSql.on(db).query(sql, r -> {
long flowID = r.getLong(1);
if (!products.contains(flowID)) {
return true;
}
double amount = r.getDouble(2);
Boolean prev = allNegs.get(flowID);
if (prev == null) {
allNegs.put(flowID, amount < 0);
} else if (prev && amount >= 0) {
allNegs.put(flowID, false);
}
return true;
});
} catch (Exception e) {
throw new RuntimeException(
"failed to search for waste flows: " + sql, e);
}
HashSet wastes = new HashSet<>();
allNegs.forEach((id, neg) -> {
if (neg != null && neg) {
wastes.add(id);
}
});
return wastes;
}
private void changeFlowType(Set flows, String flowType) {
String sql = "SELECT id, flow_type FROM tbl_flows";
try (Connection con = db.createConnection();
Statement stmt = con.createStatement(
ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
ResultSet rs = stmt.executeQuery(sql)) {
while (rs.next()) {
long flowID = rs.getLong(1);
if (!flows.contains(flowID))
continue;
rs.updateString(2, flowType);
rs.updateRow();
}
con.commit();
} catch (Exception e) {
throw new RuntimeException(
"failed to switch products to waste flows", e);
}
}
/**
* Inverts the amount values and directions of the exchanges for the given
* flows. Note that we also need to invert formulas and parameters from
* possible uncertainty distributions. Cost values should remain the same.
*/
private void invertExchanges(Set wastes) {
String sql = "SELECT " +
/* 1 */ "f_flow, " +
/* 2 */ "is_input, " +
/* 3 */ "resulting_amount_value, " +
/* 4 */ "resulting_amount_formula, " +
/* 5 */ "distribution_type, " +
/* 6 */ "parameter1_value, " +
/* 7 */ "parameter2_value, " +
/* 8 */ "parameter3_value " +
"FROM tbl_exchanges";
try (Connection con = db.createConnection();
Statement stmt = con.createStatement(
ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
ResultSet rs = stmt.executeQuery(sql)) {
while (rs.next()) {
long flowID = rs.getLong(1);
if (!wastes.contains(flowID))
continue;
// is_input
boolean isInput = rs.getBoolean(2);
rs.updateBoolean(2, !isInput);
// amount
double amount = rs.getDouble(3);
if (amount != 0.0) {
rs.updateDouble(3, -amount);
}
// formula
String formula = rs.getString(4);
if (Strings.notEmpty(formula)) {
rs.updateString(4, invertFormula(formula));
}
// uncertainty
int utype = rs.getInt(5);
if (!rs.wasNull()) {
UncertaintyType u = UncertaintyType.values()[utype];
switch (u) {
case NORMAL, LOG_NORMAL -> rs.updateDouble(6, -rs.getDouble(6));
case UNIFORM -> {
rs.updateDouble(6, -rs.getDouble(6));
rs.updateDouble(7, -rs.getDouble(7));
}
case TRIANGLE -> {
rs.updateDouble(6, -rs.getDouble(6));
rs.updateDouble(7, -rs.getDouble(7));
rs.updateDouble(8, -rs.getDouble(8));
}
default -> {
}
}
}
rs.updateRow();
}
con.commit();
} catch (Exception e) {
throw new RuntimeException(
"failed to swap waste flow exchanges", e);
}
}
private String invertFormula(String formula) {
// we try to be a bit smart here so that the inversion of an inverted
// formula returns the original formula
if (formula.startsWith("-1 * (") && formula.endsWith(")")) {
return formula.substring(6, formula.length() - 1);
}
return "-1 * (" + formula + ")";
}
}
