Mercurial > dive4elements > river
view backend/src/main/java/org/dive4elements/river/importer/ImportFlowVelocityMeasurementValue.java @ 6609:6d55614d6f87
Change artifact database v param to be type TEXT
This is neccessary for large theme lists for example in the
map. The 256 chars limit could easily be overtaken.
I am using this for quite some time now and the upcoming version
appears to be a good place to test this.
author | Andre Heinecke <aheinecke@intevation.de> |
---|---|
date | Thu, 18 Jul 2013 17:53:11 +0200 |
parents | 4c3ccf2b0304 |
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.Date; import java.util.List; import org.apache.log4j.Logger; import org.hibernate.Session; import org.hibernate.Query; import org.dive4elements.river.model.FlowVelocityMeasurement; import org.dive4elements.river.model.FlowVelocityMeasurementValue; public class ImportFlowVelocityMeasurementValue { private static final Logger log = Logger.getLogger(ImportFlowVelocityMeasurementValue.class); private Date datetime; private String description; private BigDecimal station; private BigDecimal w; private BigDecimal q; private BigDecimal v; private FlowVelocityMeasurementValue peer; public ImportFlowVelocityMeasurementValue( Date datetime, BigDecimal station, BigDecimal w, BigDecimal q, BigDecimal v, String description ) { this.datetime = datetime; this.station = station; this.w = w; this.q = q; this.v = v; this.description = description; } public void storeDependencies(FlowVelocityMeasurement measurement) { log.debug("store dependencies"); getPeer(measurement); } public FlowVelocityMeasurementValue getPeer(FlowVelocityMeasurement m) { if (peer == null) { Session session = ImporterSession.getInstance().getDatabaseSession(); Query query = session.createQuery( "from FlowVelocityMeasurementValue where " + " measurement=:measurement and " + " station=:station and " + " datetime=:datetime" ); query.setParameter("measurement", m); query.setParameter("station", station); query.setParameter("datetime", datetime); List<FlowVelocityMeasurementValue> values = query.list(); if (values.isEmpty()) { peer = new FlowVelocityMeasurementValue( m, datetime, station, w, q, v, description); session.save(peer); } else { peer = values.get(0); } } return peer; } } // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :