Mercurial > dive4elements > river
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 9015:baef34f54ee2 | 9016:6e5ff436febe |
|---|---|
| 21 import javax.persistence.JoinColumn; | 21 import javax.persistence.JoinColumn; |
| 22 import javax.persistence.OneToMany; | 22 import javax.persistence.OneToMany; |
| 23 import javax.persistence.OneToOne; | 23 import javax.persistence.OneToOne; |
| 24 import javax.persistence.SequenceGenerator; | 24 import javax.persistence.SequenceGenerator; |
| 25 import javax.persistence.Table; | 25 import javax.persistence.Table; |
| 26 | |
| 27 import org.dive4elements.river.backend.SessionHolder; | |
| 28 import org.hibernate.Query; | |
| 29 import org.hibernate.Session; | |
| 26 | 30 |
| 27 /** | 31 /** |
| 28 * Hibernate binding for the DB table tkh_column | 32 * Hibernate binding for the DB table tkh_column |
| 29 * | 33 * |
| 30 * @author Matthias Schäfer | 34 * @author Matthias Schäfer |
| 101 } | 105 } |
| 102 | 106 |
| 103 public void addValue(final TkhValue value) { | 107 public void addValue(final TkhValue value) { |
| 104 this.values.add(value); | 108 this.values.add(value); |
| 105 } | 109 } |
| 110 | |
| 111 /** | |
| 112 * Selects a tkh series column by id from the database | |
| 113 */ | |
| 114 public static TkhColumn getTkhColumnById(final int id) { | |
| 115 final Session session = SessionHolder.HOLDER.get(); | |
| 116 final Query query = session.createQuery("FROM TkhColumn WHERE id=:id"); | |
| 117 query.setParameter("id", id); | |
| 118 final List<TkhColumn> rows = query.list(); | |
| 119 return (rows != null) ? rows.get(0) : null; | |
| 120 } | |
| 106 } | 121 } |