Mercurial > dive4elements > river
comparison artifacts/src/main/java/org/dive4elements/river/artifacts/model/minfo/PorosityFactory.java @ 7860:f4dffc7d1d60
Order porosities by station.
| author | Raimund Renkert <rrenkert@intevation.de> |
|---|---|
| date | Thu, 08 May 2014 13:45:23 +0200 |
| parents | e84726b48484 |
| children | d9d2bd78eff6 |
comparison
equal
deleted
inserted
replaced
| 7853:57bd0a586a9b | 7860:f4dffc7d1d60 |
|---|---|
| 31 | 31 |
| 32 public static final String SQL_SELECT = | 32 public static final String SQL_SELECT = |
| 33 "SELECT pv.station AS station, pv.porosity AS porosity " + | 33 "SELECT pv.station AS station, pv.porosity AS porosity " + |
| 34 " FROM porosity p" + | 34 " FROM porosity p" + |
| 35 " JOIN porosity_values pv on pv.porosity_id = p.id" + | 35 " JOIN porosity_values pv on pv.porosity_id = p.id" + |
| 36 " WHERE p.id = :porosity_id"; | 36 " WHERE p.id = :porosity_id" + |
| 37 " ORDER BY station"; | |
| 37 | 38 |
| 38 private PorosityFactory() { | 39 private PorosityFactory() { |
| 39 } | 40 } |
| 40 | 41 |
| 41 | 42 |