Example usage for org.hibernate.criterion Restrictions isNull

Introduction

In this page you can find the example usage for org.hibernate.criterion Restrictions isNull.

Prototype

public static Criterion isNull(String propertyName)

Source Link

Document

Apply an "is null" constraint to the named property

Usage

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

License:Mozilla Public License

@Override
@SuppressWarnings("unchecked")
public List<Finding> retrieveUnmappedFindingsByPage(int page, Integer appId) {
    Criteria criteria = sessionFactory.getCurrentSession().createCriteria(Finding.class)
            .add(Restrictions.eq("active", true)).add(Restrictions.isNull("vulnerability"));

    if (appId != null) {
        criteria.createAlias("scan", "scanAlias").createAlias("scanAlias.application", "appAlias")
                .add(Restrictions.eq("appAlias.id", appId));
    }//from   ww  w  .  j a  v  a 2 s.  c o  m

    return criteria.createAlias("channelSeverity", "severity").createAlias("channelVulnerability", "vuln")
            .createAlias("surfaceLocation", "surface").setFirstResult((page - 1) * Finding.NUMBER_ITEM_PER_PAGE)
            .setMaxResults(Finding.NUMBER_ITEM_PER_PAGE).addOrder(Order.desc("severity.numericValue"))
            .addOrder(Order.asc("vuln.name")).addOrder(Order.asc("surface.path")).list();
}

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.HibernateFindingDao.java

License:Mozilla Public License

@Override
public List<Finding> getUnmappedFindings() {
    List<Finding> unmappedFindings = list();

    Criteria criteria = sessionFactory.getCurrentSession().createCriteria(Finding.class)
            .add(Restrictions.eq("active", true)).add(Restrictions.isNull("vulnerability"));

    unmappedFindings = criteria.list();//w w w  .  j a  v a  2  s.  c om
    return unmappedFindings;
}

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

License:Mozilla Public License

@Override
public Tag retrieveAppTagByName(String name) {
    return (Tag) getSession().createCriteria(getClassReference()).add(Restrictions.eq("active", true))
            .add(Restrictions.eq("name", name))
            .add(Restrictions.or(Restrictions.isNull("type"), Restrictions.eq("type", TagType.APPLICATION)))
            .uniqueResult();/*from  w  w  w  .j ava  2 s .  co m*/
}

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

License:Mozilla Public License

@Override
public List<Tag> retrieveAllApplicationTags() {
    return getSession().createCriteria(getClassReference()).add(Restrictions.eq("active", true))
            .add(Restrictions.or(Restrictions.isNull("type"), Restrictions.eq("type", TagType.APPLICATION)))
            .addOrder(getOrder()).list();
}

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

License:Mozilla Public License

private void addPermissionRestrictions() {
    if (parameters.getPermissionsList() != null && !parameters.getPermissionsList().isEmpty()) {
        criteria.createAlias("endpointPermissions", "permissionAlias");
        criteria.add(Restrictions.in("permissionAlias.name", parameters.getPermissionsList()));
    }/*from  w  w  w . j  a  v a 2 s .  co m*/

    if (parameters.getShowAuthenticated() || parameters.getShowUnknown()
            || parameters.getShowUnauthenticated()) {
        List<AuthenticationRequired> ordinalValues = list();

        boolean acceptNull = false;

        if (parameters.getShowAuthenticated()) {
            ordinalValues.add(AUTHENTICATED);
        }
        if (parameters.getShowUnauthenticated()) {
            ordinalValues.add(ANONYMOUS);
        }
        if (parameters.getShowUnknown()) {
            ordinalValues.add(UNKNOWN);
            acceptNull = true;
        }

        Criterion restrictions;
        if (acceptNull) {
            restrictions = Restrictions.or(Restrictions.in("authenticationRequired", ordinalValues),
                    Restrictions.isNull("authenticationRequired"));
        } else {
            restrictions = Restrictions.in("authenticationRequired", ordinalValues);
        }
        criteria.add(restrictions);
    }

}

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

License:Mozilla Public License

private void addDefectOptions() {
    boolean showDefectPresent = parameters.getShowDefectPresent() != null && parameters.getShowDefectPresent();
    boolean showDefectNotPresent = parameters.getShowDefectNotPresent() != null
            && parameters.getShowDefectNotPresent();
    boolean showDefectOpen = parameters.getShowDefectOpen() != null && parameters.getShowDefectOpen();
    boolean showDefectClosed = parameters.getShowDefectClosed() != null && parameters.getShowDefectClosed();

    Criterion defectRestrictions = null;
    boolean defectAliasCreated = false;

    if (showDefectPresent) {
        defectRestrictions = disjoinRestrictions(defectRestrictions, Restrictions.isNotNull("defect"));
        LOG.debug("Adding defect not null restriction");
    }/*  w w  w.  j  a  v a 2s  . c  o m*/

    if (showDefectNotPresent) {
        defectRestrictions = disjoinRestrictions(defectRestrictions, Restrictions.isNull("defect"));
        LOG.debug("Adding defect is null restriction");
    }

    if (showDefectOpen) {
        if (!defectAliasCreated) {
            criteria.createAlias("defect", "d", Criteria.LEFT_JOIN);
            defectAliasCreated = true;
        }
        defectRestrictions = disjoinRestrictions(defectRestrictions,
                Restrictions.in("d.status", Defect.OPEN_CODES));
        LOG.debug("Adding defect is open restriction");
    }

    if (showDefectClosed) {
        if (!defectAliasCreated) {
            criteria.createAlias("defect", "d", Criteria.LEFT_JOIN);
            defectAliasCreated = true;
        }
        defectRestrictions = disjoinRestrictions(defectRestrictions,
                Restrictions.in("d.status", Defect.CLOSED_CODES));
        LOG.debug("Adding defect is closed restriction");
    }

    if (defectRestrictions != null) {
        criteria.add(defectRestrictions);
    }
}

From source file:com.eharmony.matching.seeking.translator.hibernate.HibernateQueryTranslator.java

License:Apache License

@Override
public Criterion isNull(String fieldName) {
    return Restrictions.isNull(fieldName);
}

From source file:com.emergya.persistenceGeo.dao.impl.AbstractGenericDaoHibernateImpl.java

License:Open Source License

/**
 * Lista todos con los elementos iguales a los pasados como argumento
 * /*  www. j  a  va2 s  .c  o m*/
 * @param filtros a ejecutar
 * 
 * @return todas las entidades en session que cumplan los filtros
 */
@SuppressWarnings("unchecked")
public List<T> findExact(Map<String, Object> filtros) {
    Criteria crit = getSession().createCriteria(persistentClass);

    for (String key : filtros.keySet()) {
        if (filtros.get(key) == null) {
            crit.add(Restrictions.isNull(key));
        } else {
            crit.add(Restrictions.eq(key, filtros.get(key)));
        }
    }

    return (List<T>) crit.list();
}

From source file:com.emergya.persistenceGeo.dao.impl.AbstractGenericDaoHibernateImpl.java

License:Open Source License

/**
* Lista todos con los elementos like a los pasados como argumento
* 
* @param filtros a ejecutar// w  w  w .  ja  v a2  s.  c  o  m
* 
* @return todas las entidades en session que cumplan los filtros
*/
@SuppressWarnings("unchecked")
public List<T> findLike(Map<String, Object> filtros) {
    Criteria crit = getSession().createCriteria(persistentClass);

    for (String key : filtros.keySet()) {
        if (filtros.get(key) == null) {
            crit.add(Restrictions.isNull(key));
        } else {
            //crit.add(new LikeSpecialCharsExpression(key, filtros.get(key).toString(), MatchMode.ANYWHERE));
            crit.add(Restrictions.like(key, filtros.get(key).toString(), MatchMode.ANYWHERE));
        }
    }

    return (List<T>) crit.list();
}