Example usage for org.hibernate.criterion DetachedCriteria setProjection

List of usage examples for org.hibernate.criterion DetachedCriteria setProjection

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. DetachedCriteria
  6. setProjection

Introduction

In this page you can find the example usage for org.hibernate.criterion DetachedCriteria setProjection.

Prototype

public DetachedCriteria setProjection(Projection projection)

Source Link

Document

Set the projection to use.

Usage

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

License:Open Source License

private void addAssessmentType(Criteria c, String assessmentType) {
    final DetachedCriteria detachedCriteria = DetachedCriteria.forClass(EReportingSeries.class);
    detachedCriteria.add(Restrictions.eq(Series.DELETED, false));
    detachedCriteria.createCriteria(EReportingSeries.SAMPLING_POINT)
            .createCriteria(EReportingSamplingPoint.ASSESSMENTTYPE)
            .add(Restrictions.ilike(EReportingAssessmentType.ASSESSMENT_TYPE, assessmentType));
    detachedCriteria.setProjection(Projections.distinct(Projections.property(Series.ID)));
    c.add(Subqueries.propertyIn(SeriesObservation.SERIES, detachedCriteria));
}

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

License:Open Source License

/**
 * Get Hibernate Detached Criteria to get ObservableProperty entities from
 * ObservationConstellation for procedure identifier
 *
 * @param procedureIdentifier/*from   w  w  w.  jav a  2 s.  com*/
 *            Procedure identifier parameter
 * @param session
 *            Hibernate session
 * @return Hibernate Detached Criteria
 */
private DetachedCriteria getDetachedCriteriaObservablePropertyForProcedureFromObservationConstellation(
        String procedureIdentifier, Session session) {
    final DetachedCriteria detachedCriteria = DetachedCriteria.forClass(ObservationConstellation.class);
    detachedCriteria.add(Restrictions.eq(ObservationConstellation.DELETED, false));
    detachedCriteria.createCriteria(ObservationConstellation.PROCEDURE)
            .add(Restrictions.eq(Procedure.IDENTIFIER, procedureIdentifier));
    detachedCriteria.setProjection(
            Projections.distinct(Projections.property(ObservationConstellation.OBSERVABLE_PROPERTY)));
    return detachedCriteria;
}

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

License:Open Source License

/**
 * Get Hibernate Detached Criteria to get ObservableProperty entities from
 * Series for procedure identifier//from   w  w w  .j  a v a  2  s.  c  om
 *
 * @param procedureIdentifier
 *            Procedure identifier parameter
 * @param session
 *            Hibernate session
 * @return Hibernate Detached Criteria
 */
private DetachedCriteria getDetachedCriteriaObservablePropertiesForProcedureFromSeries(
        String procedureIdentifier, Session session) {
    final DetachedCriteria detachedCriteria = DetachedCriteria.forClass(Series.class);
    detachedCriteria.add(Restrictions.eq(Series.DELETED, false));
    detachedCriteria.createCriteria(Series.PROCEDURE)
            .add(Restrictions.eq(Procedure.IDENTIFIER, procedureIdentifier));
    detachedCriteria.setProjection(Projections.distinct(Projections.property(Series.OBSERVABLE_PROPERTY)));
    return detachedCriteria;
}

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

License:Open Source License

/**
 * Get Hibernate Detached Criteria to get ObservableProperty entities from
 * ObservationConstellation for offering identifier
 *
 * @param offeringIdentifier/*  w ww  .j  av  a  2  s .com*/
 *            Offering identifier parameter
 * @param session
 *            Hibernate session
 * @return Hibernate Detached Criteria
 */
private DetachedCriteria getDetachedCriteriaObservablePropertiesForOfferingFromObservationConstellation(
        String offeringIdentifier, Session session) {
    final DetachedCriteria detachedCriteria = DetachedCriteria.forClass(ObservationConstellation.class);
    detachedCriteria.add(Restrictions.eq(ObservationConstellation.DELETED, false));
    detachedCriteria.createCriteria(ObservationConstellation.OFFERING)
            .add(Restrictions.eq(Offering.IDENTIFIER, offeringIdentifier));
    detachedCriteria.setProjection(
            Projections.distinct(Projections.property(ObservationConstellation.OBSERVABLE_PROPERTY)));
    return detachedCriteria;
}

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

License:Open Source License

/**
 * Get Hibernate Detached Criteria for class ObservationConstellation and
 * observableProperty identifier//w w  w .j av  a  2  s . c o  m
 *
 * @param observablePropertyIdentifier
 *            ObservableProperty identifier parameter
 * @param session
 *            Hibernate session
 * @return Detached Criteria with Offering entities as result
 */
private DetachedCriteria getDetachedCriteriaOfferingForObservablePropertyFromObservationConstellation(
        String observablePropertyIdentifier, Session session) {
    final DetachedCriteria detachedCriteria = DetachedCriteria.forClass(ObservationConstellation.class);
    detachedCriteria.add(Restrictions.eq(ObservationConstellation.DELETED, false));
    detachedCriteria.createCriteria(ObservationConstellation.OBSERVABLE_PROPERTY)
            .add(Restrictions.eq(ObservableProperty.IDENTIFIER, observablePropertyIdentifier));
    detachedCriteria
            .setProjection(Projections.distinct(Projections.property(ObservationConstellation.OFFERING)));
    return detachedCriteria;
}

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

License:Open Source License

/**
 * Get Hibernate Detached Criteria for class ObservationConstellation and
 * procedure identifier/*  w  w w .j a v  a 2s.  c  om*/
 *
 * @param procedureIdentifier
 *            Procedure identifier parameter
 * @param session
 *            Hibernate session
 * @return Detached Criteria with Offering entities as result
 */
private DetachedCriteria getDetachedCriteriaOfferingForProcedureFromObservationConstellation(
        String procedureIdentifier, Session session) {
    final DetachedCriteria detachedCriteria = DetachedCriteria.forClass(ObservationConstellation.class);
    detachedCriteria.add(Restrictions.eq(ObservationConstellation.DELETED, false));
    detachedCriteria.createCriteria(ObservationConstellation.PROCEDURE)
            .add(Restrictions.eq(Procedure.IDENTIFIER, procedureIdentifier));
    detachedCriteria
            .setProjection(Projections.distinct(Projections.property(ObservationConstellation.OFFERING)));
    return detachedCriteria;
}

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

License:Open Source License

/**
 * Get Hibernate Detached Criteria for class Series and featureOfInterest
 * identifier/*from w  w  w.ja  v a 2  s  .  c om*/
 *
 * @param featureOfInterest
 *            FeatureOfInterest identifier parameter
 * @param session
 *            Hibernate session
 * @return Hiberante Detached Criteria with Procedure entities
 * @throws CodedException 
 */
private DetachedCriteria getDetachedCriteriaProceduresForFeatureOfInterestFromSeries(
        FeatureOfInterest featureOfInterest, Session session) throws CodedException {
    final DetachedCriteria detachedCriteria = DetachedCriteria
            .forClass(DaoFactory.getInstance().getSeriesDAO().getClass());
    detachedCriteria.add(Restrictions.eq(Series.DELETED, false));
    detachedCriteria.add(Restrictions.eq(Series.FEATURE_OF_INTEREST, featureOfInterest));
    detachedCriteria.setProjection(Projections.distinct(Projections.property(Series.PROCEDURE)));
    return detachedCriteria;
}

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

License:Open Source License

/**
 * Get Hibernate Detached Criteria for class ObservationConstellation and
 * observableProperty identifier/*from  w  w w  . j ava2  s  .  c  om*/
 *
 * @param observablePropertyIdentifier
 *            ObservableProperty identifier parameter
 * @param session
 *            Hibernate session
 * @return Hiberante Detached Criteria with Procedure entities
 */
private DetachedCriteria getDetachedCriteriaProceduresForObservablePropertyFromObservationConstellation(
        String observablePropertyIdentifier, Session session) {
    final DetachedCriteria detachedCriteria = DetachedCriteria.forClass(ObservationConstellation.class);
    detachedCriteria.add(Restrictions.eq(ObservationConstellation.DELETED, false));
    detachedCriteria.createCriteria(ObservationConstellation.OBSERVABLE_PROPERTY)
            .add(Restrictions.eq(ObservableProperty.IDENTIFIER, observablePropertyIdentifier));
    detachedCriteria
            .setProjection(Projections.distinct(Projections.property(ObservationConstellation.PROCEDURE)));
    return detachedCriteria;
}

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

License:Open Source License

/**
 * Get Hibernate Detached Criteria for class Series and observableProperty
 * identifier//from  w  w w  . j  a  v a 2 s .co  m
 *
 * @param observablePropertyIdentifier
 *            ObservableProperty identifier parameter
 * @param session
 *            Hibernate session
 * @return Hiberante Detached Criteria with Procedure entities
 * @throws CodedException 
 */
private DetachedCriteria getDetachedCriteriaProceduresForObservablePropertyFromSeries(
        String observablePropertyIdentifier, Session session) throws CodedException {
    final DetachedCriteria detachedCriteria = DetachedCriteria
            .forClass(DaoFactory.getInstance().getSeriesDAO().getClass());
    detachedCriteria.add(Restrictions.eq(Series.DELETED, false));
    detachedCriteria.createCriteria(Series.OBSERVABLE_PROPERTY)
            .add(Restrictions.eq(ObservableProperty.IDENTIFIER, observablePropertyIdentifier));
    detachedCriteria.setProjection(Projections.distinct(Projections.property(Series.PROCEDURE)));
    return detachedCriteria;
}

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

License:Open Source License

/**
 * Get Hibernate Detached Criteria for class ObservationConstellation and
 * offering identifier//from   w w  w .  j a  va  2 s .  c om
 *
 * @param offeringIdentifier
 *            Offering identifier parameter
 * @param session
 *            Hibernate session
 * @return Detached Criteria with Procedure entities
 */
private DetachedCriteria getDetachedCriteriaProceduresForOfferingFromObservationConstellation(
        String offeringIdentifier, Session session) {
    final DetachedCriteria detachedCriteria = DetachedCriteria.forClass(ObservationConstellation.class);
    detachedCriteria.add(Restrictions.eq(ObservationConstellation.DELETED, false));
    detachedCriteria.createCriteria(ObservationConstellation.OFFERING)
            .add(Restrictions.eq(Offering.IDENTIFIER, offeringIdentifier));
    detachedCriteria
            .setProjection(Projections.distinct(Projections.property(ObservationConstellation.PROCEDURE)));
    return detachedCriteria;
}