dive4elements/river: backend/src/main/java/org/dive4elements/river/model/sinfo/FlowDepthValue.java comparison

Added datacage select and chart display for modelled flow depth series loaded from database

comparison

equal deleted inserted replaced

-:8aa7d9eaaa21
+:c16e90a0baf7
 */
 package org.dive4elements.river.model.sinfo;
 import java.io.Serializable;
+import java.util.List;
 import javax.persistence.Column;
 import javax.persistence.Entity;
 import javax.persistence.GeneratedValue;
 import javax.persistence.GenerationType;
 import javax.persistence.Id;
 import javax.persistence.JoinColumn;
 import javax.persistence.OneToOne;
 import javax.persistence.SequenceGenerator;
 import javax.persistence.Table;
+import org.dive4elements.river.backend.SessionHolder;
+import org.hibernate.Query;
+import org.hibernate.Session;
 /**
 * Hibernate binding for the DB table flow_depth_values
 *
 }
 public void setDepth(final Double depth) {
 this.depth = depth;
 }
+/**
+* Selects the flow depth values of a flow depth series column in a km range from the database
+*/
+public static List<FlowDepthValue> getValues(final FlowDepthColumn parent, final double kmLo, final double kmHi) {
+final Session session = SessionHolder.HOLDER.get();
+final Query query = session.createQuery("FROM FlowDepthValue WHERE (flowDepthColumn=:parent)"
++ " AND (station >= :kmLo - 0.0001) AND (station <= :kmHi + 0.0001)");
+query.setParameter("parent", parent);
+query.setParameter("kmLo", new Double(kmLo));
+query.setParameter("kmHi", new Double(kmHi));
+return query.list();
+}
 }

Mercurial > dive4elements > river