Mercurial > dive4elements > river
comparison artifacts/src/main/java/org/dive4elements/river/artifacts/model/minfo/BedHeightFactory.java @ 6275:2d495b504c74
Order bed heights by station.
| author | Raimund Renkert <rrenkert@intevation.de> |
|---|---|
| date | Tue, 11 Jun 2013 14:58:13 +0200 |
| parents | af13ceeba52a |
| children | f1a3ea7fb3b6 |
comparison
equal
deleted
inserted
replaced
| 6272:24be0cc1c67c | 6275:2d495b504c74 |
|---|---|
| 31 /** Query to get km and ws for wst_id and column_pos. */ | 31 /** Query to get km and ws for wst_id and column_pos. */ |
| 32 public static final String SQL_SELECT_SINGLE = | 32 public static final String SQL_SELECT_SINGLE = |
| 33 "SELECT bhsv.height, bhsv.station, bhsv.data_gap, bhsv.sounding_width, bhs.year " + | 33 "SELECT bhsv.height, bhsv.station, bhsv.data_gap, bhsv.sounding_width, bhs.year " + |
| 34 " FROM bed_height_single bhs" + | 34 " FROM bed_height_single bhs" + |
| 35 " JOIN bed_height_single_values bhsv on bhsv.bed_height_single_id = bhs.id" + | 35 " JOIN bed_height_single_values bhsv on bhsv.bed_height_single_id = bhs.id" + |
| 36 " WHERE bhs.id = :height_id"; | 36 " WHERE bhs.id = :height_id" + |
| 37 " ORDER BY bhsv.station"; | |
| 38 | |
| 37 | 39 |
| 38 /** Query to get name for wst_id and column_pos. */ | 40 /** Query to get name for wst_id and column_pos. */ |
| 39 public static final String SQL_SELECT_EPOCH = | 41 public static final String SQL_SELECT_EPOCH = |
| 40 "SELECT bv.height, bv.station, ti.start_time, ti.stop_time" + | 42 "SELECT bv.height, bv.station, ti.start_time, ti.stop_time" + |
| 41 " FROM bed_height_epoch b" + | 43 " FROM bed_height_epoch b" + |
| 42 " JOIN bed_height_epoch_values bv ON b.id = bv.bed_height_epoch_id" + | 44 " JOIN bed_height_epoch_values bv ON b.id = bv.bed_height_epoch_id" + |
| 43 " JOIN time_intervals ti ON b.time_interval_id = ti.id" + | 45 " JOIN time_intervals ti ON b.time_interval_id = ti.id" + |
| 44 " WHERE b.id = :height_id"; | 46 " WHERE b.id = :height_id" + |
| 47 " ORDER BY bhsv.station"; | |
| 45 | 48 |
| 46 /** Query to get name (description) for wst_id. */ | 49 /** Query to get name (description) for wst_id. */ |
| 47 public static final String SQL_SELECT_DESCR_SINGLE = | 50 public static final String SQL_SELECT_DESCR_SINGLE = |
| 48 "SELECT description FROM bed_height_single "+ | 51 "SELECT description FROM bed_height_single "+ |
| 49 "WHERE id = :height_id"; | 52 "WHERE id = :height_id"; |