Mercurial > dive4elements > river
diff backend/src/main/java/org/dive4elements/river/model/sinfo/TkhColumn.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 | 32dd7e761e4e |
line wrap: on
line diff
--- a/backend/src/main/java/org/dive4elements/river/model/sinfo/TkhColumn.java Fri Apr 20 16:04:34 2018 +0200 +++ b/backend/src/main/java/org/dive4elements/river/model/sinfo/TkhColumn.java Mon Apr 23 15:18:48 2018 +0200 @@ -24,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 tkh_column * @@ -103,4 +107,15 @@ public void addValue(final TkhValue value) { this.values.add(value); } + + /** + * Selects a tkh series column by id from the database + */ + public static TkhColumn getTkhColumnById(final int id) { + final Session session = SessionHolder.HOLDER.get(); + final Query query = session.createQuery("FROM TkhColumn WHERE id=:id"); + query.setParameter("id", id); + final List<TkhColumn> rows = query.list(); + return (rows != null) ? rows.get(0) : null; + } }