Mercurial > dive4elements > river

comparison backend/src/main/java/org/dive4elements/river/model/BedHeightValue.java @ 8975:a0a0a7f912ab

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added new columns bed_height.comment and sounding_width_info; extended the bed height parser for the new meta data and the min/max_height columns
author mschaefer
date Tue, 03 Apr 2018 10:40:57 +0200
parents 798d9dcbccdd
children 8aa7d9eaaa21
comparison
equal deleted inserted replaced
8974:a275ddf7a3a1 8975:a0a0a7f912ab
6 * documentation coming with Dive4Elements River for details. 6 * documentation coming with Dive4Elements River for details.
7 */ 7 */
8 8
9 package org.dive4elements.river.model; 9 package org.dive4elements.river.model;
10 10
11 import java.io.Serializable;
11 import java.util.List; 12 import java.util.List;
12 13
13 import java.io.Serializable; 14 import javax.persistence.Column;
14
15 import javax.persistence.Entity; 15 import javax.persistence.Entity;
16 import javax.persistence.GeneratedValue;
17 import javax.persistence.GenerationType;
16 import javax.persistence.Id; 18 import javax.persistence.Id;
17 import javax.persistence.Table;
18 import javax.persistence.GeneratedValue;
19 import javax.persistence.Column;
20 import javax.persistence.SequenceGenerator;
21 import javax.persistence.GenerationType;
22 import javax.persistence.JoinColumn; 19 import javax.persistence.JoinColumn;
23 import javax.persistence.OneToOne; 20 import javax.persistence.OneToOne;
21 import javax.persistence.SequenceGenerator;
22 import javax.persistence.Table;
24 23
25 import org.apache.log4j.Logger; 24 import org.apache.log4j.Logger;
26 25 import org.dive4elements.river.backend.SessionHolder;
26 import org.hibernate.Query;
27 import org.hibernate.Session; 27 import org.hibernate.Session;
28 import org.hibernate.Query;
29
30 import org.dive4elements.river.backend.SessionHolder;
31 28
32 29
33 @Entity 30 @Entity
34 @Table(name = "bed_height_values") 31 @Table(name = "bed_height_values")
35 public class BedHeightValue 32 public class BedHeightValue
36 implements Serializable 33 implements Serializable
37 { 34 {
38 private static Logger log = 35 private static Logger log =
39 Logger.getLogger(BedHeightValue.class); 36 Logger.getLogger(BedHeightValue.class);
40 37
41 private Integer id; 38 private Integer id;
42 39
43 private BedHeight bedHeight; 40 private BedHeight bedHeight;
44 41
149 146
150 public void setMaxHeight(final Double maxHeight) { 147 public void setMaxHeight(final Double maxHeight) {
151 this.maxHeight = maxHeight; 148 this.maxHeight = maxHeight;
152 } 149 }
153 150
154 151 public static List<BedHeightValue> getBedHeightValues(final BedHeight single) {
155 public static List<BedHeightValue> getBedHeightValues( 152 final Session session = SessionHolder.HOLDER.get();
156 BedHeight single) { 153 final Query query = session.createQuery("FROM BedHeightValue WHERE bedHeight=:single");
157 Session session = SessionHolder.HOLDER.get();
158
159 Query query = session.createQuery(
160 "from BedHeightValue where bedHeight=:single");
161
162 query.setParameter("single", single); 154 query.setParameter("single", single);
163 return query.list(); 155 return query.list();
164 } 156 }
165 157
166 158
167 public static List<BedHeightValue> getBedHeightValues( 159 public static List<BedHeightValue> getBedHeightValues(final BedHeight single, final double kmLo, final double kmHi) {
168 BedHeight single, 160 final Session session = SessionHolder.HOLDER.get();
169 double kmLo, 161 final Query query = session.createQuery("FROM BedHeightValue WHERE (bedHeight=:single)"
170 double kmHi 162 + " AND (station >= :kmLo) AND (station <= :kmHi)");
171 ) {
172 Session session = SessionHolder.HOLDER.get();
173
174 Query query = session.createQuery(
175 "from BedHeightValue where bedHeight=:single " +
176 " and station >= :kmLo and station <= :kmHi");
177
178 query.setParameter("single", single); 163 query.setParameter("single", single);
179 query.setParameter("kmLo", new Double(kmLo)); 164 query.setParameter("kmLo", new Double(kmLo));
180 query.setParameter("kmHi", new Double(kmHi)); 165 query.setParameter("kmHi", new Double(kmHi));
181
182 return query.list(); 166 return query.list();
183 } 167 }
184 } 168 }
185 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 : 169 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :
http://dive4elements.wald.intevation.org