dive4elements/river: artifacts/src/main/java/org/dive4elements/river/artifacts/model/minfo/QualityMeasurementFactory.java annotate

annotate artifacts/src/main/java/org/dive4elements/river/artifacts/model/minfo/QualityMeasurementFactory.java @ 8856:5e38e2924c07 3.2.x

Fix code style.

author	Tom Gottfried <tom@intevation.de>
date	Thu, 18 Jan 2018 20:12:01 +0100
parents	5855f919cbd6
children	0a5239a1e46e

rev	line source
5863 4897a58c8746 River artifacts: Added new copyright headers. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	1 /* Copyright (C) 2011, 2012, 2013 by Bundesanstalt für Gewässerkunde
4897a58c8746 River artifacts: Added new copyright headers. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	2 * Software engineering by Intevation GmbH
4897a58c8746 River artifacts: Added new copyright headers. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	3 *
5994 af13ceeba52a Removed trailing whitespace. Sascha L. Teichmann <teichmann@intevation.de> parents: 5863 diff changeset	4 * This file is Free Software under the GNU AGPL (>=v3)
5863 4897a58c8746 River artifacts: Added new copyright headers. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	5 * and comes with ABSOLUTELY NO WARRANTY! Check out the
5994 af13ceeba52a Removed trailing whitespace. Sascha L. Teichmann <teichmann@intevation.de> parents: 5863 diff changeset	6 * documentation coming with Dive4Elements River for details.
5863 4897a58c8746 River artifacts: Added new copyright headers. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	7 */
4897a58c8746 River artifacts: Added new copyright headers. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	8
5831 bd047b71ab37 Repaired internal references Sascha L. Teichmann <teichmann@intevation.de> parents: 4807 diff changeset	9 package org.dive4elements.river.artifacts.model.minfo;
3755 9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	10
9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	11 import java.util.Date;
9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	12 import java.util.HashMap;
9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	13 import java.util.Map;
9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	14
3769 728ecd2afa20 Implemented bed quality calculation in minfo module. Raimund Renkert <raimund.renkert@intevation.de> parents: 3758 diff changeset	15 import org.apache.log4j.Logger;
3755 9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	16 import org.hibernate.SQLQuery;
9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	17 import org.hibernate.Session;
9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	18 import org.hibernate.transform.BasicTransformerAdapter;
9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	19 import org.hibernate.type.StandardBasicTypes;
9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	20
5831 bd047b71ab37 Repaired internal references Sascha L. Teichmann <teichmann@intevation.de> parents: 4807 diff changeset	21 import org.dive4elements.river.backend.SedDBSessionHolder;
8684 2e11fc7f5d35 (issue1796) Use seddb name of a river when accessing the seddb Andre Heinecke <andre.heinecke@intevation.de> parents: 8202 diff changeset	22 import org.dive4elements.river.artifacts.model.RiverFactory;
3755 9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	23
3758 75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	24
3755 9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	25 public class QualityMeasurementFactory {
9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	26
8856 5e38e2924c07 Fix code style. Tom Gottfried <tom@intevation.de> parents: 8787 diff changeset	27 private static Logger log = Logger.getLogger(
5e38e2924c07 Fix code style. Tom Gottfried <tom@intevation.de> parents: 8787 diff changeset	28 QualityMeasurementFactory.class);
3769 728ecd2afa20 Implemented bed quality calculation in minfo module. Raimund Renkert <raimund.renkert@intevation.de> parents: 3758 diff changeset	29
3758 75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	30 private static final String SQL_BED_MEASUREMENT =
8787 5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	31 "SELECT dat.km as km," +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	32 " dat.datum as datum," +
3769 728ecd2afa20 Implemented bed quality calculation in minfo module. Raimund Renkert <raimund.renkert@intevation.de> parents: 3758 diff changeset	33 " sp.tiefevon as depth1," +
728ecd2afa20 Implemented bed quality calculation in minfo module. Raimund Renkert <raimund.renkert@intevation.de> parents: 3758 diff changeset	34 " sp.tiefebis as depth2," +
3758 75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	35 " sa.d10 as d10," +
7630 3da531976039 issue1043: Fetch 'dm'-values in QualityMeasurementFactory. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6781 diff changeset	36 " sa.dm as dm," +
3758 75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	37 " sa.d16 as d16," +
75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	38 " sa.d20 as d20," +
75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	39 " sa.d25 as d25," +
75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	40 " sa.d30 as d30," +
75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	41 " sa.d40 as d40," +
75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	42 " sa.d50 as d50," +
75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	43 " sa.d60 as d60," +
75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	44 " sa.d70 as d70," +
75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	45 " sa.d75 as d75," +
75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	46 " sa.d80 as d80," +
75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	47 " sa.d84 as d84," +
75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	48 " sa.d90 as d90," +
75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	49 " sa.dmin as dmin," +
75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	50 " sa.dmax as dmax " +
8787 5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	51 "FROM sohltest dat " +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	52 " JOIN station sn ON sn.stationid = dat.stationid " +
3769 728ecd2afa20 Implemented bed quality calculation in minfo module. Raimund Renkert <raimund.renkert@intevation.de> parents: 3758 diff changeset	53 " JOIN gewaesser gw ON gw.gewaesserid = sn.gewaesserid " +
8787 5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	54 " JOIN sohlprobe sp ON sp.sohltestid = dat.sohltestid " +
3758 75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	55 " JOIN siebanalyse sa ON sa.sohlprobeid = sp.sohlprobeid " +
3755 9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	56 "WHERE gw.name = :name AND " +
8787 5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	57 " dat.km IS NOT NULL AND " +
3769 728ecd2afa20 Implemented bed quality calculation in minfo module. Raimund Renkert <raimund.renkert@intevation.de> parents: 3758 diff changeset	58 " sp.tiefevon IS NOT NULL AND " +
8856 5e38e2924c07 Fix code style. Tom Gottfried <tom@intevation.de> parents: 8787 diff changeset	59 " sp.tiefebis IS NOT NULL AND " +
8787 5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	60 " dat.km BETWEEN :from - 0.001 AND :to + 0.001 ";
8856 5e38e2924c07 Fix code style. Tom Gottfried <tom@intevation.de> parents: 8787 diff changeset	61 // TODO: Test if char diameter ist null.
3755 9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	62
3758 75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	63 private static final String SQL_BEDLOAD_MEASUREMENT =
8787 5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	64 "SELECT dat.km as km," +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	65 " dat.datum as datum," +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	66 " dat.dm as dm," +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	67 " dat.d10 as d10," +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	68 " dat.d16 as d16," +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	69 " dat.d20 as d20," +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	70 " dat.d25 as d25," +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	71 " dat.d30 as d30," +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	72 " dat.d40 as d40," +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	73 " dat.d50 as d50," +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	74 " dat.d60 as d60," +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	75 " dat.d70 as d70," +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	76 " dat.d75 as d75," +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	77 " dat.d80 as d80," +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	78 " dat.d84 as d84," +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	79 " dat.d90 as d90," +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	80 " dat.dmin as dmin," +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	81 " dat.dmax as dmax " +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	82 "FROM messung dat" +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	83 " JOIN station sn ON sn.stationid = dat.stationid" +
3758 75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	84 " JOIN gewaesser gw ON gw.gewaesserid = sn.gewaesserid " +
3756 912a398968b6 The factory for minfo bed quality calculation can load bedload and bed data from seddb now. Raimund Renkert <raimund.renkert@intevation.de> parents: 3755 diff changeset	85 "WHERE gw.name = :name AND " +
8787 5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	86 " dat.km IS NOT NULL AND " +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	87 " dat.d10 IS NOT NULL AND" + //TODO: Add all other char. diameter.
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	88 " dat.km BETWEEN :from - 0.001 AND :to + 0.001 ";
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	89
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	90 private static final String SQL_WHERE_DATE =
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	91 "AND dat.datum BETWEEN :start AND :end ";
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	92
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	93 private static final String SQL_ORDER_BY = "ORDER BY dat.km";
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	94
3756 912a398968b6 The factory for minfo bed quality calculation can load bedload and bed data from seddb now. Raimund Renkert <raimund.renkert@intevation.de> parents: 3755 diff changeset	95
6767 6a67a8f01f5b QualityMeasurementFactory: Doc about singleton usage. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6358 diff changeset	96 /** Transform query result into objects, use INSTANCE singleton. */
3755 9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	97 public static final class QualityMeasurementResultTransformer
3758 75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	98 extends BasicTransformerAdapter {
75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	99
6767 6a67a8f01f5b QualityMeasurementFactory: Doc about singleton usage. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6358 diff changeset	100 // Make a singleton
6a67a8f01f5b QualityMeasurementFactory: Doc about singleton usage. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6358 diff changeset	101 public static QualityMeasurementResultTransformer INSTANCE =
6a67a8f01f5b QualityMeasurementFactory: Doc about singleton usage. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6358 diff changeset	102 new QualityMeasurementResultTransformer();
3755 9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	103
6767 6a67a8f01f5b QualityMeasurementFactory: Doc about singleton usage. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6358 diff changeset	104 private QualityMeasurementResultTransformer() {
3755 9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	105 }
9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	106
6781 dbaa31354b58 Doc. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6767 diff changeset	107 /** tuples is a row. */
3755 9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	108 @Override
3758 75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	109 public Object transformTuple(Object[] tuple, String[] aliases) {
3755 9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	110 Map<String, Double> map = new HashMap<String, Double>();
9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	111 double km = 0;
9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	112 Date d = null;
3769 728ecd2afa20 Implemented bed quality calculation in minfo module. Raimund Renkert <raimund.renkert@intevation.de> parents: 3758 diff changeset	113 double depth1 = Double.NaN;
728ecd2afa20 Implemented bed quality calculation in minfo module. Raimund Renkert <raimund.renkert@intevation.de> parents: 3758 diff changeset	114 double depth2 = Double.NaN;
3755 9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	115 for (int i = 0; i < tuple.length; ++i) {
9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	116 if (tuple[i] != null) {
9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	117 if (aliases[i].equals("km")) {
3758 75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	118 km = ((Number) tuple[i]).doubleValue();
3755 9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	119 }
3769 728ecd2afa20 Implemented bed quality calculation in minfo module. Raimund Renkert <raimund.renkert@intevation.de> parents: 3758 diff changeset	120 else if (aliases[i].equals("datum")) {
3758 75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	121 d = (Date) tuple[i];
75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	122 }
75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	123 else if (aliases[i].equals("depth1")) {
75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	124 depth1 = ((Number) tuple[i]).doubleValue();
75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	125 }
75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	126 else if (aliases[i].equals("depth2")) {
75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	127 depth2 = ((Number) tuple[i]).doubleValue();
3755 9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	128 }
9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	129 else {
3769 728ecd2afa20 Implemented bed quality calculation in minfo module. Raimund Renkert <raimund.renkert@intevation.de> parents: 3758 diff changeset	130 map.put(aliases[i], ((Double) tuple[i])/1000);
3755 9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	131 }
9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	132 }
9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	133 }
3758 75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	134 return new QualityMeasurement(km, d, depth1, depth2, map);
3755 9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	135 }
9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	136 } // class BasicTransformerAdapter
9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	137
9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	138 private QualityMeasurementFactory() {
9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	139 }
9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	140
8787 5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	141 private static SQLQuery baseQuery(
3755 9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	142 Session session,
9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	143 String river,
9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	144 double from,
9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	145 double to,
3756 912a398968b6 The factory for minfo bed quality calculation can load bedload and bed data from seddb now. Raimund Renkert <raimund.renkert@intevation.de> parents: 3755 diff changeset	146 String statement
3755 9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	147 ) {
3756 912a398968b6 The factory for minfo bed quality calculation can load bedload and bed data from seddb now. Raimund Renkert <raimund.renkert@intevation.de> parents: 3755 diff changeset	148 SQLQuery query = session.createSQLQuery(statement)
3758 75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	149 .addScalar("km", StandardBasicTypes.DOUBLE)
3769 728ecd2afa20 Implemented bed quality calculation in minfo module. Raimund Renkert <raimund.renkert@intevation.de> parents: 3758 diff changeset	150 .addScalar("datum", StandardBasicTypes.DATE)
7630 3da531976039 issue1043: Fetch 'dm'-values in QualityMeasurementFactory. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6781 diff changeset	151 .addScalar("dm", StandardBasicTypes.DOUBLE)
3758 75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	152 .addScalar("d10", StandardBasicTypes.DOUBLE)
75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	153 .addScalar("d16", StandardBasicTypes.DOUBLE)
75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	154 .addScalar("d20", StandardBasicTypes.DOUBLE)
75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	155 .addScalar("d25", StandardBasicTypes.DOUBLE)
75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	156 .addScalar("d30", StandardBasicTypes.DOUBLE)
75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	157 .addScalar("d40", StandardBasicTypes.DOUBLE)
75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	158 .addScalar("d50", StandardBasicTypes.DOUBLE)
75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	159 .addScalar("d60", StandardBasicTypes.DOUBLE)
75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	160 .addScalar("d70", StandardBasicTypes.DOUBLE)
75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	161 .addScalar("d75", StandardBasicTypes.DOUBLE)
75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	162 .addScalar("d80", StandardBasicTypes.DOUBLE)
75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	163 .addScalar("d84", StandardBasicTypes.DOUBLE)
75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	164 .addScalar("d90", StandardBasicTypes.DOUBLE)
75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	165 .addScalar("dmin", StandardBasicTypes.DOUBLE)
75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	166 .addScalar("dmax", StandardBasicTypes.DOUBLE);
75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	167
8787 5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	168 if (statement.startsWith(SQL_BED_MEASUREMENT)) {
3758 75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	169 query.addScalar("depth1", StandardBasicTypes.DOUBLE);
75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	170 query.addScalar("depth2", StandardBasicTypes.DOUBLE);
75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	171 }
8787 5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	172
8684 2e11fc7f5d35 (issue1796) Use seddb name of a river when accessing the seddb Andre Heinecke <andre.heinecke@intevation.de> parents: 8202 diff changeset	173 String seddbRiver = RiverFactory.getRiver(river).nameForSeddb();
3755 9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	174
8684 2e11fc7f5d35 (issue1796) Use seddb name of a river when accessing the seddb Andre Heinecke <andre.heinecke@intevation.de> parents: 8202 diff changeset	175 query.setString("name", seddbRiver);
3755 9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	176 query.setDouble("from", from);
3758 75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	177 query.setDouble("to", to);
3755 9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	178
9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	179 query.setResultTransformer(
9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	180 QualityMeasurementResultTransformer.INSTANCE);
9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	181
8787 5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	182 return query;
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	183 }
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	184
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	185 protected static QualityMeasurements load(
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	186 Session session,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	187 String river,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	188 double from,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	189 double to,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	190 String statement
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	191 ) {
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	192 SQLQuery query = baseQuery(session, river, from, to, statement);
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	193
3755 9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	194 return new QualityMeasurements(query.list());
9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	195 }
9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	196
8787 5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	197 protected static QualityMeasurements load(
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	198 Session session,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	199 String river,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	200 double from,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	201 double to,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	202 Date start,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	203 Date end,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	204 String statement
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	205 ) {
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	206 SQLQuery query = baseQuery(session, river, from, to, statement);
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	207
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	208 query.setDate("start", start);
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	209 query.setDate("end", end);
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	210
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	211 return new QualityMeasurements(query.list());
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	212 }
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	213
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	214
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	215 public static QualityMeasurements getBedMeasurements(
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	216 String river,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	217 double from,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	218 double to
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	219 ) {
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	220 Session session = SedDBSessionHolder.HOLDER.get();
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	221 return load(session, river, from, to,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	222 SQL_BED_MEASUREMENT + SQL_ORDER_BY);
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	223 }
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	224
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	225 public static QualityMeasurements getBedloadMeasurements(
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	226 String river,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	227 double from,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	228 double to
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	229 ) {
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	230 Session session = SedDBSessionHolder.HOLDER.get();
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	231 return load(session, river, from, to,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	232 SQL_BEDLOAD_MEASUREMENT + SQL_ORDER_BY);
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	233 }
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	234
3756 912a398968b6 The factory for minfo bed quality calculation can load bedload and bed data from seddb now. Raimund Renkert <raimund.renkert@intevation.de> parents: 3755 diff changeset	235 public static QualityMeasurements getBedMeasurements(
3755 9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	236 String river,
9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	237 double from,
9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	238 double to,
9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	239 Date start,
8787 5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	240 Date end
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	241 ) {
3755 9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	242 Session session = SedDBSessionHolder.HOLDER.get();
8787 5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	243 return load(session, river, from, to, start, end,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	244 SQL_BED_MEASUREMENT + SQL_WHERE_DATE + SQL_ORDER_BY);
3756 912a398968b6 The factory for minfo bed quality calculation can load bedload and bed data from seddb now. Raimund Renkert <raimund.renkert@intevation.de> parents: 3755 diff changeset	245 }
912a398968b6 The factory for minfo bed quality calculation can load bedload and bed data from seddb now. Raimund Renkert <raimund.renkert@intevation.de> parents: 3755 diff changeset	246
912a398968b6 The factory for minfo bed quality calculation can load bedload and bed data from seddb now. Raimund Renkert <raimund.renkert@intevation.de> parents: 3755 diff changeset	247 public static QualityMeasurements getBedloadMeasurements(
912a398968b6 The factory for minfo bed quality calculation can load bedload and bed data from seddb now. Raimund Renkert <raimund.renkert@intevation.de> parents: 3755 diff changeset	248 String river,
912a398968b6 The factory for minfo bed quality calculation can load bedload and bed data from seddb now. Raimund Renkert <raimund.renkert@intevation.de> parents: 3755 diff changeset	249 double from,
912a398968b6 The factory for minfo bed quality calculation can load bedload and bed data from seddb now. Raimund Renkert <raimund.renkert@intevation.de> parents: 3755 diff changeset	250 double to,
912a398968b6 The factory for minfo bed quality calculation can load bedload and bed data from seddb now. Raimund Renkert <raimund.renkert@intevation.de> parents: 3755 diff changeset	251 Date start,
912a398968b6 The factory for minfo bed quality calculation can load bedload and bed data from seddb now. Raimund Renkert <raimund.renkert@intevation.de> parents: 3755 diff changeset	252 Date end
3758 75bc96dd9d82 Added depth parameter to bed quality data. Raimund Renkert <raimund.renkert@intevation.de> parents: 3756 diff changeset	253 ) {
3756 912a398968b6 The factory for minfo bed quality calculation can load bedload and bed data from seddb now. Raimund Renkert <raimund.renkert@intevation.de> parents: 3755 diff changeset	254 Session session = SedDBSessionHolder.HOLDER.get();
8787 5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	255 return load(
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	256 session,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	257 river,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	258 from,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	259 to,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	260 start,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	261 end,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime. Tom Gottfried <tom@intevation.de> parents: 8684 diff changeset	262 SQL_BEDLOAD_MEASUREMENT + SQL_WHERE_DATE + SQL_ORDER_BY);
3755 9c555ce5ca50 Data objects and factory for minfo bedquality calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	263 }
4807 dbae69a57927 QualityMesurementFactory: Added vim-line. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 3785 diff changeset	264 }
dbae69a57927 QualityMesurementFactory: Added vim-line. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 3785 diff changeset	265 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :

Mercurial > dive4elements > river

annotate artifacts/src/main/java/org/dive4elements/river/artifacts/model/minfo/QualityMeasurementFactory.java @ 8856:5e38e2924c07 3.2.x