Example usage for org.hibernate.criterion Restrictions 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.glite.security.voms.admin.persistence.dao.hibernate.RequestDAOHibernate.java

License:Apache License

public List<NewVOMembershipRequest> findExpiredVOMembershipRequests() {

    Criteria crit = getSession().createCriteria(NewVOMembershipRequest.class);

    Date now = new Date();
    crit.add(Restrictions.lt("expirationDate", now));
    crit.add(Restrictions.eq("status", STATUS.SUBMITTED));

    return crit.list();
}

---

From source file:org.gluewine.persistence_jpa_hibernate.impl.HibernateTransactionalSessionImpl.java

License:Apache License

@Override
public Criteria createCriteria(Class<?> cl, Filter filter) {
    Criteria cr = createCriteria(cl);//w w  w  .  j  a v a 2 s  .  c o  m

    for (FilterLine line : filter.getLines()) {
        switch (line.getOperator()) {
        case CONTAINS:
            cr.add(Restrictions.like(line.getFieldName(), "%" + line.getValue() + "%"));
            break;

        case DOES_NOT_CONTAIN:
            cr.add(Restrictions.not(Restrictions.like(line.getFieldName(), "%" + line.getValue() + "%")));
            break;

        case DOES_NOT_ICONTAIN:
            cr.add(Restrictions.not(Restrictions.ilike(line.getFieldName(), "%" + line.getValue() + "%")));
            break;

        case EQUALS:
            cr.add(Restrictions.eq(line.getFieldName(), line.getValue()));
            break;

        case GREATER_OR_EQUAL_THAN:
            cr.add(Restrictions.ge(line.getFieldName(), line.getValue()));
            break;

        case GREATER_THAN:
            cr.add(Restrictions.gt(line.getFieldName(), line.getValue()));
            break;

        case ICONTAINS:
            cr.add(Restrictions.ilike(line.getFieldName(), "%" + line.getValue() + "%"));
            break;

        case LESS_OR_EQUAL_THAN:
            cr.add(Restrictions.le(line.getFieldName(), line.getValue()));
            break;

        case LESS_THAN:
            cr.add(Restrictions.lt(line.getFieldName(), line.getValue()));
            break;

        case NOT_EQUALS:
            cr.add(Restrictions.ne(line.getFieldName(), line.getValue()));
            break;

        case ISNULL:
            cr.add(Restrictions.isNull(line.getFieldName()));
            break;

        case NOTNULL:
            cr.add(Restrictions.isNotNull(line.getFieldName()));
            break;

        default:
            break;
        }
    }

    for (SortLine sort : filter.getSortLines()) {
        if (sort.isAscending())
            cr.addOrder(Property.forName(sort.getField()).asc());
        else
            cr.addOrder(Property.forName(sort.getField()).desc());
    }

    if (filter.getLimit() != 0)
        cr.setMaxResults(filter.getLimit());
    if (filter.getOffset() != 0)
        cr.setFirstResult(filter.getOffset());

    return cr;
}

---

From source file:org.headsupdev.agile.app.dashboard.Account.java

License:Open Source License

public SortableEntityProvider<Issue> getIssuesWatchedBy(final org.headsupdev.agile.api.User user) {
    return new SortableEntityProvider<Issue>() {
        @Override/*w w w.  j av a 2 s . c  o  m*/
        protected Criteria createCriteria() {
            Session session = ((HibernateStorage) Manager.getStorageInstance()).getHibernateSession();

            Criteria c = session.createCriteria(Issue.class);
            c.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
            c.add(Restrictions.lt("status", Issue.STATUS_RESOLVED));
            c.createCriteria("watchers").add(Restrictions.eq("username", user.getUsername()));

            return c;
        }

        @Override
        protected List<Order> getDefaultOrder() {
            return Arrays.asList(Order.asc("priority"), Order.asc("status"), Order.asc("id.id"));
        }
    };
}

---

From source file:org.headsupdev.agile.app.milestones.MilestoneFilterPanel.java

License:Open Source License

@Override
public Criterion getDueCriterion() {
    switch (dues) {
    case MilestonesApplication.QUERY_DUE_DEFINED:
        return Restrictions.ge("due", MilestoneStatusModifier.getDueSoonDate());
    case MilestonesApplication.QUERY_DUE_SOON:
        return Restrictions.and(Restrictions.lt("due", MilestoneStatusModifier.getDueSoonDate()),
                Restrictions.ge("due", new Date()));
    case MilestonesApplication.QUERY_DUE_OVERDUE:
        return Restrictions.lt("due", new Date());
    case FILTER_DATES:
        return getDateCriterionDue();
    default:/*from ww  w  . j  a  va 2 s .co  m*/
        return null;
    }
}

---

From source file:org.headsupdev.agile.storage.issues.IssueHelper.java

License:Open Source License

public static int getIssueOpenCountForProject(Project project) {
    if (project == null) {
        return 0;
    }/* w  ww. j  ava  2 s  . c o m*/
    Session session = ((HibernateStorage) Manager.getStorageInstance()).getHibernateSession();
    Criteria criteria = session.createCriteria(Issue.class);
    criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
    criteria.add(Restrictions.lt("status", Issue.STATUS_RESOLVED));
    criteria.add(Restrictions.eq("id.project", project));
    criteria.setProjection(Projections.count("id.project"));
    return ((Number) criteria.uniqueResult()).intValue();
}

---

From source file:org.headsupdev.agile.storage.issues.IssueHelper.java

License:Open Source License

public static List<Issue> getOverworkedIssuesForMilestone(Milestone milestone) {
    if (milestone == null) {
        return new ArrayList<Issue>();
    }//from  www . j a v  a2  s  .  c o  m

    Session session = ((HibernateStorage) Manager.getStorageInstance()).getHibernateSession();
    Criteria criteria = session.createCriteria(Issue.class);
    criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
    criteria.add(Restrictions.lt("status", Issue.STATUS_RESOLVED));
    criteria.add(Restrictions.eq("milestone", milestone));

    return findOverworkedIssues(criteria.list());
}

---

From source file:org.hsqldb.hibernate.geomajas.layer.hibernate.CriteriaVisitor.java

License:Open Source License

/** {@inheritDoc} */
public Object visit(PropertyIsLessThan filter, Object userData) {
    String propertyName = getPropertyName(filter.getExpression1());
    String finalName = parsePropertyName(propertyName, userData);

    Object literal = getLiteralValue(filter.getExpression2());
    return Restrictions.lt(finalName, castLiteral(literal, propertyName));
}

---

From source file:org.ikasan.error.reporting.dao.HibernateErrorReportingServiceDao.java

License:BSD License

@Override
public List<ErrorOccurrence<byte[]>> find(List<String> moduleName, List<String> flowName,
        List<String> flowElementname, Date startDate, Date endDate) {
    DetachedCriteria criteria = DetachedCriteria.forClass(ErrorOccurrence.class);

    if (moduleName != null && moduleName.size() > 0) {
        criteria.add(Restrictions.in("moduleName", moduleName));
    }/*from w w  w . j  a va2 s  .c  o m*/

    if (flowName != null && flowName.size() > 0) {
        criteria.add(Restrictions.in("flowName", flowName));
    }

    if (flowElementname != null && flowElementname.size() > 0) {
        criteria.add(Restrictions.in("flowElementName", flowElementname));
    }

    if (startDate != null) {
        criteria.add(Restrictions.gt("timestamp", startDate.getTime()));
    }

    if (endDate != null) {
        criteria.add(Restrictions.lt("timestamp", endDate.getTime()));
    }

    criteria.addOrder(Order.desc("expiry"));

    return (List<ErrorOccurrence<byte[]>>) this.getHibernateTemplate().findByCriteria(criteria);
}

---

From source file:org.ikasan.error.reporting.dao.HibernateErrorReportingServiceDao.java

License:BSD License

/**
 * Identifies a batch (List of Ids) of housekeepable items
 *
 * @return List of ids//www . j  a v  a  2 s  .c  om
 */
@SuppressWarnings("unchecked")
private List<String> getHousekeepableBatch() {
    return (List<String>) getHibernateTemplate().execute(new HibernateCallback() {
        public Object doInHibernate(Session session) throws HibernateException {
            List<String> ids = new ArrayList<String>();

            Criteria criteria = session.createCriteria(ErrorOccurrence.class);
            criteria.add(Restrictions.lt("expiry", System.currentTimeMillis()));
            criteria.setMaxResults(housekeepingBatchSize);

            for (Object errorOccurrenceObj : criteria.list()) {
                ErrorOccurrence errorOccurrence = (ErrorOccurrence) errorOccurrenceObj;
                ids.add(errorOccurrence.getUri());
            }

            return ids;
        }
    });
}

---

From source file:org.ikasan.error.reporting.dao.HibernateErrorReportingServiceDao.java

License:BSD License

private boolean housekeepablesExist() {
    return (Boolean) getHibernateTemplate().execute(new HibernateCallback() {
        public Object doInHibernate(Session session) throws HibernateException {
            Criteria criteria = session.createCriteria(ErrorOccurrence.class);
            criteria.add(Restrictions.lt("expiry", System.currentTimeMillis()));
            criteria.setProjection(Projections.rowCount());
            Long rowCount = new Long(0);
            List<Long> rowCountList = criteria.list();
            if (!rowCountList.isEmpty()) {
                rowCount = rowCountList.get(0);
            }/*from  w  w  w . j  a  va 2  s . c  o  m*/
            return new Boolean(rowCount > 0);

        }
    });
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »