Mercurial > dive4elements > river
comparison backend/src/main/java/org/dive4elements/river/model/sinfo/Channel.java @ 9432:d194c5b24bf8
Added bundu bzws w calculation and longitudinal sections of wspl and depth
| author | mschaefer |
|---|---|
| date | Mon, 20 Aug 2018 09:46:02 +0200 |
| parents | 189cc8ededbd |
| children |
comparison
equal
deleted
inserted
replaced
| 9431:eeea16ea0980 | 9432:d194c5b24bf8 |
|---|---|
| 168 final Session session = SessionHolder.HOLDER.get(); | 168 final Session session = SessionHolder.HOLDER.get(); |
| 169 final Query query = session.createQuery("FROM Channel WHERE (id=:id)"); | 169 final Query query = session.createQuery("FROM Channel WHERE (id=:id)"); |
| 170 query.setParameter("id", id); | 170 query.setParameter("id", id); |
| 171 return (Channel) query.list().get(0); | 171 return (Channel) query.list().get(0); |
| 172 } | 172 } |
| 173 | |
| 174 /** | |
| 175 * Queries the channel series for a river and a year from the database | |
| 176 */ | |
| 177 public static Channel getSeries(final River river, final int year) { | |
| 178 final Session session = SessionHolder.HOLDER.get(); | |
| 179 final Query query = session.createQuery("FROM Channel WHERE (river=:river) AND (year_from <= :year) AND (year_to >= :year)"); | |
| 180 query.setParameter("river", river); | |
| 181 query.setParameter("year", year); | |
| 182 @SuppressWarnings("unchecked") | |
| 183 final List<Object[]> rows = query.list(); | |
| 184 if (!rows.isEmpty()) | |
| 185 return (Channel) query.list().get(0); | |
| 186 return null; | |
| 187 } | |
| 173 } | 188 } |