List of usage examples for org.hibernate.criterion DetachedCriteria createCriteria
public DetachedCriteria createCriteria(String associationPath)
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; }