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 @ 6665:b7945db8a43b

issue1413: Only show unknown sediment loads of selected unit type. Therefore, adjusted the factory to take the units name. Unfortunately, names in db do not match values of data items. Thus do manual replacing. In Facet and Calculate, take the chosen unit via access and to the string replacement. In Facet, do not transform data (we assume it comes in unit as labeled in the db), and removed the possibility of m3/a-data of unknown yields in a t/a diagram and vice versa.

author	Felix Wolfsteller <felix.wolfsteller@intevation.de>
date	Thu, 25 Jul 2013 15:08:13 +0200
parents	a4f60641e445
children	7ea933f9c6ea

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
5662 7e3cde8b564c Cosmetics, docs, vimlines. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 5661 diff changeset	32 /** 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	33 public class SedimentLoadFactory
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	34 {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	35 /** Private logger to use here. */
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	36 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	37
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	38 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	39 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	40
4434 60c728e557f4 Backed out changeset e8a4d2fd25cc Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 4428 diff changeset	41 /** Query to get km and ws for wst_id and column_pos. */
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	42 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	43 "SELECT DISTINCT " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	44 " sy.description AS description, " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	45 " ti.start_time AS year " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	46 " FROM sediment_yield sy " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	47 " 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	48 " 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	49 " 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	50 " WHERE r.name = :name " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	51 " AND ti.stop_time IS NULL " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	52 " 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	53
4434 60c728e557f4 Backed out changeset e8a4d2fd25cc Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 4428 diff changeset	54 /** Query to get name for wst_id and column_pos. */
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	55 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	56 "SELECT DISTINCT " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	57 " sy.description AS description, " +
6477 d1502b8dd091 'start' is a reserved word in Oracle Tom Gottfried <tom@intevation.de> parents: 6412 diff changeset	58 " 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	59 " 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	60 " u.name AS unit" +
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	61 " FROM sediment_yield sy " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	62 " 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	63 " 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	64 " 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	65 " 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	66 " WHERE r.name = :name " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	67 " 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	68 " 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	69
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	70 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	71 "SELECT" +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	72 " sy.description AS description, " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	73 " ti.start_time AS year, " +
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	74 " 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	75 " 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	76 " u.name AS unit " +
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	77 " FROM sediment_yield sy " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	78 " 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	79 " 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	80 " 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	81 " 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	82 " 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	83 " WHERE r.name = :name " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	84 " 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	85 " 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	86 " 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	87 " 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	88 " 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	89
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	90 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	91 "SELECT" +
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	92 " sy.description AS description, " +
6477 d1502b8dd091 'start' is a reserved word in Oracle Tom Gottfried <tom@intevation.de> parents: 6412 diff changeset	93 " 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	94 " 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	95 " 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	96 " 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	97 " 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	98 " 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	99 " 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	100 " 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	101 " 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	102 " 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	103 " 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	104 " 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	105 " 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	106 " 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	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 =
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	110 "SELECT DISTINCT " +
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 "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	115 " 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	116 " 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	117 " 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	118 " 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	119 "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	120 " 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	121 " AND u.name = :unit";
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	122
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	123 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	124 "SELECT" +
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	125 " sy.description AS description, " +
4517 a5e4fae31089 Fixed SQL statements and parameters. Raimund Renkert <rrenkert@intevation.de> parents: 4434 diff changeset	126 " ti.start_time AS startYear, " +
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	127 " syv.value AS load, " +
4546 af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	128 " 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	129 " 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	130 " u.name AS unit" +
4546 af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	131 " FROM sediment_yield sy " +
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	132 " 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	133 " 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	134 " 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	135 " 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	136 " 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	137 " WHERE r.name = :name " +
af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	138 " 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	139 " 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	140 " 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	141 " 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	142 " ORDER BY syv.station";
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	143
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	144 private SedimentLoadFactory() {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	145 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	146
4434 60c728e557f4 Backed out changeset e8a4d2fd25cc Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 4428 diff changeset	147 /**
60c728e557f4 Backed out changeset e8a4d2fd25cc Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 4428 diff changeset	148 *
60c728e557f4 Backed out changeset e8a4d2fd25cc Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 4428 diff changeset	149 */
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	150 public static SedimentLoad[] getLoads(
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	151 String river,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	152 String type,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	153 double startKm,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	154 double endKm
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	155 ) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	156 log.debug("SedimentLoadFactory.getLoads");
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	157 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	158
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	159 if (cache == null) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	160 log.debug("Cache not configured.");
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	161 return getSedimentLoadsUncached(river, type, startKm, endKm);
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
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	164 StaticSedimentLoadCacheKey key =
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	165 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	166
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	167 Element element = cache.get(key);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	168
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	169 if (element != null) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	170 log.debug("SedimentLoad found in cache");
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	171 return (SedimentLoad[])element.getValue();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	172 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	173
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	174 SedimentLoad[] values =
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	175 getSedimentLoadsUncached(river, type, startKm, endKm);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	176
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	177 if (values != null && key != null) {
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	178 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	179 element = new Element(key, values);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	180 cache.put(element);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	181 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	182 return values;
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
5661 b6297a67823e SedimentLoadFactory: Renamed getLoadwithData to getLoadWithData, update callers. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 4736 diff changeset	185 public static SedimentLoad getLoadWithData(
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	186 String river,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	187 String type,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	188 double startKm,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	189 double endKm,
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	190 int syear,
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	191 int eyear
4296 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 log.debug("SedimentLoadFactory.getLoadWithData");
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	194 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	195
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	196 if (cache == null) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	197 log.debug("Cache not configured.");
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	198 return getSedimentLoadWithDataUncached(
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	199 river,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	200 type,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	201 startKm,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	202 endKm,
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	203 syear,
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	204 eyear);
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	205 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	206
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	207 StaticSedimentLoadCacheKey key =
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	208 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	209
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	210 Element element = cache.get(key);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	211
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	212 if (element != null) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	213 log.debug("SedimentLoad found in cache");
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	214 return (SedimentLoad)element.getValue();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	215 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	216
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	217 SedimentLoad values = getSedimentLoadWithDataUncached(
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	218 river,
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	219 type,
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	220 startKm,
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	221 endKm,
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	222 syear,
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	223 eyear);
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	224
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	225 if (values != null && key != null) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	226 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	227 element = new Element(key, values);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	228 cache.put(element);
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 return values;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	231 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	232
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 * Get sediment loads from db.
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	235 * @param river the river
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	236 * @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	237 * @return according sediment loads.
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	238 */
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	239 public static SedimentLoad[] getSedimentLoadsUncached(
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	240 String river,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	241 String type,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	242 double startKm,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	243 double endKm
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	244 ) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	245 log.debug("SedimentLoadFactory.getSedimentLoadsUncached");
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	246
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	247 Session session = SessionHolder.HOLDER.get();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	248 SQLQuery sqlQuery = null;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	249
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	250 if (type.equals("single")) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	251 sqlQuery = session.createSQLQuery(SQL_SELECT_SINGLES)
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	252 .addScalar("description", StandardBasicTypes.STRING)
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	253 .addScalar("year", StandardBasicTypes.DATE);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	254 sqlQuery.setString("name", river);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	255 sqlQuery.setDouble("startKm", startKm);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	256 sqlQuery.setDouble("endKm", endKm);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	257 List<Object []> results = sqlQuery.list();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	258 SedimentLoad[] loads = new SedimentLoad[results.size()];
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	259 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	260 Object[] row = results.get(i);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	261 loads[i] = new SedimentLoad(
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	262 (String) row[0],
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	263 (Date) row[1],
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	264 null,
6392 9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	265 false,
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	266 "");
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	267 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	268 return loads;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	269 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	270 else if (type.equals("epoch")) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	271 sqlQuery = session.createSQLQuery(SQL_SELECT_EPOCHS)
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	272 .addScalar("description", StandardBasicTypes.STRING)
6477 d1502b8dd091 'start' is a reserved word in Oracle Tom Gottfried <tom@intevation.de> parents: 6412 diff changeset	273 .addScalar("startYear", StandardBasicTypes.DATE)
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	274 .addScalar("end", StandardBasicTypes.DATE);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	275 sqlQuery.setString("name", river);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	276 sqlQuery.setDouble("startKm", startKm);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	277 sqlQuery.setDouble("endKm", endKm);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	278 List<Object []> results = sqlQuery.list();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	279
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	280 SedimentLoad[] loads = new SedimentLoad[results.size()];
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	281 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	282 Object[] row = results.get(i);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	283 loads[i] = new SedimentLoad(
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	284 (String) row[0],
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	285 (Date) row[1],
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	286 (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	287 true,
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	288 "");
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	289 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	290 return loads;
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 new SedimentLoad[0];
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
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	295 /**
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	296 * Get sediment loads from db.
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	297 * @param river the river
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	298 * @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	299 * @return according sediment loads.
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	300 */
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	301 public static SedimentLoad getSedimentLoadWithDataUncached(
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	302 String river,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	303 String type,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	304 double startKm,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	305 double endKm,
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	306 int syear,
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	307 int eyear
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	308 ) {
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	309 log.debug("SedimentLoadFactory.getSedimentLoadWithDataUncached");
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	310 Session session = SessionHolder.HOLDER.get();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	311 SQLQuery sqlQuery = null;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	312
6374 48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	313 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	314 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	315 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	316 for (MeasurementStation measurementStation: allStations) {
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	317 if (measurementStation.getMeasurementType() == null \|\|
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	318 measurementStation.getRange() == null) {
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	319 continue;
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	320 }
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	321 if (measurementStation.getMeasurementType().equals("Schwebstoff")) {
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	322 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	323 }
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	324 else if (measurementStation.getMeasurementType().equals("Geschiebe")) {
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	325 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	326 }
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	327 }
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	328
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	329 Calendar start = Calendar.getInstance();
4546 af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	330 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	331 Calendar end = Calendar.getInstance();
4546 af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	332 end.set(syear, 11, 30);
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	333
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	334 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	335 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	336 .addScalar("description", StandardBasicTypes.STRING)
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	337 .addScalar("year", StandardBasicTypes.DATE)
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	338 .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	339 .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	340 .addScalar("unit", StandardBasicTypes.STRING);
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	341 sqlQuery.setString("name", river);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	342 sqlQuery.setDouble("startKm", startKm);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	343 sqlQuery.setDouble("endKm", endKm);
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	344 sqlQuery.setDate("begin", start.getTime());
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	345 sqlQuery.setDate("end", end.getTime());
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	346 sqlQuery.setString("grain", "total");
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	347 List<Object []> results = sqlQuery.list();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	348 SedimentLoad load = new SedimentLoad();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	349 Object[] row = results.get(0);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	350 load = new SedimentLoad(
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	351 (String) row[0],
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	352 (Date) row[1],
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	353 null,
6392 9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	354 false,
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	355 (String) row[4]);
6374 48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	356 getValues("coarse", sqlQuery, load, floatStations);
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	357 getValues("fine_middle", sqlQuery, load, floatStations);
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	358 getValues("sand", sqlQuery, load, floatStations);
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	359 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	360 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	361 getValues("susp_sand", sqlQuery, load, floatStations);
4736 b195fede1c3b Remove trailing whitespace. Sascha L. Teichmann <teichmann@intevation.de> parents: 4551 diff changeset	362
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	363 return load;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	364 }
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	365 else if (type.equals("off_epoch")) {
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	366 Calendar toStart = Calendar.getInstance();
4546 af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	367 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	368 Calendar toEnd = Calendar.getInstance();
6545 a4f60641e445 issue1386: Fix date parameter for official epochs query. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6544 diff changeset	369 toEnd.set(eyear+1, 11, 31);
4517 a5e4fae31089 Fixed SQL statements and parameters. Raimund Renkert <rrenkert@intevation.de> parents: 4434 diff changeset	370 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	371 .addScalar("description", StandardBasicTypes.STRING)
4517 a5e4fae31089 Fixed SQL statements and parameters. Raimund Renkert <rrenkert@intevation.de> parents: 4434 diff changeset	372 .addScalar("startYear", StandardBasicTypes.DATE)
a5e4fae31089 Fixed SQL statements and parameters. Raimund Renkert <rrenkert@intevation.de> parents: 4434 diff changeset	373 .addScalar("load", StandardBasicTypes.DOUBLE)
4546 af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	374 .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	375 .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	376 .addScalar("unit", StandardBasicTypes.STRING);
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	377 sqlQuery.setString("name", river);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	378 sqlQuery.setDouble("startKm", startKm);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	379 sqlQuery.setDouble("endKm", endKm);
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	380 sqlQuery.setDate("sbegin", start.getTime());
4517 a5e4fae31089 Fixed SQL statements and parameters. Raimund Renkert <rrenkert@intevation.de> parents: 4434 diff changeset	381 sqlQuery.setDate("send", end.getTime());
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	382 sqlQuery.setDate("ebegin",toStart.getTime());
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	383 sqlQuery.setDate("eend", toEnd.getTime());
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	384 sqlQuery.setString("grain", "total");
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	385
4546 af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	386 List<Object[]> results = null;
af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	387 results = sqlQuery.list();
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	388
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	389 SedimentLoad load = new SedimentLoad();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	390 Object[] row = results.get(0);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	391 load = new SedimentLoad(
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	392 (String) row[0],
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	393 (Date) row[1],
4546 af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	394 (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	395 true,
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	396 (String)row[5]);
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	397 TDoubleArrayList kms = new TDoubleArrayList();
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	398 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	399 row = results.get(i);
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	400 kms.add((Double)row[3]);
4546 af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	401 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	402 }
6374 48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	403 getValues("coarse", sqlQuery, load, floatStations);
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	404 getValues("fine_middle", sqlQuery, load, floatStations);
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	405 getValues("sand", sqlQuery, load, floatStations);
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	406 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	407 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	408 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	409 return load;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	410 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	411 return new SedimentLoad();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	412 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	413
5662 7e3cde8b564c Cosmetics, docs, vimlines. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 5661 diff changeset	414
5789 62ac8fa61780 Doc. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 5662 diff changeset	415 /**
62ac8fa61780 Doc. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 5662 diff changeset	416 * Run query with grain parameter set to fraction, feed result into
62ac8fa61780 Doc. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 5662 diff changeset	417 * load.
62ac8fa61780 Doc. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 5662 diff changeset	418 * @param fraction value to set 'grain' parameter in query to.
62ac8fa61780 Doc. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 5662 diff changeset	419 * @param query query in which to set 'grain' parameter and run.
62ac8fa61780 Doc. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 5662 diff changeset	420 * @param load[out] SedimentLoad which to populate with values.
62ac8fa61780 Doc. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 5662 diff changeset	421 */
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	422 protected static void getValues (
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	423 String fraction,
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	424 SQLQuery query,
6374 48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	425 SedimentLoad load,
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	426 TreeMap<Double, MeasurementStation> stations
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	427 ) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	428 query.setString("grain", fraction);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	429 List<Object[]> results = query.list();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	430 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	431 Object[] row = results.get(i);
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	432 double km = (Double)row[3];
6374 48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	433 MeasurementStation station = stations.get(km);
6377 fa8425c8694c Fix typos and NPEs. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6374 diff changeset	434 MeasurementStation nextStation = null;
fa8425c8694c Fix typos and NPEs. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6374 diff changeset	435 if (stations.ceilingEntry(km + 0.1d) != null) {
fa8425c8694c Fix typos and NPEs. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6374 diff changeset	436 nextStation = stations.ceilingEntry(km + 0.1d).getValue();
fa8425c8694c Fix typos and NPEs. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6374 diff changeset	437 }
6374 48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	438 Range range = null;
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	439 if (station == null) {
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	440 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	441 continue;
6374 48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	442 }
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	443 else {
6377 fa8425c8694c Fix typos and NPEs. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6374 diff changeset	444 if (nextStation != null)
6374 48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	445 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	446 nextStation.getRange().getA().doubleValue());
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	447 else {
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	448 // 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	449 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	450 station.getRange().getB().doubleValue());
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	451 }
48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	452 }
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	453 double v = -1;
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	454 if (row[2] != null) {
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	455 v = ((Double)row[2]).doubleValue();
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	456 }
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	457 if (fraction.equals("coarse")) {
6374 48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	458 load.setCoarse(km, v, range);
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	459 }
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	460 else if (fraction.equals("sand")) {
6374 48e92ff57f23 SedimentLoad: Set range to fraction/fractions values. Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 5994 diff changeset	461 load.setSand(km, v, range);
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	462 }
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	463 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	464 load.setFineMiddle(km, v, range);
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	465 }
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	466 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	467 load.setSuspSediment(km, v, range);
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	468 }
4517 a5e4fae31089 Fixed SQL statements and parameters. Raimund Renkert <rrenkert@intevation.de> parents: 4434 diff changeset	469 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	470 load.setSuspSand(km, v, range);
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	471 }
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	472 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	473 load.setSuspSandBed(km, v, range);
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	474 }
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	475 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	476 }
6392 9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	477
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	478 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	479 String river,
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	480 String description
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	481 ) {
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	482 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	483 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	484
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	485 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	486 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	487 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	488 }
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	489
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	490 StaticSedimentLoadCacheKey key =
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	491 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	492
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	493 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	494
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	495 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	496 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	497 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	498 }
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	499
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	500 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	501
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	502 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	503 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	504 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	505 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	506 }
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	507 return values;
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	508 }
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	509
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	510 /**
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	511 * 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	512 * @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	513 * @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	514 * @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	515 */
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	516 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	517 String river,
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	518 String description
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	519 ) {
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	520 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	521 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	522 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	523
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	524 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	525 .addScalar("description", StandardBasicTypes.STRING)
6477 d1502b8dd091 'start' is a reserved word in Oracle Tom Gottfried <tom@intevation.de> parents: 6412 diff changeset	526 .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	527 .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	528 .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	529 .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	530 .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	531 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	532 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	533 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	534 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	535 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	536 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	537 }
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	538 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	539 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	540 (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	541 (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	542 (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	543 false,
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	544 (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	545
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	546 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	547 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	548 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	549 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	550 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	551 }
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	552 return load;
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	553 }
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	554
6665 b7945db8a43b issue1413: Only show unknown sediment loads of selected unit type. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6545 diff changeset	555 /**
b7945db8a43b issue1413: Only show unknown sediment loads of selected unit type. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6545 diff changeset	556 * 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	557 * @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	558 */
b7945db8a43b issue1413: Only show unknown sediment loads of selected unit type. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6545 diff changeset	559 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	560 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	561 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	562 .addScalar("description", StandardBasicTypes.STRING)
6477 d1502b8dd091 'start' is a reserved word in Oracle Tom Gottfried <tom@intevation.de> parents: 6412 diff changeset	563 .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	564 .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	565 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	566 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	567 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	568 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	569 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	570 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	571 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	572 (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	573 counter++;
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	574 }
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	575 return loads;
9a0f8d532797 Load sedimentload fraction with sedimentload factory and add new facets to artifact. Raimund Renkert <rrenkert@intevation.de> parents: 6377 diff changeset	576 }
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	577 }
5662 7e3cde8b564c Cosmetics, docs, vimlines. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 5661 diff changeset	578 // 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 @ 6665:b7945db8a43b