Example usage for org.hibernate.criterion Restrictions lt

List of usage examples for org.hibernate.criterion Restrictions lt

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. Restrictions
  6. lt

Introduction

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

Prototype

public static SimpleExpression lt(String propertyName, Object value)

Source Link

Document

Apply a "less than" constraint to the named property

Usage

From source file:org.fireflow.engine.modules.persistence.hibernate.ReassignConfigPersisterHibernateImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<ReassignConfig> findReassignConfig(final String processId, final String processType,
        final String activityId, final String userId) {
    List<ReassignConfig> result = (List<ReassignConfig>) this.getHibernateTemplate()
            .execute(new HibernateCallback() {

                public Object doInHibernate(Session session) throws HibernateException, SQLException {
                    Criteria criteria = session.createCriteria(ReassignConfigImpl.class);
                    criteria.add(Restrictions.eq("processId", processId))
                            .add(Restrictions.eq("processType", processType))
                            .add(Restrictions.lt("activityId", activityId))
                            .add(Restrictions.lt("grantorId", userId));

                    return criteria.list();
                }//from  w  w  w.j  av  a 2 s.c om

            });

    return result;
}

From source file:org.fireflow.engine.modules.persistence.hibernate.TokenPersisterHibernateImpl.java

License:Open Source License

public List<Token> findSiblings(final Token token) {
    Object result = this.getHibernateTemplate().execute(new HibernateCallback() {

        public Object doInHibernate(Session session) throws HibernateException, SQLException {
            Criteria c = session.createCriteria(TokenImpl.class);
            c.add(Restrictions.eq("processInstanceId", token.getProcessInstanceId()));
            c.add(Restrictions.eq("elementId", token.getElementId()));
            c.add(Restrictions.eq("operationContextName", token.getOperationContextName()));
            c.add(Restrictions.lt("state", TokenState.DELIMITER));

            return c.list();
        }/*from w  w  w.j  a v  a  2  s.c om*/

    });
    return (List<Token>) result;
}

From source file:org.fireflow.engine.modules.persistence.hibernate.TokenPersisterHibernateImpl.java

License:Open Source License

public int countAliveToken(final String processInstanceId, final String nodeId,
        final OperationContextName operationContextName) {
    Object result = this.getHibernateTemplate().execute(new HibernateCallback() {

        public Object doInHibernate(Session session) throws HibernateException, SQLException {
            Criteria c = session.createCriteria(TokenImpl.class);
            c.add(Restrictions.eq("processInstanceId", processInstanceId));
            c.add(Restrictions.eq("elementId", nodeId));
            c.add(Restrictions.eq("operationContextName", operationContextName));
            c.add(Restrictions.lt("state", TokenState.DELIMITER));
            c.setProjection(Projections.rowCount());
            return c.uniqueResult();
        }//from   w  w w . j  a va2s  . co  m

    });
    if (result == null) {
        return 0;
    } else if (result instanceof Integer) {
        return ((Integer) result).intValue();
    } else if (result instanceof Long) {
        return ((Long) result).intValue();
    }
    return 0;
}

From source file:org.fornax.cartridges.sculptor.framework.accessimpl.jpahibernate.JpaHibFindByConditionAccessImpl.java

License:Apache License

private Criterion makeCriterion(ConditionalCriteria crit) {
    if (crit == null) {
        return null;
    }/*from  w w w. ja va2 s.com*/

    ConditionalCriteria.Operator operator = crit.getOperator();
    if (Operator.Equal.equals(operator)) {
        return Restrictions.eq(makePathWithAlias(crit.getPropertyFullName()), crit.getFirstOperant());
    } else if (Operator.IgnoreCaseEqual.equals(operator)) {
        return Restrictions.eq(makePathWithAlias(crit.getPropertyFullName()), crit.getFirstOperant())
                .ignoreCase();
    } else if (Operator.LessThan.equals(operator)) {
        return Restrictions.lt(makePathWithAlias(crit.getPropertyFullName()), crit.getFirstOperant());
    } else if (Operator.LessThanOrEqual.equals(operator)) {
        return Restrictions.le(makePathWithAlias(crit.getPropertyFullName()), crit.getFirstOperant());
    } else if (Operator.GreatThan.equals(operator)) {
        return Restrictions.gt(makePathWithAlias(crit.getPropertyFullName()), crit.getFirstOperant());
    } else if (Operator.GreatThanOrEqual.equals(operator)) {
        return Restrictions.ge(makePathWithAlias(crit.getPropertyFullName()), crit.getFirstOperant());
    } else if (Operator.Like.equals(operator)) {
        return Restrictions.like(makePathWithAlias(crit.getPropertyFullName()), crit.getFirstOperant());
    } else if (Operator.IgnoreCaseLike.equals(operator)) {
        return Restrictions.ilike(makePathWithAlias(crit.getPropertyFullName()), crit.getFirstOperant());
    } else if (Operator.IsNull.equals(operator)) {
        return Restrictions.isNull(makePathWithAlias(crit.getPropertyFullName()));
    } else if (Operator.IsNotNull.equals(operator)) {
        return Restrictions.isNotNull(makePathWithAlias(crit.getPropertyFullName()));
    } else if (Operator.IsEmpty.equals(operator)) {
        return Restrictions.isEmpty(makePathWithAlias(crit.getPropertyFullName()));
    } else if (Operator.IsNotEmpty.equals(operator)) {
        return Restrictions.isNotEmpty(makePathWithAlias(crit.getPropertyFullName()));
    } else if (Operator.Not.equals(operator)) {
        return Restrictions.not(makeCriterion((ConditionalCriteria) crit.getFirstOperant()));
    } else if (Operator.Or.equals(operator) && crit.getFirstOperant() instanceof List<?>) {
        Disjunction disj = Restrictions.disjunction();
        List<?> disjList = (List<?>) crit.getFirstOperant();
        for (Object disjPart : disjList) {
            disj.add(makeCriterion((ConditionalCriteria) disjPart));
        }
        return disj;
    } else if (Operator.Or.equals(operator)) {
        return Restrictions.or(makeCriterion((ConditionalCriteria) crit.getFirstOperant()),
                makeCriterion((ConditionalCriteria) crit.getSecondOperant()));
    } else if (Operator.And.equals(operator) && crit.getFirstOperant() instanceof List<?>) {
        Conjunction conj = Restrictions.conjunction();
        List<?> conjList = (List<?>) crit.getFirstOperant();
        for (Object conjPart : conjList) {
            conj.add(makeCriterion((ConditionalCriteria) conjPart));
        }
        return conj;
    } else if (Operator.And.equals(operator)) {
        return Restrictions.and(makeCriterion((ConditionalCriteria) crit.getFirstOperant()),
                makeCriterion((ConditionalCriteria) crit.getSecondOperant()));
    } else if (Operator.In.equals(operator)) {
        if (crit.getFirstOperant() instanceof Collection<?>) {
            return Restrictions.in(makePathWithAlias(crit.getPropertyFullName()),
                    (Collection<?>) crit.getFirstOperant());
        } else {
            return Restrictions.in(makePathWithAlias(crit.getPropertyFullName()),
                    (Object[]) crit.getFirstOperant());
        }
    } else if (Operator.Between.equals(operator)) {
        return Restrictions.between(makePathWithAlias(crit.getPropertyFullName()), crit.getFirstOperant(),
                crit.getSecondOperant());
    } else if (Operator.DistinctRoot.equals(operator)) {
        realDistinctRoot = true;
        return null;
    } else if (Operator.ProjectionRoot.equals(operator)) {
        resultTransformer = Criteria.PROJECTION;
        return null;
    } else if (Operator.EqualProperty.equals(operator)) {
        return Restrictions.eqProperty(makePathWithAlias(crit.getPropertyFullName()),
                (String) crit.getFirstOperant());
    } else if (Operator.LessThanProperty.equals(operator)) {
        return Restrictions.eqProperty(makePathWithAlias(crit.getPropertyFullName()),
                (String) crit.getFirstOperant());
    } else if (Operator.LessThanOrEqualProperty.equals(operator)) {
        return Restrictions.eqProperty(makePathWithAlias(crit.getPropertyFullName()),
                (String) crit.getFirstOperant());
    } else if (Operator.GreatThanProperty.equals(operator)) {
        return Restrictions.eqProperty(makePathWithAlias(crit.getPropertyFullName()),
                (String) crit.getFirstOperant());
    } else if (Operator.GreatThanOrEqualProperty.equals(operator)) {
        return Restrictions.eqProperty(makePathWithAlias(crit.getPropertyFullName()),
                (String) crit.getFirstOperant());
    } else {
        return null;
    }
}

From source file:org.generationcp.middleware.dao.ims.TransactionDAO.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Transaction> getAllReserve(final int start, final int numOfRows) {
    try {/* w w w . j  a  v a  2s.  c  o  m*/
        final Criteria criteria = this.getSession().createCriteria(Transaction.class);
        criteria.add(Restrictions.eq("status", 0));
        criteria.add(Restrictions.lt("quantity", 0d));
        criteria.setFirstResult(start);
        criteria.setMaxResults(numOfRows);
        return criteria.list();
    } catch (final HibernateException e) {
        final String message = "Error with getAllReserve() query from Transaction: " + e.getMessage();
        LOG.error(message, e);
        throw new MiddlewareQueryException(message, e);
    }
}

From source file:org.generationcp.middleware.dao.ims.TransactionDAO.java

License:Open Source License

public long countAllReserve() {
    try {//from www  .ja  va  2s. c  o m
        final Criteria criteria = this.getSession().createCriteria(Transaction.class);
        criteria.setProjection(Projections.rowCount());
        criteria.add(Restrictions.eq("status", 0));
        criteria.add(Restrictions.lt("quantity", 0d));
        return ((Long) criteria.uniqueResult());
    } catch (final HibernateException e) {
        final String message = "Error with countAllReserve query from Transaction: " + e.getMessage();
        LOG.error(message, e);
        throw new MiddlewareQueryException(message, e);
    }
}

From source file:org.generationcp.middleware.dao.ims.TransactionDAO.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Transaction> getAllWithdrawals(final int start, final int numOfRows) {
    try {//from   www. jav  a  2s  . c  o  m
        final Criteria criteria = this.getSession().createCriteria(Transaction.class);
        criteria.add(Restrictions.lt("quantity", 0d));
        criteria.setFirstResult(start);
        criteria.setMaxResults(numOfRows);
        return criteria.list();
    } catch (final HibernateException e) {
        final String message = "Error with getAllWithdrawals() query from Transaction: " + e.getMessage();
        LOG.error(message, e);
        throw new MiddlewareQueryException(message, e);
    }
}

From source file:org.generationcp.middleware.dao.ims.TransactionDAO.java

License:Open Source License

public long countAllWithdrawals() {
    try {//from w w w . j  a  v a  2s  .  co m
        final Criteria criteria = this.getSession().createCriteria(Transaction.class);
        criteria.setProjection(Projections.rowCount());
        criteria.add(Restrictions.lt("quantity", 0d));
        return ((Long) criteria.uniqueResult());
    } catch (final HibernateException e) {
        final String message = "Error with countAllWithdrawals() query from Transaction: " + e.getMessage();
        LOG.error(message, e);
        throw new MiddlewareQueryException(message, e);
    }
}

From source file:org.generationcp.middleware.dao.NumericDataDAO.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Integer> getObservationUnitIdsByTraitScaleMethodAndValueCombinations(
        List<TraitCombinationFilter> filters, int start, int numOfRows) throws MiddlewareQueryException {
    try {/*from  w  w  w .java 2 s .c om*/
        if (filters == null || filters.isEmpty()) {
            return new ArrayList<Integer>();
        }

        Criteria criteria = getSession().createCriteria(NumericData.class);
        criteria.createAlias("variate", "variate");
        criteria.setProjection(Projections.distinct(Projections.property("id.observationUnitId")));

        // keeps track if at least one filter was added
        boolean filterAdded = false;

        for (TraitCombinationFilter combination : filters) {
            Object value = combination.getValue();

            // accept only Double objects
            if (value instanceof Double || value instanceof NumericRange) {
                criteria.add(Restrictions.eq("variate.traitId", combination.getTraitId()));
                criteria.add(Restrictions.eq("variate.scaleId", combination.getScaleId()));
                criteria.add(Restrictions.eq("variate.methodId", combination.getMethodId()));

                if (value instanceof NumericRange) {
                    NumericRange range = (NumericRange) value;
                    if (range.getStart() != null) {
                        criteria.add(Restrictions.gt("value", range.getStart()));
                    }

                    if (range.getEnd() != null) {
                        criteria.add(Restrictions.lt("value", range.getEnd()));
                    }
                } else {
                    criteria.add(Restrictions.eq("value", combination.getValue()));
                }

                filterAdded = true;
            }
        }

        if (filterAdded) {
            // if there is at least one filter, execute query and return results
            criteria.setFirstResult(start);
            criteria.setMaxResults((numOfRows));
            return criteria.list();
        } else {
            // return empty list if no filter was added
            return new ArrayList<Integer>();
        }
    } catch (HibernateException e) {
        throw new MiddlewareQueryException(
                "Error with get getObservationUnitIdsByTraitScaleMethodAndValueCombinations(filters=" + filters
                        + ") query from NumericData: " + e.getMessage(),
                e);
    }
}

From source file:org.generationcp.middleware.dao.TransactionDAO.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Transaction> getAllReserve(int start, int numOfRows) throws MiddlewareQueryException {
    try {//from  ww w  . j  a va 2 s.  co  m
        Criteria criteria = getSession().createCriteria(Transaction.class);
        criteria.add(Restrictions.eq("status", Integer.valueOf(0)));
        criteria.add(Restrictions.lt("quantity", Integer.valueOf(0)));
        criteria.setFirstResult(start);
        criteria.setMaxResults(numOfRows);
        return criteria.list();
    } catch (HibernateException e) {
        throw new MiddlewareQueryException(
                "Error with getAllReserve() query from Transaction: " + e.getMessage(), e);
    }
}