Example usage for org.hibernate.criterion Restrictions isNotNull

List of usage examples for org.hibernate.criterion Restrictions isNotNull

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. Restrictions
  6. isNotNull

Introduction

In this page you can find the example usage for org.hibernate.criterion Restrictions isNotNull.

Prototype

public static Criterion isNotNull(String propertyName)

Source Link

Document

Apply an "is not null" constraint to the named property

Usage

From source file:org.n52.sos.ds.hibernate.cache.base.ProcedureCacheUpdateTask.java

License:Open Source License

@SuppressWarnings("unchecked")
protected Set<String> getObservationIdentifiers(Session session, String procedureIdentifier) {
    return Sets.newHashSet(session.createCriteria(Observation.class)
            .setProjection(Projections.distinct(Projections.property(Observation.IDENTIFIER)))
            .add(Restrictions.isNotNull(Observation.IDENTIFIER))
            .add(Restrictions.eq(Observation.DELETED, false)).createCriteria(Observation.PROCEDURE)
            .add(Restrictions.eq(Procedure.IDENTIFIER, procedureIdentifier)).list());
}

From source file:org.n52.sos.ds.hibernate.dao.AbstractObservationDAO.java

License:Open Source License

/**
 * Get all observation identifiers/*  ww w  .  j a v a  2s . com*/
 *
 * @param session
 *            Hibernate session
 * @return Observation identifiers
 */
@SuppressWarnings("unchecked")
public List<String> getObservationIdentifier(Session session) {
    Criteria criteria = session.createCriteria(getObservationInfoClass())
            .add(Restrictions.eq(Observation.DELETED, false))
            .add(Restrictions.isNotNull(Observation.IDENTIFIER))
            .setProjection(Projections.distinct(Projections.property(Observation.IDENTIFIER)));
    LOGGER.debug("QUERY getObservationIdentifiers(): {}", HibernateHelper.getSqlString(criteria));
    return criteria.list();
}

From source file:org.n52.sos.ds.hibernate.dao.AbstractObservationDAO.java

License:Open Source License

/**
 * Check if the observation table contains samplingGeometries with values
 * //  w  w  w.jav a  2  s.  c o  m
 * @param session
 *            Hibernate session
 * @return <code>true</code>, if the observation table contains samplingGeometries with values
 */
public boolean containsSamplingGeometries(Session session) {
    Criteria criteria = getDefaultObservationInfoCriteria(session);
    criteria.add(Restrictions.isNotNull(AbstractObservation.SAMPLING_GEOMETRY));
    criteria.setProjection(Projections.rowCount());
    LOGGER.debug("QUERY containsSamplingGeometries(): {}", HibernateHelper.getSqlString(criteria));
    return (Long) criteria.uniqueResult() > 0;
}

From source file:org.n52.sos.ds.hibernate.dao.ObservationConstellationDAO.java

License:Open Source License

/**
 * Get ObservationCollection entities for procedures, observableProperties
 * and offerings where observationType is not null;
 * /*from  www  . java2  s. c o  m*/
 * @param procedures
 *            Procedures to get ObservationCollection entities for
 * @param observedProperties
 *            ObservableProperties to get ObservationCollection entities for
 * @param offerings
 *            Offerings to get ObservationCollection entities for
 * @param session
 *            Hibernate session
 * @return Resulting ObservationCollection entities
 */
@SuppressWarnings("unchecked")
public List<ObservationConstellation> getObservationConstellations(List<String> procedures,
        List<String> observedProperties, List<String> offerings, Session session) {
    final Criteria c = session.createCriteria(ObservationConstellation.class)
            .add(Restrictions.eq(ObservationConstellation.DELETED, false))
            .setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
    if (CollectionHelper.isNotEmpty(offerings)) {
        c.createCriteria(ObservationConstellation.OFFERING)
                .add(Restrictions.in(Offering.IDENTIFIER, offerings));
    }
    if (CollectionHelper.isNotEmpty(observedProperties)) {
        c.createCriteria(ObservationConstellation.OBSERVABLE_PROPERTY)
                .add(Restrictions.in(ObservableProperty.IDENTIFIER, observedProperties));
    }
    if (CollectionHelper.isNotEmpty(procedures)) {
        c.createCriteria(ObservationConstellation.PROCEDURE)
                .add(Restrictions.in(Procedure.IDENTIFIER, procedures));
    }
    c.add(Restrictions.isNotNull(ObservationConstellation.OBSERVATION_TYPE));
    LOGGER.debug("QUERY getObservationConstellations(): {}", HibernateHelper.getSqlString(c));
    return c.list();

}

From source file:org.n52.sos.ds.hibernate.dao.ObservationDAO.java

License:Open Source License

@SuppressWarnings("unchecked")
public Collection<String> getObservationIdentifiers(String procedureIdentifier, Session session) {
    Criteria criteria = session.createCriteria(ObservationInfo.class)
            .setProjection(Projections.distinct(Projections.property(ObservationInfo.IDENTIFIER)))
            .add(Restrictions.isNotNull(ObservationInfo.IDENTIFIER))
            .add(Restrictions.eq(ObservationInfo.DELETED, false));
    criteria.createCriteria(ObservationInfo.PROCEDURE)
            .add(Restrictions.eq(Procedure.IDENTIFIER, procedureIdentifier));
    LOGGER.debug("QUERY ObservationDAO.getObservationIdentifiers(procedureIdentifier): {}",
            HibernateHelper.getSqlString(criteria));
    return criteria.list();
}

From source file:org.n52.sos.ds.hibernate.dao.ObservationDAO.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override/*from   ww w  . j a  va2 s  .  c o  m*/
public List<Geometry> getSamplingGeometries(String feature, Session session) {
    Criteria criteria = getDefaultObservationInfoCriteria(session);
    criteria.createCriteria(AbstractObservation.FEATURE_OF_INTEREST)
            .add(eq(FeatureOfInterest.IDENTIFIER, feature));
    criteria.add(Restrictions.isNotNull(AbstractObservationTime.SAMPLING_GEOMETRY));
    criteria.addOrder(Order.asc(AbstractObservationTime.PHENOMENON_TIME_START));
    criteria.setProjection(Projections.property(AbstractObservationTime.SAMPLING_GEOMETRY));
    return criteria.list();
}

From source file:org.n52.sos.ds.hibernate.dao.ProcedureDAO.java

License:Open Source License

@SuppressWarnings("unchecked")
protected Set<String> getObservationIdentifiers(Session session, String procedureIdentifier) {
    if (EntitiyHelper.getInstance().isSeriesObservationInfoSupported()) {
        Criteria criteria = session.createCriteria(EntitiyHelper.getInstance().getObservationInfoEntityClass())
                .setProjection(Projections.distinct(Projections.property(SeriesObservationInfo.IDENTIFIER)))
                .add(Restrictions.isNotNull(SeriesObservationInfo.IDENTIFIER))
                .add(Restrictions.eq(SeriesObservationInfo.DELETED, false));
        Criteria seriesCriteria = criteria.createCriteria(SeriesObservationInfo.SERIES);
        seriesCriteria.createCriteria(Series.PROCEDURE)
                .add(Restrictions.eq(Procedure.IDENTIFIER, procedureIdentifier));
        LOGGER.debug("QUERY getObservationIdentifiers(procedureIdentifier): {}",
                HibernateHelper.getSqlString(criteria));
        return Sets.newHashSet(criteria.list());
    } else {/*ww  w.  jav a 2s.c  o  m*/
        Criteria criteria = session.createCriteria(EntitiyHelper.getInstance().getObservationInfoEntityClass())
                .setProjection(Projections.distinct(Projections.property(ObservationInfo.IDENTIFIER)))
                .add(Restrictions.isNotNull(ObservationInfo.IDENTIFIER))
                .add(Restrictions.eq(ObservationInfo.DELETED, false));
        criteria.createCriteria(ObservationInfo.PROCEDURE)
                .add(Restrictions.eq(Procedure.IDENTIFIER, procedureIdentifier));
        LOGGER.debug("QUERY getObservationIdentifiers(procedureIdentifier): {}",
                HibernateHelper.getSqlString(criteria));
        return Sets.newHashSet(criteria.list());
    }
}

From source file:org.n52.sos.ds.hibernate.dao.series.AbstractSeriesObservationDAO.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override/*from www .j  a va  2 s.  c  o  m*/
public Collection<String> getObservationIdentifiers(String procedureIdentifier, Session session) {
    Criteria criteria = getDefaultObservationInfoCriteria(session)
            .setProjection(Projections.distinct(Projections.property(SeriesObservationInfo.IDENTIFIER)))
            .add(Restrictions.isNotNull(SeriesObservationInfo.IDENTIFIER))
            .add(Restrictions.eq(SeriesObservationInfo.DELETED, false));
    Criteria seriesCriteria = criteria.createCriteria(SeriesObservationInfo.SERIES);
    seriesCriteria.createCriteria(Series.PROCEDURE)
            .add(Restrictions.eq(Procedure.IDENTIFIER, procedureIdentifier));
    LOGGER.debug("QUERY getObservationIdentifiers(procedureIdentifier): {}",
            HibernateHelper.getSqlString(criteria));
    return criteria.list();
}

From source file:org.n52.sos.ds.hibernate.dao.series.AbstractSeriesObservationDAO.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override/*  ww  w  .j av a  2s.  c  o m*/
public List<Geometry> getSamplingGeometries(String feature, Session session) {
    Criteria criteria = getDefaultObservationTimeCriteria(session).createAlias(SeriesObservation.SERIES, "s");
    criteria.createCriteria("s." + Series.FEATURE_OF_INTEREST).add(eq(FeatureOfInterest.IDENTIFIER, feature));
    criteria.add(Restrictions.isNotNull(AbstractObservationTime.SAMPLING_GEOMETRY));
    criteria.addOrder(Order.asc(AbstractObservationTime.PHENOMENON_TIME_START));
    criteria.setProjection(Projections.property(AbstractObservationTime.SAMPLING_GEOMETRY));
    return criteria.list();
}

From source file:org.n52.sos.ds.hibernate.util.HibernateCriteriaQueryUtilities.java

License:Open Source License

@Deprecated
@SuppressWarnings("unchecked")
public static List<String> getObservationIdentifiers(Session session) {
    return session.createCriteria(Observation.class).add(Restrictions.eq(Observation.DELETED, false))
            .add(Restrictions.isNotNull(Observation.IDENTIFIER))
            .setProjection(Projections.distinct(Projections.property(Observation.IDENTIFIER))).list();
}