Mercurial > dive4elements > river
annotate backend/src/main/java/org/dive4elements/river/model/MainValue.java @ 9176:1614cb14308f
Work on calculations for S-Info flood duration workflow
author | mschaefer |
---|---|
date | Mon, 25 Jun 2018 19:21:11 +0200 |
parents | 64e56a51db3f |
children | 491e1a434457 |
rev | line source |
---|---|
5844
4dd33b86dc61
Added header to river backend.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
5838
diff
changeset
|
1 /* Copyright (C) 2011, 2012, 2013 by Bundesanstalt für Gewässerkunde |
4dd33b86dc61
Added header to river backend.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
5838
diff
changeset
|
2 * Software engineering by Intevation GmbH |
4dd33b86dc61
Added header to river backend.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
5838
diff
changeset
|
3 * |
5992
4c3ccf2b0304
Removed trailing whitespace.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
5844
diff
changeset
|
4 * This file is Free Software under the GNU AGPL (>=v3) |
5844
4dd33b86dc61
Added header to river backend.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
5838
diff
changeset
|
5 * and comes with ABSOLUTELY NO WARRANTY! Check out the |
5992
4c3ccf2b0304
Removed trailing whitespace.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
5844
diff
changeset
|
6 * documentation coming with Dive4Elements River for details. |
5844
4dd33b86dc61
Added header to river backend.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
5838
diff
changeset
|
7 */ |
4dd33b86dc61
Added header to river backend.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
5838
diff
changeset
|
8 |
5829
18619c1e7c2a
Repaired internal references.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
5828
diff
changeset
|
9 package org.dive4elements.river.model; |
189
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
10 |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
11 import java.io.Serializable; |
9159
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
12 import java.math.BigDecimal; |
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
13 import java.util.List; |
189
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
14 |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
15 import javax.persistence.Column; |
9159
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
16 import javax.persistence.Entity; |
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
17 import javax.persistence.GeneratedValue; |
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
18 import javax.persistence.GenerationType; |
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
19 import javax.persistence.Id; |
189
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
20 import javax.persistence.JoinColumn; |
9159
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
21 import javax.persistence.OneToOne; |
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
22 import javax.persistence.SequenceGenerator; |
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
23 import javax.persistence.Table; |
189
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
24 |
9159
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
25 import org.dive4elements.river.backend.SessionHolder; |
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
26 import org.dive4elements.river.model.MainValueType.MainValueTypeKey; |
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
27 import org.hibernate.Query; |
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
28 import org.hibernate.Session; |
189
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
29 |
5375 | 30 |
31 /** A Main or Extreme value of a rivers gauge. */ | |
189
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
32 @Entity |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
33 @Table(name = "main_values") |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
34 public class MainValue |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
35 implements Serializable |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
36 { |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
37 private Integer id; |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
38 |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
39 private Gauge gauge; |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
40 |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
41 private NamedMainValue mainValue; |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
42 |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
43 private BigDecimal value; |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
44 |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
45 private TimeInterval timeInterval; |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
46 |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
47 public MainValue() { |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
48 } |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
49 |
195
8d3533a03e10
Second part of parsing/storing main values. Should be finished now.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
189
diff
changeset
|
50 public MainValue( |
9159
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
51 final Gauge gauge, |
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
52 final NamedMainValue mainValue, |
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
53 final BigDecimal value, |
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
54 final TimeInterval timeInterval |
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
55 ) { |
195
8d3533a03e10
Second part of parsing/storing main values. Should be finished now.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
189
diff
changeset
|
56 this.gauge = gauge; |
8d3533a03e10
Second part of parsing/storing main values. Should be finished now.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
189
diff
changeset
|
57 this.mainValue = mainValue; |
8d3533a03e10
Second part of parsing/storing main values. Should be finished now.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
189
diff
changeset
|
58 this.value = value; |
8d3533a03e10
Second part of parsing/storing main values. Should be finished now.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
189
diff
changeset
|
59 this.timeInterval = timeInterval; |
8d3533a03e10
Second part of parsing/storing main values. Should be finished now.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
189
diff
changeset
|
60 } |
8d3533a03e10
Second part of parsing/storing main values. Should be finished now.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
189
diff
changeset
|
61 |
189
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
62 @Id |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
63 @SequenceGenerator( |
9159
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
64 name = "SEQUENCE_MAIN_VALUES_ID_SEQ", |
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
65 sequenceName = "MAIN_VALUES_ID_SEQ", |
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
66 allocationSize = 1) |
189
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
67 @GeneratedValue( |
9159
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
68 strategy = GenerationType.SEQUENCE, |
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
69 generator = "SEQUENCE_MAIN_VALUES_ID_SEQ") |
189
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
70 @Column(name = "id") |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
71 public Integer getId() { |
9159
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
72 return this.id; |
189
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
73 } |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
74 |
9159
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
75 public void setId(final Integer id) { |
189
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
76 this.id = id; |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
77 } |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
78 |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
79 @OneToOne |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
80 @JoinColumn(name = "gauge_id") |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
81 public Gauge getGauge() { |
9159
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
82 return this.gauge; |
189
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
83 } |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
84 |
9159
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
85 public void setGauge(final Gauge gauge) { |
189
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
86 this.gauge = gauge; |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
87 } |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
88 |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
89 @OneToOne |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
90 @JoinColumn(name = "named_value_id") |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
91 public NamedMainValue getMainValue() { |
9159
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
92 return this.mainValue; |
189
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
93 } |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
94 |
9159
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
95 public void setMainValue(final NamedMainValue mainValue) { |
189
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
96 this.mainValue = mainValue; |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
97 } |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
98 |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
99 @Column(name = "value") // FIXME: type mapping needed? |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
100 public BigDecimal getValue() { |
9159
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
101 return this.value; |
189
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
102 } |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
103 |
9159
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
104 public void setValue(final BigDecimal value) { |
189
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
105 this.value = value; |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
106 } |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
107 |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
108 @OneToOne |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
109 @JoinColumn(name = "time_interval_id") |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
110 public TimeInterval getTimeInterval() { |
9159
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
111 return this.timeInterval; |
189
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
112 } |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
113 |
9159
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
114 public void setTimeInterval(final TimeInterval timeInterval) { |
189
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
115 this.timeInterval = timeInterval; |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
116 } |
9159
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
117 |
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
118 /** |
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
119 * Selects from the database the main values of a gauge and a type, in ascending value order |
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
120 */ |
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
121 public static List<MainValue> getValuesOfGaugeAndType(final Gauge gauge, final MainValueTypeKey typekey) { |
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
122 final Session session = SessionHolder.HOLDER.get(); |
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
123 final Query query = session.createQuery("SELECT mv" |
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
124 + " FROM MainValue AS mv JOIN mv.mainValue AS nmv" |
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
125 + " WHERE mv.gauge.id=:gaugeid AND nmv.type.id=:typeid" |
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
126 + " ORDER BY value"); |
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
127 query.setParameter("gaugeid", gauge.getId()); |
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
128 query.setParameter("typeid", typekey.getId()); |
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
129 return query.list(); |
64e56a51db3f
Added methods to select a gauge's discharge table and main value list; added a main value type key enum
mschaefer
parents:
5992
diff
changeset
|
130 } |
9176
1614cb14308f
Work on calculations for S-Info flood duration workflow
mschaefer
parents:
9159
diff
changeset
|
131 |
1614cb14308f
Work on calculations for S-Info flood duration workflow
mschaefer
parents:
9159
diff
changeset
|
132 /** |
1614cb14308f
Work on calculations for S-Info flood duration workflow
mschaefer
parents:
9159
diff
changeset
|
133 * Selects from the database the discharge-duration main values of a gauge sorted by duration |
1614cb14308f
Work on calculations for S-Info flood duration workflow
mschaefer
parents:
9159
diff
changeset
|
134 */ |
1614cb14308f
Work on calculations for S-Info flood duration workflow
mschaefer
parents:
9159
diff
changeset
|
135 public static List<MainValue> getDurationDischargesOfGauge(final Gauge gauge) { |
1614cb14308f
Work on calculations for S-Info flood duration workflow
mschaefer
parents:
9159
diff
changeset
|
136 final Session session = SessionHolder.HOLDER.get(); |
1614cb14308f
Work on calculations for S-Info flood duration workflow
mschaefer
parents:
9159
diff
changeset
|
137 final Query query = session.createQuery("SELECT mv" |
1614cb14308f
Work on calculations for S-Info flood duration workflow
mschaefer
parents:
9159
diff
changeset
|
138 + " FROM MainValue AS mv JOIN mv.mainValue AS nmv" |
1614cb14308f
Work on calculations for S-Info flood duration workflow
mschaefer
parents:
9159
diff
changeset
|
139 + " WHERE mv.gauge.id=:gaugeid AND nmv.type.id=:typeid" |
1614cb14308f
Work on calculations for S-Info flood duration workflow
mschaefer
parents:
9159
diff
changeset
|
140 + " ORDER BY CAST(nmv.name AS int)"); |
1614cb14308f
Work on calculations for S-Info flood duration workflow
mschaefer
parents:
9159
diff
changeset
|
141 query.setParameter("gaugeid", gauge.getId()); |
1614cb14308f
Work on calculations for S-Info flood duration workflow
mschaefer
parents:
9159
diff
changeset
|
142 query.setParameter("typeid", MainValueTypeKey.DURATION.getId()); |
1614cb14308f
Work on calculations for S-Info flood duration workflow
mschaefer
parents:
9159
diff
changeset
|
143 return query.list(); |
1614cb14308f
Work on calculations for S-Info flood duration workflow
mschaefer
parents:
9159
diff
changeset
|
144 } |
189
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
145 } |
bc3747a371cc
First part of parsing main values.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
146 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 : |