Mercurial > dive4elements > river

annotate flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/MainValuesFactory.java @ 3646:3e1149adc8b9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Mark getDurationCurveData method as deprecated flys-artifacts/trunk@5367 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Bjoern Ricks <bjoern.ricks@intevation.de>
date Thu, 06 Sep 2012 12:14:15 +0000
parents 478940d06876
children 421d1b0576b8
rev   line source
330
4791fd92a208 Added a factory that returns MainValues.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
1 package de.intevation.flys.artifacts.model;
4791fd92a208 Added a factory that returns MainValues.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
2
385
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
3 import java.math.BigDecimal;
330
4791fd92a208 Added a factory that returns MainValues.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
4 import java.util.List;
4791fd92a208 Added a factory that returns MainValues.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
5
385
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
6 import org.apache.log4j.Logger;
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
7
330
4791fd92a208 Added a factory that returns MainValues.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
8 import org.hibernate.Session;
4791fd92a208 Added a factory that returns MainValues.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
9 import org.hibernate.Query;
4791fd92a208 Added a factory that returns MainValues.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
10
4791fd92a208 Added a factory that returns MainValues.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
11 import de.intevation.flys.backend.SessionHolder;
4791fd92a208 Added a factory that returns MainValues.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
12
4791fd92a208 Added a factory that returns MainValues.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
13 import de.intevation.flys.model.Gauge;
4791fd92a208 Added a factory that returns MainValues.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
14 import de.intevation.flys.model.MainValue;
4791fd92a208 Added a factory that returns MainValues.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
15
4791fd92a208 Added a factory that returns MainValues.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
16
4791fd92a208 Added a factory that returns MainValues.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
17 /**
4791fd92a208 Added a factory that returns MainValues.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
18 * @author <a href="mailto:ingo.weinzierl@intevation.de">Ingo Weinzierl</a>
4791fd92a208 Added a factory that returns MainValues.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
19 */
4791fd92a208 Added a factory that returns MainValues.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
20 public class MainValuesFactory {
4791fd92a208 Added a factory that returns MainValues.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
21
385
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
22 private static Logger logger = Logger.getLogger(MainValuesFactory.class);
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
23
330
4791fd92a208 Added a factory that returns MainValues.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
24 public static List<MainValue> getMainValues(Gauge gauge) {
4791fd92a208 Added a factory that returns MainValues.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
25 Session session = SessionHolder.HOLDER.get();
4791fd92a208 Added a factory that returns MainValues.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
26
4791fd92a208 Added a factory that returns MainValues.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
27 Query query = session.createQuery(
4791fd92a208 Added a factory that returns MainValues.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
28 "from MainValue where gauge=:gauge");
4791fd92a208 Added a factory that returns MainValues.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
29 query.setParameter("gauge", gauge);
4791fd92a208 Added a factory that returns MainValues.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
30
4791fd92a208 Added a factory that returns MainValues.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
31 return query.list();
4791fd92a208 Added a factory that returns MainValues.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
32 }
385
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
33
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
34
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
35 /**
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
36 * Returns an array of [days, qs] necessary to create duration curves.
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
37 *
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
38 * @param gauge The selected gauge.
3646
3e1149adc8b9 Mark getDurationCurveData method as deprecated
Bjoern Ricks <bjoern.ricks@intevation.de>
parents: 385
diff changeset
39 * @deprecated
385
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
40 *
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
41 * @return a 2dim array of [days, qs] where days is an int[] and qs is
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
42 * an double[].
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
43 */
3646
3e1149adc8b9 Mark getDurationCurveData method as deprecated
Bjoern Ricks <bjoern.ricks@intevation.de>
parents: 385
diff changeset
44 @Deprecated
385
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
45 public static Object[] getDurationCurveData(Gauge gauge) {
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
46 Session session = SessionHolder.HOLDER.get();
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
47
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
48 Query query = session.createQuery(
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
49 "select cast(nmv.name as integer) as days, mv.value as q " +
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
50 "from MainValue as mv " +
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
51 "join mv.mainValue as nmv " +
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
52 "join nmv.type mvt " +
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
53 "where mvt.name = 'D' and mv.gauge.id = :gauge_id " +
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
54 "order by days");
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
55
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
56 query.setParameter("gauge_id", gauge.getId());
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
57
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
58 List<Object> results = query.list();
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
59 int[] days = new int[results.size()];
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
60 double[] qs = new double[results.size()];
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
61
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
62 int idx = 0;
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
63
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
64 for (Object obj: results) {
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
65 Object[] arr = (Object[]) obj;
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
66
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
67 try {
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
68 int day = ((Integer) arr[0]).intValue();
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
69 double q = ((BigDecimal) arr[1]).doubleValue();
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
70
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
71 days[idx] = day;
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
72 qs[idx++] = q;
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
73 }
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
74 catch (NumberFormatException nfe) {
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
75 logger.warn(nfe, nfe);
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
76 }
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
77 }
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
78
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
79 return new Object[] { days, qs };
478940d06876 Enabled the WINFO artifact to create duration curves - new OutGenerator, added methods for data computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 330
diff changeset
80 }
330
4791fd92a208 Added a factory that returns MainValues.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
81 }
4791fd92a208 Added a factory that returns MainValues.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
82 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf-8 :
http://dive4elements.wald.intevation.org