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

Added datacage select and chart display for river bed collision counts loaded from database

comparison

equal deleted inserted replaced

-:edc3958b3ed2
+:623b51bf03d7
 package org.dive4elements.river.model.sinfo;
 import java.io.Serializable;
 import java.util.Date;
+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 collision_values
 *
 }
 public void setGaugeW(final Double gaugeW) {
 this.gaugeW = gaugeW;
 }
+/**
+* Selects the collision values of a data series in a km range from the database
+*/
+public static List<CollisionValue> getValues(final Collision parent, final double kmLo, final double kmHi) {
+final Session session = SessionHolder.HOLDER.get();
+final Query query = session.createQuery("FROM CollisionValue WHERE (collision=: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