dive4elements/river: flys-backend/src/main/java/de/intevation/flys/importer/ImportDischargeTable.java annotate

annotate flys-backend/src/main/java/de/intevation/flys/importer/ImportDischargeTable.java @ 4198:1cdbd8a0c994

Added two new tables ClickableQDTable and ClickableWTable and made Ws and Qs clickable in historical discharge calculation. The new tables define listener interfaces (clicked lower or upper icon) to listen to user clicks. In addition to this, there is an enum ClickMode with NONE, SINGLE and RANGE options, which allows to specifiy, which icons are displayed in the tables. NONE means no icon for user clicks, SINGLE has 1 icon, RANGE 2 icons for lower and upper.

author	Ingo Weinzierl <ingo.weinzierl@intevation.de>
date	Mon, 22 Oct 2012 13:31:25 +0200
parents	cce054f27dac
children	20b6ebf23916

rev	line source
198 d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	1 package de.intevation.flys.importer;
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	2
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	3 import java.util.ArrayList;
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	4 import java.util.List;
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	5
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	6 import org.hibernate.Session;
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	7 import org.hibernate.Query;
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	8
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	9 import de.intevation.flys.model.DischargeTable;
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	10 import de.intevation.flys.model.Gauge;
486 8ea09ec7f0c8 Importer: Attach a time interval to a discharge table if we find one during import. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 473 diff changeset	11 import de.intevation.flys.model.TimeInterval;
198 d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	12
499 cce054f27dac Importer: Only accept main value types 'Q', 'W', 'D' and 'T' by default. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 497 diff changeset	13 import org.apache.log4j.Logger;
cce054f27dac Importer: Only accept main value types 'Q', 'W', 'D' and 'T' by default. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 497 diff changeset	14
198 d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	15 public class ImportDischargeTable
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	16 {
499 cce054f27dac Importer: Only accept main value types 'Q', 'W', 'D' and 'T' by default. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 497 diff changeset	17 private static Logger log = Logger.getLogger(ImportDischargeTable.class);
cce054f27dac Importer: Only accept main value types 'Q', 'W', 'D' and 'T' by default. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 497 diff changeset	18
198 d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	19 protected DischargeTable peer;
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	20
493 b35c5dc0f8b7 Importer: Make import of historical discharge tables work. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 492 diff changeset	21 protected String description;
b35c5dc0f8b7 Importer: Make import of historical discharge tables work. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 492 diff changeset	22
b35c5dc0f8b7 Importer: Make import of historical discharge tables work. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 492 diff changeset	23 protected Integer kind;
467 c8c09e31cdb8 Added new column 'kind' in discharge tables and wst to distinguish between different types. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 198 diff changeset	24
198 d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	25 protected List<ImportDischargeTableValue> dischargeTableValues;
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	26
486 8ea09ec7f0c8 Importer: Attach a time interval to a discharge table if we find one during import. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 473 diff changeset	27 protected ImportTimeInterval timeInterval;
198 d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	28
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	29 public ImportDischargeTable() {
493 b35c5dc0f8b7 Importer: Make import of historical discharge tables work. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 492 diff changeset	30 this(0, null);
492 14de9246b356 Importer: parse historical discharge tables, too. TODO: store them in database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 486 diff changeset	31 }
14de9246b356 Importer: parse historical discharge tables, too. TODO: store them in database. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 486 diff changeset	32
493 b35c5dc0f8b7 Importer: Make import of historical discharge tables work. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 492 diff changeset	33 public ImportDischargeTable(int kind, String description) {
b35c5dc0f8b7 Importer: Make import of historical discharge tables work. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 492 diff changeset	34 this.kind = kind;
b35c5dc0f8b7 Importer: Make import of historical discharge tables work. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 492 diff changeset	35 this.description = description;
198 d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	36 dischargeTableValues = new ArrayList<ImportDischargeTableValue>();
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	37 }
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	38
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	39
493 b35c5dc0f8b7 Importer: Make import of historical discharge tables work. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 492 diff changeset	40 public String getDescription() {
b35c5dc0f8b7 Importer: Make import of historical discharge tables work. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 492 diff changeset	41 return description;
b35c5dc0f8b7 Importer: Make import of historical discharge tables work. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 492 diff changeset	42 }
b35c5dc0f8b7 Importer: Make import of historical discharge tables work. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 492 diff changeset	43
b35c5dc0f8b7 Importer: Make import of historical discharge tables work. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 492 diff changeset	44 public void setDescription(String description) {
b35c5dc0f8b7 Importer: Make import of historical discharge tables work. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 492 diff changeset	45 this.description = description;
b35c5dc0f8b7 Importer: Make import of historical discharge tables work. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 492 diff changeset	46 }
b35c5dc0f8b7 Importer: Make import of historical discharge tables work. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 492 diff changeset	47
b35c5dc0f8b7 Importer: Make import of historical discharge tables work. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 492 diff changeset	48
198 d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	49 public void addDischargeTableValue(ImportDischargeTableValue value) {
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	50 dischargeTableValues.add(value);
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	51 }
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	52
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	53
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	54 public void setDischargeTableValues(List<ImportDischargeTableValue> values){
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	55 this.dischargeTableValues = values;
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	56 }
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	57
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	58
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	59 public List<ImportDischargeTableValue> getDischargeTableValues() {
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	60 return dischargeTableValues;
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	61 }
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	62
486 8ea09ec7f0c8 Importer: Attach a time interval to a discharge table if we find one during import. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 473 diff changeset	63 public ImportTimeInterval getTimeInterval() {
8ea09ec7f0c8 Importer: Attach a time interval to a discharge table if we find one during import. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 473 diff changeset	64 return timeInterval;
8ea09ec7f0c8 Importer: Attach a time interval to a discharge table if we find one during import. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 473 diff changeset	65 }
8ea09ec7f0c8 Importer: Attach a time interval to a discharge table if we find one during import. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 473 diff changeset	66
8ea09ec7f0c8 Importer: Attach a time interval to a discharge table if we find one during import. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 473 diff changeset	67 public void setTimeInterval(ImportTimeInterval timeInterval) {
8ea09ec7f0c8 Importer: Attach a time interval to a discharge table if we find one during import. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 473 diff changeset	68 this.timeInterval = timeInterval;
8ea09ec7f0c8 Importer: Attach a time interval to a discharge table if we find one during import. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 473 diff changeset	69 }
8ea09ec7f0c8 Importer: Attach a time interval to a discharge table if we find one during import. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 473 diff changeset	70
198 d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	71
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	72 public DischargeTable getPeer(Gauge gauge) {
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	73 if (peer == null) {
486 8ea09ec7f0c8 Importer: Attach a time interval to a discharge table if we find one during import. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 473 diff changeset	74 TimeInterval ti = timeInterval != null
8ea09ec7f0c8 Importer: Attach a time interval to a discharge table if we find one during import. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 473 diff changeset	75 ? timeInterval.getPeer()
8ea09ec7f0c8 Importer: Attach a time interval to a discharge table if we find one during import. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 473 diff changeset	76 : null;
497 67fd63e4ef66 Importer: centralized caching Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 493 diff changeset	77 Session session = ImporterSession.getInstance().getDatabaseSession();
198 d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	78
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	79 Query query = session.createQuery(
486 8ea09ec7f0c8 Importer: Attach a time interval to a discharge table if we find one during import. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 473 diff changeset	80 "from DischargeTable where " +
493 b35c5dc0f8b7 Importer: Make import of historical discharge tables work. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 492 diff changeset	81 "gauge.id=:gauge and kind=:kind and " +
b35c5dc0f8b7 Importer: Make import of historical discharge tables work. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 492 diff changeset	82 "description=:description and timeInterval=:interval");
b35c5dc0f8b7 Importer: Make import of historical discharge tables work. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 492 diff changeset	83 query.setParameter("gauge", gauge.getId());
b35c5dc0f8b7 Importer: Make import of historical discharge tables work. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 492 diff changeset	84 query.setParameter("description", description);
b35c5dc0f8b7 Importer: Make import of historical discharge tables work. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 492 diff changeset	85 query.setParameter("kind", kind);
b35c5dc0f8b7 Importer: Make import of historical discharge tables work. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 492 diff changeset	86 query.setParameter("interval", ti);
198 d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	87
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	88 List<DischargeTable> dischargeTables = query.list();
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	89 if (dischargeTables.isEmpty()) {
493 b35c5dc0f8b7 Importer: Make import of historical discharge tables work. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 492 diff changeset	90 peer = new DischargeTable(gauge, description, kind, ti);
198 d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	91 session.save(peer);
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	92 }
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	93 else {
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	94 peer = dischargeTables.get(0);
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	95 }
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	96 }
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	97
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	98 return peer;
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	99 }
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	100
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	101
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	102 public void storeDependencies(Gauge gauge) {
499 cce054f27dac Importer: Only accept main value types 'Q', 'W', 'D' and 'T' by default. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 497 diff changeset	103 log.info("store discharge table '" + description + "'");
198 d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	104 storeDischargeTableValues(gauge);
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	105 }
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	106
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	107
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	108 public void storeDischargeTableValues(Gauge gauge) {
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	109 DischargeTable dischargeTable = getPeer(gauge);
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	110
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	111 for (ImportDischargeTableValue value: dischargeTableValues) {
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	112 value.getPeer(dischargeTable);
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	113 }
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	114 }
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	115 }
d980e545ccab Added import code for importing discharge tables. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	116 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :

Mercurial > dive4elements > river

annotate flys-backend/src/main/java/de/intevation/flys/importer/ImportDischargeTable.java @ 4198:1cdbd8a0c994