Mercurial > dive4elements > river
comparison artifacts/src/main/java/org/dive4elements/river/artifacts/model/minfo/SedimentLoadDataFactory.java @ 8047:c835f3cf098e
Sediment load: Added join to fetch measurement station via ranges which know the river. Added a visitor for values, too.
| author | Sascha L. Teichmann <teichmann@intevation.de> |
|---|---|
| date | Thu, 17 Jul 2014 11:19:59 +0200 |
| parents | 3a769d5fb733 |
| children | cd35b76f1ef8 |
comparison
equal
deleted
inserted
replaced
| 8046:8c14588d1f78 | 8047:c835f3cf098e |
|---|---|
| 43 "FROM sediment_load_values slv " + | 43 "FROM sediment_load_values slv " + |
| 44 "JOIN sediment_load sl ON slv.sediment_load_id = sl.id " + | 44 "JOIN sediment_load sl ON slv.sediment_load_id = sl.id " + |
| 45 "JOIN time_intervals ti ON sl.time_interval_id = ti.id " + | 45 "JOIN time_intervals ti ON sl.time_interval_id = ti.id " + |
| 46 "JOIN grain_fraction gf ON sl.grain_fraction_id = gf.id " + | 46 "JOIN grain_fraction gf ON sl.grain_fraction_id = gf.id " + |
| 47 "JOIN measurement_station ms ON slv.measurement_station_id = ms.id " + | 47 "JOIN measurement_station ms ON slv.measurement_station_id = ms.id " + |
| 48 "JOIN rivers r ON ms.river_id = r.id " + | 48 "JOIN ranges rng ON ms.range_id = rng.id " + |
| 49 "JOIN rivers r ON rng.river_id = r.id " + | |
| 49 "WHERE r.name = :river " + | 50 "WHERE r.name = :river " + |
| 50 "ORDER BY sl.id"; | 51 "ORDER BY sl.id"; |
| 51 | 52 |
| 52 private SedimentLoadDataFactory() { | 53 private SedimentLoadDataFactory() { |
| 53 } | 54 } |