Mercurial > dive4elements > river
comparison artifacts/src/main/java/org/dive4elements/river/artifacts/model/minfo/SedimentLoadDataFactory.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 | 1fc453fbc5df |
children | 665c8326b1a6 |
comparison
equal
deleted
inserted
replaced
8411:b8c6cb36607e | 8412:17db08570637 |
---|---|
39 "sl.grain_fraction_id, " + | 39 "sl.grain_fraction_id, " + |
40 "sl.sq_time_interval_id " + | 40 "sl.sq_time_interval_id " + |
41 "FROM sediment_load sl " + | 41 "FROM sediment_load sl " + |
42 "JOIN sediment_load_values slv ON sl.id = slv.sediment_load_id " + | 42 "JOIN sediment_load_values slv ON sl.id = slv.sediment_load_id " + |
43 "JOIN measurement_station ms ON ms.id = slv.measurement_station_id " + | 43 "JOIN measurement_station ms ON ms.id = slv.measurement_station_id " + |
44 "JOIN rivers r ON r.id = ms.river_id " + | 44 "JOIN ranges rs ON rs.id = ms.range_id " + |
45 "JOIN rivers r ON r.id = rs.river_id " + | |
45 "WHERE r.name = :river) " + | 46 "WHERE r.name = :river) " + |
46 "SELECT " + | 47 "SELECT " + |
47 "sl.id AS sl_id, " + | 48 "sl.id AS sl_id, " + |
48 "sl.kind AS sl_kind, " + | 49 "sl.kind AS sl_kind, " + |
49 "sl.description AS sl_description, " + | 50 "sl.description AS sl_description, " + |
53 "sqti.stop_time AS sq_stop_time, " + | 54 "sqti.stop_time AS sq_stop_time, " + |
54 "sqti.id AS sq_ti_id, " + | 55 "sqti.id AS sq_ti_id, " + |
55 "slv.value AS slv_value, " + | 56 "slv.value AS slv_value, " + |
56 "gf.name AS gf_name, " + | 57 "gf.name AS gf_name, " + |
57 "ms.id AS ms_id, " + | 58 "ms.id AS ms_id, " + |
58 "rs.a AS ms_station, " + | 59 "CASE WHEN r.km_up = 1 AND rs.b IS NOT NULL " + |
60 "THEN rs.b " + | |
61 "ELSE rs.a " + | |
62 "END AS ms_station, " + | |
59 "ms.measurement_type AS ms_type " + | 63 "ms.measurement_type AS ms_type " + |
60 "FROM load_at_river sl " + | 64 "FROM load_at_river sl " + |
61 "CROSS JOIN measurement_station ms " + | 65 "CROSS JOIN measurement_station ms " + |
62 "JOIN ranges rs ON ms.range_id = rs.id " + | 66 "JOIN ranges rs ON ms.range_id = rs.id " + |
67 "JOIN rivers r ON rs.river_id = r.id " + | |
63 "JOIN time_intervals ti ON sl.time_interval_id = ti.id " + | 68 "JOIN time_intervals ti ON sl.time_interval_id = ti.id " + |
64 "LEFT JOIN time_intervals sqti ON sl.sq_time_interval_id = sqti.id " + | 69 "LEFT JOIN time_intervals sqti ON sl.sq_time_interval_id = sqti.id " + |
65 "JOIN grain_fraction gf ON sl.grain_fraction_id = gf.id " + | 70 "JOIN grain_fraction gf ON sl.grain_fraction_id = gf.id " + |
66 "JOIN rivers r ON ms.river_id = r.id " + | |
67 "LEFT JOIN sediment_load_values slv " + | 71 "LEFT JOIN sediment_load_values slv " + |
68 "ON ms.id=slv.measurement_station_id AND sl.id=slv.sediment_load_id " + | 72 "ON ms.id=slv.measurement_station_id AND sl.id=slv.sediment_load_id " + |
69 "WHERE (" + | 73 "WHERE (" + |
70 "(ms.measurement_type='Geschiebe' AND gf.name IN " + | 74 "(ms.measurement_type='Geschiebe' AND gf.name IN " + |
71 "('coarse', 'fine_middle', 'sand', 'susp_sand', " + | 75 "('coarse', 'fine_middle', 'sand', 'susp_sand', " + |