List of usage examples for org.hibernate.criterion Restrictions isNotEmpty
public static Criterion isNotEmpty(String propertyName)
From source file:org.sculptor.framework.accessimpl.jpahibernate.JpaHibFindByConditionAccessImpl.java
License:Apache License
private Criterion makeCriterion(ConditionalCriteria crit) { if (crit == null) { return null; }// w ww. jav a 2 s . c o m 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)) { // Hibernate bug HHH-5339 + PostgreSQL missing 'number like string' conversion return new NumericLikeExpression(makePathWithAlias(crit.getPropertyFullName()), crit.getFirstOperant().toString(), false); } else if (Operator.IgnoreCaseLike.equals(operator)) { // Hibernate bug HHH-5339 + PostgreSQL missing 'number like string' conversion return new NumericLikeExpression(makePathWithAlias(crit.getPropertyFullName()), crit.getFirstOperant().toString(), true); } 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.ltProperty(makePathWithAlias(crit.getPropertyFullName()), (String) crit.getFirstOperant()); } else if (Operator.LessThanOrEqualProperty.equals(operator)) { return Restrictions.leProperty(makePathWithAlias(crit.getPropertyFullName()), (String) crit.getFirstOperant()); } else if (Operator.GreatThanProperty.equals(operator)) { return Restrictions.gtProperty(makePathWithAlias(crit.getPropertyFullName()), (String) crit.getFirstOperant()); } else if (Operator.GreatThanOrEqualProperty.equals(operator)) { return Restrictions.geProperty(makePathWithAlias(crit.getPropertyFullName()), (String) crit.getFirstOperant()); } else { return null; } }
From source file:org.shredzone.cilla.service.impl.TagServiceImpl.java
License:Open Source License
@SuppressWarnings("unchecked") @Transactional(readOnly = true)//w w w . j av a 2 s. c om @Cacheable("tagCloud") @Override public Map<Tag, Float> createTagCloud(long limit) { Date now = new Date(); Date limitDate = new Date(now.getTime() - limit); List<Page> pages = pageDao.criteria() .add(Restrictions.and(Restrictions.isNotNull("publication"), Restrictions.between("publication", limitDate, now))) .add(Restrictions.or(Restrictions.isNull("expiration"), Restrictions.gt("expiration", now))) .add(Restrictions.isNotEmpty("tags")).list(); return computeTagCloud(pages, limitDate.getTime(), limit); }
From source file:org.webical.dao.hibernateImpl.EventDaoWebDavHibernateBufferedImpl.java
License:Open Source License
/** * Retrieve a List of all recurring Event for a given calendar * @param calendar the Calendar for which the recurring Events are returned * @return a List of all recurring Events * @throws DaoException/* www . ja va 2 s . c o m*/ */ @Transaction(readOnly = true) @SuppressWarnings("unchecked") private List<Event> getAllRecurringEventsForCalendar(Calendar calendar) throws DaoException { if (calendar == null) return null; try { Criteria criteria = getSession().createCriteria(Event.class); criteria.add(Restrictions.eq(Calendar.CALENDAR_PROPERTY_NAME, calendar)); criteria.add(Restrictions.or(Restrictions.isNotEmpty("rDate"), Restrictions.isNotEmpty("rRule"))); if (log.isDebugEnabled()) log.debug(criteria.toString() + " " + calendar.getName()); return criteria.list(); } catch (Exception e) { log.error(e); throw new DaoException("Could not get recurringEvents", e); } }
From source file:qa.qcri.aidr.dbmanager.ejb.remote.facade.imp.CrisisResourceFacadeImpTest.java
/** * Test of getByCriteriaWithInnerJoinByOrder method, of class CrisisResourceFacadeImp. *///from w w w . jav a 2 s . c om @Test public void testGetByCriteriaWithInnerJoinByOrder() throws Exception { System.out.println("getByCriteriaWithInnerJoinByOrder"); Criterion criterion = null; String order = ""; String[] orderBy = null; Integer count = null; String aliasTable = "document"; CrisisResourceFacadeImp instance = new CrisisResourceFacadeImp(); List<Crisis> expResult = null; List<Crisis> result = instance.getByCriteriaWithInnerJoinByOrder(criterion, order, orderBy, count, aliasTable, Restrictions.isNotEmpty("crisis")); assertEquals(expResult, result); // TODO review the generated test code and remove the default call to fail. fail("The test case is a prototype."); }