Example usage for org.hibernate.criterion DetachedCriteria createCriteria

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

Introduction

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

Prototype

public DetachedCriteria createCriteria(String associationPath) 

Source Link

Document

Creates a nested DetachedCriteria representing the association path.

Usage

From source file:org.ikasan.security.dao.HibernateSecurityDao.java

License:BSD License

@Override
public List<Policy> getAllPoliciesWithRole(String roleName) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Policy.class);
    criteria.createCriteria("roles").add(Restrictions.eq("name", roleName));

    return (List<Policy>) this.getHibernateTemplate().findByCriteria(criteria);
}

From source file:org.ikasan.topology.dao.HibernateTopologyDao.java

License:BSD License

@SuppressWarnings("unchecked")
@Override//from w w w .j av a2 s.  c  o  m
public List<Flow> getFlowsByServerIdAndModuleId(Long serverId, Long moduleId) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Flow.class);
    criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);

    if (serverId != null && moduleId != null) {
        criteria.createCriteria("module").add(Restrictions.eq("id", moduleId)).createCriteria("server")
                .add(Restrictions.eq("id", serverId));
    } else if (moduleId != null) {
        criteria.createCriteria("module").add(Restrictions.eq("id", moduleId));
    } else if (serverId != null) {
        criteria.createCriteria("module").createCriteria("server").add(Restrictions.eq("id", serverId));
    }

    return (List<Flow>) this.getHibernateTemplate().findByCriteria(criteria);
}

From source file:org.ikasan.topology.dao.HibernateTopologyDao.java

License:BSD License

@Override
public Flow getFlowsByServerIdModuleIdAndFlowname(Long serverId, Long moduleId, String flowName) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Flow.class);
    criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);

    if (serverId != null && moduleId != null) {
        criteria.createCriteria("module").add(Restrictions.eq("id", moduleId)).createCriteria("server")
                .add(Restrictions.eq("id", serverId));
    } else if (moduleId != null) {
        criteria.createCriteria("module").add(Restrictions.eq("id", moduleId));
    } else if (serverId != null) {
        criteria.createCriteria("module").createCriteria("server").add(Restrictions.eq("id", serverId));
    }/*from w  ww  .ja v  a  2 s  . c om*/

    if (flowName != null) {
        criteria.add(Restrictions.eq("name", flowName));
    }

    return (Flow) DataAccessUtils.uniqueResult(this.getHibernateTemplate().findByCriteria(criteria));
}

From source file:org.jspresso.framework.model.persistence.hibernate.criterion.EnhancedDetachedCriteria.java

License:Open Source License

/**
 * Creates or gets a previously registered sub-criteria.
 *
 * @param masterCriteria// ww w.j  a  v a  2s  .c  om
 *          the parent criteria holding the sub-criteria.
 * @param associationPath
 *          the association path.
 * @return the new or previously registered sub-criteria.
 */
public DetachedCriteria getSubCriteriaFor(DetachedCriteria masterCriteria, String associationPath) {
    DetachedCriteria subCriteria = getRegisteredSubCriteria(masterCriteria, associationPath);
    if (subCriteria == null) {
        subCriteria = masterCriteria.createCriteria(associationPath);
        registerSubCriteria(masterCriteria, associationPath, subCriteria);
    }
    return subCriteria;
}

From source file:org.n52.series.db.dao.DbQuery.java

License:Open Source License

private DetachedCriteria addFilterRestriction(Set<String> values, String entity, DetachedCriteria filter) {
    if (hasValues(values)) {
        Criterion restriction = createIdCriterion(values);
        if (entity == null || entity.isEmpty()) {
            return filter.add(restriction);
        } else {//from  w ww .  j a v  a2s . c om
            // return subquery for further chaining
            return filter.createCriteria(entity).add(restriction);
        }
    }
    return filter;
}

From source file:org.n52.series.db.dao.DbQuery.java

License:Open Source License

@Deprecated
private void filterWithSingularParmameters(DetachedCriteria filter) {
    // old query parameter to stay backward compatible
    if (getParameters().getPhenomenon() != null) {
        filter.createCriteria("phenomenon")
                .add(Restrictions.eq(COLUMN_KEY, parseToId(getParameters().getPhenomenon())));
    }//from  w ww . ja  v a2 s.  co  m
    if (getParameters().getProcedure() != null) {
        filter.createCriteria("procedure")
                .add(Restrictions.eq(COLUMN_KEY, parseToId(getParameters().getProcedure())));
    }
    if (getParameters().getOffering() != null) {
        filter.createCriteria("offering")
                .add(Restrictions.eq(COLUMN_KEY, parseToId(getParameters().getOffering())));
    }
    if (getParameters().getFeature() != null) {
        filter.createCriteria("feature")
                .add(Restrictions.eq(COLUMN_KEY, parseToId(getParameters().getFeature())));
    }
    if (getParameters().getStation() != null) {
        // here feature == station
        filter.createCriteria("feature")
                .add(Restrictions.eq(COLUMN_KEY, parseToId(getParameters().getStation())));
    }
    if (getParameters().getCategory() != null) {
        filter.createCriteria("category")
                .add(Restrictions.eq(COLUMN_KEY, parseToId(getParameters().getCategory())));
    }
}

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 . j a  va 2s.  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/*  w ww  .java  2  s.c  o m*/
 *
 * @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/*ww w. j  a v  a  2s.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;
}