Example usage for org.hibernate.criterion Restrictions and

Introduction

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

Prototype

public static LogicalExpression and(Criterion lhs, Criterion rhs)

Source Link

Document

Return the conjuction of two expressions

Usage

From source file:com.vmware.appfactory.feed.dao.FeedDaoImpl.java

License:Open Source License

@Override
public long countFailed() {
    Criterion criterion = Restrictions.and(Restrictions.isNotNull("_failure._summary"),
            Restrictions.ne("_failure._summary", Feed.SCANNING));
    return countByCriterion(criterion);
}

From source file:com.vmware.bdd.dal.impl.NodeDAO.java

License:Open Source License

@Override
public NodeEntity findByName(NodeGroupEntity group, String name) {
    AuAssert.check(group != null);//w w  w  .j ava2 s  .c  om
    return findUniqueByCriteria(
            Restrictions.and(Restrictions.eq("nodeGroup", group), Restrictions.eq("vmName", name)));
}

From source file:com.vmware.bdd.entity.HadoopNodeEntity.java

License:Open Source License

public static HadoopNodeEntity findByName(NodeGroupEntity group, String name) {
    AuAssert.check(group != null);/*from   w  ww . ja  v  a2 s .com*/
    return DAL.findUniqueByCriteria(HadoopNodeEntity.class,
            Restrictions.and(Restrictions.eq("nodeGroup", group), Restrictions.eq("vmName", name)));
}

From source file:com.vmware.bdd.entity.TaskEntity.java

License:Open Source License

public static List<TaskEntity> findAllByStatus(final Status[] anyStatus, final String exceptCookie) {
    return DAL.autoTransactionDo(new Saveable<List<TaskEntity>>() {
        @Override//  w ww.j  a  v  a2 s .  c o  m
        public List<TaskEntity> body() throws Exception {
            Criterion crit = null;
            for (Status s : anyStatus) {
                if (crit == null) {
                    crit = Restrictions.eq("status", s);
                } else {
                    crit = Restrictions.or(crit, Restrictions.eq("status", s));
                }
            }

            AuAssert.check(crit != null);

            if (exceptCookie != null) {
                crit = Restrictions.and(crit, Restrictions.ne("cookie", exceptCookie));
            }

            return DAL.findByCriteria(TaskEntity.class, crit);
        }
    });
}

From source file:com.webbfontaine.valuewebb.action.pricedb.mp.PRDConsult.java

License:Open Source License

private void fillPDs(Pd pd) {
    Calendar calendar = Calendar.getInstance();
    calendar.setTime(new Date());
    calendar.add(Calendar.MONTH, -3);
    Date dateOfTodayMinus3Months = calendar.getTime();

    Criteria criteria = PersistenceUtil.getSession(entityManager).createCriteria(Pd.class)
            .setMaxResults(Constants.MAX_RECORDS_IN_FINDER_RESULT).addOrder(Order.desc("id"));
    if (pd.getHsCodeF() != null) {
        criteria.add(Restrictions.like("hsCodeF", pd.getHsCodeF(), MatchMode.START));
    }// www  .  ja  v a2  s  . c  om
    if (pd.getProductDscF() != null) {
        criteria.add(Restrictions.ilike("productDscF", pd.getProductDscF(), MatchMode.ANYWHERE));
    }
    if (!StringUtils.isEmpty(pd.getValMethod())) {
        criteria.add(Restrictions.ilike("valMethod", pd.getValMethod(), MatchMode.ANYWHERE));
    }

    if (ApplicationProperties.getAppCountry().equals(Constants.CI)) {
        // according to ELL-1186, hardcoded restriction added to qlClassLine, qlValLine
        criteria.add(Restrictions.and(
                Restrictions.or(Restrictions.eq("qlValLine", "1"), Restrictions.isNull("qlValLine")),
                Restrictions.or(Restrictions.eq("qlClassLine", "1"), Restrictions.isNull("qlClassLine"))));
    }

    Criteria ttCrit = criteria.createCriteria("ttGen");
    ttCrit.add(Restrictions.ge("date", dateOfTodayMinus3Months));

    pdDB.addAll(criteria.list());
}

From source file:com.webbfontaine.valuewebb.search.custom.UserCriterion.java

License:Open Source License

private Criterion getPercentRange() {
    BigDecimal bdValue = new BigDecimal(value.toString());

    BigDecimal range = bdValue.multiply(new BigDecimal(diff).divide(new BigDecimal(100)));

    BigDecimal bdValueFrom = bdValue.subtract(range);
    BigDecimal bdValueTo = bdValue.add(range);
    return Restrictions.and(Restrictions.ge(fullKey, bdValueFrom), Restrictions.le(fullKey, bdValueTo));
}

From source file:com.yahoo.elide.datastores.hibernate3.filter.CriterionFilterOperation.java

License:Apache License

@Override
public Criterion applyAll(Set<FilterPredicate> filterPredicates) {
    Criterion result = null;/*from w  w  w. ja v  a2  s .c o  m*/

    for (FilterPredicate filterPredicate : filterPredicates) {
        if (result == null) {
            result = apply(filterPredicate);
        }
        result = Restrictions.and(result, apply(filterPredicate));
    }

    return result;
}

From source file:com.z.services.dao.impl.EstablecimientosDAOService.java

@Override
@Transactional(readOnly = true)/*  w  ww . j  av a  2  s . c  om*/
public List<Establecimientos> listByLocalidadAndDepartamento(String localidad, String departamento) {
    Criterion loc = Restrictions.eq("Localidad", localidad);
    Criterion dep = Restrictions.eq("Departamento", departamento);
    LogicalExpression andExp = Restrictions.and(loc, dep);
    Criteria crit = sessionFactory.getCurrentSession().createCriteria(Establecimientos.class);
    crit.add(andExp);
    return crit.list();
}

From source file:com.z.services.dao.impl.EstablecimientosDAOService.java

@Override
@Transactional(readOnly = true)//from  www.  j  av  a 2 s .c o m
public List<Establecimientos> listByLocalidadAndDepartamento(String localidad, String departamento,
        String regimen) {
    Criterion loc = Restrictions.eq("Localidad", localidad);
    Criterion dep = Restrictions.eq("Departamento", departamento);
    Criterion reg = Restrictions.eq("Regimen", regimen);
    LogicalExpression andExp = Restrictions.and(loc, dep);
    Criteria crit = sessionFactory.getCurrentSession().createCriteria(Establecimientos.class);
    crit.add(andExp);
    crit.add(reg);
    return crit.list();
}

From source file:com.zapangtrainer.model.dao.ClientDAOImpl.java

@Transactional(propagation = Propagation.REQUIRED, readOnly = true)
public Object readProperty(String listType, String name, String number, String email, String ipAddress,
        String date) {//from   w w w .j av  a 2 s . co m
    List<Client> client = null;
    switch (listType) {
    case "All":

        session = getSessionFactory().getCurrentSession();

        client = (List<Client>) session.createCriteria(Client.class).list();
        for (Client tclient : client) {
            tclient.getReply().size();
        }

    case "NameNumberEmailIpaddressDate":

        session = getSessionFactory().getCurrentSession();

        client = (List<Client>) session.createCriteria(Client.class).add(Restrictions.and(Restrictions.and(
                Restrictions.and(Restrictions.eq("name", name), Restrictions.eq("phoneNumber", number)),
                Restrictions.and(Restrictions.eq("ipAddress", ipAddress), Restrictions.eq("date", date))),
                Restrictions.eq("emailId", email))).list();

    default:
    }
    return (T) client;
}