Mercurial > dive4elements > river
comparison flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/minfo/SedimentLoadFactory.java @ 4426:b03f2e74025c
SedimentLoadFactory: Changed comments, removed empty one.
author | Felix Wolfsteller <felix.wolfsteller@intevation.de> |
---|---|
date | Wed, 07 Nov 2012 09:20:37 +0100 |
parents | 6a65e7ef43c0 |
children | 5ec5e950bdad |
comparison
equal
deleted
inserted
replaced
4418:e0a355d0c771 | 4426:b03f2e74025c |
---|---|
25 private static Logger log = Logger.getLogger(SedimentLoadFactory.class); | 25 private static Logger log = Logger.getLogger(SedimentLoadFactory.class); |
26 | 26 |
27 public static final String LOADS_CACHE_NAME = "sedimentloads"; | 27 public static final String LOADS_CACHE_NAME = "sedimentloads"; |
28 public static final String LOAD_DATA_CACHE_NAME = "sedimentload-data"; | 28 public static final String LOAD_DATA_CACHE_NAME = "sedimentload-data"; |
29 | 29 |
30 /** Query to get km and ws for wst_id and column_pos. */ | 30 /** Query to get description and start year, given name and a km range. */ |
31 public static final String SQL_SELECT_SINGLES = | 31 public static final String SQL_SELECT_SINGLES = |
32 "SELECT DISTINCT " + | 32 "SELECT DISTINCT " + |
33 " sy.description AS description, " + | 33 " sy.description AS description, " + |
34 " ti.start_time AS year " + | 34 " ti.start_time AS year " + |
35 " FROM sediment_yield sy " + | 35 " FROM sediment_yield sy " + |
38 " JOIN time_intervals ti ON sy.time_interval_id = ti.id " + | 38 " JOIN time_intervals ti ON sy.time_interval_id = ti.id " + |
39 " WHERE r.name = :name " + | 39 " WHERE r.name = :name " + |
40 " AND ti.stop_time IS NULL " + | 40 " AND ti.stop_time IS NULL " + |
41 " AND syv.station BETWEEN :startKm AND :endKm"; | 41 " AND syv.station BETWEEN :startKm AND :endKm"; |
42 | 42 |
43 /** Query to get name for wst_id and column_pos. */ | 43 /** Query to get start time, stop time and description. */ |
44 public static final String SQL_SELECT_EPOCHS = | 44 public static final String SQL_SELECT_EPOCHS = |
45 "SELECT DISTINCT " + | 45 "SELECT DISTINCT " + |
46 " sy.description AS description, " + | 46 " sy.description AS description, " + |
47 " ti.start_time AS start, " + | 47 " ti.start_time AS start, " + |
48 " ti.stop_time AS end " + | 48 " ti.stop_time AS end " + |
90 " AND syv.station BETWEEN :startKm AND :endKm"; | 90 " AND syv.station BETWEEN :startKm AND :endKm"; |
91 | 91 |
92 private SedimentLoadFactory() { | 92 private SedimentLoadFactory() { |
93 } | 93 } |
94 | 94 |
95 /** | 95 |
96 * | |
97 */ | |
98 public static SedimentLoad[] getLoads( | 96 public static SedimentLoad[] getLoads( |
99 String river, | 97 String river, |
100 String type, | 98 String type, |
101 double startKm, | 99 double startKm, |
102 double endKm | 100 double endKm |