/** * Creates a property count projection * * @return The projection * * @see Projections#count */ public CountProjection count() { return Projections.count( getPropertyName() ); }
public void executeCount() { final Criteria criteria = createCriteria(); prepareCache(criteria); // Prepare where clause addSubCriterias(criteria); addConditionalCriteria(criteria); addResultTransformer(criteria); if (realDistinctRoot) { criteria.setProjection(Projections.countDistinct(Criteria.ROOT_ALIAS+".id")); } else { criteria.setProjection(Projections.count(Criteria.ROOT_ALIAS+".id")); } rowCount = (Long) criteria.uniqueResult(); }
longValue = (Long) s.createCriteria( Human.class ).setProjection( Projections.count("heightInches")).uniqueResult(); assertEquals(longValue, new Long(1));
s.clear(); count = ( Long ) s.createCriteria( Human.class ) .setProjection( Projections.count( "nickName" ) ) .uniqueResult(); assertEquals( 3, count.longValue() ); s.clear(); count = ( Long ) s.createCriteria( Human.class ) .setProjection( Projections.count( "nickName" ).setDistinct() ) .uniqueResult(); assertEquals( 2, count.longValue() ); try { count = ( Long ) s.createCriteria( Human.class ) .setProjection( Projections.count( "name" ).setDistinct() ) .uniqueResult(); if ( ! getDialect().supportsTupleDistinctCounts() ) { s.clear(); count = ( Long ) s.createCriteria( Human.class ) .setProjection( Projections.count( "name.first" ).setDistinct() ) .uniqueResult(); assertEquals( 1, count.longValue() ); try { count = ( Long ) s.createCriteria( Human.class ) .setProjection( Projections.count( "name" ) ) .uniqueResult(); if ( ! getDialect().supportsTupleCounts() ) {
/** * @see org.openmrs.api.db.FormDAO#getFormCount(java.lang.String, java.lang.Boolean, * java.util.Collection, java.lang.Boolean, java.util.Collection, java.util.Collection, * java.util.Collection) */ @Override public Integer getFormCount(String partialName, Boolean published, Collection<EncounterType> encounterTypes, Boolean retired, Collection<FormField> containingAnyFormField, Collection<FormField> containingAllFormFields, Collection<Field> fields) throws DAOException { Criteria crit = getFormCriteria(partialName, published, encounterTypes, retired, containingAnyFormField, containingAllFormFields, fields); crit.setProjection(Projections.count("formId")); return OpenmrsUtil.convertToInteger((Long) crit.uniqueResult()); }
subquery.setProjection(Projections.count("ff.formFieldId")). add(Property.forName("ff.form.formId").eqProperty("f.formId")). add(Restrictions.in("ff.formFieldId", allFormFieldIds));
public CountProjection count() { return Projections.count(getPropertyName()); }
public CountProjection count() { return Projections.count(getPropertyName()); }
public CountProjection count() { return Projections.count(getPropertyName()); }
public CountProjection count() { return Projections.count(getPropertyName()); }
@Override public Long countPublicationsNotProcessedInProcess(Long corpusId, Long processId){ Session session = sessionFactory.getCurrentSession(); Criteria subQuery = session.createCriteria(CorpusHasPublicationsHasProcesses.class, "docsprocessed"); subQuery.createAlias("docsprocessed.corpusHasPublications", "allpubs", JoinType.RIGHT_OUTER_JOIN, Restrictions.eq("docsprocessed.id.chphpProcessesId", processId)); subQuery.add(Restrictions.eq("allpubs.id.chpCorpusId", corpusId)); subQuery.add(Restrictions.isNull("docsprocessed.id.chphpPublicationId")); subQuery.setProjection(Projections.count("allpubs.id.chpPublicationId")); Long count = (Long) subQuery.uniqueResult(); return count; }
/** * Adds a projection that allows the criteria to return the property count * * @param propertyName The name of the property * @param alias The alias to use */ public void count(String propertyName, String alias) { final CountProjection proj = Projections.count(calculatePropertyName(propertyName)); addProjectionToList(proj, alias); }
public Integer countAllComplexes( ) { if ( log.isDebugEnabled() ) { log.debug( "Counting all complexes" ); } final Long count = (Long) getSession().createCriteria(InteractionImpl.class) .createAlias("annotations", "a") .createAlias("a.cvTopic", "cv") .add(Restrictions.eq("cv.shortLabel", "curated-complex")) .setProjection(Projections.count("ac")).uniqueResult(); return count.intValue(); }
public Integer countAllComplexes( ) { if ( log.isDebugEnabled() ) { log.debug( "Counting all complexes" ); } final Long count = (Long) getSession().createCriteria(InteractionImpl.class) .createAlias("annotations", "a") .createAlias("a.cvTopic", "cv") .add(Restrictions.eq("cv.shortLabel", "curated-complex")) .setProjection(Projections.count("ac")).uniqueResult(); return count.intValue(); }
@Override public Query<T> number(String... properties) { if (properties != null && properties.length > 0) { for (String property : properties) { this.projections.add(Projections.count(this.getCriteriaAlias(property))); } } return this; }
/** * Adds a projection that allows the criteria to return the property count * * @param propertyName The name of the property * @param alias The alias to use */ public void count(String propertyName, String alias) { final CountProjection proj = Projections.count(calculatePropertyName(propertyName)); addProjectionToList(proj, alias); }
/** * Create a Criteria to find how many permission entries match the given granted permission. * * @param grantedPermission the granted permission to match * @return the search Criteria */ private Criteria createHasPermissionEntryCriteria(InternalGrantedPermission grantedPermission) { return session().createCriteria(InternalGrantedPermission.class) .add(Restrictions.eq("permission", grantedPermission.getPermission())) .add(Restrictions.eq("directoryMapping", grantedPermission.getDirectoryMapping())) .add(Restrictions.eq("groupName", grantedPermission.getGroupName())) .setProjection(Projections.count("id")); } }
@Override public Long countCorpusPublicationsOutdatedProcess(Long corpusId, Long processId){ Session session = sessionFactory.getCurrentSession(); Criteria subQuery = session.createCriteria(CorpusHasPublicationsHasProcesses.class, "docsprocessed"); subQuery.createAlias("docsprocessed.processes", "process", JoinType.LEFT_OUTER_JOIN, Restrictions.eq("docsprocessed.id.chphpProcessesId", processId)); subQuery.createAlias("docsprocessed.corpusHasPublications", "allpubs", JoinType.RIGHT_OUTER_JOIN, Restrictions.eq("docsprocessed.id.chphpProcessesId", processId)); subQuery.add(Restrictions.eq("allpubs.id.chpCorpusId", corpusId)); subQuery.add(Restrictions.or(Restrictions.isNull("docsprocessed.id.chphpPublicationId"), Restrictions.ltProperty("docsprocessed.chphpProcessesVersion", "process.proVersion"))); subQuery.setProjection(Projections.count("allpubs.id.chpPublicationId")); Long count = (Long) subQuery.uniqueResult(); return count; }
public static Map<String, Integer> countInteractionCountsForExperiments( String shortLabelLike ) { List<Object[]> expWithInteractionsCount = getSession().createCriteria( Experiment.class ) .add( Restrictions.like( "shortLabel", shortLabelLike ) ) .createAlias( "interactions", "int" ) .setProjection( Projections.projectionList() .add( Projections.distinct( Projections.property( "ac" ) ) ) .add( Projections.count( "int.ac" ) ) .add( Projections.groupProperty( "ac" ) ) ).list(); Map<String, Integer> interactionCountByExpAc = new HashMap<String, Integer>(); for ( Object[] expAndIntCount : expWithInteractionsCount ) { interactionCountByExpAc.put( (String) expAndIntCount[ 0 ], (Integer) expAndIntCount[ 1 ] ); } return interactionCountByExpAc; }
@Override public Long getNumberOfSourceValuesForGroupId(Long groupId) { DetachedCriteria criteria = DetachedCriteria.forClass(SourceConfigurationValue.class); criteria.add(Restrictions.eq("sourceConfigGroupId", groupId)); criteria.setProjection(Projections.rowCount()); criteria.setProjection(Projections.projectionList() .add(Projections.count("sourceConfigGroupId"))); return (Long) DataAccessUtils.uniqueResult(this.getHibernateTemplate().findByCriteria(criteria)); } }