dive4elements/river: flys-backend/src/main/java/de/intevation/flys/model/Wst.java annotate

annotate flys-backend/src/main/java/de/intevation/flys/model/Wst.java @ 470:f4afea9b7537

Forget ',' in schema. flys-backend/trunk@1709 c6561f87-3c4e-4783-a992-168aeb5c3f6f

author	Sascha L. Teichmann <sascha.teichmann@intevation.de>
date	Fri, 15 Apr 2011 15:28:35 +0000
parents	b5ca22aae092
children	9aa0eddc5221

rev	line source
167 15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	1 package de.intevation.flys.model;
15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	2
15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	3 import java.io.Serializable;
468 8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	4 import java.math.BigDecimal;
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	5 import java.util.List;
167 15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	6
171 4a83e14f40f9 Added entity and id annotations. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 168 diff changeset	7 import javax.persistence.Entity;
4a83e14f40f9 Added entity and id annotations. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 168 diff changeset	8 import javax.persistence.Id;
4a83e14f40f9 Added entity and id annotations. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 168 diff changeset	9 import javax.persistence.Table;
4a83e14f40f9 Added entity and id annotations. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 168 diff changeset	10 import javax.persistence.GeneratedValue;
4a83e14f40f9 Added entity and id annotations. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 168 diff changeset	11 import javax.persistence.Column;
4a83e14f40f9 Added entity and id annotations. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 168 diff changeset	12 import javax.persistence.SequenceGenerator;
4a83e14f40f9 Added entity and id annotations. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 168 diff changeset	13 import javax.persistence.GenerationType;
174 249390dd24e7 Added foreign key constraint annotations to model classes. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 172 diff changeset	14 import javax.persistence.JoinColumn;
249390dd24e7 Added foreign key constraint annotations to model classes. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 172 diff changeset	15 import javax.persistence.OneToOne;
171 4a83e14f40f9 Added entity and id annotations. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 168 diff changeset	16
468 8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	17 import org.apache.log4j.Logger;
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	18
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	19 import org.hibernate.Session;
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	20 import org.hibernate.Query;
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	21
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	22 import de.intevation.flys.backend.SessionHolder;
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	23
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	24
171 4a83e14f40f9 Added entity and id annotations. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 168 diff changeset	25 @Entity
4a83e14f40f9 Added entity and id annotations. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 168 diff changeset	26 @Table(name = "wsts")
167 15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	27 public class Wst
15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	28 implements Serializable
15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	29 {
468 8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	30 private static Logger logger = Logger.getLogger(Wst.class);
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	31
171 4a83e14f40f9 Added entity and id annotations. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 168 diff changeset	32 private Integer id;
4a83e14f40f9 Added entity and id annotations. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 168 diff changeset	33 private River river;
4a83e14f40f9 Added entity and id annotations. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 168 diff changeset	34 private String description;
467 c8c09e31cdb8 Added new column 'kind' in discharge tables and wst to distinguish between different types. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 201 diff changeset	35 private Integer kind;
167 15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	36
15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	37 public Wst() {
15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	38 }
15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	39
201 3169b559ca3c Build models for wsts, wst columns and q ranges and store them in the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	40 public Wst(River river, String description) {
467 c8c09e31cdb8 Added new column 'kind' in discharge tables and wst to distinguish between different types. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 201 diff changeset	41 this(river, description, 0);
c8c09e31cdb8 Added new column 'kind' in discharge tables and wst to distinguish between different types. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 201 diff changeset	42 }
c8c09e31cdb8 Added new column 'kind' in discharge tables and wst to distinguish between different types. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 201 diff changeset	43
c8c09e31cdb8 Added new column 'kind' in discharge tables and wst to distinguish between different types. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 201 diff changeset	44 public Wst(River river, String description, Integer kind) {
201 3169b559ca3c Build models for wsts, wst columns and q ranges and store them in the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	45 this.river = river;
3169b559ca3c Build models for wsts, wst columns and q ranges and store them in the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	46 this.description = description;
467 c8c09e31cdb8 Added new column 'kind' in discharge tables and wst to distinguish between different types. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 201 diff changeset	47 this.kind = kind;
201 3169b559ca3c Build models for wsts, wst columns and q ranges and store them in the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	48 }
3169b559ca3c Build models for wsts, wst columns and q ranges and store them in the backend. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 174 diff changeset	49
171 4a83e14f40f9 Added entity and id annotations. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 168 diff changeset	50 @Id
4a83e14f40f9 Added entity and id annotations. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 168 diff changeset	51 @SequenceGenerator(
4a83e14f40f9 Added entity and id annotations. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 168 diff changeset	52 name = "SEQUENCE_WSTS_ID_SEQ",
4a83e14f40f9 Added entity and id annotations. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 168 diff changeset	53 sequenceName = "WSTS_ID_SEQ",
4a83e14f40f9 Added entity and id annotations. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 168 diff changeset	54 allocationSize = 1)
4a83e14f40f9 Added entity and id annotations. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 168 diff changeset	55 @GeneratedValue(
4a83e14f40f9 Added entity and id annotations. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 168 diff changeset	56 strategy = GenerationType.SEQUENCE,
4a83e14f40f9 Added entity and id annotations. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 168 diff changeset	57 generator = "SEQUENCE_WSTS_ID_SEQ")
4a83e14f40f9 Added entity and id annotations. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 168 diff changeset	58 @Column(name = "id")
4a83e14f40f9 Added entity and id annotations. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 168 diff changeset	59 public Integer getId() {
4a83e14f40f9 Added entity and id annotations. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 168 diff changeset	60 return id;
4a83e14f40f9 Added entity and id annotations. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 168 diff changeset	61 }
4a83e14f40f9 Added entity and id annotations. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 168 diff changeset	62
168 86a1bd9cc50e More Hibernate/JPA stuff Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 167 diff changeset	63 public void setId(Integer id) {
167 15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	64 this.id = id;
15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	65 }
15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	66
174 249390dd24e7 Added foreign key constraint annotations to model classes. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 172 diff changeset	67 @OneToOne
249390dd24e7 Added foreign key constraint annotations to model classes. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 172 diff changeset	68 @JoinColumn(name = "river_id" )
249390dd24e7 Added foreign key constraint annotations to model classes. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 172 diff changeset	69 public River getRiver() {
249390dd24e7 Added foreign key constraint annotations to model classes. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 172 diff changeset	70 return river;
249390dd24e7 Added foreign key constraint annotations to model classes. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 172 diff changeset	71 }
249390dd24e7 Added foreign key constraint annotations to model classes. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 172 diff changeset	72
167 15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	73 public void setRiver(River river) {
15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	74 this.river = river;
15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	75 }
15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	76
172 605320b7df94 Added column annotations for simple fields. TODO: foreign keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 171 diff changeset	77 @Column(name = "description")
605320b7df94 Added column annotations for simple fields. TODO: foreign keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 171 diff changeset	78 public String getDescription() {
605320b7df94 Added column annotations for simple fields. TODO: foreign keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 171 diff changeset	79 return description;
605320b7df94 Added column annotations for simple fields. TODO: foreign keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 171 diff changeset	80 }
605320b7df94 Added column annotations for simple fields. TODO: foreign keys. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 171 diff changeset	81
167 15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	82 public void setDescription(String description) {
15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	83 this.description = description;
15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	84 }
467 c8c09e31cdb8 Added new column 'kind' in discharge tables and wst to distinguish between different types. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 201 diff changeset	85
c8c09e31cdb8 Added new column 'kind' in discharge tables and wst to distinguish between different types. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 201 diff changeset	86 @Column(name = "kind")
c8c09e31cdb8 Added new column 'kind' in discharge tables and wst to distinguish between different types. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 201 diff changeset	87 public Integer getKind() {
c8c09e31cdb8 Added new column 'kind' in discharge tables and wst to distinguish between different types. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 201 diff changeset	88 return kind;
c8c09e31cdb8 Added new column 'kind' in discharge tables and wst to distinguish between different types. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 201 diff changeset	89 }
c8c09e31cdb8 Added new column 'kind' in discharge tables and wst to distinguish between different types. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 201 diff changeset	90
c8c09e31cdb8 Added new column 'kind' in discharge tables and wst to distinguish between different types. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 201 diff changeset	91 public void setKind(Integer kind) {
c8c09e31cdb8 Added new column 'kind' in discharge tables and wst to distinguish between different types. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 201 diff changeset	92 this.kind = kind;
c8c09e31cdb8 Added new column 'kind' in discharge tables and wst to distinguish between different types. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 201 diff changeset	93 }
468 8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	94
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	95
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	96 /**
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	97 * Determines the min and max Q values of this WST. The min value is placed
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	98 * in the first field of the resulting array - the max value is placed in
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	99 * the second field.
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	100 *
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	101 * @return the min and max Q values of this WST.
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	102 */
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	103 public double[] determineMinMaxQ() {
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	104 double[] ab = river.determineMinMaxDistance();
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	105 return determineMinMaxQ(new Range(ab[0], ab[1], river));
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	106 }
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	107
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	108
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	109 /**
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	110 * Determines the min and max Q values of this WST in the given range. The
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	111 * min value is placed in the first field of the resulting array - the max
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	112 * value is placed in the second field.
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	113 *
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	114 * @param range The range used for querying the Q values.
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	115 *
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	116 * @return the min and max Q values of this WST.
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	117 */
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	118 public double[] determineMinMaxQ(Range range) {
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	119 Session session = SessionHolder.HOLDER.get();
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	120
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	121 Query query = session.createQuery(
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	122 "select min(q), max(q) from WstQRange where " +
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	123 " id in " +
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	124 " (select wstQRange.id from WstColumnQRange where " +
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	125 " wstColumn.id in (select id from WstColumn where wst.id = :wst)) " +
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	126 " and range.id in " +
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	127 " (select id from Range where not (a > :end or b < :start))");
8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	128
469 b5ca22aae092 Fixed index problem when an empty list is returned. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 468 diff changeset	129 query.setParameter("wst", getId());
468 8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	130 query.setParameter("start", range.getA());
469 b5ca22aae092 Fixed index problem when an empty list is returned. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 468 diff changeset	131 query.setParameter("end", range.getB());
468 8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	132
469 b5ca22aae092 Fixed index problem when an empty list is returned. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 468 diff changeset	133 List<Object []> results = query.list();
468 8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	134
469 b5ca22aae092 Fixed index problem when an empty list is returned. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 468 diff changeset	135 if (results.isEmpty()) {
b5ca22aae092 Fixed index problem when an empty list is returned. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 468 diff changeset	136 return null;
b5ca22aae092 Fixed index problem when an empty list is returned. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 468 diff changeset	137 }
b5ca22aae092 Fixed index problem when an empty list is returned. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 468 diff changeset	138
b5ca22aae092 Fixed index problem when an empty list is returned. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 468 diff changeset	139 Object [] result = results.get(0);
b5ca22aae092 Fixed index problem when an empty list is returned. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 468 diff changeset	140
b5ca22aae092 Fixed index problem when an empty list is returned. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 468 diff changeset	141 return new double [] {
b5ca22aae092 Fixed index problem when an empty list is returned. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 468 diff changeset	142 ((BigDecimal)result[0]).doubleValue(),
b5ca22aae092 Fixed index problem when an empty list is returned. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 468 diff changeset	143 ((BigDecimal)result[1]).doubleValue() };
468 8d76556c9616 Added methods to retrieve the min and max W and Q values of a Wst and Gauge. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 467 diff changeset	144 }
167 15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	145 }
15d515fe15f5 Added POJOs to be mapped to schema. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	146 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :

Mercurial > dive4elements > river

annotate flys-backend/src/main/java/de/intevation/flys/model/Wst.java @ 470:f4afea9b7537