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

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

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

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
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	27 public class BedHeightFactory {
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	28 /** 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	29 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	30
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	31 /** 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	32 public static final String SQL_SELECT_SINGLE =
3897 bce2dd4310a6 MINFO: Updated data fields to fit the needs of bedheight difference calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: 3886 diff changeset	33 "SELECT bhsv.height, bhsv.station, bhsv.data_gap, bhsv.sounding_width, bhs.year " +
bce2dd4310a6 MINFO: Updated data fields to fit the needs of bedheight difference calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: 3886 diff changeset	34 " 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	35 " 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	36 " WHERE bhs.id = :height_id" +
2d495b504c74 Order bed heights by station. Raimund Renkert <rrenkert@intevation.de> parents: 5994 diff changeset	37 " ORDER BY bhsv.station";
2d495b504c74 Order bed heights by station. Raimund Renkert <rrenkert@intevation.de> parents: 5994 diff changeset	38
3614 68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	39
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	40 /** 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	41 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	42 "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	43 " 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	44 " 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	45 " 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	46 " WHERE b.id = :height_id" +
2d495b504c74 Order bed heights by station. Raimund Renkert <rrenkert@intevation.de> parents: 5994 diff changeset	47 " 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	48
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	49 /** 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	50 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	51 "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	52 "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	53
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	54 /** 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	55 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	56 "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	57 "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	58
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	59
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	60 private BedHeightFactory() {
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
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	64 /**
6563 ec32ccf7a753 More doc fixes. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6562 diff changeset	65 * Get BedHeight 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	66 */
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	67 public static BedHeight getHeight(String type, int height_id, int time) {
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	68 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	69 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	70
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	71 StaticBedHeightCacheKey cacheKey;
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	72
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	73 if (cache != null) {
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	74 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	75 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	76 if (element != null) {
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	77 log.debug("Got static bedheight values from cache");
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	78 return (BedHeight)element.getValue();
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	79 }
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	80 }
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	81 else {
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	82 cacheKey = null;
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
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	85 BedHeight values = getBedHeightUncached(type, height_id, time);
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 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	88 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	89 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	90 cache.put(element);
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	91 }
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	92 return values;
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	93 }
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	94
6563 ec32ccf7a753 More doc fixes. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6562 diff changeset	95 /** 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	96 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	97 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	98
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	99 String name = null;
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	100 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	101
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	102 SQLQuery nameQuery = null;
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	103 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	104 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	105 .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	106 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	107 }
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	108 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	109 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	110 .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	111 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	112 }
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	113 else {
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	114 return "none";
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 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	117 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	118 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	119 }
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	120
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	121 return name;
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
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	125 /**
6562 4f67b9ceb9e2 Fix doc. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6352 diff changeset	126 * Get BedHeight from db.
4f67b9ceb9e2 Fix doc. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6352 diff changeset	127 * @param height_id database id of the bed_height
4f67b9ceb9e2 Fix doc. Felix Wolfsteller <felix.wolfsteller@intevation.de> parents: 6352 diff changeset	128 * @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	129 */
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	130 public static BedHeight getBedHeightUncached(
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	131 String type,
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	132 int height_id,
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	133 int time)
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	134 {
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	135 if (log.isDebugEnabled()) {
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	136 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	137 }
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	138
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	139 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	140 SQLQuery sqlQuery = null;
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	141 if (type.equals("single")) {
3886 633fbb61a0cc Split bed heights into bed height epochs and single bed heights. Raimund Renkert <raimund.renkert@intevation.de> parents: 3614 diff changeset	142 BedHeightSingle height =
633fbb61a0cc Split bed heights into bed height epochs and single bed heights. Raimund Renkert <raimund.renkert@intevation.de> parents: 3614 diff changeset	143 new BedHeightSingle(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	144 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	145 .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	146 .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	147 .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	148 .addScalar("sounding_width", StandardBasicTypes.DOUBLE)
633fbb61a0cc Split bed heights into bed height epochs and single bed heights. Raimund Renkert <raimund.renkert@intevation.de> parents: 3614 diff changeset	149 .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	150 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	151 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	152
3897 bce2dd4310a6 MINFO: Updated data fields to fit the needs of bedheight difference calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: 3886 diff changeset	153 for (int i = 0; i < results.size(); i++) {
3614 68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	154 Object[] row = results.get(i);
3897 bce2dd4310a6 MINFO: Updated data fields to fit the needs of bedheight difference calculation. Raimund Renkert <raimund.renkert@intevation.de> parents: 3886 diff changeset	155 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	156 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	157 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	158 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	159 Double row3 = row[3] != null ? (Double)row[3] : Double.NaN;
f1a3ea7fb3b6 Insert Double.NaN for missing values in bed height factory. Raimund Renkert <rrenkert@intevation.de> parents: 6275 diff changeset	160 height.add(row0, row1, row2, row3, (Integer) row[4]);
3614 68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	161 }
3886 633fbb61a0cc Split bed heights into bed height epochs and single bed heights. Raimund Renkert <raimund.renkert@intevation.de> parents: 3614 diff changeset	162 return height;
3614 68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	163 }
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	164 else if (type.equals("epoch")) {
3886 633fbb61a0cc Split bed heights into bed height epochs and single bed heights. Raimund Renkert <raimund.renkert@intevation.de> parents: 3614 diff changeset	165 BedHeightEpoch height =
633fbb61a0cc Split bed heights into bed height epochs and single bed heights. Raimund Renkert <raimund.renkert@intevation.de> parents: 3614 diff changeset	166 new BedHeightEpoch(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	167 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	168 .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	169 .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	170 .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	171 .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	172 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	173 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	174
4051 58bdf95df5e4 More dead code removal. Minor code clean ups. Sascha L. Teichmann <teichmann@intevation.de> parents: 3897 diff changeset	175 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	176 height.add(
633fbb61a0cc Split bed heights into bed height epochs and single bed heights. Raimund Renkert <raimund.renkert@intevation.de> parents: 3614 diff changeset	177 (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	178 (Double) row[1],
4051 58bdf95df5e4 More dead code removal. Minor code clean ups. Sascha L. Teichmann <teichmann@intevation.de> parents: 3897 diff changeset	179 (Date) row[2],
58bdf95df5e4 More dead code removal. Minor code clean ups. Sascha L. Teichmann <teichmann@intevation.de> parents: 3897 diff changeset	180 (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	181 }
3886 633fbb61a0cc Split bed heights into bed height epochs and single bed heights. Raimund Renkert <raimund.renkert@intevation.de> parents: 3614 diff changeset	182 return height;
3614 68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	183 }
3886 633fbb61a0cc Split bed heights into bed height epochs and single bed heights. Raimund Renkert <raimund.renkert@intevation.de> parents: 3614 diff changeset	184 return new BedHeight();
3614 68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	185 }
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	186 }
68beaa827751 MINFO: Implemented UI and facet/artifact stack for bed height differences. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	187 // 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 @ 6665:b7945db8a43b