Mercurial > dive4elements > river
diff backend/src/main/java/org/dive4elements/river/model/sinfo/CollisionValue.java @ 9117:623b51bf03d7
Added datacage select and chart display for river bed collision counts loaded from database
author | mschaefer |
---|---|
date | Mon, 04 Jun 2018 17:31:51 +0200 |
parents | 50416a0df385 |
children | 38e8febd11b6 |
line wrap: on
line diff
--- a/backend/src/main/java/org/dive4elements/river/model/sinfo/CollisionValue.java Mon Jun 04 12:50:39 2018 +0200 +++ b/backend/src/main/java/org/dive4elements/river/model/sinfo/CollisionValue.java Mon Jun 04 17:31:51 2018 +0200 @@ -12,6 +12,7 @@ import java.io.Serializable; import java.util.Date; +import java.util.List; import javax.persistence.Column; import javax.persistence.Entity; @@ -23,6 +24,10 @@ 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 @@ -146,4 +151,17 @@ 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(); + } }