Mercurial > dive4elements > river
comparison backend/src/main/java/org/dive4elements/river/model/Gauge.java @ 6838:a895eb07a7dc
(issue1353) Add method to model to gauge by number and river name
| author | Andre Heinecke <aheinecke@intevation.de> |
|---|---|
| date | Thu, 15 Aug 2013 15:57:54 +0200 |
| parents | 447ed3dee890 |
| children | 0c22ef71d154 |
comparison
equal
deleted
inserted
replaced
| 6837:9da2298ae380 | 6838:a895eb07a7dc |
|---|---|
| 221 | 221 |
| 222 public void setMainValues(List<MainValue> mainValues) { | 222 public void setMainValues(List<MainValue> mainValues) { |
| 223 this.mainValues = mainValues; | 223 this.mainValues = mainValues; |
| 224 } | 224 } |
| 225 | 225 |
| 226 | |
| 227 public static Gauge getGaugeByOfficialNumber(long number) { | 226 public static Gauge getGaugeByOfficialNumber(long number) { |
| 228 Session session = SessionHolder.HOLDER.get(); | 227 Session session = SessionHolder.HOLDER.get(); |
| 229 | 228 |
| 230 Query query = session.createQuery( | 229 Query query = session.createQuery( |
| 231 "from Gauge where officialNumber=:number"); | 230 "from Gauge where officialNumber=:number"); |
| 232 | 231 |
| 233 query.setParameter("number", number); | 232 query.setParameter("number", number); |
| 233 | |
| 234 List<Gauge> results = query.list(); | |
| 235 | |
| 236 return results.isEmpty() ? null : results.get(0); | |
| 237 } | |
| 238 | |
| 239 public static Gauge getGaugeByOfficialNumber(long number, String river_name) { | |
| 240 Session session = SessionHolder.HOLDER.get(); | |
| 241 | |
| 242 Query query = session.createQuery( | |
| 243 "from Gauge as gau " + | |
| 244 "where gau.officialNumber=:number and gau.river.name=:river_name"); | |
| 245 | |
| 246 query.setParameter("number", number); | |
| 247 query.setParameter("river_name", river_name); | |
| 234 | 248 |
| 235 List<Gauge> results = query.list(); | 249 List<Gauge> results = query.list(); |
| 236 | 250 |
| 237 return results.isEmpty() ? null : results.get(0); | 251 return results.isEmpty() ? null : results.get(0); |
| 238 } | 252 } |