Java tutorial
/** * Copyright (C) 2012-2015 52North Initiative for Geospatial Open Source * Software GmbH * * This program is free software; you can redistribute it and/or modify it * under the terms of the GNU General Public License version 2 as published * by the Free Software Foundation. * * If the program is linked with libraries which are licensed under one of * the following licenses, the combination of the program with the linked * library is not considered a "derivative work" of the program: * * - Apache License, version 2.0 * - Apache Software License, version 1.0 * - GNU Lesser General Public License, version 3 * - Mozilla Public License, versions 1.0, 1.1 and 2.0 * - Common Development and Distribution License (CDDL), version 1.0 * * Therefore the distribution of the program linked with libraries licensed * under the aforementioned licenses, is permitted by the copyright holders * if the distribution is compliant with both the GNU General Public * License version 2 and the aforementioned licenses. * * This program is distributed in the hope that it will be useful, but * WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General * Public License for more details. */ package org.n52.sos.ds.hibernate.dao.series; import org.hibernate.Criteria; import org.hibernate.Session; import org.hibernate.criterion.Criterion; import org.hibernate.criterion.ProjectionList; import org.hibernate.criterion.Projections; import org.hibernate.criterion.Restrictions; import org.n52.sos.ds.hibernate.dao.AbstractValueTimeDAO; import org.n52.sos.ds.hibernate.entities.AbstractObservationTime; import org.n52.sos.ds.hibernate.entities.Offering; import org.n52.sos.ds.hibernate.entities.series.Series; import org.n52.sos.ds.hibernate.entities.series.values.SeriesValueTime; import org.n52.sos.ds.hibernate.util.HibernateHelper; import org.n52.sos.ds.hibernate.util.ObservationTimeExtrema; import org.n52.sos.ogc.ows.OwsExceptionReport; import org.n52.sos.ogc.sos.SosConstants.SosIndeterminateTime; import org.n52.sos.request.GetObservationRequest; import org.n52.sos.util.CollectionHelper; import org.n52.sos.util.DateTimeHelper; import org.slf4j.Logger; import org.slf4j.LoggerFactory; /** * Abstract value time data access object class for {@link SeriesValueTime} * * @author Carsten Hollmann <c.hollmann@52north.org> * @since 4.3.0 * */ public abstract class AbstractSeriesValueTimeDAO extends AbstractValueTimeDAO { private static final Logger LOGGER = LoggerFactory.getLogger(AbstractSeriesValueTimeDAO.class); /** * Get the concrete {@link SeriesValueTime} class. * * @return The concrete {@link SeriesValueTime} class */ protected abstract Class<?> getSeriesValueTimeClass(); /** * Get {@link ObservationTimeExtrema} for a {@link Series} with temporal * filter. * * @param request * {@link GetObservationRequest} request * @param series * {@link Series} to get time extrema for * @param temporalFilterCriterion * Temporal filter * @param session * Hibernate session * @return Time extrema for {@link Series} * @throws OwsExceptionReport * If an error occurs */ public ObservationTimeExtrema getTimeExtremaForSeries(GetObservationRequest request, long series, Criterion temporalFilterCriterion, Session session) throws OwsExceptionReport { Criteria c = getSeriesValueCriteriaFor(request, series, temporalFilterCriterion, null, session); addMinMaxTimeProjection(c); LOGGER.debug("QUERY getTimeExtremaForSeries(request, series, temporalFilter): {}", HibernateHelper.getSqlString(c)); return parseMinMaxTime((Object[]) c.uniqueResult()); } /** * Get {@link ObservationTimeExtrema} for a {@link Series}. * * @param request * {@link GetObservationRequest} request * @param series * {@link Series} to get time extrema for * @param session * Hibernate session * @return Time extrema for {@link Series} * @throws OwsExceptionReport * If an error occurs */ public ObservationTimeExtrema getTimeExtremaForSeries(GetObservationRequest request, long series, Session session) throws OwsExceptionReport { return getTimeExtremaForSeries(request, series, null, session); } /** * Query the minimum {@link SeriesValueTime} for parameter * * @param request * {@link GetObservationRequest} * @param series * Datasource series id * @param temporalFilterCriterion * Temporal filter {@link Criterion} * @param session * Hibernate Session * @return Resulting minimum {@link SeriesValueTime} * @throws OwsExceptionReport * If an error occurs when executing the query */ public SeriesValueTime getMinSeriesValueFor(GetObservationRequest request, long series, Criterion temporalFilterCriterion, Session session) throws OwsExceptionReport { return (SeriesValueTime) getSeriesValueCriteriaFor(request, series, temporalFilterCriterion, SosIndeterminateTime.first, session).uniqueResult(); } /** * Query the maximum {@link SeriesValueTime} for parameter * * @param request * {@link GetObservationRequest} * @param series * Datasource series id * @param temporalFilterCriterion * Temporal filter {@link Criterion} * @param session * Hibernate Session * @return Resulting maximum {@link SeriesValueTime} * @throws OwsExceptionReport * If an error occurs when executing the query */ public SeriesValueTime getMaxSeriesValueFor(GetObservationRequest request, long series, Criterion temporalFilterCriterion, Session session) throws OwsExceptionReport { return (SeriesValueTime) getSeriesValueCriteriaFor(request, series, temporalFilterCriterion, SosIndeterminateTime.latest, session).uniqueResult(); } /** * Query the minimum {@link SeriesValueTime} for parameter * * @param request * {@link GetObservationRequest} * @param series * Datasource series id * @param temporalFilterCriterion * Temporal filter {@link Criterion} * @param session * Hibernate Session * @return Resulting minimum {@link SeriesValueTime} * @throws OwsExceptionReport * If an error occurs when executing the query */ public SeriesValueTime getMinSeriesValueFor(GetObservationRequest request, long series, Session session) throws OwsExceptionReport { return (SeriesValueTime) getSeriesValueCriteriaFor(request, series, null, SosIndeterminateTime.first, session).uniqueResult(); } /** * Query the maximum {@link SeriesValueTime} for parameter * * @param request * {@link GetObservationRequest} * @param series * Datasource series id * @param temporalFilterCriterion * Temporal filter {@link Criterion} * @param session * Hibernate Session * @return Resulting maximum {@link SeriesValueTime} * @throws OwsExceptionReport * If an error occurs when executing the query */ public SeriesValueTime getMaxSeriesValueFor(GetObservationRequest request, long series, Session session) throws OwsExceptionReport { return (SeriesValueTime) getSeriesValueCriteriaFor(request, series, null, SosIndeterminateTime.latest, session).uniqueResult(); } /** * Get default {@link Criteria} for {@link Class} * * @param clazz * {@link Class} to get default {@link Criteria} for * @param session * Hibernate Session * @return Default {@link Criteria} */ public Criteria getDefaultObservationCriteria(Session session) { return session.createCriteria(getSeriesValueTimeClass()) .add(Restrictions.eq(SeriesValueTime.DELETED, false)) .setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY); } private void addMinMaxTimeProjection(Criteria c) { ProjectionList projectionList = Projections.projectionList(); projectionList.add(Projections.min(AbstractObservationTime.PHENOMENON_TIME_START)); projectionList.add(Projections.max(AbstractObservationTime.PHENOMENON_TIME_END)); projectionList.add(Projections.max(AbstractObservationTime.RESULT_TIME)); if (HibernateHelper.isColumnSupported(getSeriesValueTimeClass(), AbstractObservationTime.VALID_TIME_START) && HibernateHelper.isColumnSupported(getSeriesValueTimeClass(), AbstractObservationTime.VALID_TIME_END)) { projectionList.add(Projections.min(AbstractObservationTime.VALID_TIME_START)); projectionList.add(Projections.max(AbstractObservationTime.VALID_TIME_END)); } c.setProjection(projectionList); } private ObservationTimeExtrema parseMinMaxTime(Object[] result) { ObservationTimeExtrema ote = new ObservationTimeExtrema(); if (result != null) { ote.setMinPhenTime(DateTimeHelper.makeDateTime(result[0])); ote.setMaxPhenTime(DateTimeHelper.makeDateTime(result[1])); ote.setMaxResultTime(DateTimeHelper.makeDateTime(result[2])); if (result.length == 5) { ote.setMinValidTime(DateTimeHelper.makeDateTime(result[3])); ote.setMaxValidTime(DateTimeHelper.makeDateTime(result[4])); } } return ote; } /** * Create {@link Criteria} for parameter * * @param request * {@link GetObservationRequest} * @param series * Datasource series id * @param temporalFilterCriterion * Temporal filter {@link Criterion} * @param sosIndeterminateTime * first/latest indicator * @param session * Hibernate Session * @return Resulting {@link Criteria} * @throws OwsExceptionReport * If an error occurs when adding Spatial Filtering Profile * restrictions */ private Criteria getSeriesValueCriteriaFor(GetObservationRequest request, long series, Criterion temporalFilterCriterion, SosIndeterminateTime sosIndeterminateTime, Session session) throws OwsExceptionReport { final Criteria c = getDefaultObservationCriteria(session).createAlias(SeriesValueTime.SERIES, "s"); checkAndAddSpatialFilteringProfileCriterion(c, request, session); c.add(Restrictions.eq("s." + Series.ID, series)); if (CollectionHelper.isNotEmpty(request.getOfferings())) { c.createCriteria(SeriesValueTime.OFFERINGS) .add(Restrictions.in(Offering.IDENTIFIER, request.getOfferings())); } String logArgs = "request, series, offerings"; if (temporalFilterCriterion != null) { logArgs += ", filterCriterion"; c.add(temporalFilterCriterion); } if (sosIndeterminateTime != null) { logArgs += ", sosIndeterminateTime"; addIndeterminateTimeRestriction(c, sosIndeterminateTime); } addSpecificRestrictions(c, request); LOGGER.debug("QUERY getSeriesObservationFor({}): {}", logArgs, HibernateHelper.getSqlString(c)); return c; } }