Example usage for org.hibernate.criterion Restrictions isNotNull

Introduction

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

Prototype

public static Criterion isNotNull(String propertyName)

Source Link

Document

Apply an "is not null" constraint to the named property

Usage

From source file:org.candlepin.model.PoolCurator.java

License:Open Source License

/**
 * @param consumer//from ww w .j a va 2  s. com
 * @param stackId
 * @return Number of derived pools which exist for the given consumer and stack
 */
public Pool getSubPoolForStackId(Consumer consumer, String stackId) {
    Criteria getCount = createSecureCriteria().createAlias("sourceStack", "ss")
            .add(Restrictions.eq("ss.sourceConsumer", consumer)).add(Restrictions.and(
                    Restrictions.isNotNull("ss.sourceStackId"), Restrictions.eq("ss.sourceStackId", stackId)));
    return (Pool) getCount.uniqueResult();
}

From source file:org.cimmyt.dnast.dao.imp.StProjectHome.java

License:Apache License

@Override
protected void buildCriteria(Criteria criteria, StProject filter) {
    //TEMPORAL RESTRICTION
    criteria.add(Restrictions.isNotNull("fundingSource"));

    if (filter == null)
        return;// w w  w  .j  a v a2  s.c  om

    if (filter.getProjectid() != null && filter.getProjectid().intValue() > 0) {
        criteria.add(Restrictions.eq("projectid", filter.getProjectid()));
    }
    if (filter.getProjectName() != null && !filter.getProjectName().trim().equals("")) {
        criteria.add(Restrictions.like("projectName", "%" + filter.getProjectName() + "%"));
    }
    if (filter.getPurposeName() != null && !filter.getPurposeName().trim().equals("")) {
        criteria.add(Restrictions.like("purposeName", "%" + filter.getPurposeName() + "%"));
    }
}

From source file:org.codehaus.groovy.grails.orm.hibernate.query.AbstractHibernateCriterionAdapter.java

License:Apache License

protected void addSimpleCriterionAdapters() {
    criterionAdaptors.put(Query.IsNull.class, new CriterionAdaptor<Query.IsNull>() {
        @Override//  w  ww  .  j  a v a  2s .  c o m
        public Criterion toHibernateCriterion(AbstractHibernateQuery hibernateQuery, Query.IsNull criterion,
                String alias) {
            String propertyName = getPropertyName(criterion, alias);
            return Restrictions.isNull(propertyName);
        }
    });
    criterionAdaptors.put(Query.IsNotNull.class, new CriterionAdaptor<Query.IsNotNull>() {
        @Override
        public Criterion toHibernateCriterion(AbstractHibernateQuery hibernateQuery, Query.IsNotNull criterion,
                String alias) {
            String propertyName = getPropertyName(criterion, alias);
            return Restrictions.isNotNull(propertyName);
        }
    });
    criterionAdaptors.put(Query.IsEmpty.class, new CriterionAdaptor<Query.IsEmpty>() {
        @Override
        public Criterion toHibernateCriterion(AbstractHibernateQuery hibernateQuery, Query.IsEmpty criterion,
                String alias) {
            String propertyName = getPropertyName(criterion, alias);
            return Restrictions.isEmpty(propertyName);
        }
    });
    criterionAdaptors.put(Query.IsNotEmpty.class, new CriterionAdaptor<Query.IsNotEmpty>() {
        @Override
        public Criterion toHibernateCriterion(AbstractHibernateQuery hibernateQuery, Query.IsNotEmpty criterion,
                String alias) {
            String propertyName = getPropertyName(criterion, alias);
            return Restrictions.isNotEmpty(propertyName);
        }
    });
}

From source file:org.codehaus.groovy.grails.orm.hibernate.query.AbstractHibernateQuery.java

License:Apache License

@Override
public Query isNotNull(String property) {
    addToCriteria(Restrictions.isNotNull(calculatePropertyName(property)));
    return this;
}

From source file:org.codehaus.groovy.grails.orm.hibernate.query.HibernateQuery.java

License:Apache License

@Override
public Query isNotNull(String property) {
    criteria.add(Restrictions.isNotNull(property));
    return this;
}

From source file:org.dspace.eperson.dao.impl.EPersonDAOImpl.java

License:BSD License

@Override
public List<EPerson> findWithPasswordWithoutDigestAlgorithm(Context context) throws SQLException {
    Criteria criteria = createCriteria(context, EPerson.class);
    criteria.add(Restrictions.and(Restrictions.isNotNull("password"), Restrictions.isNull("digestAlgorithm")));
    return list(criteria);
}

From source file:org.dspace.identifier.dao.impl.DOIDAOImpl.java

License:BSD License

@Override
public List<DOI> findSimilarNotInState(Context context, String doi, List<Integer> excludedStatuses,
        boolean dsoNotNull) throws SQLException {
    // SELECT * FROM Doi WHERE doi LIKE ? AND resource_type_id = ? AND resource_id IS NOT NULL AND status != ? AND status != ?
    Criteria criteria = createCriteria(context, DOI.class);
    Conjunction conjunctionAnd = Restrictions.and();
    Disjunction statusQuery = Restrictions.or();
    for (Integer status : excludedStatuses) {
        statusQuery.add(Restrictions.ne("status", status));
    }/*w  w w . jav  a  2  s.  com*/
    conjunctionAnd.add(Restrictions.like("doi", doi));
    conjunctionAnd.add(statusQuery);
    if (dsoNotNull) {
        conjunctionAnd.add(Restrictions.isNotNull("dSpaceObject"));
    }
    criteria.add(conjunctionAnd);
    return list(criteria);
}

From source file:org.dspace.versioning.dao.impl.VersionDAOImpl.java

License:BSD License

@Override
public List<Version> findVersionsWithItems(Context context, VersionHistory versionHistory) throws SQLException {
    Criteria criteria = createCriteria(context, Version.class);
    criteria.add(Restrictions.eq("versionHistory", versionHistory));
    criteria.add(Restrictions.and(Restrictions.isNotNull("item")));
    criteria.addOrder(Order.desc("versionNumber"));
    return list(criteria);
}

From source file:org.egov.tl.service.TradeLicenseService.java

License:Open Source License

@ReadOnly
public List<OnlineSearchForm> onlineSearchTradeLicense(final OnlineSearchForm searchForm) {
    final Criteria searchCriteria = entityManager.unwrap(Session.class).createCriteria(TradeLicense.class);
    searchCriteria.createAlias("licensee", "licc").createAlias("category", "cat")
            .createAlias("tradeName", "subcat").createAlias("status", "licstatus");
    if (isNotBlank(searchForm.getApplicationNumber()))
        searchCriteria// w w  w  . j av  a  2  s.  co m
                .add(Restrictions.eq("applicationNumber", searchForm.getApplicationNumber()).ignoreCase());
    if (isNotBlank(searchForm.getLicenseNumber()))
        searchCriteria.add(Restrictions.eq("licenseNumber", searchForm.getLicenseNumber()).ignoreCase());
    if (isNotBlank(searchForm.getMobileNo()))
        searchCriteria.add(Restrictions.eq("licc.mobilePhoneNumber", searchForm.getMobileNo()));
    if (isNotBlank(searchForm.getTradeOwnerName()))
        searchCriteria.add(Restrictions.like("licc.applicantName", searchForm.getTradeOwnerName(), ANYWHERE));

    searchCriteria.add(Restrictions.isNotNull("applicationNumber"));
    searchCriteria.addOrder(Order.asc("id"));
    List<OnlineSearchForm> searchResult = new ArrayList<>();
    for (TradeLicense license : (List<TradeLicense>) searchCriteria.list()) {
        if (license != null)
            searchResult.add(new OnlineSearchForm(license, getDemandColl(license)));
    }
    return searchResult;
}

From source file:org.emonocot.persistence.dao.hibernate.ResourceDaoImpl.java

License:Open Source License

@Override
public boolean isHarvesting() {
    Criteria criteria = getSession().createCriteria(type);
    criteria.add(Restrictions.isNotNull("resourceType"));
    criteria.add(Restrictions.not(Restrictions.in("status", Arrays.asList(new BatchStatus[] {
            BatchStatus.COMPLETED, BatchStatus.FAILED, BatchStatus.ABANDONED, BatchStatus.STOPPED }))));
    criteria.setProjection(Projections.rowCount());
    return (Long) criteria.uniqueResult() > 0;
}