dive4elements/river: flys-aft/src/main/java/de/intevation/aft/WQDiff.java annotate

annotate flys-aft/src/main/java/de/intevation/aft/WQDiff.java @ 4798:39885bdfc6fc

Added calculation of the "Umhuellende" to calculation of "W fuer ungleichwertige Abfluesse". This is done by figuring out the WST columns that imfold the data and then do simple "gleichwertige" calculations from the start of the interval. This is too much because only the Qs are needed for the "Umhuellende".

author	Sascha L. Teichmann <teichmann@intevation.de>
date	Sun, 13 Jan 2013 16:18:28 +0100
parents	f939e1e6cfa4
children

rev	line source
4096 82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	1 package de.intevation.aft;
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	2
4772 f939e1e6cfa4 Sorted imports. Sascha L. Teichmann <teichmann@intevation.de> parents: 4736 diff changeset	3 import de.intevation.db.ConnectedStatements;
f939e1e6cfa4 Sorted imports. Sascha L. Teichmann <teichmann@intevation.de> parents: 4736 diff changeset	4 import de.intevation.db.SymbolicStatement;
4096 82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	5
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	6 import java.sql.ResultSet;
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	7 import java.sql.SQLException;
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	8
4772 f939e1e6cfa4 Sorted imports. Sascha L. Teichmann <teichmann@intevation.de> parents: 4736 diff changeset	9 import java.util.Collection;
f939e1e6cfa4 Sorted imports. Sascha L. Teichmann <teichmann@intevation.de> parents: 4736 diff changeset	10 import java.util.Iterator;
f939e1e6cfa4 Sorted imports. Sascha L. Teichmann <teichmann@intevation.de> parents: 4736 diff changeset	11 import java.util.Set;
f939e1e6cfa4 Sorted imports. Sascha L. Teichmann <teichmann@intevation.de> parents: 4736 diff changeset	12 import java.util.TreeSet;
4096 82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	13
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	14 public class WQDiff
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	15 {
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	16 protected Set<WQ> toAdd;
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	17 protected Set<WQ> toDelete;
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	18
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	19 public WQDiff() {
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	20 }
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	21
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	22 public WQDiff(Collection<WQ> a, Collection<WQ> b) {
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	23 toAdd = new TreeSet<WQ>(WQ.EPS_CMP);
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	24 toDelete = new TreeSet<WQ>(WQ.EPS_CMP);
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	25 build(a, b);
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	26 }
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	27
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	28 public void build(Collection<WQ> a, Collection<WQ> b) {
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	29 toAdd.addAll(b);
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	30 toAdd.removeAll(a);
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	31
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	32 toDelete.addAll(a);
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	33 toDelete.removeAll(b);
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	34 }
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	35
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	36 public void clear() {
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	37 toAdd.clear();
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	38 toDelete.clear();
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	39 }
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	40
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	41 public Set<WQ> getToAdd() {
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	42 return toAdd;
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	43 }
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	44
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	45 public void setToAdd(Set<WQ> toAdd) {
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	46 this.toAdd = toAdd;
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	47 }
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	48
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	49 public Set<WQ> getToDelete() {
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	50 return toDelete;
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	51 }
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	52
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	53 public void setToDelete(Set<WQ> toDelete) {
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	54 this.toDelete = toDelete;
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	55 }
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	56
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	57 public boolean hasChanges() {
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	58 return !(toAdd.isEmpty() && toDelete.isEmpty());
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	59 }
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	60
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	61 public void writeChanges(
4736 b195fede1c3b Remove trailing whitespace. Sascha L. Teichmann <teichmann@intevation.de> parents: 4096 diff changeset	62 SyncContext context,
4096 82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	63 int tableId
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	64 )
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	65 throws SQLException
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	66 {
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	67 ConnectedStatements flysStatements = context.getFlysStatements();
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	68
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	69 // Delete the old entries
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	70 if (!toDelete.isEmpty()) {
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	71 SymbolicStatement.Instance deleteDTV =
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	72 flysStatements.getStatement("delete.discharge.table.value");
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	73 for (WQ wq: toDelete) {
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	74 deleteDTV
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	75 .clearParameters()
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	76 .setInt("id", wq.getId())
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	77 .execute();
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	78 }
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	79 }
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	80
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	81 // Add the new entries.
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	82 if (!toAdd.isEmpty()) {
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	83 SymbolicStatement.Instance nextId =
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	84 flysStatements.getStatement("next.discharge.table.values.id");
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	85
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	86 SymbolicStatement.Instance insertDTV =
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	87 flysStatements.getStatement("insert.discharge.table.value");
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	88
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	89 // Recycle old ids as much as possible.
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	90 Iterator<WQ> oldIds = toDelete.iterator();
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	91
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	92 // Create ids for new entries.
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	93 for (WQ wq: toAdd) {
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	94 if (oldIds.hasNext()) {
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	95 wq.setId(oldIds.next().getId());
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	96 }
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	97 else {
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	98 ResultSet rs = nextId.executeQuery();
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	99 rs.next();
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	100 wq.setId(rs.getInt("discharge_table_values_id"));
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	101 rs.close();
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	102 }
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	103 }
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	104
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	105 // Write the new entries.
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	106 for (WQ wq: toAdd) {
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	107 insertDTV
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	108 .clearParameters()
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	109 .setInt("id", wq.getId())
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	110 .setInt("table_id", tableId)
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	111 .setDouble("w", wq.getW())
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	112 .setDouble("q", wq.getQ())
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	113 .execute();
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	114 }
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	115 }
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	116 }
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	117 }
82f5266f881b Add code to build the difference of the W/Q values of two discharge tables. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	118 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :

Mercurial > dive4elements > river

annotate flys-aft/src/main/java/de/intevation/aft/WQDiff.java @ 4798:39885bdfc6fc