Mercurial > dive4elements > river
comparison artifacts/src/main/java/org/dive4elements/river/artifacts/model/sq/StaticSQFactory.java @ 8412:17db08570637
SCHEMA CHANGE: removed superfluous columns station and river_id from measurement_stations and adapted other components accordingly.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Wed, 15 Oct 2014 19:20:26 +0200 |
| parents | a9bd4a23a852 |
| children | 9a5b3079aad4 |
comparison
equal
deleted
inserted
replaced
| 8411:b8c6cb36607e | 8412:17db08570637 |
|---|---|
| 32 "SELECT " + | 32 "SELECT " + |
| 33 "sq.description AS description,"+ | 33 "sq.description AS description,"+ |
| 34 "ti.start_time AS start_time," + | 34 "ti.start_time AS start_time," + |
| 35 "ti.stop_time AS stop_time, " + | 35 "ti.stop_time AS stop_time, " + |
| 36 "ms.name AS station_name, " + | 36 "ms.name AS station_name, " + |
| 37 "ms.station AS station_km, " + | 37 "CASE WHEN r.km_up = 1 AND ra.b IS NOT NULL " + |
| 38 "THEN ra.b " + | |
| 39 "ELSE ra.a " + | |
| 40 "END AS station_km, " + | |
| 38 "ms.measurement_type AS measurement_type, " + | 41 "ms.measurement_type AS measurement_type, " + |
| 39 "sqv.parameter AS parameter, " + | 42 "sqv.parameter AS parameter, " + |
| 40 "sqv.a AS a, " + | 43 "sqv.a AS a, " + |
| 41 "sqv.b AS b, " + | 44 "sqv.b AS b, " + |
| 42 "sqv.qmax AS qmax " + | 45 "sqv.qmax AS qmax " + |
| 43 "FROM sq_relation sq " + | 46 "FROM sq_relation sq " + |
| 44 "JOIN time_intervals ti ON ti.id = sq.time_interval_id " + | 47 "JOIN time_intervals ti ON ti.id = sq.time_interval_id " + |
| 45 "JOIN rivers r ON r.id = sq.river_id " + | |
| 46 "JOIN sq_relation_value sqv ON sqv.sq_relation_id = sq.id " + | 48 "JOIN sq_relation_value sqv ON sqv.sq_relation_id = sq.id " + |
| 47 "JOIN measurement_station ms ON sqv.measurement_station_id = ms.id "; | 49 "JOIN measurement_station ms " + |
| 50 "ON sqv.measurement_station_id = ms.id " + | |
| 51 "JOIN ranges ra ON ra.id = ms.range_id " + | |
| 52 "JOIN rivers r ON r.id = ra.river_id "; | |
| 48 | 53 |
| 49 public static final String STATION_CLAUSE = | 54 public static final String STATION_CLAUSE = |
| 50 "WHERE " + | 55 "WHERE " + |
| 51 "r.name = :river " + | 56 "r.name = :river " + |
| 52 "AND ms.id = :ms_id "; | 57 "AND ms.id = :ms_id "; |