Mercurial > dive4elements > river
view backend/src/main/java/org/dive4elements/river/importer/ImportPorosityValue.java @ 8975:a0a0a7f912ab
Added new columns bed_height.comment and sounding_width_info; extended the bed height parser for the new meta data and the min/max_height columns
author | mschaefer |
---|---|
date | Tue, 03 Apr 2018 10:40:57 +0200 |
parents | 5e38e2924c07 |
children | 392bbcd8a88b 0a5239a1e46e |
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 :