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

annotate artifacts/src/main/java/org/dive4elements/river/artifacts/model/minfo/BedHeightFactory.java @ 7829:1aba75321441 minfo-opt

Added morph. active width to bed height difference calculation.

author	Raimund Renkert <rrenkert@intevation.de>
date	Fri, 28 Mar 2014 11:20:49 +0100
parents	04b70a6fe8c5
children	868f55932fe6

rev	line source
5863 4897a58c8746 River artifacts: Added new copyright headers. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	1 /* Copyright (C) 2011, 2012, 2013 by Bundesanstalt für Gewässerkunde
4897a58c8746 River artifacts: Added new copyright headers. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	2 * Software engineering by Intevation GmbH
4897a58c8746 River artifacts: Added new copyright headers. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	3 *
5994 af13ceeba52a Removed trailing whitespace. Sascha L. Teichmann <teichmann@intevation.de> parents: 5863 diff changeset	4 * This file is Free Software under the GNU AGPL (>=v3)
5863 4897a58c8746 River artifacts: Added new copyright headers. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	5 * and comes with ABSOLUTELY NO WARRANTY! Check out the
5994 af13ceeba52a Removed trailing whitespace. Sascha L. Teichmann <teichmann@intevation.de> parents: 5863 diff changeset	6 * documentation coming with Dive4Elements River for details.
5863 4897a58c8746 River artifacts: Added new copyright headers. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	7 */
4897a58c8746 River artifacts: Added new copyright headers. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	8
5831 bd047b71ab37 Repaired internal references Sascha L. Teichmann <teichmann@intevation.de> parents: 4051 diff changeset	9 package org.dive4elements.river.artifacts.model.minfo;
3614 68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	10
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	11
3886 633fbb61a0cc Split bed heights into bed height epochs and single bed heights. Raimund Renkert <raimund.renkert@intevation.de> parents: 3614 diff changeset	12 import java.util.Date;
3614 68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	13 import java.util.List;
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	14
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	15 import net.sf.ehcache.Cache;
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	16 import net.sf.ehcache.Element;
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	17
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	18 import org.apache.log4j.Logger;
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	19 import org.hibernate.SQLQuery;
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	20 import org.hibernate.Session;
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	21 import org.hibernate.type.StandardBasicTypes;
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	22
5831 bd047b71ab37 Repaired internal references Sascha L. Teichmann <teichmann@intevation.de> parents: 4051 diff changeset	23 import org.dive4elements.river.artifacts.cache.CacheFactory;
bd047b71ab37 Repaired internal references Sascha L. Teichmann <teichmann@intevation.de> parents: 4051 diff changeset	24 import org.dive4elements.river.artifacts.model.StaticBedHeightCacheKey;
bd047b71ab37 Repaired internal references Sascha L. Teichmann <teichmann@intevation.de> parents: 4051 diff changeset	25 import org.dive4elements.river.backend.SessionHolder;
3614 68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	26
6765 4ac054834294 Doc. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6563 diff changeset	27
4ac054834294 Doc. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6563 diff changeset	28 /** Create BedHeights from database. */
3614 68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	29 public class BedHeightFactory {
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	30 /** Private logger to use here. */
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	31 private static Logger log = Logger.getLogger(BedHeightFactory.class);
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	32
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	33 /** Query to get km and ws for wst_id and column_pos. */
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	34 public static final String SQL_SELECT_SINGLE =
7829 1aba75321441 Added morph. active width to bed height difference calculation. Raimund Renkert <rrenkert@intevation.de> parents: 7392 diff changeset	35 "SELECT bhsv.height, bhsv.station, bhsv.data_gap, bhsv.sounding_width," +
1aba75321441 Added morph. active width to bed height difference calculation. Raimund Renkert <rrenkert@intevation.de> parents: 7392 diff changeset	36 " bhs.year, bhsv.width" +
3897 bce2dd4310a6 MINFO: Updated data fields to fit the needs of bedheight difference calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: 3886 diff changeset	37 " FROM bed_height_single bhs" +
bce2dd4310a6 MINFO: Updated data fields to fit the needs of bedheight difference calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: 3886 diff changeset	38 " JOIN bed_height_single_values bhsv on bhsv.bed_height_single_id = bhs.id" +
6275 2d495b504c74 Order bed heights by station. Raimund Renkert <rrenkert@intevation.de> parents: 5994 diff changeset	39 " WHERE bhs.id = :height_id" +
2d495b504c74 Order bed heights by station. Raimund Renkert <rrenkert@intevation.de> parents: 5994 diff changeset	40 " ORDER BY bhsv.station";
2d495b504c74 Order bed heights by station. Raimund Renkert <rrenkert@intevation.de> parents: 5994 diff changeset	41
3614 68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	42
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	43 /** Query to get name for wst_id and column_pos. */
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	44 public static final String SQL_SELECT_EPOCH =
3897 bce2dd4310a6 MINFO: Updated data fields to fit the needs of bedheight difference calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: 3886 diff changeset	45 "SELECT bv.height, bv.station, ti.start_time, ti.stop_time" +
bce2dd4310a6 MINFO: Updated data fields to fit the needs of bedheight difference calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: 3886 diff changeset	46 " FROM bed_height_epoch b" +
bce2dd4310a6 MINFO: Updated data fields to fit the needs of bedheight difference calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: 3886 diff changeset	47 " JOIN bed_height_epoch_values bv ON b.id = bv.bed_height_epoch_id" +
bce2dd4310a6 MINFO: Updated data fields to fit the needs of bedheight difference calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: 3886 diff changeset	48 " JOIN time_intervals ti ON b.time_interval_id = ti.id" +
6275 2d495b504c74 Order bed heights by station. Raimund Renkert <rrenkert@intevation.de> parents: 5994 diff changeset	49 " WHERE b.id = :height_id" +
2d495b504c74 Order bed heights by station. Raimund Renkert <rrenkert@intevation.de> parents: 5994 diff changeset	50 " ORDER BY bhsv.station";
3614 68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	51
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	52 /** Query to get name (description) for wst_id. */
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	53 public static final String SQL_SELECT_DESCR_SINGLE =
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	54 "SELECT description FROM bed_height_single "+
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	55 "WHERE id = :height_id";
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	56
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	57 /** Query to get name (description) for wst_id. */
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	58 public static final String SQL_SELECT_DESCR_EPOCH =
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	59 "SELECT description from bed_height_epoch "+
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	60 "WHERE id = :height_id";
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	61
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	62
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	63 private BedHeightFactory() {
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	64 }
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	65
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	66
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	67 /**
7391 9513d1af7d58 Renamed artifacts/*/BedHeight(Single) to BedHeight(Single)Data, to resolve Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 7254 diff changeset	68 * Get BedHeightData for given type and height_id, caring about the cache.
3614 68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	69 */
7391 9513d1af7d58 Renamed artifacts/*/BedHeight(Single) to BedHeight(Single)Data, to resolve Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 7254 diff changeset	70 public static BedHeightData getHeight(String type, int height_id, int time) {
3614 68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	71 log.debug("BedHeightFactory.getHeight");
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	72 Cache cache = CacheFactory.getCache(StaticBedHeightCacheKey.CACHE_NAME);
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	73
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	74 StaticBedHeightCacheKey cacheKey;
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	75
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	76 if (cache != null) {
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	77 cacheKey = new StaticBedHeightCacheKey(height_id, time);
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	78 Element element = cache.get(cacheKey);
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	79 if (element != null) {
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	80 log.debug("Got static bedheight values from cache");
7391 9513d1af7d58 Renamed artifacts/*/BedHeight(Single) to BedHeight(Single)Data, to resolve Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 7254 diff changeset	81 return (BedHeightData)element.getValue();
3614 68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	82 }
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	83 }
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	84 else {
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	85 cacheKey = null;
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	86 }
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	87
7391 9513d1af7d58 Renamed artifacts/*/BedHeight(Single) to BedHeight(Single)Data, to resolve Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 7254 diff changeset	88 BedHeightData values = getBedHeightUncached(type, height_id, time);
3614 68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	89
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	90 if (values != null && cacheKey != null) {
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	91 log.debug("Store static bed height values in cache.");
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	92 Element element = new Element(cacheKey, values);
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	93 cache.put(element);
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	94 }
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	95 return values;
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	96 }
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	97
6563 ec32ccf7a753 More doc fixes. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6562 diff changeset	98 /** Get name for a BedHeight. */
3614 68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	99 public static String getHeightName(String type, int height_id) {
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	100 log.debug("BedHeightFactory.getHeightName height_id/" + height_id);
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	101
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	102 String name = null;
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	103 Session session = SessionHolder.HOLDER.get();
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	104
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	105 SQLQuery nameQuery = null;
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	106 if (type.equals("single")) {
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	107 nameQuery = session.createSQLQuery(SQL_SELECT_DESCR_SINGLE)
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	108 .addScalar("description", StandardBasicTypes.STRING);
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	109 nameQuery.setInteger("height_id", height_id);
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	110 }
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	111 else if (type.equals("epoch")) {
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	112 nameQuery = session.createSQLQuery(SQL_SELECT_DESCR_EPOCH)
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	113 .addScalar("description", StandardBasicTypes.STRING);
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	114 nameQuery.setInteger("height_id", height_id);
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	115 }
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	116 else {
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	117 return "none";
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	118 }
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	119 List<String> names = nameQuery.list();
4051 58bdf95df5e4 More dead code removal. Minor code clean ups. Sascha L. Teichmann <teichmann@intevation.de> parents: 3897 diff changeset	120 if (!names.isEmpty()) {
3614 68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	121 name = names.get(0);
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	122 }
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	123
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	124 return name;
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	125 }
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	126
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	127
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	128 /**
7391 9513d1af7d58 Renamed artifacts/*/BedHeight(Single) to BedHeight(Single)Data, to resolve Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 7254 diff changeset	129 * Get BedHeightData from db.
6562 4f67b9ceb9e2 Fix doc. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6352 diff changeset	130 * @param height_id database id of the bed_height
4f67b9ceb9e2 Fix doc. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6352 diff changeset	131 * @return according BedHeight.
3614 68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	132 */
7391 9513d1af7d58 Renamed artifacts/*/BedHeight(Single) to BedHeight(Single)Data, to resolve Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 7254 diff changeset	133 public static BedHeightData getBedHeightUncached(
3614 68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	134 String type,
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	135 int height_id,
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	136 int time)
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	137 {
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	138 if (log.isDebugEnabled()) {
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	139 log.debug("BedHeightFactory.getBedHeightUncached");
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	140 }
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	141
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	142 Session session = SessionHolder.HOLDER.get();
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	143 SQLQuery sqlQuery = null;
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	144 if (type.equals("single")) {
7391 9513d1af7d58 Renamed artifacts/*/BedHeight(Single) to BedHeight(Single)Data, to resolve Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 7254 diff changeset	145 BedHeightSingleData height =
9513d1af7d58 Renamed artifacts/*/BedHeight(Single) to BedHeight(Single)Data, to resolve Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 7254 diff changeset	146 new BedHeightSingleData(getHeightName(type, height_id));
3614 68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	147 sqlQuery = session.createSQLQuery(SQL_SELECT_SINGLE)
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	148 .addScalar("height", StandardBasicTypes.DOUBLE)
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	149 .addScalar("station", StandardBasicTypes.DOUBLE)
3886 633fbb61a0cc Split bed heights into bed height epochs and single bed heights. Raimund Renkert <raimund.renkert@intevation.de> parents: 3614 diff changeset	150 .addScalar("data_gap", StandardBasicTypes.DOUBLE)
633fbb61a0cc Split bed heights into bed height epochs and single bed heights. Raimund Renkert <raimund.renkert@intevation.de> parents: 3614 diff changeset	151 .addScalar("sounding_width", StandardBasicTypes.DOUBLE)
7829 1aba75321441 Added morph. active width to bed height difference calculation. Raimund Renkert <rrenkert@intevation.de> parents: 7392 diff changeset	152 .addScalar("width", StandardBasicTypes.DOUBLE)
3886 633fbb61a0cc Split bed heights into bed height epochs and single bed heights. Raimund Renkert <raimund.renkert@intevation.de> parents: 3614 diff changeset	153 .addScalar("year", StandardBasicTypes.INTEGER);
3614 68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	154 sqlQuery.setInteger("height_id", height_id);
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	155 List<Object []> results = sqlQuery.list();
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	156
7254 fe32a7f9655e Reduce usage of careless 'for (int i = 0; i < x.size(); i++)' pattern. Sascha L. Teichmann <teichmann@intevation.de> parents: 6765 diff changeset	157 for (Object [] row: results) {
3897 bce2dd4310a6 MINFO: Updated data fields to fit the needs of bedheight difference calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: 3886 diff changeset	158 log.debug("got station: " + (Double)row[1]);
6352 f1a3ea7fb3b6 Insert Double.NaN for missing values in bed height factory. Raimund Renkert <rrenkert@intevation.de> parents: 6275 diff changeset	159 Double row0 = row[0] != null ? (Double)row[0] : Double.NaN;
f1a3ea7fb3b6 Insert Double.NaN for missing values in bed height factory. Raimund Renkert <rrenkert@intevation.de> parents: 6275 diff changeset	160 Double row1 = row[1] != null ? (Double)row[1] : Double.NaN;
f1a3ea7fb3b6 Insert Double.NaN for missing values in bed height factory. Raimund Renkert <rrenkert@intevation.de> parents: 6275 diff changeset	161 Double row2 = row[2] != null ? (Double)row[2] : Double.NaN;
f1a3ea7fb3b6 Insert Double.NaN for missing values in bed height factory. Raimund Renkert <rrenkert@intevation.de> parents: 6275 diff changeset	162 Double row3 = row[3] != null ? (Double)row[3] : Double.NaN;
7829 1aba75321441 Added morph. active width to bed height difference calculation. Raimund Renkert <rrenkert@intevation.de> parents: 7392 diff changeset	163 Double row4 = row[4] != null ? (Double)row[4] : Double.NaN;
1aba75321441 Added morph. active width to bed height difference calculation. Raimund Renkert <rrenkert@intevation.de> parents: 7392 diff changeset	164 height.add(row0, row1, row2, row3, row4, (Integer) row[5]);
3614 68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	165 }
3886 633fbb61a0cc Split bed heights into bed height epochs and single bed heights. Raimund Renkert <raimund.renkert@intevation.de> parents: 3614 diff changeset	166 return height;
3614 68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	167 }
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	168 else if (type.equals("epoch")) {
7392 04b70a6fe8c5 Moved BedHeightEpoch to BedHeightEpochData. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 7391 diff changeset	169 BedHeightEpochData height =
04b70a6fe8c5 Moved BedHeightEpoch to BedHeightEpochData. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 7391 diff changeset	170 new BedHeightEpochData(getHeightName(type, height_id));
3614 68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	171 sqlQuery = session.createSQLQuery(SQL_SELECT_EPOCH)
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	172 .addScalar("height", StandardBasicTypes.DOUBLE)
3886 633fbb61a0cc Split bed heights into bed height epochs and single bed heights. Raimund Renkert <raimund.renkert@intevation.de> parents: 3614 diff changeset	173 .addScalar("station", StandardBasicTypes.DOUBLE)
633fbb61a0cc Split bed heights into bed height epochs and single bed heights. Raimund Renkert <raimund.renkert@intevation.de> parents: 3614 diff changeset	174 .addScalar("start_time", StandardBasicTypes.DATE)
633fbb61a0cc Split bed heights into bed height epochs and single bed heights. Raimund Renkert <raimund.renkert@intevation.de> parents: 3614 diff changeset	175 .addScalar("stop_time", StandardBasicTypes.DATE);
3614 68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	176 sqlQuery.setInteger("height_id", height_id);
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	177 List<Object []> results = sqlQuery.list();
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	178
4051 58bdf95df5e4 More dead code removal. Minor code clean ups. Sascha L. Teichmann <teichmann@intevation.de> parents: 3897 diff changeset	179 for (Object [] row: results) {
3886 633fbb61a0cc Split bed heights into bed height epochs and single bed heights. Raimund Renkert <raimund.renkert@intevation.de> parents: 3614 diff changeset	180 height.add(
633fbb61a0cc Split bed heights into bed height epochs and single bed heights. Raimund Renkert <raimund.renkert@intevation.de> parents: 3614 diff changeset	181 (Double) row[0],
633fbb61a0cc Split bed heights into bed height epochs and single bed heights. Raimund Renkert <raimund.renkert@intevation.de> parents: 3614 diff changeset	182 (Double) row[1],
4051 58bdf95df5e4 More dead code removal. Minor code clean ups. Sascha L. Teichmann <teichmann@intevation.de> parents: 3897 diff changeset	183 (Date) row[2],
58bdf95df5e4 More dead code removal. Minor code clean ups. Sascha L. Teichmann <teichmann@intevation.de> parents: 3897 diff changeset	184 (Date) row[3]);
3614 68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	185 }
3886 633fbb61a0cc Split bed heights into bed height epochs and single bed heights. Raimund Renkert <raimund.renkert@intevation.de> parents: 3614 diff changeset	186 return height;
3614 68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	187 }
7391 9513d1af7d58 Renamed artifacts/*/BedHeight(Single) to BedHeight(Single)Data, to resolve Felix Wolfsteller <felix.wolfsteller@intevation.de>* parents: 7254 diff changeset	188 return new BedHeightData();
3614 68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	189 }
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	190 }
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	191 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :

Mercurial > dive4elements > river

annotate artifacts/src/main/java/org/dive4elements/river/artifacts/model/minfo/BedHeightFactory.java @ 7829:1aba75321441 minfo-opt