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 |