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 |