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

annotate flys-backend/src/main/java/de/intevation/flys/model/FlowVelocityModel.java @ 4837:9e25c7523485

Fixed calculation of effective width in MINFO SQ relation. * Get all (including empty datasets) from db. * Filter empty datasets when processing data of the same date. * Added debug outputs.

author	Raimund Renkert <rrenkert@intevation.de>
date	Wed, 23 Jan 2013 11:14:41 +0100
parents	5a89c2b05e6d
children	c7ce7c9e405e

rev	line source
2825 a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	1 package de.intevation.flys.model;
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	2
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	3 import java.io.Serializable;
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	4 import java.util.List;
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	5
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	6 import javax.persistence.Entity;
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	7 import javax.persistence.Id;
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	8 import javax.persistence.Table;
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	9 import javax.persistence.GeneratedValue;
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	10 import javax.persistence.Column;
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	11 import javax.persistence.SequenceGenerator;
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	12 import javax.persistence.GenerationType;
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	13 import javax.persistence.JoinColumn;
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	14 import javax.persistence.OneToOne;
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	15
2871 5a89c2b05e6d Added functions to retrieve data from database. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2825 diff changeset	16 import org.hibernate.Session;
5a89c2b05e6d Added functions to retrieve data from database. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2825 diff changeset	17 import org.hibernate.Query;
5a89c2b05e6d Added functions to retrieve data from database. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2825 diff changeset	18
2825 a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	19 import org.apache.log4j.Logger;
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	20
2871 5a89c2b05e6d Added functions to retrieve data from database. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2825 diff changeset	21 import de.intevation.flys.backend.SessionHolder;
5a89c2b05e6d Added functions to retrieve data from database. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2825 diff changeset	22
2825 a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	23
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	24 @Entity
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	25 @Table(name = "flow_velocity_model")
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	26 public class FlowVelocityModel
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	27 implements Serializable
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	28 {
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	29 private static Logger logger = Logger.getLogger(FlowVelocityModel.class);
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	30
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	31
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	32 private Integer id;
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	33
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	34 private River river;
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	35
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	36 private DischargeZone dischargeZone;
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	37
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	38 private List<FlowVelocityModelValue> values;
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 String description;
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
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	43 public FlowVelocityModel() {
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	44 }
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	45
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	46
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	47 public FlowVelocityModel(River river, DischargeZone dischargeZone) {
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	48 this(river, dischargeZone, null);
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	49 }
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	50
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	51
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	52 public FlowVelocityModel(
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	53 River river,
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	54 DischargeZone dischargeZone,
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	55 String description
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 this.river = river;
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	58 this.dischargeZone = dischargeZone;
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	59 this.description = description;
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	60 }
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	61
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	62 @Id
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	63 @SequenceGenerator(
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	64 name = "SEQUENCE_FLOW_VELOCITY_MODEL_ID_SEQ",
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	65 sequenceName = "FLOW_VELOCITY_MODEL_ID_SEQ",
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	66 allocationSize = 1)
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	67 @GeneratedValue(
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	68 strategy = GenerationType.SEQUENCE,
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	69 generator = "SEQUENCE_FLOW_VELOCITY_MODEL_ID_SEQ")
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	70 @Column(name = "id")
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	71 public Integer getId() {
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	72 return id;
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	73 }
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	74
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	75 public void setId(Integer id) {
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	76 this.id = id;
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	77 }
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	78
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	79 @OneToOne
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	80 @JoinColumn(name = "river_id")
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	81 public River getRiver() {
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	82 return river;
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
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	85 public void setRiver(River river) {
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	86 this.river = river;
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
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	89 @OneToOne
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	90 @JoinColumn(name = "discharge_zone_id")
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	91 public DischargeZone getDischargeZone() {
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	92 return dischargeZone;
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
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	95 public void setDischargeZone(DischargeZone dischargeZone) {
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	96 this.dischargeZone = dischargeZone;
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	97 }
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	98
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	99 @Column(name = "description")
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	100 public String getDescription() {
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	101 return description;
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	102 }
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	103
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	104 public void setDescription(String description) {
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	105 this.description = description;
a948366d8ac5 Added new model classes for MINFO specific flow velocity. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	106 }
2871 5a89c2b05e6d Added functions to retrieve data from database. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2825 diff changeset	107
5a89c2b05e6d Added functions to retrieve data from database. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2825 diff changeset	108
5a89c2b05e6d Added functions to retrieve data from database. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2825 diff changeset	109 public static List<FlowVelocityModel> getModels(
5a89c2b05e6d Added functions to retrieve data from database. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2825 diff changeset	110 River river,
5a89c2b05e6d Added functions to retrieve data from database. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2825 diff changeset	111 DischargeZone zone
5a89c2b05e6d Added functions to retrieve data from database. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2825 diff changeset	112 ) {
5a89c2b05e6d Added functions to retrieve data from database. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2825 diff changeset	113 Session session = SessionHolder.HOLDER.get();
5a89c2b05e6d Added functions to retrieve data from database. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2825 diff changeset	114
5a89c2b05e6d Added functions to retrieve data from database. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2825 diff changeset	115 Query query = session.createQuery(
5a89c2b05e6d Added functions to retrieve data from database. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2825 diff changeset	116 "from FlowVelocityModel where river=:river and dischargeZone=:zone");
5a89c2b05e6d Added functions to retrieve data from database. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2825 diff changeset	117
5a89c2b05e6d Added functions to retrieve data from database. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2825 diff changeset	118 query.setParameter("river", river);
5a89c2b05e6d Added functions to retrieve data from database. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2825 diff changeset	119 query.setParameter("zone", zone);
5a89c2b05e6d Added functions to retrieve data from database. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2825 diff changeset	120
5a89c2b05e6d Added functions to retrieve data from database. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2825 diff changeset	121 return query.list();
5a89c2b05e6d Added functions to retrieve data from database. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 2825 diff changeset	122 }
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 // 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/FlowVelocityModel.java @ 4837:9e25c7523485