Mercurial > dive4elements > river
view backend/src/main/java/org/dive4elements/river/importer/ImportPorosityValue.java @ 8032:fd3a24336e6a
SCHEMA CHANGE and Importer (only longitudinal section data so far): only grain fractions given now in schema are valid. We are handling sediment loads, not yields.
author | "Tom Gottfried <tom@intevation.de>" |
---|---|
date | Mon, 14 Jul 2014 15:36:44 +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 :