Example usage for org.hibernate.criterion Projections rowCount

Introduction

In this page you can find the example usage for org.hibernate.criterion Projections rowCount.

Prototype

public static Projection rowCount()

Source Link

Document

The query row count, ie.

Usage

From source file:com.jaspersoft.jasperserver.api.metadata.tenant.service.impl.TenantServiceImpl.java

License:Open Source License

public int getSubTenantsCount(ExecutionContext context, String parentTenantId, String text) {
    DetachedCriteria criteria = createSearchTenantsCriteria(parentTenantId, text);

    criteria.setProjection(Projections.rowCount());
    criteria.getExecutableCriteria(getSession()).setCacheable(true);

    List results = getHibernateTemplate().findByCriteria(criteria);

    if (results != null && !results.isEmpty()) {
        return (Integer) results.get(0);
    }/*from   w ww . java 2  s .  c  o  m*/

    return 0;
}

From source file:com.jaspersoft.jasperserver.api.metadata.tenant.service.impl.TenantServiceImpl.java

License:Open Source License

public Map<String, Integer> getSubTenantsCountMap(List<String> tenantIds) {
    if (tenantIds == null || tenantIds.size() == 0) {
        return Collections.emptyMap();
    }/*  www .java 2  s  . c o  m*/

    DetachedCriteria criteria = DetachedCriteria.forClass(persistentTenantClass());

    criteria.createAlias("parent", "p");
    criteria.add(Restrictions.in("p.tenantId", tenantIds));

    criteria.setProjection(Projections.projectionList().add(Projections.rowCount())
            .add(Projections.groupProperty("p.tenantId")));
    criteria.getExecutableCriteria(getSession()).setCacheable(true);

    List results = getHibernateTemplate().findByCriteria(criteria);

    Map<String, Integer> subTenantCounts = new HashMap<String, Integer>(tenantIds.size(), 1);
    if (results != null && results.size() > 0) {
        for (Object result : results) {
            String tenantId = (String) ((Object[]) result)[1];
            Integer count = (Integer) ((Object[]) result)[0];

            subTenantCounts.put(tenantId, count);
        }
    }

    for (String tenantId : tenantIds) {
        if (!subTenantCounts.containsKey(tenantId)) {
            subTenantCounts.put(tenantId, 0);
        }
    }

    return subTenantCounts;
}

From source file:com.jaspersoft.jasperserver.api.metadata.user.service.impl.UserAuthorityServiceImpl.java

License:Open Source License

@Transactional(propagation = Propagation.REQUIRED)
public int getTenantVisibleRolesCount(ExecutionContext context, Set tenantIds, String name) {
    DetachedCriteria criteria = createTenantVisibleRolesCriteria(tenantIds, name, false);

    criteria.setProjection(Projections.rowCount());

    List results = getHibernateTemplate().findByCriteria(criteria);

    Integer rowCount = new Integer(0);
    if (results != null && !results.isEmpty()) {
        rowCount = (Integer) results.get(0);
    }/*w w  w  .j  a  v a2  s  . c o m*/

    return rowCount.intValue();
}

From source file:com.jaspersoft.jasperserver.api.metadata.user.service.impl.UserAuthorityServiceImpl.java

License:Open Source License

@Transactional(propagation = Propagation.REQUIRED)
public int getTenantUsersCount(ExecutionContext context, final Set tenantIds, final String name) {
    Integer rowCount = (Integer) getHibernateTemplate().execute(new HibernateCallback() {
        public Object doInHibernate(Session session) throws HibernateException, SQLException {
            Criteria criteria = createTenantUsersCriteria(session, tenantIds, name, false);
            criteria.setProjection(Projections.rowCount());
            return criteria.uniqueResult();
        }//from   w ww  .  ja  va  2  s  . c o  m
    });
    return rowCount.intValue();
}

From source file:com.jaspersoft.jasperserver.api.metadata.user.service.impl.UserAuthorityServiceImpl.java

License:Open Source License

@Transactional(propagation = Propagation.REQUIRED)
public int getTenantRolesCount(ExecutionContext context, final Set tenantIds, final String name) {
    Integer rowCount = (Integer) getHibernateTemplate().execute(new HibernateCallback() {
        public Object doInHibernate(Session session) throws HibernateException, SQLException {
            Criteria criteria = createTenantRolesCriteria(session, tenantIds, name, false);
            criteria.setProjection(Projections.rowCount());
            return criteria.uniqueResult();
        }/*from w  ww. j  ava  2  s .c om*/
    });
    return rowCount.intValue();
}

From source file:com.jaspersoft.jasperserver.api.metadata.user.service.impl.UserAuthorityServiceImpl.java

License:Open Source License

@Transactional(propagation = Propagation.REQUIRED)
public int getAvailableRolesCount(ExecutionContext context, String roleName, Set userRoles, String userName) {

    DetachedCriteria criteria = createAvailableRolesCriteria(roleName, userRoles, userName, false);
    criteria.setProjection(Projections.rowCount());

    List results = getHibernateTemplate().findByCriteria(criteria);

    Integer rowCount = new Integer(0);
    if (results != null && !results.isEmpty()) {
        rowCount = (Integer) results.get(0);
    }/*from w  w  w  .  j a v a2  s  .co  m*/

    return rowCount.intValue();
}

From source file:com.jaspersoft.jasperserver.api.metadata.user.service.impl.UserAuthorityServiceImpl.java

License:Open Source License

@Transactional(propagation = Propagation.REQUIRED)
public int getAvailableRolesCount(ExecutionContext context, String userName, String text) {
    DetachedCriteria criteria = createAvailableRolesCriteria(context, userName, text, false);
    criteria.setProjection(Projections.rowCount());

    List results = getHibernateTemplate().findByCriteria(criteria);

    int rowCount = 0;
    if (results != null && !results.isEmpty()) {
        rowCount = (Integer) results.get(0);
    }/*from   w ww .ja  v  a2s .c om*/

    return rowCount;
}

From source file:com.jaspersoft.jasperserver.api.metadata.user.service.impl.UserAuthorityServiceImpl.java

License:Open Source License

@Transactional(propagation = Propagation.REQUIRED)
public int getAssignedRolesCount(ExecutionContext context, String userName, String text) {
    RepoUser user = getRepoUser(context, userName);

    DetachedCriteria criteria = createAssignedRolesCriteria(context, user, text, false);
    criteria.setProjection(Projections.rowCount());

    List results = getHibernateTemplate().findByCriteria(criteria);

    int rowCount = 0;
    if (results != null && !results.isEmpty()) {
        rowCount = (Integer) results.get(0);
    }// w  w  w  .  j  ava2s.  c o m

    return rowCount;
}

From source file:com.jaspersoft.jasperserver.api.metadata.user.service.impl.UserAuthorityServiceImpl.java

License:Open Source License

@Transactional(propagation = Propagation.REQUIRED)
public int getUsersCountWithoutRole(ExecutionContext context, String roleName, String userName) {

    DetachedCriteria criteria = createUsersWithoutRoleCriteria(roleName, userName, false);
    criteria.setProjection(Projections.rowCount());

    List results = getHibernateTemplate().findByCriteria(criteria);

    return getRowCountFromResult(results);
}

From source file:com.jaspersoft.jasperserver.api.metadata.user.service.impl.UserAuthorityServiceImpl.java

License:Open Source License

@Transactional(propagation = Propagation.REQUIRED)
public int getUsersCountWithRole(ExecutionContext context, String roleName, String userName) {

    DetachedCriteria criteria = createUsersWithRoleCriteria(roleName, userName, false);
    criteria.setProjection(Projections.rowCount());

    List results = getHibernateTemplate().findByCriteria(criteria);

    return getRowCountFromResult(results);
}