Mercurial > dive4elements > river
view backend/src/main/java/org/dive4elements/river/importer/ImportPorosityValue.java @ 8691:bfca77cbf353
(issue1750) There can be only one SQ-relation of a parameter for a time range (given by sq_relation_id) per station and some other attributes might be null.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Fri, 17 Apr 2015 14:55:42 +0200 |
parents | cdef048c4ac5 |
children | 5e38e2924c07 |
line wrap: on
line source
/* Copyright (C) 2011, 2012, 2013 by Bundesanstalt für Gewässerkunde * Software engineering by Intevation GmbH * * This file is Free Software under the GNU AGPL (>=v3) * and comes with ABSOLUTELY NO WARRANTY! Check out the * documentation coming with Dive4Elements River for details. */ package org.dive4elements.river.importer; import java.math.BigDecimal; import java.util.List; import org.apache.log4j.Logger; import org.hibernate.Session; import org.hibernate.Query; import org.dive4elements.river.model.Porosity; import org.dive4elements.river.model.PorosityValue; public class ImportPorosityValue { private static final Logger log = Logger.getLogger(ImportPorosityValue.class); protected PorosityValue peer; protected BigDecimal station; protected BigDecimal shoreOffset; protected BigDecimal porosity; protected String description; public ImportPorosityValue( BigDecimal station, BigDecimal shoreOffset, BigDecimal porosity, String description ) { this.station = station; this.shoreOffset = shoreOffset; this.porosity = porosity; this.description = description; } public void storeDependencies(Porosity porosity) { log.info("store dependencies"); getPeer(porosity); } public PorosityValue getPeer(Porosity porosity) { log.info("get peer"); if (peer == null) { Session session = ImporterSession.getInstance().getDatabaseSession(); Query query = session.createQuery( "from PorosityValue where " + " porosity=:porosity and " + " station between :station - 0.0001f and :station + 0.0001f and" + " porosityValue between :poros -0.0001f and :poros + 0.0001f and" + " description=:description"); query.setParameter("porosity", porosity); query.setParameter("station", station.floatValue()); query.setParameter("poros", this.porosity.floatValue()); query.setParameter("description", description); List<PorosityValue> values = query.list(); if (values.isEmpty()) { log.debug("Create new PorosityValue DB instance."); peer = new PorosityValue( porosity, station, shoreOffset, this.porosity, description); session.save(peer); } else { peer = values.get(0); } } return peer; } } // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :