Example usage for org.hibernate.criterion DetachedCriteria setProjection

Introduction

In this page you can find the example usage for org.hibernate.criterion DetachedCriteria setProjection.

Prototype

public DetachedCriteria setProjection(Projection projection)

Source Link

Document

Set the projection to use.

Usage

From source file:org.linagora.linshare.core.repository.hibernate.ThreadEntryRepositoryImpl.java

License:Open Source License

@Override
public int count(Thread thread) {
    DetachedCriteria det = DetachedCriteria.forClass(ThreadEntry.class);

    det.add(Restrictions.eq("entryOwner", thread));
    det.setProjection(Projections.rowCount());
    return DataAccessUtils.intResult(findByCriteria(det));
}

From source file:org.linagora.linshare.core.repository.hibernate.ThreadMemberRepositoryImpl.java

License:Open Source License

@Override
public boolean isUserAdminOfAny(User user) {
    DetachedCriteria det = DetachedCriteria.forClass(ThreadMember.class);

    det.add(Restrictions.eq("user", user));
    det.add(Restrictions.eq("admin", true));
    det.setProjection(Projections.rowCount());
    return DataAccessUtils.singleResult(findByCriteria(det)) != null;
}

From source file:org.linagora.linshare.core.repository.hibernate.ThreadMemberRepositoryImpl.java

License:Open Source License

@Override
public int count(Thread thread) {
    DetachedCriteria det = DetachedCriteria.forClass(ThreadMember.class);

    det.add(Restrictions.eq("thread", thread));
    det.setProjection(Projections.rowCount());
    return DataAccessUtils.intResult(findByCriteria(det));
}

From source file:org.linagora.linshare.core.repository.hibernate.ThreadRepositoryImpl.java

License:Open Source License

@Override
public List<Thread> searchAmongMembers(User actor, String pattern) {
    DetachedCriteria det = DetachedCriteria.forClass(Thread.class);
    det.add(Restrictions.eq("destroyed", false));

    Disjunction or = Restrictions.disjunction();

    det.createAlias("myMembers", "member2");
    det.createAlias("member2.user", "u");
    or.add(Restrictions.ilike("u.firstName", pattern, ANYWHERE));
    or.add(Restrictions.ilike("u.lastName", pattern, ANYWHERE));
    det.add(or);/*from   ww  w  .  java 2s.  co  m*/

    DetachedCriteria sub = DetachedCriteria.forClass(Thread.class);
    sub.createAlias("myMembers", "member");
    if (!actor.isSuperAdmin())
        sub.add(Restrictions.eq("member.user", actor));
    sub.setProjection(Projections.id());

    det.add(Subqueries.propertyIn("id", sub));
    return findByCriteria(det);
}

From source file:org.linagora.linshare.core.repository.hibernate.UploadRequestGroupRepositoryImpl.java

License:Open Source License

@Override
public List<UploadRequestGroup> findAllByOwner(Account owner) {
    DetachedCriteria cri = DetachedCriteria.forClass(UploadRequest.class);
    cri.add(Restrictions.eq("owner", owner));
    cri.setProjection(Projections.property("uploadRequestGroup"));
    cri.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return findByCriteria(cri);
}

From source file:org.linagora.linshare.core.repository.hibernate.UploadRequestRepositoryImpl.java

License:Open Source License

@Override
public List<String> findOutdatedRequests() {
    DetachedCriteria crit = DetachedCriteria.forClass(getPersistentClass());
    crit.add(Restrictions.lt("expiryDate", new Date()));
    crit.add(Restrictions.eq("status", UploadRequestStatus.STATUS_ENABLED));
    crit.setProjection(Projections.property("uuid"));
    @SuppressWarnings("unchecked")
    List<String> list = listByCriteria(crit);
    return list;// www .java  2 s . com
}

From source file:org.linagora.linshare.core.repository.hibernate.UploadRequestRepositoryImpl.java

License:Open Source License

@Override
public List<String> findCreatedUploadRequests() {
    DetachedCriteria crit = DetachedCriteria.forClass(getPersistentClass());
    crit.add(Restrictions.lt("activationDate", new Date()));
    crit.add(Restrictions.eq("status", UploadRequestStatus.STATUS_CREATED));
    crit.setProjection(Projections.property("uuid"));
    @SuppressWarnings("unchecked")
    List<String> list = listByCriteria(crit);
    return list;/*from w ww . j a v  a  2 s.  c o  m*/
}

From source file:org.linagora.linshare.core.repository.hibernate.UploadRequestRepositoryImpl.java

License:Open Source License

@Override
public List<String> findAllRequestsToBeNotified() {
    DetachedCriteria crit = DetachedCriteria.forClass(getPersistentClass());
    GregorianCalendar gc = new GregorianCalendar();
    gc.set(GregorianCalendar.HOUR_OF_DAY, 0);
    gc.set(GregorianCalendar.MINUTE, 0);
    gc.set(GregorianCalendar.SECOND, 0);
    gc.set(GregorianCalendar.MILLISECOND, 0);
    Date before = gc.getTime();//from w  ww  . ja v  a2s.  c om
    gc.add(GregorianCalendar.DAY_OF_MONTH, 1);
    Date after = gc.getTime();
    crit.add(Restrictions.lt("notificationDate", after));
    crit.add(Restrictions.gt("notificationDate", before));
    crit.add(Restrictions.ltProperty("notificationDate", "expiryDate"));
    crit.add(Restrictions.eq("status", UploadRequestStatus.STATUS_ENABLED));
    crit.setProjection(Projections.property("uuid"));
    @SuppressWarnings("unchecked")
    List<String> list = listByCriteria(crit);
    return list;
}

From source file:org.molasdin.wbase.hibernate.cursor.BasicHibernateCursor.java

License:Apache License

@Override
public Long totalCallback(Session session) {
    DetachedCriteria criteria = searchSpecification().query();
    if (searchSpecification().distinctProperty() != null) {
        criteria.setProjection(Projections.countDistinct(searchSpecification().distinctProperty()));
    } else {// w w  w. j  ava  2 s  . co  m
        criteria.setProjection(Projections.rowCount());
    }
    criteria.add(populateFilters(searchSpecification().filterModes()));
    return (Long) criteria.getExecutableCriteria(session).uniqueResult();
}

From source file:org.n52.sos.ds.hibernate.dao.AbstractSpatialFilteringProfileDAO.java

License:Open Source License

/**
 * Create detached observation criteria for spatial filter
 * /*from w  ww. ja  v a2  s .c o  m*/
 * @param clazz
 *            Entity to create Criteria for
 * @param spatialFilter
 * @return Detached criteria
 * @throws OwsExceptionReport
 *             If coordinate switching fails
 */
@SuppressWarnings("rawtypes")
protected DetachedCriteria getDetachedCriteria(Class clazz, SpatialFilter spatialFilter)
        throws OwsExceptionReport {
    final DetachedCriteria detachedCriteria = DetachedCriteria.forClass(clazz);
    if (spatialFilter != null) {
        detachedCriteria.add(SpatialRestrictions.filter(AbstractSpatialFilteringProfile.GEOMETRY,
                spatialFilter.getOperator(), GeometryHandler.getInstance()
                        .switchCoordinateAxisFromToDatasourceIfNeeded(spatialFilter.getGeometry())));
    }
    detachedCriteria.setProjection(
            Projections.distinct(Projections.property(AbstractSpatialFilteringProfile.OBSERVATION)));
    return detachedCriteria;
}