Mercurial > dive4elements > river

annotate backend/src/main/java/org/dive4elements/river/importer/ImportSQRelationValue.java @ 5844:4dd33b86dc61

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added header to river backend.
author Sascha L. Teichmann <teichmann@intevation.de>
date Fri, 26 Apr 2013 08:25:41 +0200
parents 5aa05a7a34b7
children 4c3ccf2b0304
rev   line source
5844
4dd33b86dc61 Added header to river backend.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5838
diff changeset
1 /* Copyright (C) 2011, 2012, 2013 by Bundesanstalt für Gewässerkunde
4dd33b86dc61 Added header to river backend.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5838
diff changeset
2 * Software engineering by Intevation GmbH
4dd33b86dc61 Added header to river backend.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5838
diff changeset
3 *
4dd33b86dc61 Added header to river backend.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5838
diff changeset
4 * This file is Free Software under the GNU AGPL (>=v3)
4dd33b86dc61 Added header to river backend.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5838
diff changeset
5 * and comes with ABSOLUTELY NO WARRANTY! Check out the
4dd33b86dc61 Added header to river backend.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5838
diff changeset
6 * documentation coming with Dive4Elements River for details.
4dd33b86dc61 Added header to river backend.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5838
diff changeset
7 */
4dd33b86dc61 Added header to river backend.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5838
diff changeset
8
5829
18619c1e7c2a Repaired internal references.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5828
diff changeset
9 package org.dive4elements.river.importer;
3328
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
10
5429
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
11 import java.math.BigDecimal;
3328
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
12 import java.sql.SQLException;
3329
cc8fc6b29649 Store sq relations into database after parsing.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3328
diff changeset
13 import java.util.List;
3328
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
14
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
15 import org.apache.log4j.Logger;
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
16
3329
cc8fc6b29649 Store sq relations into database after parsing.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3328
diff changeset
17 import org.hibernate.Query;
cc8fc6b29649 Store sq relations into database after parsing.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3328
diff changeset
18 import org.hibernate.Session;
3328
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
19 import org.hibernate.exception.ConstraintViolationException;
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
20
5829
18619c1e7c2a Repaired internal references.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5828
diff changeset
21 import org.dive4elements.river.model.MeasurementStation;
18619c1e7c2a Repaired internal references.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5828
diff changeset
22 import org.dive4elements.river.model.SQRelation;
18619c1e7c2a Repaired internal references.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5828
diff changeset
23 import org.dive4elements.river.model.SQRelationValue;
3328
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
24
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
25
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
26 public class ImportSQRelationValue {
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
27
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
28 private static Logger log = Logger.getLogger(ImportSQRelationValue.class);
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
29
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
30
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
31 private SQRelationValue peer;
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
32
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
33 private String parameter;
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
34
5429
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
35 private Double km;
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
36 private Double a;
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
37 private Double b;
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
38 private Double qMax;
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
39 private Double rSQ;
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
40 private Integer nTot;
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
41 private Integer nOutlier;
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
42 private Double cFerguson;
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
43 private Double cDuan;
3328
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
44
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
45
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
46 public ImportSQRelationValue(
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
47 String parameter,
5429
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
48 Double km,
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
49 Double a,
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
50 Double b,
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
51 Double qMax,
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
52 Double rSQ,
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
53 Integer nTot,
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
54 Integer nOutlier,
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
55 Double cFerguson,
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
56 Double cDuan
3328
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
57 ) {
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
58 this.parameter = parameter;
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
59 this.km = km;
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
60 this.a = a;
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
61 this.b = b;
5429
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
62 this.qMax = qMax;
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
63 this.rSQ = rSQ;
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
64 this.nTot = nTot;
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
65 this.nOutlier = nOutlier;
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
66 this.cFerguson = cFerguson;
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
67 this.cDuan = cDuan;
3328
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
68 }
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
69
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
70
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
71 public void storeDependencies(SQRelation owner)
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
72 throws SQLException, ConstraintViolationException
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
73 {
3329
cc8fc6b29649 Store sq relations into database after parsing.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3328
diff changeset
74 getPeer(owner);
3328
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
75 }
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
76
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
77
3329
cc8fc6b29649 Store sq relations into database after parsing.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3328
diff changeset
78 public SQRelationValue getPeer(SQRelation owner) {
cc8fc6b29649 Store sq relations into database after parsing.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3328
diff changeset
79 if (peer == null) {
cc8fc6b29649 Store sq relations into database after parsing.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3328
diff changeset
80 Session session = ImporterSession.getInstance().getDatabaseSession();
3328
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
81
3329
cc8fc6b29649 Store sq relations into database after parsing.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3328
diff changeset
82 Query query = session.createQuery(
5429
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
83 "from MeasurementStation " +
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
84 " where station between :kml and :kmh");
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
85 query.setDouble("kml", km - 1e-4);
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
86 query.setDouble("kmh", km + 1e-4);
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
87
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
88 List<MeasurementStation> result = query.list();
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
89
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
90 if (result.isEmpty()) {
5521
bc140668db82 Morpho-Importer: small logging improvements
Tom Gottfried <tom.gottfried@intevation.de>
parents: 5458
diff changeset
91 log.error("No measurement stations found at km " + km);
5429
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
92 return null;
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
93 }
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
94
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
95 Query query2 = session.createQuery(
3329
cc8fc6b29649 Store sq relations into database after parsing.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3328
diff changeset
96 "from SQRelationValue " +
cc8fc6b29649 Store sq relations into database after parsing.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3328
diff changeset
97 " where sqRelation=:owner " +
cc8fc6b29649 Store sq relations into database after parsing.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3328
diff changeset
98 " and parameter=:parameter" +
5429
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
99 " and measurementStation=:measurementStation" +
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
100 " and a=:a" +
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
101 " and b=:b" +
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
102 " and qMax=:qMax" +
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
103 " and rSQ=:rSQ" +
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
104 " and cFerguson=:cFerguson" +
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
105 " and cDuan=:cDuan");
3329
cc8fc6b29649 Store sq relations into database after parsing.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3328
diff changeset
106
5429
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
107 query2.setParameter("owner", owner);
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
108 query2.setString("parameter", parameter);
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
109 query2.setParameter("measurementStation", result.get(0));
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
110 query2.setBigDecimal("a", toBigDecimal(a));
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
111 query2.setBigDecimal("b", toBigDecimal(b));
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
112 query2.setBigDecimal("qMax", toBigDecimal(qMax));
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
113 query2.setBigDecimal("rSQ", toBigDecimal(rSQ));
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
114 query2.setBigDecimal("cFerguson", toBigDecimal(cFerguson));
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
115 query2.setBigDecimal("cDuan", toBigDecimal(cDuan));
3329
cc8fc6b29649 Store sq relations into database after parsing.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3328
diff changeset
116
5429
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
117 List<SQRelationValue> values = query2.list();
3329
cc8fc6b29649 Store sq relations into database after parsing.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3328
diff changeset
118
cc8fc6b29649 Store sq relations into database after parsing.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3328
diff changeset
119 if (values.isEmpty()) {
cc8fc6b29649 Store sq relations into database after parsing.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3328
diff changeset
120 peer = new SQRelationValue(
cc8fc6b29649 Store sq relations into database after parsing.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3328
diff changeset
121 owner,
cc8fc6b29649 Store sq relations into database after parsing.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3328
diff changeset
122 parameter,
5429
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
123 result.get(0),
3329
cc8fc6b29649 Store sq relations into database after parsing.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3328
diff changeset
124 a,
5429
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
125 b,
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
126 qMax,
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
127 rSQ,
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
128 nTot,
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
129 nOutlier,
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
130 cFerguson,
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
131 cDuan
3329
cc8fc6b29649 Store sq relations into database after parsing.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3328
diff changeset
132 );
cc8fc6b29649 Store sq relations into database after parsing.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3328
diff changeset
133
cc8fc6b29649 Store sq relations into database after parsing.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3328
diff changeset
134 session.save(peer);
cc8fc6b29649 Store sq relations into database after parsing.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3328
diff changeset
135 }
cc8fc6b29649 Store sq relations into database after parsing.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3328
diff changeset
136 else {
cc8fc6b29649 Store sq relations into database after parsing.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3328
diff changeset
137 peer = values.get(0);
cc8fc6b29649 Store sq relations into database after parsing.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3328
diff changeset
138 }
3328
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
139 }
5429
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
140 return peer;
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
141 }
3328
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
142
5429
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
143 private static final BigDecimal toBigDecimal(Double x) {
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
144 if (x == null) return null;
13596605e81f Added new columns to sq relation importer to import all values from csv and use
Raimund Renkert <rrenkert@intevation.de>
parents: 3329
diff changeset
145 return new BigDecimal(x);
3328
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
146 }
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
147 }
a41f279a66e2 Added parser and import classes to import MINFO sq relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
148 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :
http://dive4elements.wald.intevation.org