/** * Creates a restriction to check that a collection is not empty * * @return The restriction * * @see Restrictions#isNotEmpty(String) */ public Criterion isNotEmpty() { return Restrictions.isNotEmpty( getPropertyName() ); }
public Users findNotificationSubscribingUsers() { return (Users) transactionTemplate.execute((TransactionCallback) transactionStatus -> { Criteria criteria = sessionFactory.getCurrentSession().createCriteria(User.class); criteria.setCacheable(true); criteria.add(Restrictions.isNotEmpty("notificationFilters")); criteria.add(Restrictions.eq("enabled", true)); return new Users(criteria.list()); }); }
.createAlias("student", "s") .createAlias("course", "c") .add( Restrictions.isNotEmpty("s.enrolments") ) .setCacheable(true) .setReadOnly( true ) .createAlias("course", "c") .setReadOnly( true ) .add( Restrictions.isNotEmpty("s.enrolments") ) .setCacheable(true) .setReadOnly( true ) .createAlias("student", "s") .createAlias("course", "c") .add( Restrictions.isNotEmpty("s.enrolments") ) .setCacheable(true) .list();
@Override public Criterion toHibernateCriterion(AbstractHibernateQuery hibernateQuery, Query.IsNotEmpty criterion, String alias) { String propertyName = getPropertyName(criterion, alias); return Restrictions.isNotEmpty(propertyName); } });
@Override public Query isNotEmpty(String property) { addToCriteria(Restrictions.isNotEmpty(calculatePropertyName(property))); return this; }
/** * * @param id * @return */ public List<T> getReportsWithSeveralPossibleUniprotByResultId(long id) { return getSession().createCriteria(getEntityClass()) .createAlias("updateResult", "u").add(Restrictions.eq("u.id", id)) .add(Restrictions.isNotEmpty("possibleAccessions")).list(); }
@Override public Query isNotEmpty(String property) { addToCriteria(Restrictions.isNotEmpty(calculatePropertyName(property))); return this; }
@Override public Query isNotEmpty(String property) { addToCriteria(Restrictions.isNotEmpty(calculatePropertyName(property))); return this; }
@Override public Query isNotEmpty(String property) { addToCriteria(Restrictions.isNotEmpty(calculatePropertyName(property))); return this; }
public org.grails.datastore.mapping.query.api.Criteria isNotEmpty(String property) { String propertyName = calculatePropertyName(property); addToCriteria(Restrictions.isNotEmpty(propertyName)); return this; }
@Override public List<UniprotUpdateEvent> getUniprotUpdateEventWithUpdatedXrefs(long processId) { return getSession().createCriteria(getEntityClass()). createAlias("updateProcess", "p").add(Restrictions.eq("p.id", processId)). add(Restrictions.isNotEmpty("updatedXrefs")) .addOrder(Order.asc("eventDate")).list(); }
@Override public List<UniprotUpdateEvent> getUniprotUpdateEventWithUpdatedAnnotations(long processId) { return getSession().createCriteria(getEntityClass()). createAlias("updateProcess", "p").add(Restrictions.eq("p.id", processId)). add(Restrictions.isNotEmpty("updatedAnnotations")) .addOrder(Order.asc("eventDate")).list(); }
public int countInteractorInvolvedInInteraction() { final Long count = (Long) getSession().createCriteria(InteractorImpl.class) .add(Restrictions.isNotEmpty("activeInstances")) .setProjection(Projections.rowCount()).uniqueResult(); return count.intValue(); }
public Integer countUniprotProteinsInvolvedInInteractions() { final Long count = (Long) criteriaForUniprotProteins() .add(Restrictions.isNotEmpty("activeInstances")) .setProjection(Projections.rowCount()).uniqueResult(); return count.intValue(); }
public Integer countUniprotProteinsInvolvedInInteractions() { final Long count = (Long) criteriaForUniprotProteins() .add(Restrictions.isNotEmpty("activeInstances")) .setProjection(Projections.rowCount()).uniqueResult(); return count.intValue(); }
public int countInteractorInvolvedInInteraction() { return ( Integer ) getSession().createCriteria( InteractorImpl.class ) .add( Restrictions.isNotEmpty( "activeInstances" ) ) .setProjection( Projections.rowCount() ).uniqueResult(); }
public List<ProteinImpl> getUniprotProteinsInvolvedInInteractions( Integer firstResult, Integer maxResults ) { Criteria crit = criteriaForUniprotProteins() .add( Restrictions.isNotEmpty( "activeInstances" ) ) .addOrder( Order.asc( "xref.primaryId" ) ); if ( firstResult != null && firstResult >= 0 ) { crit.setFirstResult( firstResult ); } if ( maxResults != null && maxResults > 0 ) { crit.setMaxResults( maxResults ); } return crit.list(); }
public Integer countUniprotProteinsInvolvedInInteractions() { return ( Integer ) criteriaForUniprotProteins() .add( Restrictions.isNotEmpty( "activeInstances" ) ) .setProjection( Projections.rowCount() ).uniqueResult(); }
public List<ProteinImpl> getUniprotProteinsInvolvedInInteractions( Integer firstResult, Integer maxResults ) { Criteria crit = criteriaForUniprotProteins() .add( Restrictions.isNotEmpty( "activeInstances" ) ) .addOrder( Order.asc( "xref.primaryId" ) ) .addOrder( Order.asc("ac")); return autosetFirstMax(firstResult, maxResults, crit); }
public List<ProteinImpl> getUniprotProteinsInvolvedInInteractions( Integer firstResult, Integer maxResults ) { Criteria crit = criteriaForUniprotProteins() .add( Restrictions.isNotEmpty( "activeInstances" ) ) .addOrder( Order.asc( "xref.primaryId" ) ) .addOrder( Order.asc("ac")); return autosetFirstMax(firstResult, maxResults, crit); }