Mercurial > dive4elements > river
comparison backend/src/main/java/org/dive4elements/river/model/MainValue.java @ 9176:1614cb14308f
Work on calculations for S-Info flood duration workflow
| author | mschaefer |
|---|---|
| date | Mon, 25 Jun 2018 19:21:11 +0200 |
| parents | 64e56a51db3f |
| children | 491e1a434457 |
comparison
equal
deleted
inserted
replaced
| 9175:34dc0163ad2d | 9176:1614cb14308f |
|---|---|
| 126 + " ORDER BY value"); | 126 + " ORDER BY value"); |
| 127 query.setParameter("gaugeid", gauge.getId()); | 127 query.setParameter("gaugeid", gauge.getId()); |
| 128 query.setParameter("typeid", typekey.getId()); | 128 query.setParameter("typeid", typekey.getId()); |
| 129 return query.list(); | 129 return query.list(); |
| 130 } | 130 } |
| 131 | |
| 132 /** | |
| 133 * Selects from the database the discharge-duration main values of a gauge sorted by duration | |
| 134 */ | |
| 135 public static List<MainValue> getDurationDischargesOfGauge(final Gauge gauge) { | |
| 136 final Session session = SessionHolder.HOLDER.get(); | |
| 137 final Query query = session.createQuery("SELECT mv" | |
| 138 + " FROM MainValue AS mv JOIN mv.mainValue AS nmv" | |
| 139 + " WHERE mv.gauge.id=:gaugeid AND nmv.type.id=:typeid" | |
| 140 + " ORDER BY CAST(nmv.name AS int)"); | |
| 141 query.setParameter("gaugeid", gauge.getId()); | |
| 142 query.setParameter("typeid", MainValueTypeKey.DURATION.getId()); | |
| 143 return query.list(); | |
| 144 } | |
| 131 } | 145 } |
| 132 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 : | 146 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 : |