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 @ 5863:4897a58c8746

River artifacts: Added new copyright headers.

author	Sascha L. Teichmann <teichmann@intevation.de>
date	Sun, 28 Apr 2013 14:40:59 +0200
parents	5aa05a7a34b7
children	af13ceeba52a

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 *
4897a58c8746 River artifacts: Added new copyright headers. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	4 * This file is Free Software under the GNU AGPL (>=v3)
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
4897a58c8746 River artifacts: Added new copyright headers. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	6 * documentation coming with Dive4Elements River for details.
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;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	16
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	17 import net.sf.ehcache.Cache;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	18 import net.sf.ehcache.Element;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	19
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	20 import org.apache.log4j.Logger;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	21 import org.hibernate.SQLQuery;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	22 import org.hibernate.Session;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	23 import org.hibernate.type.StandardBasicTypes;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	24
5831 bd047b71ab37 Repaired internal references Sascha L. Teichmann <teichmann@intevation.de> parents: 5789 diff changeset	25 import org.dive4elements.river.artifacts.cache.CacheFactory;
bd047b71ab37 Repaired internal references Sascha L. Teichmann <teichmann@intevation.de> parents: 5789 diff changeset	26 import org.dive4elements.river.artifacts.model.StaticSedimentLoadCacheKey;
bd047b71ab37 Repaired internal references Sascha L. Teichmann <teichmann@intevation.de> parents: 5789 diff changeset	27 import org.dive4elements.river.backend.SessionHolder;
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	28
5662 7e3cde8b564c Cosmetics, docs, vimlines. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 5661 diff changeset	29 /** 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	30 public class SedimentLoadFactory
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	31 {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	32 /** Private logger to use here. */
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	33 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	34
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	35 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	36 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	37
4434 60c728e557f4 Backed out changeset e8a4d2fd25cc Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 4428 diff changeset	38 /** 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	39 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	40 "SELECT DISTINCT " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	41 " sy.description AS description, " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	42 " ti.start_time AS year " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	43 " FROM sediment_yield sy " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	44 " 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	45 " 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	46 " 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	47 " WHERE r.name = :name " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	48 " AND ti.stop_time IS NULL " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	49 " 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	50
4434 60c728e557f4 Backed out changeset e8a4d2fd25cc Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 4428 diff changeset	51 /** 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	52 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	53 "SELECT DISTINCT " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	54 " sy.description AS description, " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	55 " ti.start_time AS start, " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	56 " ti.stop_time AS end " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	57 " FROM sediment_yield sy " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	58 " 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	59 " 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	60 " 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	61 " WHERE r.name = :name " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	62 " 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	63 " 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	64
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	65 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	66 "SELECT" +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	67 " sy.description AS description, " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	68 " ti.start_time AS year, " +
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	69 " syv.value AS load, " +
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	70 " syv.station AS km " +
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	71 " FROM sediment_yield sy " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	72 " 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	73 " 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	74 " 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	75 " JOIN grain_fraction gf ON sy.grain_fraction_id = gf.id " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	76 " WHERE r.name = :name " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	77 " 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	78 " 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	79 " AND gf.name = :grain " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	80 " 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	81
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	82 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	83 "SELECT" +
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	84 " sy.description AS description, " +
4517 a5e4fae31089 Fixed SQL statements and parameters. Raimund Renkert <rrenkert@intevation.de> parents: 4434 diff changeset	85 " ti.start_time AS startYear, " +
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	86 " syv.value AS load, " +
4546 af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	87 " syv.station AS km," +
af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	88 " ti.stop_time AS endYear " +
af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	89 " FROM sediment_yield sy " +
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	90 " 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	91 " 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	92 " 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	93 " JOIN grain_fraction gf ON sy.grain_fraction_id = gf.id " +
af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	94 " WHERE r.name = :name " +
af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	95 " 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	96 " 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	97 " AND gf.name = :grain " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	98 " 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	99
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	100 private SedimentLoadFactory() {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	101 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	102
4434 60c728e557f4 Backed out changeset e8a4d2fd25cc Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 4428 diff changeset	103 /**
60c728e557f4 Backed out changeset e8a4d2fd25cc Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 4428 diff changeset	104 *
60c728e557f4 Backed out changeset e8a4d2fd25cc Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 4428 diff changeset	105 */
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	106 public static SedimentLoad[] getLoads(
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	107 String river,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	108 String type,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	109 double startKm,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	110 double endKm
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	111 ) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	112 log.debug("SedimentLoadFactory.getLoads");
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	113 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	114
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	115 if (cache == null) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	116 log.debug("Cache not configured.");
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	117 return getSedimentLoadsUncached(river, type, startKm, endKm);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	118 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	119
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	120 StaticSedimentLoadCacheKey key =
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	121 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	122
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	123 Element element = cache.get(key);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	124
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	125 if (element != null) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	126 log.debug("SedimentLoad found in cache");
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	127 return (SedimentLoad[])element.getValue();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	128 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	129
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	130 SedimentLoad[] values =
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	131 getSedimentLoadsUncached(river, type, startKm, endKm);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	132
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	133 if (values != null && key != null) {
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	134 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	135 element = new Element(key, values);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	136 cache.put(element);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	137 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	138 return values;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	139 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	140
5661 b6297a67823e SedimentLoadFactory: Renamed getLoadwithData to getLoadWithData, update callers. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 4736 diff changeset	141 public static SedimentLoad getLoadWithData(
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	142 String river,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	143 String type,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	144 double startKm,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	145 double endKm,
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	146 int syear,
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	147 int eyear
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	148 ) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	149 log.debug("SedimentLoadFactory.getLoadWithData");
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	150 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	151
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	152 if (cache == null) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	153 log.debug("Cache not configured.");
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	154 return getSedimentLoadWithDataUncached(
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	155 river,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	156 type,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	157 startKm,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	158 endKm,
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	159 syear,
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	160 eyear);
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	161 }
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 StaticSedimentLoadCacheKey key =
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	164 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	165
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	166 Element element = cache.get(key);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	167
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	168 if (element != null) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	169 log.debug("SedimentLoad found in cache");
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	170 return (SedimentLoad)element.getValue();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	171 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	172
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	173 SedimentLoad values = getSedimentLoadWithDataUncached(
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	174 river,
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	175 type,
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	176 startKm,
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	177 endKm,
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	178 syear,
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	179 eyear);
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	180
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	181 if (values != null && key != null) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	182 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	183 element = new Element(key, values);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	184 cache.put(element);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	185 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	186 return values;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	187 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	188
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	189 /**
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	190 * Get sediment loads from db.
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	191 * @param river the river
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	192 * @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	193 * @return according sediment loads.
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	194 */
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	195 public static SedimentLoad[] getSedimentLoadsUncached(
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	196 String river,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	197 String type,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	198 double startKm,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	199 double endKm
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	200 ) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	201 log.debug("SedimentLoadFactory.getSedimentLoadsUncached");
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	202
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	203 Session session = SessionHolder.HOLDER.get();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	204 SQLQuery sqlQuery = null;
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 if (type.equals("single")) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	207 sqlQuery = session.createSQLQuery(SQL_SELECT_SINGLES)
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	208 .addScalar("description", StandardBasicTypes.STRING)
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	209 .addScalar("year", StandardBasicTypes.DATE);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	210 sqlQuery.setString("name", river);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	211 sqlQuery.setDouble("startKm", startKm);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	212 sqlQuery.setDouble("endKm", endKm);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	213 List<Object []> results = sqlQuery.list();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	214 SedimentLoad[] loads = new SedimentLoad[results.size()];
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	215 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	216 Object[] row = results.get(i);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	217 loads[i] = new SedimentLoad(
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	218 (String) row[0],
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	219 (Date) row[1],
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	220 null,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	221 false);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	222 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	223 return loads;
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 else if (type.equals("epoch")) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	226 sqlQuery = session.createSQLQuery(SQL_SELECT_EPOCHS)
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	227 .addScalar("description", StandardBasicTypes.STRING)
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	228 .addScalar("start", StandardBasicTypes.DATE)
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	229 .addScalar("end", StandardBasicTypes.DATE);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	230 sqlQuery.setString("name", river);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	231 sqlQuery.setDouble("startKm", startKm);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	232 sqlQuery.setDouble("endKm", endKm);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	233 List<Object []> results = sqlQuery.list();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	234
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	235 SedimentLoad[] loads = new SedimentLoad[results.size()];
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	236 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	237 Object[] row = results.get(i);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	238 loads[i] = new SedimentLoad(
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	239 (String) row[0],
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	240 (Date) row[1],
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	241 (Date) row[2],
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	242 true);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	243 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	244 return loads;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	245 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	246 return new SedimentLoad[0];
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	247 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	248
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	249 /**
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	250 * Get sediment loads from db.
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	251 * @param river the river
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	252 * @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	253 * @return according sediment loads.
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	254 */
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	255 public static SedimentLoad getSedimentLoadWithDataUncached(
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	256 String river,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	257 String type,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	258 double startKm,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	259 double endKm,
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	260 int syear,
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	261 int eyear
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	262 ) {
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	263 log.debug("SedimentLoadFactory.getSedimentLoadWithDataUncached");
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	264 Session session = SessionHolder.HOLDER.get();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	265 SQLQuery sqlQuery = null;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	266
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	267 Calendar start = Calendar.getInstance();
4546 af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	268 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	269 Calendar end = Calendar.getInstance();
4546 af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	270 end.set(syear, 11, 30);
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	271
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	272 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	273 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	274 .addScalar("description", StandardBasicTypes.STRING)
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	275 .addScalar("year", StandardBasicTypes.DATE)
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	276 .addScalar("load", StandardBasicTypes.DOUBLE)
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	277 .addScalar("km", StandardBasicTypes.DOUBLE);
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	278 sqlQuery.setString("name", river);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	279 sqlQuery.setDouble("startKm", startKm);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	280 sqlQuery.setDouble("endKm", endKm);
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	281 sqlQuery.setDate("begin", start.getTime());
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	282 sqlQuery.setDate("end", end.getTime());
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	283 sqlQuery.setString("grain", "total");
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	284 List<Object []> results = sqlQuery.list();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	285 SedimentLoad load = new SedimentLoad();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	286 Object[] row = results.get(0);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	287 load = new SedimentLoad(
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	288 (String) row[0],
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	289 (Date) row[1],
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	290 null,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	291 false);
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	292 getValues("coarse", sqlQuery, load);
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	293 getValues("fine_middle", sqlQuery, load);
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	294 getValues("sand", sqlQuery, load);
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	295 getValues("suspended_sediment", sqlQuery, load);
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	296 getValues("susp_sand_bed", sqlQuery, load);
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	297 getValues("susp_sand", sqlQuery, load);
4736 b195fede1c3b Remove trailing whitespace. Sascha L. Teichmann <teichmann@intevation.de> parents: 4551 diff changeset	298
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	299 return load;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	300 }
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	301 else if (type.equals("off_epoch")) {
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	302 Calendar toStart = Calendar.getInstance();
4546 af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	303 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	304 Calendar toEnd = Calendar.getInstance();
4546 af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	305 toEnd.set(eyear, 11, 30);
4517 a5e4fae31089 Fixed SQL statements and parameters. Raimund Renkert <rrenkert@intevation.de> parents: 4434 diff changeset	306 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	307 .addScalar("description", StandardBasicTypes.STRING)
4517 a5e4fae31089 Fixed SQL statements and parameters. Raimund Renkert <rrenkert@intevation.de> parents: 4434 diff changeset	308 .addScalar("startYear", StandardBasicTypes.DATE)
a5e4fae31089 Fixed SQL statements and parameters. Raimund Renkert <rrenkert@intevation.de> parents: 4434 diff changeset	309 .addScalar("load", StandardBasicTypes.DOUBLE)
4546 af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	310 .addScalar("km", StandardBasicTypes.DOUBLE)
af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	311 .addScalar("endYear", StandardBasicTypes.DATE);
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	312 sqlQuery.setString("name", river);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	313 sqlQuery.setDouble("startKm", startKm);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	314 sqlQuery.setDouble("endKm", endKm);
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	315 sqlQuery.setDate("sbegin", start.getTime());
4517 a5e4fae31089 Fixed SQL statements and parameters. Raimund Renkert <rrenkert@intevation.de> parents: 4434 diff changeset	316 sqlQuery.setDate("send", end.getTime());
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	317 sqlQuery.setDate("ebegin",toStart.getTime());
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	318 sqlQuery.setDate("eend", toEnd.getTime());
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	319 sqlQuery.setString("grain", "total");
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	320
4546 af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	321 List<Object[]> results = null;
af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	322 results = sqlQuery.list();
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	323
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	324 SedimentLoad load = new SedimentLoad();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	325 Object[] row = results.get(0);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	326 load = new SedimentLoad(
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	327 (String) row[0],
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	328 (Date) row[1],
4546 af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	329 (Date) row[4],
af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	330 true);
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	331 TDoubleArrayList kms = new TDoubleArrayList();
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	332 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	333 row = results.get(i);
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	334 kms.add((Double)row[3]);
4546 af1938d4e957 New field in sediment load object and calculation. Raimund Renkert <rrenkert@intevation.de> parents: 4517 diff changeset	335 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	336 }
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	337 getValues("coarse", sqlQuery, load);
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	338 getValues("fine_middle", sqlQuery, load);
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	339 getValues("sand", sqlQuery, load);
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	340 getValues("suspended_sediment", sqlQuery, load);
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	341 getValues("susp_sand_bed", sqlQuery, load);
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	342 getValues("susp_sand", sqlQuery, load);
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	343 return load;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	344 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	345 return new SedimentLoad();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	346 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	347
5662 7e3cde8b564c Cosmetics, docs, vimlines. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 5661 diff changeset	348
5789 62ac8fa61780 Doc. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 5662 diff changeset	349 /**
62ac8fa61780 Doc. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 5662 diff changeset	350 * Run query with grain parameter set to fraction, feed result into
62ac8fa61780 Doc. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 5662 diff changeset	351 * load.
62ac8fa61780 Doc. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 5662 diff changeset	352 * @param fraction value to set 'grain' parameter in query to.
62ac8fa61780 Doc. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 5662 diff changeset	353 * @param query query in which to set 'grain' parameter and run.
62ac8fa61780 Doc. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 5662 diff changeset	354 * @param load[out] SedimentLoad which to populate with values.
62ac8fa61780 Doc. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 5662 diff changeset	355 */
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	356 protected static void getValues (
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	357 String fraction,
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	358 SQLQuery query,
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	359 SedimentLoad load
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	360 ) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	361 query.setString("grain", fraction);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	362 List<Object[]> results = query.list();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	363 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	364 Object[] row = results.get(i);
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	365 double km = (Double)row[3];
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	366 double v = -1;
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	367 if (row[2] != null) {
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	368 v = ((Double)row[2]).doubleValue();
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	369 }
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	370 if (fraction.equals("coarse")) {
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	371 load.setCoarse(km, v);
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	372 }
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	373 else if (fraction.equals("sand")) {
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	374 load.setSand(km, v);
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	375 }
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	376 else if (fraction.equals("fine_middle")) {
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	377 load.setFineMiddle(km, v);
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	378 }
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	379 else if (fraction.equals("suspended_sediment")) {
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	380 load.setSuspSediment(km, v);
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	381 }
4517 a5e4fae31089 Fixed SQL statements and parameters. Raimund Renkert <rrenkert@intevation.de> parents: 4434 diff changeset	382 else if (fraction.equals("susp_sand")) {
4370 6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	383 load.setSuspSand(km, v);
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	384 }
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	385 else if (fraction.equals("susp_sand_bed")) {
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	386 load.setSuspSandBed(km, v);
6a65e7ef43c0 Updated data object and factory for sediment load. Raimund Renkert <rrenkert@intevation.de> parents: 4296 diff changeset	387 }
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 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	390 }
5662 7e3cde8b564c Cosmetics, docs, vimlines. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 5661 diff changeset	391 // 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 @ 5863:4897a58c8746