Mercurial > dive4elements > river
diff backend/src/main/java/org/dive4elements/river/model/sinfo/TkhValue.java @ 9016:6e5ff436febe
Added datacage select and chart display for TKH series loaded from database
author | mschaefer |
---|---|
date | Mon, 23 Apr 2018 15:18:48 +0200 |
parents | 50416a0df385 |
children | 1f63e9d3b0ec |
line wrap: on
line diff
--- a/backend/src/main/java/org/dive4elements/river/model/sinfo/TkhValue.java Fri Apr 20 16:04:34 2018 +0200 +++ b/backend/src/main/java/org/dive4elements/river/model/sinfo/TkhValue.java Mon Apr 23 15:18:48 2018 +0200 @@ -11,6 +11,7 @@ package org.dive4elements.river.model.sinfo; import java.io.Serializable; +import java.util.List; import javax.persistence.Column; import javax.persistence.Entity; @@ -22,6 +23,9 @@ 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 tkh_values @@ -109,4 +113,17 @@ public void setTkheight(final Double tkheight) { this.tkheight = tkheight; } + + /** + * Selects the tkh values of a tkh series column in a km range from the database + */ + public static List<TkhValue> getTkhValues(final TkhColumn parent, final double kmLo, final double kmHi) { + final Session session = SessionHolder.HOLDER.get(); + final Query query = session.createQuery("FROM TkhValue WHERE (tkhColumn=: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(); + } }