dive4elements/river: flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/minfo/SedimentLoadFactory.java annotate

author	Raimund Renkert <rrenkert@intevation.de>
date	Mon, 29 Oct 2012 12:14:50 +0100
parents
children	6a65e7ef43c0

rev	line source
4296 3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	1 package de.intevation.flys.artifacts.model.minfo;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	2
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	3 import gnu.trove.TDoubleArrayList;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	4
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	5 import java.util.Calendar;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	6 import java.util.Date;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	7 import java.util.List;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	8
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	9 import net.sf.ehcache.Cache;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	10 import net.sf.ehcache.Element;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	11
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	12 import org.apache.log4j.Logger;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	13 import org.hibernate.SQLQuery;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	14 import org.hibernate.Session;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	15 import org.hibernate.type.StandardBasicTypes;
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 de.intevation.flys.artifacts.cache.CacheFactory;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	18 import de.intevation.flys.artifacts.model.StaticSedimentLoadCacheKey;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	19 import de.intevation.flys.backend.SessionHolder;
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
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	22 public class SedimentLoadFactory
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	23 {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	24 /** Private logger to use here. */
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	25 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	26
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	27 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	28 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	29
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	30 /** Query to get km and ws for wst_id and column_pos. */
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	31 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	32 "SELECT DISTINCT " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	33 " sy.description AS description, " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	34 " ti.start_time AS year " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	35 " FROM sediment_yield sy " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	36 " 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	37 " 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	38 " 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	39 " WHERE r.name = :name " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	40 " AND ti.stop_time IS NULL " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	41 " 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	42
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	43 /** Query to get name for wst_id and column_pos. */
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	44 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	45 "SELECT DISTINCT " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	46 " sy.description AS description, " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	47 " ti.start_time AS start, " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	48 " ti.stop_time AS end " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	49 " FROM sediment_yield sy " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	50 " JOIN rivers r ON sy.river_id = r.id " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	51 " JOIN sediment_yield_values syv ON sy.id = syv.sediment_yield_id " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	52 " JOIN time_intervals ti ON sy.time_interval_id = ti.id " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	53 " WHERE r.name = :name " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	54 " AND ti.stop_time IS NOT NULL " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	55 " AND syv.station BETWEEN :startKm AND :endKm";
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	56
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	57 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	58 "SELECT" +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	59 " sy.description AS description, " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	60 " ti.start_time AS year, " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	61 " syv.value AS load " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	62 " FROM sediment_yield sy " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	63 " 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	64 " 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	65 " JOIN sediment_yield_vales 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	66 " 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	67 " WHERE r.name = :name " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	68 " AND ti.start_time BETWEEN :begin AND :end " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	69 " AND ti_stop_time IS NULL " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	70 " AND gf.name = :grain " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	71 " 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	72
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	73 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	74 "SELECT" +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	75 " sy.description AS description," +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	76 " ti.start_time AS year," +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	77 " syv.value AS load" +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	78 " FROM sediment_yield sy" +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	79 " 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	80 " 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	81 " JOIN sediment_yield_vales 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	82 " 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	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 :sbegin AND :send" +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	85 " 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	86 " AND ti_stop_time BETWEEN :ebegin AND :eend" +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	87 " AND gf.name = :grain " +
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	88 " 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	89
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	90 private SedimentLoadFactory() {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	91 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	92
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	93 /**
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	94 *
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	95 */
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	96 public static SedimentLoad[] getLoads(
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	97 String river,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	98 String type,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	99 double startKm,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	100 double endKm
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 log.debug("SedimentLoadFactory.getLoads");
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	103 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	104
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	105 if (cache == null) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	106 log.debug("Cache not configured.");
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	107 return getSedimentLoadsUncached(river, type, startKm, endKm);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	108 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	109
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	110 StaticSedimentLoadCacheKey key =
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	111 new StaticSedimentLoadCacheKey(river, startKm, endKm, null);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	112
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	113 Element element = cache.get(key);
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 (element != null) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	116 log.debug("SedimentLoad found in cache");
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	117 return (SedimentLoad[])element.getValue();
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 SedimentLoad[] values =
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	121 getSedimentLoadsUncached(river, type, startKm, endKm);
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 if (values != null && key != null) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	124 log.debug("Store static sediment loads values in cache.");
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	125 element = new Element(key, values);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	126 cache.put(element);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	127 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	128 return values;
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
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	131 public static SedimentLoad getLoadwithData(
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	132 String river,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	133 String type,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	134 double startKm,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	135 double endKm,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	136 Date startDate,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	137 Date endDate
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	138 ) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	139 log.debug("SedimentLoadFactory.getLoadWithData");
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	140 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	141
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	142 if (cache == null) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	143 log.debug("Cache not configured.");
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	144 return getSedimentLoadWithDataUncached(
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	145 river,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	146 type,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	147 startKm,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	148 endKm,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	149 startDate,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	150 endDate);
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
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	153 StaticSedimentLoadCacheKey key =
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	154 new StaticSedimentLoadCacheKey(river, startKm, endKm, startDate);
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 Element element = cache.get(key);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	157
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	158 if (element != null) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	159 log.debug("SedimentLoad found in cache");
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	160 return (SedimentLoad)element.getValue();
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 SedimentLoad values =
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	164 getSedimentLoadWithDataUncached(river, type, startKm, endKm, startDate, endDate);
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 if (values != null && key != null) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	167 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	168 element = new Element(key, values);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	169 cache.put(element);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	170 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	171 return values;
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 /**
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	175 * Get sediment loads from db.
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	176 * @param river the river
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	177 * @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	178 * @return according sediment loads.
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	179 */
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	180 public static SedimentLoad[] getSedimentLoadsUncached(
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	181 String river,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	182 String type,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	183 double startKm,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	184 double endKm
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 log.debug("SedimentLoadFactory.getSedimentLoadsUncached");
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 Session session = SessionHolder.HOLDER.get();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	189 SQLQuery sqlQuery = null;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	190
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	191
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	192 if (type.equals("single")) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	193 sqlQuery = session.createSQLQuery(SQL_SELECT_SINGLES)
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	194 .addScalar("description", StandardBasicTypes.STRING)
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	195 .addScalar("year", StandardBasicTypes.DATE);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	196 sqlQuery.setString("name", river);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	197 sqlQuery.setDouble("startKm", startKm);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	198 sqlQuery.setDouble("endKm", endKm);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	199 List<Object []> results = sqlQuery.list();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	200 SedimentLoad[] loads = new SedimentLoad[results.size()];
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	201 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	202 Object[] row = results.get(i);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	203 loads[i] = new SedimentLoad(
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	204 (String) row[0],
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	205 (Date) row[1],
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	206 null,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	207 false);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	208 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	209 return loads;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	210 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	211 else if (type.equals("epoch")) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	212 sqlQuery = session.createSQLQuery(SQL_SELECT_EPOCHS)
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	213 .addScalar("description", StandardBasicTypes.STRING)
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	214 .addScalar("start", StandardBasicTypes.DATE)
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	215 .addScalar("end", StandardBasicTypes.DATE);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	216 sqlQuery.setString("name", river);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	217 sqlQuery.setDouble("startKm", startKm);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	218 sqlQuery.setDouble("endKm", endKm);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	219 List<Object []> results = sqlQuery.list();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	220
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	221 SedimentLoad[] loads = new SedimentLoad[results.size()];
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	222 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	223 Object[] row = results.get(i);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	224 loads[i] = new SedimentLoad(
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	225 (String) row[0],
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	226 (Date) row[1],
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	227 (Date) row[2],
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	228 true);
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 loads;
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 return new SedimentLoad[0];
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
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	235 /**
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	236 * Get sediment loads from db.
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	237 * @param river the river
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	238 * @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	239 * @return according sediment loads.
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	240 */
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	241 public static SedimentLoad getSedimentLoadWithDataUncached(
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	242 String river,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	243 String type,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	244 double startKm,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	245 double endKm,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	246 Date sdate,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	247 Date edate
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 log.debug("SedimentLoadFactory.getBedHeightUncached");
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	250
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	251 Session session = SessionHolder.HOLDER.get();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	252 SQLQuery sqlQuery = null;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	253
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	254 Calendar cal = Calendar.getInstance();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	255 cal.setTime(sdate);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	256 int year = cal.get(Calendar.YEAR);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	257 cal.set(year, 1, 1);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	258 Calendar end = Calendar.getInstance();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	259 end.set(year, 12, 31);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	260
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	261 if (type.equals("single")) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	262 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	263 .addScalar("description", StandardBasicTypes.STRING)
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	264 .addScalar("year", StandardBasicTypes.DATE)
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	265 .addScalar("load", StandardBasicTypes.DOUBLE);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	266 sqlQuery.setString("name", river);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	267 sqlQuery.setDouble("startKm", startKm);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	268 sqlQuery.setDouble("endKm", endKm);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	269 sqlQuery.setDate("begin", cal.getTime());
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	270 sqlQuery.setDate("end", end.getTime());
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	271 sqlQuery.setString("grain", "total");
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	272 List<Object []> results = sqlQuery.list();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	273 SedimentLoad load = new SedimentLoad();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	274 if (results.size() != 1) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	275 // should not happen. throw some exception.
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	276 return new SedimentLoad();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	277 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	278 Object[] row = results.get(0);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	279 load = new SedimentLoad(
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	280 (String) row[0],
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	281 (Date) row[1],
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	282 null,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	283 false);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	284 load.addCoarseValues(getValues("coarse", sqlQuery));
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	285 load.addFineMiddleValues(getValues("fine_middle", sqlQuery));
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	286 load.addSandValues(getValues("sand", sqlQuery));
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	287 load.addSuspSandBedValues(getValues("suspended_sediment", sqlQuery));
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	288 load.addSuspSandBedValues(getValues("susp_sand_bed", sqlQuery));
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	289 return load;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	290 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	291 else if (type.equals("epoch")) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	292 Calendar send = Calendar.getInstance();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	293 send.setTime(edate);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	294 int eyear = send.get(Calendar.YEAR);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	295 send.set(year, 1, 1);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	296 Calendar eend = Calendar.getInstance();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	297 eend.set(eyear, 12, 31);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	298
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	299 sqlQuery = session.createSQLQuery(SQL_SELECT_EPOCHS)
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	300 .addScalar("description", StandardBasicTypes.STRING)
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	301 .addScalar("start_time", StandardBasicTypes.DATE)
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	302 .addScalar("stop_time", StandardBasicTypes.DATE)
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	303 .addScalar("load", StandardBasicTypes.DOUBLE);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	304 sqlQuery.setString("name", river);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	305 sqlQuery.setDouble("startKm", startKm);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	306 sqlQuery.setDouble("endKm", endKm);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	307 sqlQuery.setDate("sbegin", cal.getTime());
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	308 sqlQuery.setDate("sbegin", end.getTime());
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	309 sqlQuery.setDate("ebegin",send.getTime());
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	310 sqlQuery.setDate("eend", eend.getTime());
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	311 sqlQuery.setString("grain", "total");
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	312
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	313 List<Object []> results = sqlQuery.list();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	314
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	315 SedimentLoad load = new SedimentLoad();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	316 if (results.size() != 1) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	317 // should not happen. throw some exception.
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	318 return new SedimentLoad();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	319 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	320 Object[] row = results.get(0);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	321 load = new SedimentLoad(
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	322 (String) row[0],
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	323 (Date) row[1],
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	324 null,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	325 false);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	326 load.addCoarseValues(getValues("coarse", sqlQuery));
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	327 load.addFineMiddleValues(getValues("fine_middle", sqlQuery));
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	328 load.addSandValues(getValues("sand", sqlQuery));
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	329 load.addSuspSandBedValues(getValues("suspended_sediment", sqlQuery));
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	330 load.addSuspSandBedValues(getValues("susp_sand_bed", sqlQuery));
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	331 return load;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	332 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	333 return new SedimentLoad();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	334 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	335
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	336 /**
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	337 *
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	338 */
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	339 protected static TDoubleArrayList getValues (
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	340 String fraction,
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	341 SQLQuery query
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	342 ) {
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	343 query.setString("grain", fraction);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	344 List<Object[]> results = query.list();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	345 TDoubleArrayList values = new TDoubleArrayList();
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	346 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	347 Object[] row = results.get(i);
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	348 values.add(((Double)row[2]).doubleValue());
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	349 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	350 return values;
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	351 }
3051bc28ac43 Added data object and factory for sediment load calculation. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	352 }

4296

3051bc28ac43 Added data object and factory for sediment load calculation.