Mercurial > dive4elements > river
comparison backend/src/main/java/org/dive4elements/river/model/sinfo/Tkh.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 | dcbdff96d1a8 |
| children | 1f63e9d3b0ec |
comparison
equal
deleted
inserted
replaced
| 9015:baef34f54ee2 | 9016:6e5ff436febe |
|---|---|
| 24 import javax.persistence.OneToMany; | 24 import javax.persistence.OneToMany; |
| 25 import javax.persistence.OneToOne; | 25 import javax.persistence.OneToOne; |
| 26 import javax.persistence.SequenceGenerator; | 26 import javax.persistence.SequenceGenerator; |
| 27 import javax.persistence.Table; | 27 import javax.persistence.Table; |
| 28 | 28 |
| 29 import org.dive4elements.river.backend.SessionHolder; | |
| 29 import org.dive4elements.river.model.River; | 30 import org.dive4elements.river.model.River; |
| 31 import org.hibernate.Query; | |
| 32 import org.hibernate.Session; | |
| 30 | 33 |
| 31 /** | 34 /** |
| 32 * Hibernate binding for the DB table tkh | 35 * Hibernate binding for the DB table tkh |
| 33 * | 36 * |
| 34 * @author Matthias Schäfer | 37 * @author Matthias Schäfer |
| 169 } | 172 } |
| 170 | 173 |
| 171 public void addColumn(final TkhColumn value) { | 174 public void addColumn(final TkhColumn value) { |
| 172 this.columns.add(value); | 175 this.columns.add(value); |
| 173 } | 176 } |
| 177 | |
| 178 /** | |
| 179 * Selects a tkh series by id from the database | |
| 180 */ | |
| 181 public static Tkh getTkhById(final int id) { | |
| 182 final Session session = SessionHolder.HOLDER.get(); | |
| 183 final Query query = session.createQuery("FROM Tkh WHERE id=:id"); | |
| 184 query.setParameter("id", id); | |
| 185 final List<Tkh> rows = query.list(); | |
| 186 return (rows != null) ? rows.get(0) : null; | |
| 187 } | |
| 174 } | 188 } |