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.denimgroup.threadfix.data.dao.hibernate.HibernateApplicationDao.java

License:Mozilla Public License

@Override
public long getUnmappedFindingCount(Integer appId) {
    Long result = (Long) sessionFactory.getCurrentSession().createCriteria(Finding.class)
            .add(Restrictions.isNull("vulnerability")).createAlias("scan", "scanAlias")
            .createAlias("scanAlias.application", "applicationAlias")
            .add(Restrictions.eq("applicationAlias.id", appId)).setProjection(Projections.rowCount())
            .uniqueResult();//from w  ww .  jav a 2s  .  c o  m
    return result == null ? 0 : result;
}

From source file:com.denimgroup.threadfix.data.dao.hibernate.HibernateApplicationDao.java

License:Mozilla Public License

@Override
public long getApplicationCount() {
    Long result = (Long) getActiveAppCriteria().setProjection(Projections.rowCount()).uniqueResult();
    return result == null ? 0 : result;
}

From source file:com.denimgroup.threadfix.data.dao.hibernate.HibernateApplicationDao.java

License:Mozilla Public License

@Override
public Long countApps(Integer teamId, String searchString) {

    return (Long) getSearchAppCriteria(teamId, searchString).setProjection(Projections.rowCount())
            .uniqueResult();//from   w ww .j  a  v  a 2s  . c  o m
}

From source file:com.denimgroup.threadfix.data.dao.hibernate.HibernateApplicationDao.java

License:Mozilla Public License

@Override
public Long countApps(Integer orgId, String searchString, Set<Integer> appIds, Set<Integer> teamIds) {
    Criteria criteria = getSearchAppCriteria(orgId, searchString);
    addFiltering(criteria, teamIds, appIds);

    return (Long) criteria.setProjection(Projections.rowCount()).uniqueResult();
}

From source file:com.denimgroup.threadfix.data.dao.hibernate.HibernateExceptionLogDao.java

License:Mozilla Public License

@Override
public Long countLogs() {
    return (Long) sessionFactory.getCurrentSession().createCriteria(ExceptionLog.class)
            .setProjection(Projections.rowCount()).uniqueResult();
}

From source file:com.denimgroup.threadfix.data.dao.hibernate.HibernateFindingDao.java

License:Mozilla Public License

@Override
public long getTotalUnmappedFindings() {
    Long maybeLong = (Long) sessionFactory.getCurrentSession().createCriteria(Finding.class)
            .add(Restrictions.eq("active", true)).add(Restrictions.isNull("vulnerability"))
            .setProjection(Projections.rowCount()).uniqueResult();
    return maybeLong == null ? 0 : maybeLong;
}

From source file:com.denimgroup.threadfix.data.dao.hibernate.HibernateScheduledJobDao.java

License:Mozilla Public License

@Override
public boolean checkSameDate(@Nonnull S scheduledJob) {
    if (scheduledJob.getDay() == null && scheduledJob.getFrequency() == null) {
        throw new IllegalArgumentException("Got scheduled job without day or frequency.");
    }//from www .j  a v a  2  s .  com

    Criteria criteria = getSession().createCriteria(getClassReference());

    if (scheduledJob.getDay() != null) {
        criteria.add(Restrictions.eq("day", scheduledJob.getDay()));
    } else if (scheduledJob.getFrequency() != null) {
        criteria.add(Restrictions.eq("frequency", scheduledJob.getFrequency()));
    }

    criteria.add(Restrictions.eq("hour", scheduledJob.getHour()));
    criteria.add(Restrictions.eq("minute", scheduledJob.getMinute()));
    criteria.add(Restrictions.eq("period", scheduledJob.getPeriod()));
    criteria.setProjection(Projections.rowCount());

    Long count = (Long) criteria.uniqueResult();

    return (count > 0);
}

From source file:com.denimgroup.threadfix.data.dao.hibernate.HibernateUserDao.java

License:Mozilla Public License

public boolean canRemovePermissionFromRole(Integer id, String string) {
    Long result = (Long) sessionFactory.getCurrentSession().createCriteria(User.class)
            .createAlias("globalRole", "roleAlias").add(Restrictions.eq("active", true))
            .add(Restrictions.eq("isLdapUser", false)).add(Restrictions.eq("roleAlias." + string, true))
            .add(Restrictions.ne("roleAlias.id", id)).setProjection(Projections.rowCount()).uniqueResult();

    if (result == null || result == 0) {
        // we also need to do a lookup on groups
        result += (Long) sessionFactory.getCurrentSession().createCriteria(User.class)
                .createAlias("groups", "groupAlias").createAlias("groupAlias.globalRole", "roleAlias")
                .add(Restrictions.eq("active", true)).add(Restrictions.eq("isLdapUser", false))
                .add(Restrictions.eq("groupAlias.active", true))
                .add(Restrictions.eq("roleAlias." + string, true)).add(Restrictions.ne("roleAlias.id", id))
                .setProjection(Projections.rowCount()).uniqueResult();
    }/*from   www  .j  av  a2  s .  c  o  m*/

    return result != null && result > 0;
}

From source file:com.denimgroup.threadfix.data.dao.hibernate.HibernateUserDao.java

License:Mozilla Public License

public boolean canRemovePermissionFromUser(Integer id, String string) {
    Long result = (Long) sessionFactory.getCurrentSession().createCriteria(User.class)
            .createAlias("globalRole", "roleAlias").add(Restrictions.eq("active", true))
            .add(Restrictions.eq("isLdapUser", false)).add(Restrictions.eq("roleAlias." + string, true))
            .add(Restrictions.ne("id", id)).setProjection(Projections.rowCount()).uniqueResult();

    if (result == null || result == 0) {
        // we also need to do a lookup on groups
        result += (Long) sessionFactory.getCurrentSession().createCriteria(User.class)
                .createAlias("groups", "groupAlias").createAlias("groupAlias.globalRole", "roleAlias")
                .add(Restrictions.eq("active", true)).add(Restrictions.eq("isLdapUser", false))
                .add(Restrictions.eq("groupAlias.active", true))
                .add(Restrictions.eq("roleAlias." + string, true)).add(Restrictions.ne("id", id))
                .setProjection(Projections.rowCount()).uniqueResult();
    }//w  ww  . ja  va2s . c  om

    return result != null && result > 0;
}

From source file:com.denimgroup.threadfix.data.dao.hibernate.HibernateUserDao.java

License:Mozilla Public License

@Override
public Long countUsers(String searchString) {
    Criteria criteria = getActiveUserCriteria().setProjection(Projections.rowCount());

    if (searchString != null) {
        criteria.add(Restrictions.or(Restrictions.like("name", "%" + searchString + "%"),
                Restrictions.like("displayName", "%" + searchString + "%")));
    }/*from  ww  w .j  a v a 2s.c om*/

    return (Long) criteria.uniqueResult();
}