Mercurial > dive4elements > river
diff artifacts/src/main/java/org/dive4elements/river/artifacts/model/minfo/FlowVelocityMeasurementFactory.java @ 5838:5aa05a7a34b7
Rename modules to more fitting names.
author | Sascha L. Teichmann <teichmann@intevation.de> |
---|---|
date | Thu, 25 Apr 2013 15:23:37 +0200 |
parents | flys-artifacts/src/main/java/org/dive4elements/river/artifacts/model/minfo/FlowVelocityMeasurementFactory.java@bd047b71ab37 |
children | 4897a58c8746 |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/artifacts/src/main/java/org/dive4elements/river/artifacts/model/minfo/FlowVelocityMeasurementFactory.java Thu Apr 25 15:23:37 2013 +0200 @@ -0,0 +1,53 @@ +package org.dive4elements.river.artifacts.model.minfo; + +import java.util.List; + +import org.apache.log4j.Logger; +import org.hibernate.SQLQuery; +import org.hibernate.Session; + +import org.dive4elements.river.model.FlowVelocityMeasurementValue; +import org.dive4elements.river.backend.SessionHolder; + + +public class FlowVelocityMeasurementFactory +{ + /** Private logger to use here. */ + private static Logger log = Logger.getLogger(FlowVelocityMeasurementFactory.class); + + /** Query to get description and start year, given name and a km range. */ + public static final String SQL_SELECT_ONE = + "SELECT station, datetime, w, q, v, description " + + " FROM flow_velocity_measure_values" + + " WHERE id = :id"; + + + private FlowVelocityMeasurementFactory() { + } + + + public static FlowVelocityMeasurementValue.FastFlowVelocityMeasurementValue + getFlowVelocityMeasurement(int id) + { + log.debug("FlowVelocityMeasurementFactory.getFlowVelocityMeasurementValue"); + Session session = SessionHolder.HOLDER.get(); + SQLQuery sqlQuery = null; + sqlQuery = session.createSQLQuery(SQL_SELECT_ONE); + sqlQuery.setParameter("id", id); + + List<Object []> results = sqlQuery.list(); + if (results.size() > 0) { + Object[] row = results.get(0); + if (row == null || row.length < 6) { + return null; + } + return FlowVelocityMeasurementValue.getUnmapped( + Double.parseDouble(row[0].toString()), + Double.parseDouble(row[2].toString()), + Double.valueOf(row[3].toString()), + Double.valueOf(row[4].toString()), null, row[5].toString()); + } + return null; + } +} +// vim:set ts=4 sw=4 si et sta sts=4 fenc=utf-8 :