dive4elements/river: artifacts/src/main/java/org/dive4elements/river/artifacts/model/minfo/SedimentLoadFactory.java annotate

annotate artifacts/src/main/java/org/dive4elements/river/artifacts/model/minfo/SedimentLoadFactory.java @ 6740:68c7b5811c4f

Cosmetics, docs, in range of issue1393.

author	Felix Wolfsteller <felix.wolfsteller@intevation.de>
date	Thu, 01 Aug 2013 11:58:25 +0200
parents	1960d55bafb1
children	35f2d32b921d

rev	line source
5863 4897a58c8746 River artifacts: Added new copyright headers. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	1 /* Copyright (C) 2011, 2012, 2013 by Bundesanstalt für Gewässerkunde
4897a58c8746 River artifacts: Added new copyright headers. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	2 * Software engineering by Intevation GmbH
4897a58c8746 River artifacts: Added new copyright headers. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	3 *
5994 af13ceeba52a Removed trailing whitespace. Sascha L. Teichmann <teichmann@intevation.de> parents: 5863 diff changeset	4 * This file is Free Software under the GNU AGPL (>=v3)
5863 4897a58c8746 River artifacts: Added new copyright headers. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	5 * and comes with ABSOLUTELY NO WARRANTY! Check out the
5994 af13ceeba52a Removed trailing whitespace. Sascha L. Teichmann <teichmann@intevation.de> parents: 5863 diff changeset	6 * documentation coming with Dive4Elements River for details.
5863 4897a58c8746 River artifacts: Added new copyright headers. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	7 */
4897a58c8746 River artifacts: Added new copyright headers. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	8
5831 bd047b71ab37 Repaired internal references Sascha L. Teichmann <teichmann@intevation.de> parents: 5789 diff changeset	9 package org.dive4elements.river.artifacts.model.minfo;
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	10
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	11 import gnu.trove.TDoubleArrayList;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	12
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	13 import java.util.Calendar;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	14 import java.util.Date;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	15 import java.util.List;
6374 48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	16 import java.util.TreeMap;
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	17
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	18 import net.sf.ehcache.Cache;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	19 import net.sf.ehcache.Element;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	20
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	21 import org.apache.log4j.Logger;
5831 bd047b71ab37 Repaired internal references Sascha L. Teichmann <teichmann@intevation.de> parents: 5789 diff changeset	22 import org.dive4elements.river.artifacts.cache.CacheFactory;
6374 48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	23 import org.dive4elements.river.artifacts.model.Range;
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	24 import org.dive4elements.river.artifacts.model.RiverFactory;
5831 bd047b71ab37 Repaired internal references Sascha L. Teichmann <teichmann@intevation.de> parents: 5789 diff changeset	25 import org.dive4elements.river.artifacts.model.StaticSedimentLoadCacheKey;
bd047b71ab37 Repaired internal references Sascha L. Teichmann <teichmann@intevation.de> parents: 5789 diff changeset	26 import org.dive4elements.river.backend.SessionHolder;
6392 9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	27 import org.dive4elements.river.model.MeasurementStation;
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	28 import org.hibernate.SQLQuery;
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	29 import org.hibernate.Session;
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	30 import org.hibernate.type.StandardBasicTypes;
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	31
6740 68c7b5811c4f Cosmetics, docs, in range of issue1393. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6737 diff changeset	32
5662 7e3cde8b564c Cosmetics, docs, vimlines. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 5661 diff changeset	33 /** Pull Sediment Loads out of db. */
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	34 public class SedimentLoadFactory
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	35 {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	36 /** Private logger to use here. */
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	37 private static Logger log = Logger.getLogger(SedimentLoadFactory.class);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	38
6725 7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	39 // Cache name/keys
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	40 public static final String LOADS_CACHE_NAME = "sedimentloads";
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	41 public static final String LOAD_DATA_CACHE_NAME = "sedimentload-data";
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	42
6725 7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	43 /** Query to get description and start year of single type
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	44 * sediment_yields. */
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	45 public static final String SQL_SELECT_SINGLES =
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	46 "SELECT DISTINCT " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	47 " sy.description AS description, " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	48 " ti.start_time AS year " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	49 " FROM sediment_yield sy " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	50 " JOIN rivers r ON sy.river_id = r.id " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	51 " JOIN sediment_yield_values syv ON sy.id = syv.sediment_yield_id " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	52 " JOIN time_intervals ti ON sy.time_interval_id = ti.id " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	53 " WHERE r.name = :name " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	54 " AND ti.stop_time IS NULL " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	55 " AND syv.station BETWEEN :startKm AND :endKm";
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	56
6725 7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	57 /** Query to get description, name and time range for official
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	58 * epoch-type sediment yields. */
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	59 public static final String SQL_SELECT_OFFEPOCHS =
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	60 "SELECT DISTINCT " +
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	61 " ti.start_time AS startYear, " +
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	62 " ti.stop_time AS end " +
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	63 " FROM sediment_yield sy " +
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	64 " JOIN rivers r ON sy.river_id = r.id " +
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	65 " JOIN sediment_yield_values syv ON sy.id = syv.sediment_yield_id " +
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	66 " JOIN time_intervals ti ON sy.time_interval_id = ti.id " +
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	67 " WHERE r.name = :name " +
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	68 " AND ti.stop_time IS NOT NULL " +
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	69 " AND syv.station BETWEEN :startKm AND :endKm " +
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	70 " AND sy.kind = 1";
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	71
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	72 /** Query to get description, name and time range for epoch-type
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	73 * sediment yields. */
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	74 public static final String SQL_SELECT_EPOCHS =
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	75 "SELECT DISTINCT " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	76 " sy.description AS description, " +
6477 d1502b8dd091 'start' is a reserved word in Oracle Tom Gottfried <tom@intevation.de> parents: 6412 diff changeset	77 " ti.start_time AS startYear, " +
6392 9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	78 " ti.stop_time AS end, " +
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	79 " u.name AS unit" +
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	80 " FROM sediment_yield sy " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	81 " JOIN rivers r ON sy.river_id = r.id " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	82 " JOIN sediment_yield_values syv ON sy.id = syv.sediment_yield_id " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	83 " JOIN time_intervals ti ON sy.time_interval_id = ti.id " +
6392 9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	84 " JOIN units u ON u.id = sy.unit_id " +
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	85 " WHERE r.name = :name " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	86 " AND ti.stop_time IS NOT NULL " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	87 " AND syv.station BETWEEN :startKm AND :endKm";
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	88
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	89 public static final String SQL_SELECT_SINGLES_DATA =
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	90 "SELECT" +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	91 " sy.description AS description, " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	92 " ti.start_time AS year, " +
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	93 " syv.value AS load, " +
6392 9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	94 " syv.station AS km, " +
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	95 " u.name AS unit " +
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	96 " FROM sediment_yield sy " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	97 " JOIN rivers r ON sy.river_id = r.id " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	98 " JOIN time_intervals ti ON sy.time_interval_id = ti.id " +
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	99 " JOIN sediment_yield_values syv ON sy.id = syv.sediment_yield_id " +
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	100 " JOIN grain_fraction gf ON sy.grain_fraction_id = gf.id " +
6392 9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	101 " JOIN units u ON u.id = sy.unit_id" +
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	102 " WHERE r.name = :name " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	103 " AND ti.start_time BETWEEN :begin AND :end " +
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	104 " AND ti.stop_time IS NULL " +
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	105 " AND gf.name = :grain " +
6392 9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	106 " AND syv.station BETWEEN :startKm AND :endKm " +
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	107 " ORDER BY syv.station";
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	108
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	109 public static final String SQL_SELECT_UNKNOWN_DATA =
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	110 "SELECT" +
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	111 " sy.description AS description, " +
6477 d1502b8dd091 'start' is a reserved word in Oracle Tom Gottfried <tom@intevation.de> parents: 6412 diff changeset	112 " ti.start_time AS startYear, " +
6392 9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	113 " ti.stop_time AS end, " +
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	114 " syv.value AS load, " +
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	115 " syv.station AS km, " +
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	116 " u.name AS unit " +
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	117 " FROM sediment_yield sy " +
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	118 " JOIN rivers r ON sy.river_id = r.id " +
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	119 " JOIN time_intervals ti ON sy.time_interval_id = ti.id " +
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	120 " JOIN sediment_yield_values syv ON sy.id = syv.sediment_yield_id " +
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	121 " JOIN grain_fraction gf ON sy.grain_fraction_id = gf.id " +
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	122 " JOIN units u ON u.id = sy.unit_id" +
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	123 " WHERE r.name = :name " +
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	124 " AND sy.description = :descr " +
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	125 " AND gf.name = 'unknown' " +
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	126 " ORDER BY syv.station";
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	127
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	128 public static final String SQL_SELECT_UNKNOWN =
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	129 "SELECT DISTINCT " +
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	130 " sy.description AS description, " +
6477 d1502b8dd091 'start' is a reserved word in Oracle Tom Gottfried <tom@intevation.de> parents: 6412 diff changeset	131 " ti.start_time AS startYear, " +
6392 9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	132 " ti.stop_time AS end " +
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	133 "FROM sediment_yield sy " +
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	134 " JOIN rivers r ON sy.river_id = r.id " +
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	135 " JOIN time_intervals ti ON sy.time_interval_id = ti.id " +
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	136 " JOIN grain_fraction gf ON sy.grain_fraction_id = gf.id " +
6665 b7945db8a43b issue1413: Only show unknown sediment loads of selected unit type. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6545 diff changeset	137 " JOIN units u ON sy.unit_id = u.id " +
b7945db8a43b issue1413: Only show unknown sediment loads of selected unit type. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6545 diff changeset	138 "WHERE r.name = :river " +
b7945db8a43b issue1413: Only show unknown sediment loads of selected unit type. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6545 diff changeset	139 " AND gf.name = 'unknown' " +
b7945db8a43b issue1413: Only show unknown sediment loads of selected unit type. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6545 diff changeset	140 " AND u.name = :unit";
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	141
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	142 public static final String SQL_SELECT_EPOCHS_DATA =
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	143 "SELECT" +
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	144 " sy.description AS description, " +
4517 a5e4fae31089 Fixed SQL statements and parameters. Raimund Renkert <rrenkert@intevation.de> parents: 4434 diff changeset	145 " ti.start_time AS startYear, " +
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	146 " syv.value AS load, " +
4546 af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	147 " syv.station AS km," +
6392 9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	148 " ti.stop_time AS endYear, " +
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	149 " u.name AS unit" +
4546 af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	150 " FROM sediment_yield sy " +
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	151 " JOIN rivers r ON sy.river_id = r.id " +
4546 af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	152 " JOIN time_intervals ti ON sy.time_interval_id = ti.id " +
af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	153 " JOIN sediment_yield_values syv ON sy.id = syv.sediment_yield_id " +
af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	154 " JOIN grain_fraction gf ON sy.grain_fraction_id = gf.id " +
6392 9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	155 " JOIN units u ON u.id = sy.unit_id " +
4546 af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	156 " WHERE r.name = :name " +
af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	157 " AND ti.start_time BETWEEN :sbegin AND :send " +
af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	158 " AND ti.stop_time BETWEEN :ebegin AND :eend " +
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	159 " AND gf.name = :grain " +
6392 9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	160 " AND syv.station BETWEEN :startKm AND :endKm " +
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	161 " ORDER BY syv.station";
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	162
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	163 private SedimentLoadFactory() {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	164 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	165
4434 60c728e557f4 Backed out changeset e8a4d2fd25cc Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 4428 diff changeset	166 /**
6725 7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	167 * @param river name of river.
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	168 * @param type
4434 60c728e557f4 Backed out changeset e8a4d2fd25cc Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 4428 diff changeset	169 */
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	170 public static SedimentLoad[] getLoads(
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	171 String river,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	172 String type,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	173 double startKm,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	174 double endKm
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	175 ) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	176 log.debug("SedimentLoadFactory.getLoads");
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	177 Cache cache = CacheFactory.getCache(LOADS_CACHE_NAME);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	178
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	179 if (cache == null) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	180 log.debug("Cache not configured.");
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	181 return getSedimentLoadsUncached(river, type, startKm, endKm);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	182 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	183
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	184 StaticSedimentLoadCacheKey key =
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	185 new StaticSedimentLoadCacheKey(river, startKm, endKm, 0, 0);
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	186
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	187 Element element = cache.get(key);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	188
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	189 if (element != null) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	190 log.debug("SedimentLoad found in cache");
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	191 return (SedimentLoad[])element.getValue();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	192 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	193
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	194 SedimentLoad[] values =
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	195 getSedimentLoadsUncached(river, type, startKm, endKm);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	196
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	197 if (values != null && key != null) {
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	198 log.debug("Store static sediment load values in cache.");
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	199 element = new Element(key, values);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	200 cache.put(element);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	201 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	202 return values;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	203 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	204
6740 68c7b5811c4f Cosmetics, docs, in range of issue1393. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6737 diff changeset	205 /**
68c7b5811c4f Cosmetics, docs, in range of issue1393. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6737 diff changeset	206 * Get a sedimentLoad filled with data from db (or cache).
68c7b5811c4f Cosmetics, docs, in range of issue1393. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6737 diff changeset	207 * @param type "epoch","off_epoch" or "single"
68c7b5811c4f Cosmetics, docs, in range of issue1393. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6737 diff changeset	208 */
5661 b6297a67823e SedimentLoadFactory: Renamed getLoadwithData to getLoadWithData, update callers. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 4736 diff changeset	209 public static SedimentLoad getLoadWithData(
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	210 String river,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	211 String type,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	212 double startKm,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	213 double endKm,
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	214 int syear,
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	215 int eyear
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	216 ) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	217 log.debug("SedimentLoadFactory.getLoadWithData");
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	218 Cache cache = CacheFactory.getCache(LOAD_DATA_CACHE_NAME);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	219
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	220 if (cache == null) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	221 log.debug("Cache not configured.");
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	222 return getSedimentLoadWithDataUncached(
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	223 river,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	224 type,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	225 startKm,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	226 endKm,
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	227 syear,
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	228 eyear);
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	229 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	230
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	231 StaticSedimentLoadCacheKey key =
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	232 new StaticSedimentLoadCacheKey(river, startKm, endKm, syear, eyear);
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	233
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	234 Element element = cache.get(key);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	235
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	236 if (element != null) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	237 log.debug("SedimentLoad found in cache");
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	238 return (SedimentLoad)element.getValue();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	239 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	240
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	241 SedimentLoad values = getSedimentLoadWithDataUncached(
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	242 river,
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	243 type,
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	244 startKm,
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	245 endKm,
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	246 syear,
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	247 eyear);
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	248
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	249 if (values != null && key != null) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	250 log.debug("Store static bed height values in cache.");
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	251 element = new Element(key, values);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	252 cache.put(element);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	253 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	254 return values;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	255 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	256
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	257 /**
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	258 * Get sediment loads from db.
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	259 * @param river the river
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	260 * @param type the sediment load type (year or epoch)
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	261 * @return according sediment loads.
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	262 */
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	263 public static SedimentLoad[] getSedimentLoadsUncached(
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	264 String river,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	265 String type,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	266 double startKm,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	267 double endKm
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	268 ) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	269 log.debug("SedimentLoadFactory.getSedimentLoadsUncached");
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	270
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	271 Session session = SessionHolder.HOLDER.get();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	272 SQLQuery sqlQuery = null;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	273
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	274 if (type.equals("single")) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	275 sqlQuery = session.createSQLQuery(SQL_SELECT_SINGLES)
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	276 .addScalar("description", StandardBasicTypes.STRING)
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	277 .addScalar("year", StandardBasicTypes.DATE);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	278 sqlQuery.setString("name", river);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	279 sqlQuery.setDouble("startKm", startKm);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	280 sqlQuery.setDouble("endKm", endKm);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	281 List<Object []> results = sqlQuery.list();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	282 SedimentLoad[] loads = new SedimentLoad[results.size()];
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	283 for (int i = 0; i < results.size(); i++) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	284 Object[] row = results.get(i);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	285 loads[i] = new SedimentLoad(
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	286 (String) row[0],
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	287 (Date) row[1],
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	288 null,
6392 9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	289 false,
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	290 "");
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	291 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	292 return loads;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	293 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	294 else if (type.equals("epoch")) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	295 sqlQuery = session.createSQLQuery(SQL_SELECT_EPOCHS)
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	296 .addScalar("description", StandardBasicTypes.STRING)
6477 d1502b8dd091 'start' is a reserved word in Oracle Tom Gottfried <tom@intevation.de> parents: 6412 diff changeset	297 .addScalar("startYear", StandardBasicTypes.DATE)
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	298 .addScalar("end", StandardBasicTypes.DATE);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	299 sqlQuery.setString("name", river);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	300 sqlQuery.setDouble("startKm", startKm);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	301 sqlQuery.setDouble("endKm", endKm);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	302 List<Object []> results = sqlQuery.list();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	303
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	304 SedimentLoad[] loads = new SedimentLoad[results.size()];
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	305 for (int i = 0; i < results.size(); i++) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	306 Object[] row = results.get(i);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	307 loads[i] = new SedimentLoad(
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	308 (String) row[0],
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	309 (Date) row[1],
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	310 (Date) row[2],
6392 9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	311 true,
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	312 "");
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	313 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	314 return loads;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	315 }
6725 7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	316 else if (type.equals("off_epoch")) {
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	317 sqlQuery = session.createSQLQuery(SQL_SELECT_OFFEPOCHS)
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	318 .addScalar("startYear", StandardBasicTypes.DATE)
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	319 .addScalar("end", StandardBasicTypes.DATE);
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	320 sqlQuery.setString("name", river);
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	321 sqlQuery.setDouble("startKm", startKm);
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	322 sqlQuery.setDouble("endKm", endKm);
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	323 List<Object []> results = sqlQuery.list();
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	324
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	325 SedimentLoad[] loads = new SedimentLoad[results.size()];
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	326 for (int i = 0; i < results.size(); i++) {
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	327 Object[] row = results.get(i);
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	328 loads[i] = new SedimentLoad(
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	329 ((Date) row[0]).toString() + (Date) row[1],
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	330 (Date) row[0],
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	331 (Date) row[1],
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	332 true,
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	333 "");
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	334 }
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	335 return loads;
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	336 }
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	337 else {
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	338 log.warn("getSedimentLoadsUncached does not understand type " + type);
7ea933f9c6ea issu1393/SedimentLoadFactory: Handle off_epoch type queries. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6665 diff changeset	339 }
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	340 return new SedimentLoad[0];
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	341 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	342
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	343 /**
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	344 * Get sediment loads from db.
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	345 * @param river the river
6740 68c7b5811c4f Cosmetics, docs, in range of issue1393. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6737 diff changeset	346 * @param type the sediment load type (year, epoch or off_epoch)
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	347 * @return according sediment loads.
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	348 */
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	349 public static SedimentLoad getSedimentLoadWithDataUncached(
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	350 String river,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	351 String type,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	352 double startKm,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	353 double endKm,
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	354 int syear,
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	355 int eyear
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	356 ) {
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	357 log.debug("SedimentLoadFactory.getSedimentLoadWithDataUncached");
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	358 Session session = SessionHolder.HOLDER.get();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	359 SQLQuery sqlQuery = null;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	360
6374 48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	361 List<MeasurementStation> allStations = RiverFactory.getRiver(river).getMeasurementStations();
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	362 TreeMap<Double,MeasurementStation> floatStations = new TreeMap<Double, MeasurementStation>();
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	363 TreeMap<Double,MeasurementStation> suspStations = new TreeMap<Double, MeasurementStation>();
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	364 for (MeasurementStation measurementStation: allStations) {
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	365 if (measurementStation.getMeasurementType() == null \|\|
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	366 measurementStation.getRange() == null) {
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	367 continue;
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	368 }
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	369 if (measurementStation.getMeasurementType().equals("Schwebstoff")) {
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	370 suspStations.put(measurementStation.getRange().getA().doubleValue(), measurementStation);
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	371 }
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	372 else if (measurementStation.getMeasurementType().equals("Geschiebe")) {
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	373 floatStations.put(measurementStation.getRange().getA().doubleValue(), measurementStation);
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	374 }
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	375 }
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	376
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	377 Calendar start = Calendar.getInstance();
4546 af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	378 start.set(syear - 1, 11, 31);
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	379 Calendar end = Calendar.getInstance();
4546 af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	380 end.set(syear, 11, 30);
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	381
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	382 if (type.equals("year") \|\| type.equals("epoch")) {
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	383 sqlQuery = session.createSQLQuery(SQL_SELECT_SINGLES_DATA)
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	384 .addScalar("description", StandardBasicTypes.STRING)
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	385 .addScalar("year", StandardBasicTypes.DATE)
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	386 .addScalar("load", StandardBasicTypes.DOUBLE)
6392 9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	387 .addScalar("km", StandardBasicTypes.DOUBLE)
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	388 .addScalar("unit", StandardBasicTypes.STRING);
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	389 sqlQuery.setString("name", river);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	390 sqlQuery.setDouble("startKm", startKm);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	391 sqlQuery.setDouble("endKm", endKm);
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	392 sqlQuery.setDate("begin", start.getTime());
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	393 sqlQuery.setDate("end", end.getTime());
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	394 sqlQuery.setString("grain", "total");
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	395 List<Object []> results = sqlQuery.list();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	396 SedimentLoad load = new SedimentLoad();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	397 Object[] row = results.get(0);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	398 load = new SedimentLoad(
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	399 (String) row[0],
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	400 (Date) row[1],
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	401 null,
6392 9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	402 false,
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	403 (String) row[4]);
6374 48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	404 getValues("coarse", sqlQuery, load, floatStations);
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	405 getValues("fine_middle", sqlQuery, load, floatStations);
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	406 getValues("sand", sqlQuery, load, floatStations);
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	407 getValues("suspended_sediment", sqlQuery, load, suspStations);
6412 c74261e05a62 issue1235: revert some changes, use correct Schwebstoff/Geschiebe-measurement-stations. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6406 diff changeset	408 getValues("susp_sand_bed", sqlQuery, load, floatStations);
c74261e05a62 issue1235: revert some changes, use correct Schwebstoff/Geschiebe-measurement-stations. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6406 diff changeset	409 getValues("susp_sand", sqlQuery, load, floatStations);
4736 b195fede1c3b Remove trailing whitespace. Sascha L. Teichmann <teichmann@intevation.de> parents: 4551 diff changeset	410
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	411 return load;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	412 }
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	413 else if (type.equals("off_epoch")) {
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	414 Calendar toStart = Calendar.getInstance();
4546 af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	415 toStart.set(eyear - 1, 11, 31);
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	416 Calendar toEnd = Calendar.getInstance();
6545 a4f60641e445 issue1386: Fix date parameter for official epochs query. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6544 diff changeset	417 toEnd.set(eyear+1, 11, 31);
4517 a5e4fae31089 Fixed SQL statements and parameters. Raimund Renkert <rrenkert@intevation.de> parents: 4434 diff changeset	418 sqlQuery = session.createSQLQuery(SQL_SELECT_EPOCHS_DATA)
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	419 .addScalar("description", StandardBasicTypes.STRING)
4517 a5e4fae31089 Fixed SQL statements and parameters. Raimund Renkert <rrenkert@intevation.de> parents: 4434 diff changeset	420 .addScalar("startYear", StandardBasicTypes.DATE)
a5e4fae31089 Fixed SQL statements and parameters. Raimund Renkert <rrenkert@intevation.de> parents: 4434 diff changeset	421 .addScalar("load", StandardBasicTypes.DOUBLE)
4546 af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	422 .addScalar("km", StandardBasicTypes.DOUBLE)
6392 9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	423 .addScalar("endYear", StandardBasicTypes.DATE)
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	424 .addScalar("unit", StandardBasicTypes.STRING);
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	425 sqlQuery.setString("name", river);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	426 sqlQuery.setDouble("startKm", startKm);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	427 sqlQuery.setDouble("endKm", endKm);
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	428 sqlQuery.setDate("sbegin", start.getTime());
4517 a5e4fae31089 Fixed SQL statements and parameters. Raimund Renkert <rrenkert@intevation.de> parents: 4434 diff changeset	429 sqlQuery.setDate("send", end.getTime());
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	430 sqlQuery.setDate("ebegin",toStart.getTime());
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	431 sqlQuery.setDate("eend", toEnd.getTime());
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	432 sqlQuery.setString("grain", "total");
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	433
4546 af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	434 List<Object[]> results = null;
af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	435 results = sqlQuery.list();
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	436
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	437 SedimentLoad load = new SedimentLoad();
6737 1960d55bafb1 issue1393: Avoid NPE for off-epoch when actually no off-epoch data available. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6725 diff changeset	438 if (results.isEmpty()) {
1960d55bafb1 issue1393: Avoid NPE for off-epoch when actually no off-epoch data available. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6725 diff changeset	439 log.warn("No results for off-epoch");
1960d55bafb1 issue1393: Avoid NPE for off-epoch when actually no off-epoch data available. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6725 diff changeset	440 return new SedimentLoad();
1960d55bafb1 issue1393: Avoid NPE for off-epoch when actually no off-epoch data available. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6725 diff changeset	441 }
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	442 Object[] row = results.get(0);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	443 load = new SedimentLoad(
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	444 (String) row[0],
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	445 (Date) row[1],
4546 af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	446 (Date) row[4],
6392 9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	447 true,
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	448 (String)row[5]);
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	449 TDoubleArrayList kms = new TDoubleArrayList();
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	450 for (int i = 0; i < results.size(); i++) {
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	451 row = results.get(i);
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	452 kms.add((Double)row[3]);
4546 af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	453 load.setLoadTotal((Double)row[3], (Double)row[2]);
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	454 }
6374 48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	455 getValues("coarse", sqlQuery, load, floatStations);
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	456 getValues("fine_middle", sqlQuery, load, floatStations);
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	457 getValues("sand", sqlQuery, load, floatStations);
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	458 getValues("suspended_sediment", sqlQuery, load, suspStations);
6412 c74261e05a62 issue1235: revert some changes, use correct Schwebstoff/Geschiebe-measurement-stations. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6406 diff changeset	459 getValues("susp_sand_bed", sqlQuery, load, floatStations);
c74261e05a62 issue1235: revert some changes, use correct Schwebstoff/Geschiebe-measurement-stations. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6406 diff changeset	460 getValues("susp_sand", sqlQuery, load, floatStations);
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	461 return load;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	462 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	463 return new SedimentLoad();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	464 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	465
5662 7e3cde8b564c Cosmetics, docs, vimlines. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 5661 diff changeset	466
5789 62ac8fa61780 Doc. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 5662 diff changeset	467 /**
62ac8fa61780 Doc. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 5662 diff changeset	468 * Run query with grain parameter set to fraction, feed result into
62ac8fa61780 Doc. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 5662 diff changeset	469 * load.
62ac8fa61780 Doc. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 5662 diff changeset	470 * @param fraction value to set 'grain' parameter in query to.
62ac8fa61780 Doc. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 5662 diff changeset	471 * @param query query in which to set 'grain' parameter and run.
6740 68c7b5811c4f Cosmetics, docs, in range of issue1393. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6737 diff changeset	472 * @param load[out] SedimentLoad which to populate with values. if null
68c7b5811c4f Cosmetics, docs, in range of issue1393. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6737 diff changeset	473 * and values are found, return a new load.
5789 62ac8fa61780 Doc. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 5662 diff changeset	474 */
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	475 protected static void getValues (
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	476 String fraction,
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	477 SQLQuery query,
6374 48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	478 SedimentLoad load,
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	479 TreeMap<Double, MeasurementStation> stations
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	480 ) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	481 query.setString("grain", fraction);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	482 List<Object[]> results = query.list();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	483 for (int i = 0; i < results.size(); i++) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	484 Object[] row = results.get(i);
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	485 double km = (Double)row[3];
6374 48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	486 MeasurementStation station = stations.get(km);
6377 fa8425c8694c Fix typos and NPEs. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6374 diff changeset	487 MeasurementStation nextStation = null;
fa8425c8694c Fix typos and NPEs. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6374 diff changeset	488 if (stations.ceilingEntry(km + 0.1d) != null) {
fa8425c8694c Fix typos and NPEs. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6374 diff changeset	489 nextStation = stations.ceilingEntry(km + 0.1d).getValue();
fa8425c8694c Fix typos and NPEs. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6374 diff changeset	490 }
6374 48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	491 Range range = null;
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	492 if (station == null) {
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	493 log.warn("No measurement station for " + fraction + " km " + km);
6544 b24dc0320b75 issue1386: Prevent null-ranges to be set when station of sediment measurement Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6477 diff changeset	494 continue;
6374 48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	495 }
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	496 else {
6377 fa8425c8694c Fix typos and NPEs. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6374 diff changeset	497 if (nextStation != null)
6374 48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	498 range = new Range(station.getRange().getA().doubleValue(),
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	499 nextStation.getRange().getA().doubleValue());
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	500 else {
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	501 // TODO end-of-river instead of B.
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	502 range = new Range(station.getRange().getA().doubleValue(),
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	503 station.getRange().getB().doubleValue());
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	504 }
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	505 }
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	506 double v = -1;
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	507 if (row[2] != null) {
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	508 v = ((Double)row[2]).doubleValue();
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	509 }
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	510 if (fraction.equals("coarse")) {
6374 48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	511 load.setCoarse(km, v, range);
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	512 }
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	513 else if (fraction.equals("sand")) {
6374 48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	514 load.setSand(km, v, range);
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	515 }
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	516 else if (fraction.equals("fine_middle")) {
6374 48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	517 load.setFineMiddle(km, v, range);
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	518 }
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	519 else if (fraction.equals("suspended_sediment")) {
6374 48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	520 load.setSuspSediment(km, v, range);
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	521 }
4517 a5e4fae31089 Fixed SQL statements and parameters. Raimund Renkert <rrenkert@intevation.de> parents: 4434 diff changeset	522 else if (fraction.equals("susp_sand")) {
6374 48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	523 load.setSuspSand(km, v, range);
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	524 }
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	525 else if (fraction.equals("susp_sand_bed")) {
6374 48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	526 load.setSuspSandBed(km, v, range);
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	527 }
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	528 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	529 }
6392 9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	530
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	531 public static SedimentLoad getLoadUnknown(
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	532 String river,
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	533 String description
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	534 ) {
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	535 log.debug("SedimentLoadFactory.getLoadWithData");
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	536 Cache cache = CacheFactory.getCache(LOAD_DATA_CACHE_NAME);
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	537
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	538 if (cache == null) {
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	539 log.debug("Cache not configured.");
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	540 return getSedimentLoadUnknownUncached(river, description);
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	541 }
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	542
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	543 StaticSedimentLoadCacheKey key =
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	544 new StaticSedimentLoadCacheKey(river, 0d, 0d, 0, 0);
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	545
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	546 Element element = cache.get(key);
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	547
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	548 if (element != null) {
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	549 log.debug("SedimentLoad found in cache");
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	550 return (SedimentLoad)element.getValue();
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	551 }
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	552
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	553 SedimentLoad values = getSedimentLoadUnknownUncached(river, description);
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	554
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	555 if (values != null && key != null) {
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	556 log.debug("Store static bed height values in cache.");
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	557 element = new Element(key, values);
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	558 cache.put(element);
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	559 }
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	560 return values;
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	561 }
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	562
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	563 /**
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	564 * Get sediment loads with fraction 'unknown' from db.
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	565 * @param river the river
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	566 * @param type the sediment load type (year or epoch)
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	567 * @return according sediment loads.
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	568 */
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	569 public static SedimentLoad getSedimentLoadUnknownUncached(
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	570 String river,
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	571 String description
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	572 ) {
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	573 log.debug("SedimentLoadFactory.getSedimentLoadWithDataUncached");
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	574 Session session = SessionHolder.HOLDER.get();
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	575 SQLQuery sqlQuery = null;
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	576
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	577 sqlQuery = session.createSQLQuery(SQL_SELECT_UNKNOWN_DATA)
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	578 .addScalar("description", StandardBasicTypes.STRING)
6477 d1502b8dd091 'start' is a reserved word in Oracle Tom Gottfried <tom@intevation.de> parents: 6412 diff changeset	579 .addScalar("startYear", StandardBasicTypes.DATE)
6392 9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	580 .addScalar("end", StandardBasicTypes.DATE)
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	581 .addScalar("load", StandardBasicTypes.DOUBLE)
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	582 .addScalar("km", StandardBasicTypes.DOUBLE)
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	583 .addScalar("unit", StandardBasicTypes.STRING);
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	584 sqlQuery.setString("name", river);
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	585 sqlQuery.setString("descr", description);
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	586 List<Object []> results = sqlQuery.list();
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	587 SedimentLoad load = new SedimentLoad();
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	588 if (results.isEmpty()) {
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	589 return new SedimentLoad();
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	590 }
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	591 Object[] row = results.get(0);
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	592 load = new SedimentLoad(
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	593 (String) row[0],
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	594 (Date) row[1],
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	595 (Date) row[2],
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	596 false,
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	597 (String)row[5]);
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	598
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	599 for (int i = 0; i < results.size(); i++) {
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	600 row = results.get(i);
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	601 SedimentLoadFraction fraction = new SedimentLoadFraction();
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	602 fraction.setUnknown((Double)row[3]);
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	603 load.addKm((Double)row[4], fraction);
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	604 }
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	605 return load;
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	606 }
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	607
6665 b7945db8a43b issue1413: Only show unknown sediment loads of selected unit type. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6545 diff changeset	608 /**
b7945db8a43b issue1413: Only show unknown sediment loads of selected unit type. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6545 diff changeset	609 * Return sediment loads with 'unknown' fraction type.
b7945db8a43b issue1413: Only show unknown sediment loads of selected unit type. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6545 diff changeset	610 * @param unit Restrict result set to those of given unit.
b7945db8a43b issue1413: Only show unknown sediment loads of selected unit type. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6545 diff changeset	611 */
b7945db8a43b issue1413: Only show unknown sediment loads of selected unit type. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6545 diff changeset	612 public static SedimentLoad[] getSedimentLoadUnknown(String river, String unit) {
6392 9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	613 Session session = SessionHolder.HOLDER.get();
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	614 SQLQuery sqlQuery = session.createSQLQuery(SQL_SELECT_UNKNOWN)
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	615 .addScalar("description", StandardBasicTypes.STRING)
6477 d1502b8dd091 'start' is a reserved word in Oracle Tom Gottfried <tom@intevation.de> parents: 6412 diff changeset	616 .addScalar("startYear", StandardBasicTypes.DATE)
6392 9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	617 .addScalar("end", StandardBasicTypes.DATE);
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	618 sqlQuery.setString("river", river);
6665 b7945db8a43b issue1413: Only show unknown sediment loads of selected unit type. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6545 diff changeset	619 sqlQuery.setString("unit", unit);
6392 9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	620 List<Object[]> results = sqlQuery.list();
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	621 SedimentLoad[] loads = new SedimentLoad[results.size()];
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	622 int counter = 0;
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	623 for (Object[] row: results) {
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	624 loads[counter] = new SedimentLoad(
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	625 (String)row[0], (Date)row[1], (Date)row[2], false, "");
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	626 counter++;
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	627 }
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	628 return loads;
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	629 }
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	630 }
5662 7e3cde8b564c Cosmetics, docs, vimlines. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 5661 diff changeset	631 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf-8 :

Mercurial > dive4elements > river

annotate artifacts/src/main/java/org/dive4elements/river/artifacts/model/minfo/SedimentLoadFactory.java @ 6740:68c7b5811c4f