Mercurial > dive4elements > river

annotate artifacts/src/main/java/org/dive4elements/river/artifacts/model/WKmsFactory.java @ 7300:83bb52fa0c32

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
(issue1529) Be more tolerant in the fitting. The invalid value warning is removed because invalid data is expected there when datapoints are not valid for this KM
author Andre Heinecke <aheinecke@intevation.de>
date Fri, 11 Oct 2013 18:40:33 +0200
parents af13ceeba52a
children 7484132b2fbb
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;
1722
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
10
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
11 import java.util.List;
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
12
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
13 import net.sf.ehcache.Cache;
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
14 import net.sf.ehcache.Element;
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
15
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
16 import org.apache.log4j.Logger;
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
17
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
18 import org.hibernate.Session;
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
19
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
20 import org.hibernate.SQLQuery;
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
21 import org.hibernate.type.StandardBasicTypes;
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@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;
1722
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
24
5831
bd047b71ab37 Repaired internal references
Sascha L. Teichmann <teichmann@intevation.de>
parents: 4051
diff changeset
25 import org.dive4elements.river.backend.SessionHolder;
1722
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
26
3442
cd5eb8f5f6f1 Cosmetics, docs.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 3317
diff changeset
27
1722
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
28 /**
3076
5642a83420f2 FLYS artifacts: Removed trailing whitespace.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 1897
diff changeset
29 * Factory to access ready-made WKms for other (than computed) 'kinds' of
1722
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
30 * WST-data.
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
31 */
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
32 public class WKmsFactory
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
33 {
3442
cd5eb8f5f6f1 Cosmetics, docs.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 3317
diff changeset
34 /** Private logger to use here. */
1722
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
35 private static Logger log = Logger.getLogger(WKmsFactory.class);
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
36
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
37 /** Query to get km and ws for wst_id and column_pos. */
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
38 public static final String SQL_SELECT_WS =
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
39 "SELECT km, w FROM wst_w_values " +
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
40 "WHERE wst_id = :wst_id AND column_pos = :column_pos";
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
41
1729
2e5ebdeb8af9 Give StaticWKmsArtifacts proper names, and pre-deselect them.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1726
diff changeset
42 /** Query to get name for wst_id and column_pos. */
1726
e3b9164a85fe Fetch name of static WKms.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1722
diff changeset
43 public static final String SQL_SELECT_NAME =
e3b9164a85fe Fetch name of static WKms.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1722
diff changeset
44 "SELECT name " +
e3b9164a85fe Fetch name of static WKms.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1722
diff changeset
45 "FROM wst_columns "+
e3b9164a85fe Fetch name of static WKms.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1722
diff changeset
46 "WHERE wst_id = :wst_id AND position = :column_pos";
e3b9164a85fe Fetch name of static WKms.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1722
diff changeset
47
1892
eef657302834 Added function to get name/description of Wst.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1796
diff changeset
48 /** Query to get name (description) for wst_id. */
eef657302834 Added function to get name/description of Wst.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1796
diff changeset
49 public static final String SQL_SELECT_WST_NAME =
eef657302834 Added function to get name/description of Wst.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1796
diff changeset
50 "SELECT description from wsts "+
1897
cf8a376eb4c9 Fix and use SQL statement to fetch wst-names.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1893
diff changeset
51 "WHERE id = :wst_id";
1892
eef657302834 Added function to get name/description of Wst.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1796
diff changeset
52
1722
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
53
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
54 private WKmsFactory() {
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
55 }
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
56
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
57
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
58 /**
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
59 * Get WKms for given column and wst_id, caring about the cache.
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
60 */
1726
e3b9164a85fe Fetch name of static WKms.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1722
diff changeset
61 public static WKms getWKms(int column, int wst_id) {
1722
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
62 log.debug("WKmsFactory.getWKms");
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
63 Cache cache = CacheFactory.getCache(StaticWKmsCacheKey.CACHE_NAME);
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
64
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
65 StaticWKmsCacheKey cacheKey;
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
66
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
67 if (cache != null) {
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
68 cacheKey = new StaticWKmsCacheKey(wst_id, column);
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
69 Element element = cache.get(cacheKey);
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
70 if (element != null) {
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
71 log.debug("Got static wst values from cache");
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
72 return (WKms)element.getValue();
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
73 }
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
74 }
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
75 else {
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
76 cacheKey = null;
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
77 }
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
78
1726
e3b9164a85fe Fetch name of static WKms.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1722
diff changeset
79 WKms values = getWKmsUncached(column, wst_id);
1722
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
80
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
81 if (values != null && cacheKey != null) {
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
82 log.debug("Store static wst values in cache.");
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
83 Element element = new Element(cacheKey, values);
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
84 cache.put(element);
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
85 }
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
86 return values;
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
87 }
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
88
1892
eef657302834 Added function to get name/description of Wst.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1796
diff changeset
89 /** Get name for a WKms. */
1893
1cf36ffe69b5 Fix definition.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1892
diff changeset
90 public static String getWKmsName(int wst_id) {
1892
eef657302834 Added function to get name/description of Wst.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1796
diff changeset
91 log.debug("WKmsFactory.getWKmsName wst_id/" + wst_id);
eef657302834 Added function to get name/description of Wst.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1796
diff changeset
92
eef657302834 Added function to get name/description of Wst.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1796
diff changeset
93 String name = null;
eef657302834 Added function to get name/description of Wst.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1796
diff changeset
94 Session session = SessionHolder.HOLDER.get();
eef657302834 Added function to get name/description of Wst.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1796
diff changeset
95
1897
cf8a376eb4c9 Fix and use SQL statement to fetch wst-names.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1893
diff changeset
96 SQLQuery nameQuery = session.createSQLQuery(SQL_SELECT_WST_NAME)
cf8a376eb4c9 Fix and use SQL statement to fetch wst-names.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1893
diff changeset
97 .addScalar("description", StandardBasicTypes.STRING);
1892
eef657302834 Added function to get name/description of Wst.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1796
diff changeset
98 nameQuery.setInteger("wst_id", wst_id);
eef657302834 Added function to get name/description of Wst.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1796
diff changeset
99
eef657302834 Added function to get name/description of Wst.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1796
diff changeset
100 List<String> names = nameQuery.list();
eef657302834 Added function to get name/description of Wst.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1796
diff changeset
101 if (names.size() >= 1) {
eef657302834 Added function to get name/description of Wst.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1796
diff changeset
102 name = names.get(0);
eef657302834 Added function to get name/description of Wst.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1796
diff changeset
103 }
eef657302834 Added function to get name/description of Wst.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1796
diff changeset
104
eef657302834 Added function to get name/description of Wst.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1796
diff changeset
105 return name;
eef657302834 Added function to get name/description of Wst.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1796
diff changeset
106 }
1722
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
107
1729
2e5ebdeb8af9 Give StaticWKmsArtifacts proper names, and pre-deselect them.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1726
diff changeset
108 /** Get name for a WKms. */
2e5ebdeb8af9 Give StaticWKmsArtifacts proper names, and pre-deselect them.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1726
diff changeset
109 public static String getWKmsName(int column, int wst_id) {
2e5ebdeb8af9 Give StaticWKmsArtifacts proper names, and pre-deselect them.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1726
diff changeset
110 log.debug("WKmsFactory.getWKmsName c/" + column + ", wst_id/" + wst_id);
2e5ebdeb8af9 Give StaticWKmsArtifacts proper names, and pre-deselect them.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1726
diff changeset
111
2e5ebdeb8af9 Give StaticWKmsArtifacts proper names, and pre-deselect them.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1726
diff changeset
112 String name = null;
1722
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
113 Session session = SessionHolder.HOLDER.get();
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
114
1726
e3b9164a85fe Fetch name of static WKms.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1722
diff changeset
115 SQLQuery nameQuery = session.createSQLQuery(SQL_SELECT_NAME)
e3b9164a85fe Fetch name of static WKms.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1722
diff changeset
116 .addScalar("name", StandardBasicTypes.STRING);
e3b9164a85fe Fetch name of static WKms.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1722
diff changeset
117 nameQuery.setInteger("wst_id", wst_id);
e3b9164a85fe Fetch name of static WKms.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1722
diff changeset
118 nameQuery.setInteger("column_pos", column);
e3b9164a85fe Fetch name of static WKms.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1722
diff changeset
119
e3b9164a85fe Fetch name of static WKms.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1722
diff changeset
120 List<String> names = nameQuery.list();
e3b9164a85fe Fetch name of static WKms.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1722
diff changeset
121 if (names.size() >= 1) {
e3b9164a85fe Fetch name of static WKms.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1722
diff changeset
122 name = names.get(0);
e3b9164a85fe Fetch name of static WKms.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1722
diff changeset
123 }
e3b9164a85fe Fetch name of static WKms.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1722
diff changeset
124
1729
2e5ebdeb8af9 Give StaticWKmsArtifacts proper names, and pre-deselect them.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1726
diff changeset
125 return name;
2e5ebdeb8af9 Give StaticWKmsArtifacts proper names, and pre-deselect them.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1726
diff changeset
126 }
1726
e3b9164a85fe Fetch name of static WKms.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1722
diff changeset
127
1729
2e5ebdeb8af9 Give StaticWKmsArtifacts proper names, and pre-deselect them.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1726
diff changeset
128
2e5ebdeb8af9 Give StaticWKmsArtifacts proper names, and pre-deselect them.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1726
diff changeset
129 /**
2e5ebdeb8af9 Give StaticWKmsArtifacts proper names, and pre-deselect them.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1726
diff changeset
130 * Get WKms from db.
2e5ebdeb8af9 Give StaticWKmsArtifacts proper names, and pre-deselect them.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1726
diff changeset
131 * @param column the position columns value
2e5ebdeb8af9 Give StaticWKmsArtifacts proper names, and pre-deselect them.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1726
diff changeset
132 * @param wst_id database id of the wst
2e5ebdeb8af9 Give StaticWKmsArtifacts proper names, and pre-deselect them.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1726
diff changeset
133 * @return according WKms.
2e5ebdeb8af9 Give StaticWKmsArtifacts proper names, and pre-deselect them.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1726
diff changeset
134 */
2e5ebdeb8af9 Give StaticWKmsArtifacts proper names, and pre-deselect them.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1726
diff changeset
135 public static WKms getWKmsUncached(int column, int wst_id) {
1796
ae6ace900c07 Small loop optimization
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 1729
diff changeset
136
ae6ace900c07 Small loop optimization
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 1729
diff changeset
137 if (log.isDebugEnabled()) {
ae6ace900c07 Small loop optimization
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 1729
diff changeset
138 log.debug("WKmsFactory.getWKmsUncached c/" + column + ", wst_id/" + wst_id);
ae6ace900c07 Small loop optimization
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 1729
diff changeset
139 }
1729
2e5ebdeb8af9 Give StaticWKmsArtifacts proper names, and pre-deselect them.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1726
diff changeset
140
2e5ebdeb8af9 Give StaticWKmsArtifacts proper names, and pre-deselect them.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1726
diff changeset
141 WKmsImpl wkms = new WKmsImpl(getWKmsName(column, wst_id));
2e5ebdeb8af9 Give StaticWKmsArtifacts proper names, and pre-deselect them.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1726
diff changeset
142
2e5ebdeb8af9 Give StaticWKmsArtifacts proper names, and pre-deselect them.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 1726
diff changeset
143 Session session = SessionHolder.HOLDER.get();
1722
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
144 SQLQuery sqlQuery = session.createSQLQuery(SQL_SELECT_WS)
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
145 .addScalar("km", StandardBasicTypes.DOUBLE)
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
146 .addScalar("w", StandardBasicTypes.DOUBLE);
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
147 sqlQuery.setInteger("wst_id", wst_id);
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
148 sqlQuery.setInteger("column_pos", column);
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
149
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
150 List<Object []> results = sqlQuery.list();
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
151
1796
ae6ace900c07 Small loop optimization
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 1729
diff changeset
152 for (int i = 0, N = results.size(); i < N; i++) {
1722
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
153 Object[] row = results.get(i);
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
154 wkms.add((Double) row[0], (Double) row[1]);
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
155 }
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
156
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
157 return wkms;
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
158 }
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
159 }
fb4fb1c67c35 Added WKmsFactory.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents:
diff changeset
160 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :
http://dive4elements.wald.intevation.org