comparison backend/src/main/java/org/dive4elements/river/importer/sinfo/importitem/CollisionKmLineImport.java @ 8971:50416a0df385

Importer for the Schifffahrt (S-INFO) and Oekologie (U-INFO) files
author mschaefer
date Tue, 03 Apr 2018 10:18:30 +0200
parents
children
comparison
equal deleted inserted replaced
8970:da5dc7446652 8971:50416a0df385
1 /* Copyright (C) 2017 by Bundesanstalt für Gewässerkunde
2 * Software engineering by
3 * Björnsen Beratende Ingenieure GmbH
4 * Dr. Schumacher Ingenieurbüro für Wasser und Umwelt
5 *
6 * This file is Free Software under the GNU AGPL (>=v3)
7 * and comes with ABSOLUTELY NO WARRANTY! Check out the
8 * documentation coming with Dive4Elements River for details.
9 */
10
11 package org.dive4elements.river.importer.sinfo.importitem;
12
13 import java.util.Date;
14 import java.util.List;
15
16 import org.dive4elements.river.importer.common.AbstractKmLineImport;
17 import org.dive4elements.river.model.sinfo.Collision;
18 import org.dive4elements.river.model.sinfo.CollisionValue;
19 import org.hibernate.Query;
20 import org.hibernate.Session;
21
22 /**
23 * Imported collision event of a river station.
24 *
25 * @author Matthias Schäfer
26 *
27 */
28 public class CollisionKmLineImport extends AbstractKmLineImport<Collision, CollisionValue> {
29
30 /***** FIELDS *****/
31
32 private final CollisionTypeImport collisionType;
33
34 private final Date eventDate;
35
36 private final String gaugeName;
37
38 private final double gaugeW;
39
40
41 /***** CONSTRUCTOR *****/
42
43 public CollisionKmLineImport(final Double km, final CollisionTypeImport collisionType, final Date eventDate, final String gaugeName, final double gaugeW) {
44 super(km.doubleValue());
45 this.collisionType = collisionType;
46 this.eventDate = eventDate;
47 this.gaugeName = gaugeName;
48 this.gaugeW = gaugeW;
49 }
50
51
52 /***** METHODS *****/
53
54 @Override
55 protected CollisionValue queryValueItem(final Session session, final Collision parent) {
56 final Query query = session.createQuery("FROM CollisionValue WHERE (collision=:parent) AND (eventDate=:eventdate)"
57 + " AND (station BETWEEN (:station-0.0001) AND (:station+0.0001))");
58 query.setParameter("parent", parent);
59 query.setParameter("station", this.station);
60 query.setParameter("eventdate", this.eventDate);
61 final List rows = query.list();
62 if (!rows.isEmpty())
63 return (CollisionValue) rows.get(0);
64 else
65 return null;
66 }
67
68
69 @Override
70 protected CollisionValue createValueItem(final Collision parent) {
71 return new CollisionValue(parent, this.station, this.collisionType.getPeer(), this.eventDate, this.gaugeName, this.gaugeW);
72 }
73 }

http://dive4elements.wald.intevation.org