Example usage for org.hibernate.criterion DetachedCriteria setResultTransformer

List of usage examples for org.hibernate.criterion DetachedCriteria setResultTransformer

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. DetachedCriteria
  6. setResultTransformer

Introduction

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

Prototype

public DetachedCriteria setResultTransformer(ResultTransformer resultTransformer)

Source Link

Document

Set the result transformer to use.

Usage

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

License:Open Source License

@Override
public List<AbstractDomain> findDomainBetweenTwoDates(Date beginDate, Date endDate) {
    DetachedCriteria criteria = DetachedCriteria.forClass(getPersistentClass());
    if (beginDate != null) {
        criteria.add(Restrictions.ge("statisticDate", beginDate));
    }//from   ww  w  . j  ava  2s  . c  om
    if (endDate != null) {
        criteria.add(Restrictions.le("statisticDate", endDate));
    }
    criteria.setProjection(Projections.property("domain"));
    criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
    @SuppressWarnings("unchecked")
    List<AbstractDomain> listDomains = (List<AbstractDomain>) getHibernateTemplate().findByCriteria(criteria);
    return listDomains;
}

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

License:Open Source License

@Override
public List<Account> findAccountBetweenTwoDates(Date beginDate, Date endDate) {
    DetachedCriteria criteria = DetachedCriteria.forClass(getPersistentClass());
    if (beginDate != null) {
        criteria.add(Restrictions.ge("statisticDate", beginDate));
    }//w  ww .  ja  v a  2s .c  o  m
    if (endDate != null) {
        criteria.add(Restrictions.le("statisticDate", endDate));
    }
    criteria.setProjection(Projections.property("account"));
    criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
    @SuppressWarnings("unchecked")
    List<Account> listAccounts = (List<Account>) getHibernateTemplate().findByCriteria(criteria);
    return listAccounts;
}

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

License:Open Source License

@Override
public List<String> findUuidAccountBetweenTwoDates(Date beginDate, Date endDate) {
    DetachedCriteria criteria = DetachedCriteria.forClass(getPersistentClass());
    if (beginDate != null) {
        criteria.add(Restrictions.ge("statisticDate", beginDate));
    }//from   ww  w .  ja  v  a  2 s .  c  o  m
    if (endDate != null) {
        criteria.add(Restrictions.le("statisticDate", endDate));
    }
    criteria.setProjection(Projections.property("account"));
    criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
    @SuppressWarnings("unchecked")
    List<Account> listAccount = (List<Account>) getHibernateTemplate().findByCriteria(criteria);

    List<String> listUuid = new ArrayList<>();
    for (Account acccount : listAccount) {
        listUuid.add(acccount.getLsUuid());
    }
    return listUuid;
}

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

License:Open Source License

@Override
public List<String> findIdentifierDomainBetweenTwoDates(Date beginDate, Date endDate) {
    DetachedCriteria criteria = DetachedCriteria.forClass(getPersistentClass());
    if (beginDate != null) {
        criteria.add(Restrictions.ge("statisticDate", beginDate));
    }//from   ww w.  ja  va2 s  .co m
    if (endDate != null) {
        criteria.add(Restrictions.le("statisticDate", endDate));
    }
    criteria.setProjection(Projections.property("domain"));
    criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
    @SuppressWarnings("unchecked")
    List<AbstractDomain> listDomain = (List<AbstractDomain>) getHibernateTemplate().findByCriteria(criteria);

    List<String> identifiers = new ArrayList<>();
    for (AbstractDomain domain : listDomain) {
        identifiers.add(domain.getUuid());
    }
    return identifiers;
}

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

License:Open Source License

@Override
public List<String> findAllAnonymousShareEntriesAboutToBeNotified(Date dt) {
    DetachedCriteria det = DetachedCriteria.forClass(getPersistentClass());
    det.add(Restrictions.eq("notified", false));
    det.add(Restrictions.lt("notificationDate", dt));
    // only identifier instead of entity
    det.setProjection(Projections.property("uuid"));
    det.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
    // join/*from w  ww . ja  va 2  s .c o m*/
    det.createAlias("anonymousShareEntries", "ase");
    // restrict
    det.add(Restrictions.eq("ase.downloaded", new Long(0)));
    @SuppressWarnings("unchecked")
    List<String> list = listByCriteria(det);
    return list;
}

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

License:Open Source License

@Override
public List<String> findAllShareEntriesAboutToBeNotified(Date dt) {
    DetachedCriteria det = DetachedCriteria.forClass(getPersistentClass());
    det.add(Restrictions.eq("notified", false));
    det.add(Restrictions.lt("notificationDate", dt));
    // only identifier instead of entity
    det.setProjection(Projections.property("uuid"));
    det.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
    // join/*from  w w  w .  j  a  v  a2s  .c  o  m*/
    det.createAlias("shareEntries", "se");
    // restrict
    det.add(Restrictions.eq("se.downloaded", new Long(0)));
    @SuppressWarnings("unchecked")
    List<String> list = listByCriteria(det);
    return list;
}

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.n2.chess.beans.GameService.java

License:Open Source License

@Override
public List<Game> loadGames(User user) {
    DetachedCriteria crit = DetachedCriteria.forClass(Game.class);
    crit.add(Restrictions.or(Restrictions.eq("playerWhite.id", user.getId()),
            Restrictions.eq("playerBlack.id", user.getId())));
    crit.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
    return getGameDao().find(crit);
}

From source file:org.n2.chess.beans.GameService.java

License:Open Source License

@Override
public Game loadGame(Integer id) {
    DetachedCriteria crit = DetachedCriteria.forClass(Game.class);
    crit.add(Restrictions.eq("id", id));
    crit.setFetchMode("playerWhite", FetchMode.JOIN);
    crit.setFetchMode("playerBlack", FetchMode.JOIN);
    crit.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
    List<Game> result = getGameDao().find(crit);
    return singleValue(result);
}

From source file:org.n2.chess.beans.ReminderService.java

License:Open Source License

@Scheduled(cron = "0 0 0/1 * * ?")
public void send() {
    if (LOG.isDebugEnabled()) {
        LOG.debug("Sending reminder...");
    }/*  ww w. ja  va2 s  .co m*/
    DetachedCriteria crit = DetachedCriteria.forClass(Game.class);
    crit.add(Restrictions.isNull("notifyDate"));
    crit.setFetchMode("playerWhite", FetchMode.JOIN);
    crit.setFetchMode("playerBlack", FetchMode.JOIN);
    crit.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
    List<Game> gameList = getGameDao().find(crit);
    for (Game game : gameList) {
        sendReminder(game);
    }
}