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

Added datacage select and chart display for river infrastructure heights loaded from database

comparison

equal deleted inserted replaced

-:31b3cae5de0d
+:a165cd63099f
 */
 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.JoinColumn;
 import javax.persistence.OneToOne;
 import javax.persistence.SequenceGenerator;
 import javax.persistence.Table;
+import org.dive4elements.river.backend.SessionHolder;
 import org.dive4elements.river.model.Attribute;
+import org.hibernate.Query;
+import org.hibernate.Session;
 /**
 * Hibernate binding for the DB table infrastructure_values
 *
 }
 public void setHeight(final Double height) {
 this.height = height;
 }
+/**
+* Selects the infrastructure values of a data series in a km range from the database
+*/
+public static List<InfrastructureValue> getValues(final Infrastructure parent, final double kmLo, final double kmHi) {
+final Session session = SessionHolder.HOLDER.get();
+final Query query = session.createQuery("FROM InfrastructureValue WHERE (infrastructure=: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