Mercurial > dive4elements > river

annotate artifacts/src/main/java/org/dive4elements/river/artifacts/model/minfo/QualityMeasurementFactory.java @ 8787:5855f919cbd6

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Issue1854: Avoid assumptions about limits of SQL datetime.
author Tom Gottfried <tom@intevation.de>
date Tue, 08 Dec 2015 20:15:45 +0100
parents 2e11fc7f5d35
children 5e38e2924c07
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
8202
e4606eae8ea5 sed src/**/*.java 's/logger/log/g'
Sascha L. Teichmann <teichmann@intevation.de>
parents: 7630
diff changeset
27 private static Logger log = Logger.getLogger(QualityMeasurementFactory.class);
3769
728ecd2afa20 Implemented bed quality calculation in minfo module.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3758
diff changeset
28
3758
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
29 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
30 "SELECT dat.km as km," +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
31 " dat.datum as datum," +
3769
728ecd2afa20 Implemented bed quality calculation in minfo module.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3758
diff changeset
32 " sp.tiefevon as depth1," +
728ecd2afa20 Implemented bed quality calculation in minfo module.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3758
diff changeset
33 " sp.tiefebis as depth2," +
3758
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
34 " sa.d10 as d10," +
7630
3da531976039 issue1043: Fetch 'dm'-values in QualityMeasurementFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 6781
diff changeset
35 " sa.dm as dm," +
3758
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
36 " sa.d16 as d16," +
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
37 " sa.d20 as d20," +
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
38 " sa.d25 as d25," +
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
39 " sa.d30 as d30," +
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
40 " sa.d40 as d40," +
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
41 " sa.d50 as d50," +
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
42 " sa.d60 as d60," +
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
43 " sa.d70 as d70," +
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
44 " sa.d75 as d75," +
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
45 " sa.d80 as d80," +
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
46 " sa.d84 as d84," +
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
47 " sa.d90 as d90," +
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
48 " sa.dmin as dmin," +
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
49 " sa.dmax as dmax " +
8787
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
50 "FROM sohltest dat " +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
51 " 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
52 " 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
53 " 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
54 " 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
55 "WHERE gw.name = :name AND " +
8787
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
56 " 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
57 " sp.tiefevon IS NOT NULL AND " +
3785
a5f65e8983be Merged revisions 5501-5502,5504-5508,5511-5513,5516-5519 via svnmerge from
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3769
diff changeset
58 " sp.tiefebis IS NOT NULL AND " + // TODO: Test if char diameter ist null.
8787
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
59 " dat.km BETWEEN :from - 0.001 AND :to + 0.001 ";
3755
9c555ce5ca50 Data objects and factory for minfo bedquality calculation.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
60
3758
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
61 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
62 "SELECT dat.km as km," +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
63 " dat.datum as datum," +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
64 " dat.dm as dm," +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
65 " dat.d10 as d10," +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
66 " dat.d16 as d16," +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
67 " dat.d20 as d20," +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
68 " dat.d25 as d25," +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
69 " dat.d30 as d30," +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
70 " dat.d40 as d40," +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
71 " dat.d50 as d50," +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
72 " dat.d60 as d60," +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
73 " dat.d70 as d70," +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
74 " dat.d75 as d75," +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
75 " dat.d80 as d80," +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
76 " dat.d84 as d84," +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
77 " dat.d90 as d90," +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
78 " dat.dmin as dmin," +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
79 " dat.dmax as dmax " +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
80 "FROM messung dat" +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
81 " 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
82 " 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
83 "WHERE gw.name = :name AND " +
8787
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
84 " dat.km IS NOT NULL AND " +
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
85 " 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
86 " 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
87
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
88 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
89 "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
90
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
91 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
92
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
93
6767
6a67a8f01f5b QualityMeasurementFactory: Doc about singleton usage.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 6358
diff changeset
94 /** 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
95 public static final class QualityMeasurementResultTransformer
3758
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
96 extends BasicTransformerAdapter {
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
97
6767
6a67a8f01f5b QualityMeasurementFactory: Doc about singleton usage.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 6358
diff changeset
98 // Make a singleton
6a67a8f01f5b QualityMeasurementFactory: Doc about singleton usage.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 6358
diff changeset
99 public static QualityMeasurementResultTransformer INSTANCE =
6a67a8f01f5b QualityMeasurementFactory: Doc about singleton usage.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 6358
diff changeset
100 new QualityMeasurementResultTransformer();
3755
9c555ce5ca50 Data objects and factory for minfo bedquality calculation.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
101
6767
6a67a8f01f5b QualityMeasurementFactory: Doc about singleton usage.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 6358
diff changeset
102 private QualityMeasurementResultTransformer() {
3755
9c555ce5ca50 Data objects and factory for minfo bedquality calculation.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
103 }
9c555ce5ca50 Data objects and factory for minfo bedquality calculation.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
104
6781
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 6767
diff changeset
105 /** tuples is a row. */
3755
9c555ce5ca50 Data objects and factory for minfo bedquality calculation.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
106 @Override
3758
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
107 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
108 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
109 double km = 0;
9c555ce5ca50 Data objects and factory for minfo bedquality calculation.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
110 Date d = null;
3769
728ecd2afa20 Implemented bed quality calculation in minfo module.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3758
diff changeset
111 double depth1 = Double.NaN;
728ecd2afa20 Implemented bed quality calculation in minfo module.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3758
diff changeset
112 double depth2 = Double.NaN;
3755
9c555ce5ca50 Data objects and factory for minfo bedquality calculation.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
113 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
114 if (tuple[i] != null) {
9c555ce5ca50 Data objects and factory for minfo bedquality calculation.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
115 if (aliases[i].equals("km")) {
3758
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
116 km = ((Number) tuple[i]).doubleValue();
3755
9c555ce5ca50 Data objects and factory for minfo bedquality calculation.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
117 }
3769
728ecd2afa20 Implemented bed quality calculation in minfo module.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3758
diff changeset
118 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
119 d = (Date) tuple[i];
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
120 }
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
121 else if (aliases[i].equals("depth1")) {
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
122 depth1 = ((Number) tuple[i]).doubleValue();
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
123 }
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
124 else if (aliases[i].equals("depth2")) {
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
125 depth2 = ((Number) tuple[i]).doubleValue();
3755
9c555ce5ca50 Data objects and factory for minfo bedquality calculation.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
126 }
9c555ce5ca50 Data objects and factory for minfo bedquality calculation.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
127 else {
3769
728ecd2afa20 Implemented bed quality calculation in minfo module.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3758
diff changeset
128 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
129 }
9c555ce5ca50 Data objects and factory for minfo bedquality calculation.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
130 }
9c555ce5ca50 Data objects and factory for minfo bedquality calculation.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
131 }
3758
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
132 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
133 }
9c555ce5ca50 Data objects and factory for minfo bedquality calculation.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
134 } // class BasicTransformerAdapter
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 private QualityMeasurementFactory() {
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
8787
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
139 private static SQLQuery baseQuery(
3755
9c555ce5ca50 Data objects and factory for minfo bedquality calculation.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
140 Session session,
9c555ce5ca50 Data objects and factory for minfo bedquality calculation.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
141 String river,
9c555ce5ca50 Data objects and factory for minfo bedquality calculation.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
142 double from,
9c555ce5ca50 Data objects and factory for minfo bedquality calculation.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
143 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
144 String statement
3755
9c555ce5ca50 Data objects and factory for minfo bedquality calculation.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
145 ) {
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 SQLQuery query = session.createSQLQuery(statement)
3758
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
147 .addScalar("km", StandardBasicTypes.DOUBLE)
3769
728ecd2afa20 Implemented bed quality calculation in minfo module.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3758
diff changeset
148 .addScalar("datum", StandardBasicTypes.DATE)
7630
3da531976039 issue1043: Fetch 'dm'-values in QualityMeasurementFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 6781
diff changeset
149 .addScalar("dm", StandardBasicTypes.DOUBLE)
3758
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
150 .addScalar("d10", StandardBasicTypes.DOUBLE)
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
151 .addScalar("d16", StandardBasicTypes.DOUBLE)
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
152 .addScalar("d20", StandardBasicTypes.DOUBLE)
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
153 .addScalar("d25", StandardBasicTypes.DOUBLE)
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
154 .addScalar("d30", StandardBasicTypes.DOUBLE)
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
155 .addScalar("d40", StandardBasicTypes.DOUBLE)
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
156 .addScalar("d50", StandardBasicTypes.DOUBLE)
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
157 .addScalar("d60", StandardBasicTypes.DOUBLE)
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
158 .addScalar("d70", StandardBasicTypes.DOUBLE)
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
159 .addScalar("d75", StandardBasicTypes.DOUBLE)
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
160 .addScalar("d80", StandardBasicTypes.DOUBLE)
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
161 .addScalar("d84", StandardBasicTypes.DOUBLE)
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
162 .addScalar("d90", StandardBasicTypes.DOUBLE)
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
163 .addScalar("dmin", StandardBasicTypes.DOUBLE)
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
164 .addScalar("dmax", StandardBasicTypes.DOUBLE);
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
165
8787
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
166 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
167 query.addScalar("depth1", StandardBasicTypes.DOUBLE);
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
168 query.addScalar("depth2", StandardBasicTypes.DOUBLE);
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
169 }
8787
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
170
8684
2e11fc7f5d35 (issue1796) Use seddb name of a river when accessing the seddb
Andre Heinecke <andre.heinecke@intevation.de>
parents: 8202
diff changeset
171 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
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 query.setString("name", seddbRiver);
3755
9c555ce5ca50 Data objects and factory for minfo bedquality calculation.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
174 query.setDouble("from", from);
3758
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
175 query.setDouble("to", to);
3755
9c555ce5ca50 Data objects and factory for minfo bedquality calculation.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
176
9c555ce5ca50 Data objects and factory for minfo bedquality calculation.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
177 query.setResultTransformer(
9c555ce5ca50 Data objects and factory for minfo bedquality calculation.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
178 QualityMeasurementResultTransformer.INSTANCE);
9c555ce5ca50 Data objects and factory for minfo bedquality calculation.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
179
8787
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
180 return query;
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
181 }
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
182
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
183 protected static QualityMeasurements load(
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
184 Session session,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
185 String river,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
186 double from,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
187 double to,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
188 String statement
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
189 ) {
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
190 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
191
3755
9c555ce5ca50 Data objects and factory for minfo bedquality calculation.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
192 return new QualityMeasurements(query.list());
9c555ce5ca50 Data objects and factory for minfo bedquality calculation.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
193 }
9c555ce5ca50 Data objects and factory for minfo bedquality calculation.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
194
8787
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
195 protected static QualityMeasurements load(
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
196 Session session,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
197 String river,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
198 double from,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
199 double to,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
200 Date start,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
201 Date end,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
202 String statement
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
203 ) {
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
204 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
205
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
206 query.setDate("start", start);
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
207 query.setDate("end", end);
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
208
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
209 return new QualityMeasurements(query.list());
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
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 public static QualityMeasurements getBedMeasurements(
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
214 String river,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
215 double from,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
216 double to
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
217 ) {
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
218 Session session = SedDBSessionHolder.HOLDER.get();
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
219 return load(session, river, from, to,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
220 SQL_BED_MEASUREMENT + SQL_ORDER_BY);
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
221 }
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
222
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
223 public static QualityMeasurements getBedloadMeasurements(
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
224 String river,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
225 double from,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
226 double to
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
227 ) {
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
228 Session session = SedDBSessionHolder.HOLDER.get();
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
229 return load(session, river, from, to,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
230 SQL_BEDLOAD_MEASUREMENT + SQL_ORDER_BY);
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
231 }
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
232
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
233 public static QualityMeasurements getBedMeasurements(
3755
9c555ce5ca50 Data objects and factory for minfo bedquality calculation.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
234 String river,
9c555ce5ca50 Data objects and factory for minfo bedquality calculation.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
235 double from,
9c555ce5ca50 Data objects and factory for minfo bedquality calculation.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
236 double to,
9c555ce5ca50 Data objects and factory for minfo bedquality calculation.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
237 Date start,
8787
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
238 Date end
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
239 ) {
3755
9c555ce5ca50 Data objects and factory for minfo bedquality calculation.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff changeset
240 Session session = SedDBSessionHolder.HOLDER.get();
8787
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
241 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
242 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
243 }
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
244
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 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
246 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
247 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
248 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
249 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
250 Date end
3758
75bc96dd9d82 Added depth parameter to bed quality data.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 3756
diff changeset
251 ) {
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
252 Session session = SedDBSessionHolder.HOLDER.get();
8787
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
253 return load(
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
254 session,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
255 river,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
256 from,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
257 to,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
258 start,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
259 end,
5855f919cbd6 Issue1854: Avoid assumptions about limits of SQL datetime.
Tom Gottfried <tom@intevation.de>
parents: 8684
diff changeset
260 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
261 }
4807
dbae69a57927 QualityMesurementFactory: Added vim-line.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 3785
diff changeset
262 }
dbae69a57927 QualityMesurementFactory: Added vim-line.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 3785
diff changeset
263 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :
http://dive4elements.wald.intevation.org