Mercurial > dive4elements > river

annotate artifacts/src/main/java/org/dive4elements/river/artifacts/model/WstFactory.java @ 8962:708f210ff242

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fetching year informations for waterlevels used in sinfo
author gernotbelger
date Wed, 28 Mar 2018 17:03:11 +0200
parents af13ceeba52a
children
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: 622
diff changeset
9 package org.dive4elements.river.artifacts.model;
318
8a4360ccbe1c Added a WstFactory to return Wst objects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
10
8a4360ccbe1c Added a WstFactory to return Wst objects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
11 import java.util.List;
8a4360ccbe1c Added a WstFactory to return Wst objects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
12
5831
bd047b71ab37 Repaired internal references
Sascha L. Teichmann <teichmann@intevation.de>
parents: 622
diff changeset
13 import org.dive4elements.river.backend.SessionHolder;
bd047b71ab37 Repaired internal references
Sascha L. Teichmann <teichmann@intevation.de>
parents: 622
diff changeset
14 import org.dive4elements.river.model.River;
bd047b71ab37 Repaired internal references
Sascha L. Teichmann <teichmann@intevation.de>
parents: 622
diff changeset
15 import org.dive4elements.river.model.Wst;
318
8a4360ccbe1c Added a WstFactory to return Wst objects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
16
8a4360ccbe1c Added a WstFactory to return Wst objects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
17 import org.hibernate.Query;
8a4360ccbe1c Added a WstFactory to return Wst objects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
18 import org.hibernate.Session;
8a4360ccbe1c Added a WstFactory to return Wst objects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
19
8a4360ccbe1c Added a WstFactory to return Wst objects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
20 /**
8a4360ccbe1c Added a WstFactory to return Wst objects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
21 * @author <a href="mailto:ingo.weinzierl@intevation.de">Ingo Weinzierl</a>
8a4360ccbe1c Added a WstFactory to return Wst objects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
22 */
8a4360ccbe1c Added a WstFactory to return Wst objects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
23 public class WstFactory {
8a4360ccbe1c Added a WstFactory to return Wst objects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
24
622
02ca2ff96dee flys/issue84: Forget to select wst kind.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 318
diff changeset
25 public static final int DEFAULT_KIND = 0;
02ca2ff96dee flys/issue84: Forget to select wst kind.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 318
diff changeset
26
318
8a4360ccbe1c Added a WstFactory to return Wst objects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
27 /** We don't need to instantiate concrete objects of this class. */
8a4360ccbe1c Added a WstFactory to return Wst objects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
28 private WstFactory() {
8a4360ccbe1c Added a WstFactory to return Wst objects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
29 }
8a4360ccbe1c Added a WstFactory to return Wst objects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
30
8a4360ccbe1c Added a WstFactory to return Wst objects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
31
8a4360ccbe1c Added a WstFactory to return Wst objects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
32 /**
8a4360ccbe1c Added a WstFactory to return Wst objects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
33 * Returns the Wst object for a given river.
8a4360ccbe1c Added a WstFactory to return Wst objects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
34 *
8a4360ccbe1c Added a WstFactory to return Wst objects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
35 * @param river The river.
8a4360ccbe1c Added a WstFactory to return Wst objects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
36 *
8a4360ccbe1c Added a WstFactory to return Wst objects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
37 * @return the Wst of <i>river</i>.
8a4360ccbe1c Added a WstFactory to return Wst objects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
38 */
8a4360ccbe1c Added a WstFactory to return Wst objects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
39 public static Wst getWst(River river) {
622
02ca2ff96dee flys/issue84: Forget to select wst kind.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 318
diff changeset
40 return getWst(river, DEFAULT_KIND);
02ca2ff96dee flys/issue84: Forget to select wst kind.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 318
diff changeset
41 }
02ca2ff96dee flys/issue84: Forget to select wst kind.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 318
diff changeset
42
02ca2ff96dee flys/issue84: Forget to select wst kind.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 318
diff changeset
43 public static Wst getWst(River river, int kind) {
318
8a4360ccbe1c Added a WstFactory to return Wst objects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
44 Session session = SessionHolder.HOLDER.get();
8a4360ccbe1c Added a WstFactory to return Wst objects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
45
8a4360ccbe1c Added a WstFactory to return Wst objects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
46 Query query = session.createQuery(
622
02ca2ff96dee flys/issue84: Forget to select wst kind.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 318
diff changeset
47 "from Wst where river=:river and kind = :kind");
318
8a4360ccbe1c Added a WstFactory to return Wst objects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
48 query.setParameter("river", river);
622
02ca2ff96dee flys/issue84: Forget to select wst kind.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 318
diff changeset
49 query.setInteger("kind", kind);
318
8a4360ccbe1c Added a WstFactory to return Wst objects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
50
622
02ca2ff96dee flys/issue84: Forget to select wst kind.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 318
diff changeset
51 List<Wst> wsts = query.list();
318
8a4360ccbe1c Added a WstFactory to return Wst objects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
52
622
02ca2ff96dee flys/issue84: Forget to select wst kind.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 318
diff changeset
53 return wsts.isEmpty() ? null : wsts.get(0);
318
8a4360ccbe1c Added a WstFactory to return Wst objects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
54 }
8962
708f210ff242 Fetching year informations for waterlevels used in sinfo
gernotbelger
parents: 5994
diff changeset
55
708f210ff242 Fetching year informations for waterlevels used in sinfo
gernotbelger
parents: 5994
diff changeset
56
708f210ff242 Fetching year informations for waterlevels used in sinfo
gernotbelger
parents: 5994
diff changeset
57 public static Wst getWst(final int id) {
708f210ff242 Fetching year informations for waterlevels used in sinfo
gernotbelger
parents: 5994
diff changeset
58 final Session session = SessionHolder.HOLDER.get();
708f210ff242 Fetching year informations for waterlevels used in sinfo
gernotbelger
parents: 5994
diff changeset
59
708f210ff242 Fetching year informations for waterlevels used in sinfo
gernotbelger
parents: 5994
diff changeset
60 final Query query = session.createQuery("from Wst where id=:id");
708f210ff242 Fetching year informations for waterlevels used in sinfo
gernotbelger
parents: 5994
diff changeset
61 query.setInteger("id", id);
708f210ff242 Fetching year informations for waterlevels used in sinfo
gernotbelger
parents: 5994
diff changeset
62
708f210ff242 Fetching year informations for waterlevels used in sinfo
gernotbelger
parents: 5994
diff changeset
63 final List<Wst> wsts = query.list();
708f210ff242 Fetching year informations for waterlevels used in sinfo
gernotbelger
parents: 5994
diff changeset
64
708f210ff242 Fetching year informations for waterlevels used in sinfo
gernotbelger
parents: 5994
diff changeset
65 return wsts.isEmpty() ? null : wsts.get(0);
708f210ff242 Fetching year informations for waterlevels used in sinfo
gernotbelger
parents: 5994
diff changeset
66 }
318
8a4360ccbe1c Added a WstFactory to return Wst objects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
67 }
8a4360ccbe1c Added a WstFactory to return Wst objects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
68 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf-8 :
http://dive4elements.wald.intevation.org