Mercurial > dive4elements > river
annotate backend/src/main/java/org/dive4elements/river/model/DischargeZone.java @ 8764:d5917ff74d8a
(issue1838) Get min and max directly from database.
The former implementation led to a connection leak.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Mon, 17 Aug 2015 10:18:05 +0200 |
parents | 9d2e69f971f5 |
children | ff27548d078c |
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; |
2825
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
10 |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
11 import java.io.Serializable; |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
12 import java.math.BigDecimal; |
2870
28526b0b0a90
Added DischargeZone.getDischargeZones() that returns all DischargeZones for a given river.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2833
diff
changeset
|
13 import java.util.List; |
2825
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
14 |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
15 import javax.persistence.Entity; |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
16 import javax.persistence.Id; |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
17 import javax.persistence.Table; |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
18 import javax.persistence.GeneratedValue; |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
19 import javax.persistence.Column; |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
20 import javax.persistence.SequenceGenerator; |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
21 import javax.persistence.GenerationType; |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
22 import javax.persistence.JoinColumn; |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
23 import javax.persistence.OneToOne; |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
24 |
2870
28526b0b0a90
Added DischargeZone.getDischargeZones() that returns all DischargeZones for a given river.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2833
diff
changeset
|
25 import org.hibernate.Session; |
28526b0b0a90
Added DischargeZone.getDischargeZones() that returns all DischargeZones for a given river.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2833
diff
changeset
|
26 import org.hibernate.Query; |
28526b0b0a90
Added DischargeZone.getDischargeZones() that returns all DischargeZones for a given river.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2833
diff
changeset
|
27 |
2825
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
28 import org.apache.log4j.Logger; |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
29 |
5829
18619c1e7c2a
Repaired internal references.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
5828
diff
changeset
|
30 import org.dive4elements.river.backend.SessionHolder; |
2870
28526b0b0a90
Added DischargeZone.getDischargeZones() that returns all DischargeZones for a given river.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2833
diff
changeset
|
31 |
2825
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
32 |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
33 @Entity |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
34 @Table(name = "discharge_zone") |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
35 public class DischargeZone |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
36 implements Serializable |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
37 { |
8200
9d2e69f971f5
sed -i src/**/*.java 's/logger/log/g'
Sascha L. Teichmann <teichmann@intevation.de>
parents:
5992
diff
changeset
|
38 private static Logger log = Logger.getLogger(DischargeZone.class); |
2825
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
39 |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
40 private Integer id; |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
41 |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
42 private River river; |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
43 |
2833
5b54a648f702
Finished flow velocity data import: finished parsing meta data of model files and repaired broken HQL statements.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2825
diff
changeset
|
44 private String gaugeName; |
2825
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
45 |
2833
5b54a648f702
Finished flow velocity data import: finished parsing meta data of model files and repaired broken HQL statements.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2825
diff
changeset
|
46 private BigDecimal value; |
2825
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
47 |
2833
5b54a648f702
Finished flow velocity data import: finished parsing meta data of model files and repaired broken HQL statements.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2825
diff
changeset
|
48 private String lowerDischarge; |
5b54a648f702
Finished flow velocity data import: finished parsing meta data of model files and repaired broken HQL statements.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2825
diff
changeset
|
49 private String upperDischarge; |
2825
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
50 |
4621
25c5e344733e
Added new member variable for zone type.
Raimund Renkert <rrenkert@intevation.de>
parents:
4483
diff
changeset
|
51 private String type; |
2825
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
52 |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
53 public DischargeZone() { |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
54 } |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
55 |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
56 |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
57 public DischargeZone( |
2833
5b54a648f702
Finished flow velocity data import: finished parsing meta data of model files and repaired broken HQL statements.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2825
diff
changeset
|
58 River river, |
5b54a648f702
Finished flow velocity data import: finished parsing meta data of model files and repaired broken HQL statements.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2825
diff
changeset
|
59 String gaugeName, |
5b54a648f702
Finished flow velocity data import: finished parsing meta data of model files and repaired broken HQL statements.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2825
diff
changeset
|
60 BigDecimal value, |
5b54a648f702
Finished flow velocity data import: finished parsing meta data of model files and repaired broken HQL statements.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2825
diff
changeset
|
61 String lowerDischarge, |
5b54a648f702
Finished flow velocity data import: finished parsing meta data of model files and repaired broken HQL statements.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2825
diff
changeset
|
62 String upperDischarge |
2825
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
63 ) { |
2833
5b54a648f702
Finished flow velocity data import: finished parsing meta data of model files and repaired broken HQL statements.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2825
diff
changeset
|
64 this.river = river; |
5b54a648f702
Finished flow velocity data import: finished parsing meta data of model files and repaired broken HQL statements.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2825
diff
changeset
|
65 this.gaugeName = gaugeName; |
5b54a648f702
Finished flow velocity data import: finished parsing meta data of model files and repaired broken HQL statements.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2825
diff
changeset
|
66 this.value = value; |
5b54a648f702
Finished flow velocity data import: finished parsing meta data of model files and repaired broken HQL statements.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2825
diff
changeset
|
67 this.lowerDischarge = lowerDischarge; |
5b54a648f702
Finished flow velocity data import: finished parsing meta data of model files and repaired broken HQL statements.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2825
diff
changeset
|
68 this.upperDischarge = upperDischarge; |
2825
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
69 } |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
70 |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
71 @Id |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
72 @SequenceGenerator( |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
73 name = "SEQUENCE_DISCHARGE_ZONE_ID_SEQ", |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
74 sequenceName = "DISCHARGE_ZONE_ID_SEQ", |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
75 allocationSize = 1) |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
76 @GeneratedValue( |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
77 strategy = GenerationType.SEQUENCE, |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
78 generator = "SEQUENCE_DISCHARGE_ZONE_ID_SEQ") |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
79 @Column(name = "id") |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
80 public Integer getId() { |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
81 return id; |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
82 } |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
83 |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
84 public void setId(Integer id) { |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
85 this.id = id; |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
86 } |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
87 |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
88 @OneToOne |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
89 @JoinColumn(name = "river_id" ) |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
90 public River getRiver() { |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
91 return river; |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
92 } |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
93 |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
94 public void setRiver(River river) { |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
95 this.river = river; |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
96 } |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
97 |
2833
5b54a648f702
Finished flow velocity data import: finished parsing meta data of model files and repaired broken HQL statements.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2825
diff
changeset
|
98 @Column(name = "value") |
5b54a648f702
Finished flow velocity data import: finished parsing meta data of model files and repaired broken HQL statements.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2825
diff
changeset
|
99 public BigDecimal getValue() { |
5b54a648f702
Finished flow velocity data import: finished parsing meta data of model files and repaired broken HQL statements.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2825
diff
changeset
|
100 return value; |
2825
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
101 } |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
102 |
2833
5b54a648f702
Finished flow velocity data import: finished parsing meta data of model files and repaired broken HQL statements.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2825
diff
changeset
|
103 public void setValue(BigDecimal value) { |
5b54a648f702
Finished flow velocity data import: finished parsing meta data of model files and repaired broken HQL statements.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2825
diff
changeset
|
104 this.value = value; |
2825
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
105 } |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
106 |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
107 @Column(name = "gauge_name") |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
108 public String getGaugeName() { |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
109 return gaugeName; |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
110 } |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
111 |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
112 public void setGaugeName(String gaugeName) { |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
113 this.gaugeName = gaugeName; |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
114 } |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
115 |
2833
5b54a648f702
Finished flow velocity data import: finished parsing meta data of model files and repaired broken HQL statements.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2825
diff
changeset
|
116 @Column(name = "lower_discharge") |
5b54a648f702
Finished flow velocity data import: finished parsing meta data of model files and repaired broken HQL statements.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2825
diff
changeset
|
117 public String getLowerDischarge() { |
5b54a648f702
Finished flow velocity data import: finished parsing meta data of model files and repaired broken HQL statements.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2825
diff
changeset
|
118 return lowerDischarge; |
2825
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
119 } |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
120 |
2833
5b54a648f702
Finished flow velocity data import: finished parsing meta data of model files and repaired broken HQL statements.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2825
diff
changeset
|
121 public void setLowerDischarge(String lowerDischarge) { |
5b54a648f702
Finished flow velocity data import: finished parsing meta data of model files and repaired broken HQL statements.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2825
diff
changeset
|
122 this.lowerDischarge = lowerDischarge; |
2825
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
123 } |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
124 |
2833
5b54a648f702
Finished flow velocity data import: finished parsing meta data of model files and repaired broken HQL statements.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2825
diff
changeset
|
125 @Column(name = "upper_discharge") |
5b54a648f702
Finished flow velocity data import: finished parsing meta data of model files and repaired broken HQL statements.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2825
diff
changeset
|
126 public String getUpperDischarge() { |
5b54a648f702
Finished flow velocity data import: finished parsing meta data of model files and repaired broken HQL statements.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2825
diff
changeset
|
127 return upperDischarge; |
2825
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
128 } |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
129 |
2833
5b54a648f702
Finished flow velocity data import: finished parsing meta data of model files and repaired broken HQL statements.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2825
diff
changeset
|
130 public void setUpperDischarge(String upperDischarge) { |
5b54a648f702
Finished flow velocity data import: finished parsing meta data of model files and repaired broken HQL statements.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2825
diff
changeset
|
131 this.upperDischarge = upperDischarge; |
2825
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
132 } |
2870
28526b0b0a90
Added DischargeZone.getDischargeZones() that returns all DischargeZones for a given river.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2833
diff
changeset
|
133 |
4621
25c5e344733e
Added new member variable for zone type.
Raimund Renkert <rrenkert@intevation.de>
parents:
4483
diff
changeset
|
134 public void putType(String type) { |
25c5e344733e
Added new member variable for zone type.
Raimund Renkert <rrenkert@intevation.de>
parents:
4483
diff
changeset
|
135 this.type = type; |
25c5e344733e
Added new member variable for zone type.
Raimund Renkert <rrenkert@intevation.de>
parents:
4483
diff
changeset
|
136 } |
25c5e344733e
Added new member variable for zone type.
Raimund Renkert <rrenkert@intevation.de>
parents:
4483
diff
changeset
|
137 |
25c5e344733e
Added new member variable for zone type.
Raimund Renkert <rrenkert@intevation.de>
parents:
4483
diff
changeset
|
138 public String fetchType() { |
25c5e344733e
Added new member variable for zone type.
Raimund Renkert <rrenkert@intevation.de>
parents:
4483
diff
changeset
|
139 return this.type; |
25c5e344733e
Added new member variable for zone type.
Raimund Renkert <rrenkert@intevation.de>
parents:
4483
diff
changeset
|
140 } |
2870
28526b0b0a90
Added DischargeZone.getDischargeZones() that returns all DischargeZones for a given river.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2833
diff
changeset
|
141 |
28526b0b0a90
Added DischargeZone.getDischargeZones() that returns all DischargeZones for a given river.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2833
diff
changeset
|
142 public static List<DischargeZone> getDischargeZones(River river) { |
28526b0b0a90
Added DischargeZone.getDischargeZones() that returns all DischargeZones for a given river.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2833
diff
changeset
|
143 Session session = SessionHolder.HOLDER.get(); |
28526b0b0a90
Added DischargeZone.getDischargeZones() that returns all DischargeZones for a given river.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2833
diff
changeset
|
144 |
28526b0b0a90
Added DischargeZone.getDischargeZones() that returns all DischargeZones for a given river.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2833
diff
changeset
|
145 Query query = session.createQuery( |
28526b0b0a90
Added DischargeZone.getDischargeZones() that returns all DischargeZones for a given river.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2833
diff
changeset
|
146 "from DischargeZone where river=:river"); |
28526b0b0a90
Added DischargeZone.getDischargeZones() that returns all DischargeZones for a given river.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2833
diff
changeset
|
147 |
28526b0b0a90
Added DischargeZone.getDischargeZones() that returns all DischargeZones for a given river.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2833
diff
changeset
|
148 query.setParameter("river", river); |
28526b0b0a90
Added DischargeZone.getDischargeZones() that returns all DischargeZones for a given river.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2833
diff
changeset
|
149 |
28526b0b0a90
Added DischargeZone.getDischargeZones() that returns all DischargeZones for a given river.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2833
diff
changeset
|
150 return query.list(); |
28526b0b0a90
Added DischargeZone.getDischargeZones() that returns all DischargeZones for a given river.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2833
diff
changeset
|
151 } |
2871
5a89c2b05e6d
Added functions to retrieve data from database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2870
diff
changeset
|
152 |
5a89c2b05e6d
Added functions to retrieve data from database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2870
diff
changeset
|
153 |
5a89c2b05e6d
Added functions to retrieve data from database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2870
diff
changeset
|
154 public static DischargeZone getDischargeZoneById(int id) { |
5a89c2b05e6d
Added functions to retrieve data from database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2870
diff
changeset
|
155 Session session = SessionHolder.HOLDER.get(); |
5a89c2b05e6d
Added functions to retrieve data from database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2870
diff
changeset
|
156 |
5a89c2b05e6d
Added functions to retrieve data from database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2870
diff
changeset
|
157 Query query = session.createQuery( |
5a89c2b05e6d
Added functions to retrieve data from database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2870
diff
changeset
|
158 "from DischargeZone where id=:id"); |
5a89c2b05e6d
Added functions to retrieve data from database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2870
diff
changeset
|
159 |
5a89c2b05e6d
Added functions to retrieve data from database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2870
diff
changeset
|
160 query.setParameter("id", id); |
5a89c2b05e6d
Added functions to retrieve data from database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2870
diff
changeset
|
161 |
5a89c2b05e6d
Added functions to retrieve data from database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2870
diff
changeset
|
162 List<DischargeZone> zones = query.list(); |
5a89c2b05e6d
Added functions to retrieve data from database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2870
diff
changeset
|
163 |
5a89c2b05e6d
Added functions to retrieve data from database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2870
diff
changeset
|
164 return zones.isEmpty() ? null : zones.get(0); |
5a89c2b05e6d
Added functions to retrieve data from database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2870
diff
changeset
|
165 } |
2825
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
166 } |
a948366d8ac5
Added new model classes for MINFO specific flow velocity.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
167 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 : |