Mercurial > dive4elements > river
comparison artifacts/src/main/java/org/dive4elements/river/artifacts/model/minfo/BedHeightFactory.java @ 8582:17a3030bbda2
Update SQL-statements to schema-changes in rev 6d8d7425a6b5.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Mon, 16 Mar 2015 16:59:37 +0100 |
| parents | 078b07a94023 |
| children | 5e38e2924c07 |
comparison
equal
deleted
inserted
replaced
| 8581:073ea4bcea58 | 8582:17a3030bbda2 |
|---|---|
| 30 | 30 |
| 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," + | 33 "SELECT bhsv.height, bhsv.station, bhsv.data_gap," + |
| 34 " bhsv.sounding_width, bhs.year" + | 34 " bhsv.sounding_width, bhs.year" + |
| 35 " FROM bed_height_single bhs" + | 35 " FROM bed_height bhs" + |
| 36 " JOIN bed_height_single_values bhsv on bhsv.bed_height_single_id = bhs.id"; | 36 " JOIN bed_height_values bhsv on bhsv.bed_height_id = bhs.id"; |
| 37 | 37 |
| 38 public static final String ID_CLAUSE = | 38 public static final String ID_CLAUSE = |
| 39 " WHERE bhs.id = :height_id" + | 39 " WHERE bhs.id = :height_id" + |
| 40 " ORDER BY bhsv.station"; | 40 " ORDER BY bhsv.station"; |
| 41 | 41 |
| 44 " bhsv.station BETWEEN :fromkm AND :tokm" + | 44 " bhsv.station BETWEEN :fromkm AND :tokm" + |
| 45 " ORDER BY bhsv.station"; | 45 " ORDER BY bhsv.station"; |
| 46 | 46 |
| 47 /** Query to get name (description) for wst_id. */ | 47 /** Query to get name (description) for wst_id. */ |
| 48 public static final String SQL_SELECT_DESCR_SINGLE = | 48 public static final String SQL_SELECT_DESCR_SINGLE = |
| 49 "SELECT description FROM bed_height_single "+ | 49 "SELECT description FROM bed_height "+ |
| 50 "WHERE id = :height_id"; | 50 "WHERE id = :height_id"; |
| 51 | 51 |
| 52 private BedHeightFactory() { | 52 private BedHeightFactory() { |
| 53 } | 53 } |
| 54 | 54 |