/** * Creates a sub-query NOT IN expression for this property. I.e., {@code [prop] NOT IN [subquery]} * * @param subselect The sub-query * * @return The expression * * @see Subqueries#propertyNotIn(String, DetachedCriteria) */ @SuppressWarnings("UnusedDeclaration") public Criterion notIn(DetachedCriteria subselect) { return Subqueries.propertyNotIn( getPropertyName(), subselect ); }
public Criterion notIn(DetachedCriteria subselect) { return Subqueries.propertyNotIn( getPropertyName(), subselect ); }
public Criterion notIn(DetachedCriteria subselect) { return Subqueries.propertyNotIn( getPropertyName(), subselect ); }
@Override @SuppressWarnings("unchecked") public void clearUnusedForService(ServiceEntity service) { Criteria criteria = session.createCriteria(getEntityClass()) .add(Restrictions.eq(PhenomenonEntity.PROPERTY_SERVICE, service)) .add(Subqueries.propertyNotIn(PhenomenonEntity.PROPERTY_PKID, createDetachedDatasetFilter())); criteria.list().forEach(session::delete); }
@Override @SuppressWarnings("unchecked") public void clearUnusedForService(ServiceEntity service) { Criteria criteria = this.session.createCriteria(getEntityClass()) .add(Restrictions.eq(OfferingEntity.PROPERTY_SERVICE, service)) .add(Subqueries.propertyNotIn(OfferingEntity.PROPERTY_PKID, createDetachedDatasetFilter())); criteria.list().forEach(session::delete); }
public Criterion notIn(DetachedCriteria subselect) { return Subqueries.propertyNotIn( getPropertyName(), subselect ); }
public Criterion notIn(DetachedCriteria subselect) { return Subqueries.propertyNotIn( getPropertyName(), subselect ); }
@Override @SuppressWarnings("unchecked") public void clearUnusedForService(ServiceEntity service) { Criteria criteria = session.createCriteria(getEntityClass()) .add(Restrictions.eq(ProcedureEntity.PROPERTY_SERVICE, service)) .add(Subqueries.propertyNotIn(ProcedureEntity.PROPERTY_PKID, createDetachedDatasetFilter())); criteria.list().forEach(session::delete); }
@Override @SuppressWarnings("unchecked") public void clearUnusedForService(ServiceEntity service) { Criteria criteria = session.createCriteria(getEntityClass()) .add(Restrictions.eq(CategoryEntity.PROPERTY_SERVICE, service)) .add(Subqueries.propertyNotIn(DescribableEntity.PROPERTY_PKID, createDetachedDatasetFilter())); criteria.list().forEach(session::delete); }
@Override @SuppressWarnings("unchecked") public void clearUnusedForService(ServiceEntity service) { this.session.createCriteria(getEntityClass()) .add(Restrictions.eq(FeatureEntity.PROPERTY_SERVICE, service)) .add(Subqueries.propertyNotIn( DescribableEntity.PROPERTY_PKID, DetachedCriteria.forClass(DatasetEntity.class) .setProjection(Projections.distinct(Projections.property(getDatasetProperty()))))) .list() .forEach(this.session::delete); }
@SuppressWarnings("unchecked") public List<OfferingEntity> getPublishedOffering(Collection<String> identifiers, Session session) throws OwsExceptionReport { if (HibernateHelper.isEntitySupported(DatasetEntity.class)) { Criteria c = getDefaultCriteria(session); c.add(Subqueries.propertyNotIn(OfferingEntity.PROPERTY_ID, getDetachedCriteriaSeries(session))); return c.list(); } return getOfferingObjectsForCacheUpdate(identifiers, session); }
Criteria c = getDefaultCriteria(session); if (HibernateHelper.isEntitySupported(DatasetEntity.class)) { c.add(Subqueries.propertyNotIn(AbstractFeatureEntity.PROPERTY_ID, getPublishedDetachedCriteriaSeries(session))); } return c; } private DetachedCriteria getPublishedDetachedCriteriaSeries(Session session) throws OwsExceptionReport {
@SuppressWarnings("unchecked") public List<ProcedureEntity> getPublishedProcedure(Session session) throws OwsExceptionReport { if (HibernateHelper.isEntitySupported(DatasetEntity.class)) { Criteria c = getDefaultCriteria(session); c.add(Subqueries.propertyNotIn(ProcedureEntity.PROPERTY_ID, getDetachedCriteriaSeries(session))); return c.list(); } return getProcedureObjects(session); }
Criteria c = getDefaultCriteria(session); if (HibernateHelper.isEntitySupported(DatasetEntity.class)) { c.add(Subqueries.propertyNotIn(AbstractFeatureEntity.PROPERTY_ID, getPublishedDetachedCriteriaSeries(session))); } return c; } private DetachedCriteria getPublishedDetachedCriteriaSeries(Session session) throws OwsExceptionReport {
@SuppressWarnings("unchecked") public List<PhenomenonEntity> getPublishedObservableProperty(Session session) throws OwsExceptionReport { if (HibernateHelper.isEntitySupported(DatasetEntity.class)) { Criteria c = getDefaultCriteria(session); c.add(Subqueries.propertyNotIn(PhenomenonEntity.PROPERTY_ID, getDetachedCriteriaSeries(session))); return c.list(); } return getObservablePropertyObjects(session); }
@SuppressWarnings("unchecked") public List<ProcedureEntity> getPublishedProcedure(Session session) throws OwsExceptionReport { if (HibernateHelper.isEntitySupported(DatasetEntity.class)) { Criteria c = getDefaultCriteria(session); c.add(Subqueries.propertyNotIn(ProcedureEntity.PROPERTY_ID, getDetachedCriteriaSeries(session))); return c.list(); } return getProcedureObjects(session); }
@SuppressWarnings("unchecked") public List<PhenomenonEntity> getPublishedObservableProperty(Session session) throws OwsExceptionReport { if (HibernateHelper.isEntitySupported(DatasetEntity.class)) { Criteria c = getDefaultCriteria(session); c.add(Subqueries.propertyNotIn(PhenomenonEntity.PROPERTY_ID, getDetachedCriteriaSeries(session))); return c.list(); } return getObservablePropertyObjects(session); }
@SuppressWarnings("unchecked") public List<OfferingEntity> getPublishedOffering(Collection<String> identifiers, Session session) throws OwsExceptionReport { if (HibernateHelper.isEntitySupported(DatasetEntity.class)) { Criteria c = getDefaultCriteria(session); c.add(Subqueries.propertyNotIn(OfferingEntity.PROPERTY_ID, getDetachedCriteriaSeries(session))); return c.list(); } return getOfferingObjectsForCacheUpdate(identifiers, session); }
@Override public List<ThesaurusConcept> getPaginatedAvailableConceptsOfGroup( Integer startIndex, Integer limit, String groupId, String thesaurusId, Boolean onlyValidatedConcepts,String like) { DetachedCriteria dc = DetachedCriteria.forClass(ThesaurusConceptGroup.class, "gr"); dc.createCriteria("concepts", "tc", JoinType.RIGHT_OUTER_JOIN); dc.setProjection(Projections.projectionList().add(Projections.property("tc.identifier"))); dc.add(Restrictions.eq("gr.identifier", groupId)); Criteria criteria = selectPaginatedConceptsByAlphabeticalOrder(startIndex, limit); criteria.add(Subqueries.propertyNotIn("tc.identifier", dc)); selectThesaurus(criteria, thesaurusId); criteria.add( Restrictions.not(Restrictions.and( Restrictions.eq("topConcept", false), Restrictions.or(Restrictions.isNull("tc.parentConcepts"), Restrictions.isEmpty("tc.parentConcepts")) ))); if(null != like){ conceptNameIsLike(criteria,like); } onlyValidatedConcepts(criteria, onlyValidatedConcepts); return criteria.list(); }
@Override @SuppressWarnings("unchecked") public void clearUnusedForService(ServiceEntity service) { // this will actuall remove all data entities that are associated with an // non-existing dataset or are neither the first or last value for the // dataset, independent of the service DetachedCriteria existingDatasetIds = DetachedCriteria.forClass(DatasetEntity.class) .setProjection(Projections.distinct(Projections .property(DatasetEntity.PROPERTY_PKID))); DetachedCriteria minTimeByDataset = DetachedCriteria.forClass(DataEntity.class) .setProjection(Projections.projectionList() .add(Projections.groupProperty(DataEntity.PROPERTY_SERIES_PKID)) .add(Projections.min(DataEntity.PROPERTY_RESULTTIME))); DetachedCriteria maxTimeByDataset = DetachedCriteria.forClass(DataEntity.class) .setProjection(Projections.projectionList() .add(Projections.groupProperty(DataEntity.PROPERTY_SERIES_PKID)) .add(Projections.max(DataEntity.PROPERTY_RESULTTIME))); Criterion notExistingDataset = Subqueries.propertyNotIn(DataEntity.PROPERTY_SERIES_PKID, existingDatasetIds); Criterion notFirstData = Subqueries.propertiesNotIn(new String[] { DataEntity.PROPERTY_SERIES_PKID, DataEntity.PROPERTY_RESULTTIME }, minTimeByDataset); Criterion notLatestData = Subqueries.propertiesNotIn(new String[] { DataEntity.PROPERTY_SERIES_PKID, DataEntity.PROPERTY_RESULTTIME }, maxTimeByDataset); session.createCriteria(getEntityClass()) .add(Restrictions.or(notExistingDataset, Restrictions.and(notFirstData, notLatestData))) .list() .forEach(session::delete); }