Example usage for org.hibernate.criterion Projections property

Introduction

In this page you can find the example usage for org.hibernate.criterion Projections property.

Prototype

public static PropertyProjection property(String propertyName)

Source Link

Document

A property value projection

Usage

From source file:com.square.adherent.noyau.dao.implementations.magazine.MagazineDaoImpl.java

License:Open Source License

/**
 * {@inheritDoc}//from  ww w  .  j  a v a  2 s  .c om
 */
@SuppressWarnings("unchecked")
public List<Long> getListeAdherentsByIdMagazineEnvoye(Long idMagazine) {
    final Criteria crit = createCriteria(AdherentMagazine.class);
    crit.add(Restrictions.eq("magazine.id", idMagazine));
    crit.setProjection(Projections.property("uidPersonne"));
    return (ArrayList<Long>) crit.list();
}

From source file:com.square.adherent.noyau.dao.implementations.MagazineDaoImpl.java

License:Open Source License

/**
 * {@inheritDoc}//from  w ww . j  a  v a 2s . com
 */
@SuppressWarnings("unchecked")
public List<Long> getListeAdherentsByIdMagazineEnvoye(Long idMagazine) {
    final Criteria crit = createCriteria(AdherentMagazine.class);
    crit.add(Restrictions.eq("adherentMagazinePk.magazine.idMagazine", idMagazine));
    crit.setProjection(Projections.property("adherentMagazinePk.uidPersonne"));
    return (ArrayList<Long>) crit.list();
}

From source file:com.square.core.dao.implementations.AideDaoImplementation.java

License:Open Source License

@Override
@SuppressWarnings("unchecked")
public List<Long> rechercherIdsComposantsAides(List<Long> listeIdsComposant) {
    final Criteria criteria = createCriteria(Aide.class);
    if (listeIdsComposant != null && listeIdsComposant.size() > 0) {
        criteria.add(Restrictions.in("idComposant", listeIdsComposant));
    }/*from   ww  w .j  a  v a  2s.  c  om*/
    criteria.setProjection(Projections.property("idComposant"));
    return criteria.list();
}

From source file:com.square.core.dao.implementations.DepartementDaoImplementation.java

License:Open Source License

@Override
public Departement rechercherDepartementParIdCommune(Long idCommune) {
    final Criteria criteria = createCriteria(Commune.class);
    criteria.add(Restrictions.eq("id", idCommune));
    criteria.setProjection(Projections.property("departement"));
    return (Departement) criteria.uniqueResult();
}

From source file:com.square.tarificateur.noyau.dao.implementations.OpportuniteDaoImpl.java

License:Open Source License

/**
 * {@inheritDoc}/*  w  ww.  j a  v a 2s.  co m*/
 */
@SuppressWarnings("unchecked")
public List<String> getIdsBaAdhesionNonTelecharges() {
    final Criteria crit = createCriteria(Adhesion.class);
    crit.setProjection(Projections.property("idFichierCNS"));
    crit.add(Restrictions.isNull("dateTelechargementBA"));
    crit.add(Restrictions.isNotNull("idFichierCNS"));
    return (List<String>) crit.list();
}

From source file:com.square.tarificateur.noyau.dao.implementations.OpportuniteDaoImpl.java

License:Open Source License

@Override
public Long getIdDevisLieAdhesion(Long idAdhesion, Long idFinaliteAccepte) {
    final Criteria crit = createCriteria(Devis.class);
    crit.setProjection(Projections.property("id"));
    crit.createAlias("opportunite", "opp");
    crit.createAlias("opp.adhesion", "adh");
    crit.add(Restrictions.eq("adh.id", idAdhesion));
    crit.add(Restrictions.eq("finalite.id", idFinaliteAccepte));
    return (Long) crit.uniqueResult();
}

From source file:com.thoughtworks.go.server.dao.PipelineStateDao.java

License:Apache License

public List<String> lockedPipelines() {
    return (List<String>) transactionTemplate.execute(new TransactionCallback() {
        @Override//from   w w  w  .j  a  v a2  s . c om
        public Object doInTransaction(TransactionStatus status) {
            PropertyProjection pipelineName = Projections.property("pipelineName");
            Criteria criteria = sessionFactory.getCurrentSession().createCriteria(PipelineState.class)
                    .setProjection(pipelineName).add(Restrictions.eq("locked", true));
            criteria.setCacheable(false);
            List<String> list = criteria.list();
            return list;
        }
    });
}

From source file:com.thoughtworks.go.server.persistence.MaterialRepository.java

License:Apache License

private void checkAndRemoveDuplicates(MaterialInstance materialInstance, List<Modification> newChanges,
        ArrayList<Modification> list) {
    if (!new SystemEnvironment().get(SystemEnvironment.CHECK_AND_REMOVE_DUPLICATE_MODIFICATIONS)) {
        return;/*from  w  w w .j a va2s  . c  o m*/
    }
    DetachedCriteria criteria = DetachedCriteria.forClass(Modification.class);
    criteria.setProjection(Projections.projectionList().add(Projections.property("revision")));
    criteria.add(Restrictions.eq("materialInstance.id", materialInstance.getId()));
    ArrayList<String> revisions = new ArrayList<>();
    for (Modification modification : newChanges) {
        revisions.add(modification.getRevision());
    }
    criteria.add(Restrictions.in("revision", revisions));
    List<String> matchingRevisionsFromDb = (List<String>) getHibernateTemplate().findByCriteria(criteria);
    if (!matchingRevisionsFromDb.isEmpty()) {
        for (final String revision : matchingRevisionsFromDb) {
            Modification modification = list.stream().filter(item -> item.getRevision().equals(revision))
                    .findFirst().orElse(null);
            list.remove(modification);
        }
    }
    if (!newChanges.isEmpty() && list.isEmpty()) {
        LOGGER.debug("All modifications already exist in db [{}]", revisions);
    }
    if (!matchingRevisionsFromDb.isEmpty()) {
        LOGGER.info("Saving revisions for material [{}] after removing the following duplicates {}",
                materialInstance.toOldMaterial(null, null, null).getLongDescription(), matchingRevisionsFromDb);
    }

}

From source file:com.tony.DaoImpl.UsuarioInternoImpl.java

@Override
public Estado_documentos get_estado(Documento documento) {
    EntityManager em = Entidad.getEntidad().getEntidadManager();
    Estado_documentos estado = null;//w ww.  j a  va2s .  co  m
    Session sesionHibernate = (Session) em.getDelegate();
    List<Estado_documentos> lista = new ArrayList<>();
    try {
        em.getTransaction().begin();
        lista = (List<Estado_documentos>) sesionHibernate.createCriteria(Operacion_EstadosDocumentos.class)
                .createAlias("documento", "documentoBuscar")
                .add(Restrictions.eq("documentoBuscar.id_documento", documento.getId_documento()))
                .setProjection(Projections.property("estados")).list();
        lista.forEach(System.out::println);
        estado = lista.stream().max(Comparator.comparingInt(Estado_documentos::getId_estadoDocumento)).get();
        em.getTransaction().commit();

    } catch (Exception e) {
        if (em.getTransaction().isActive()) {
            em.getTransaction().rollback();
        }
        System.out.println("Mensja de get_estado:usuarioInternoImpl" + e.getMessage());
    } finally {
        em.close();

    }
    System.out.println(estado);
    return estado;
}

From source file:com.tysanclan.site.projectewok.entities.dao.hibernate.BattleNetChannelDAOImpl.java

License:Open Source License

/**
 * @see com.tysanclan.site.projectewok.entities.dao.BattleNetChannelDAO#getPasswordByUID(java.lang.String)
 *///from   ww  w . ja va2  s  . c o m
@Override
public String getPasswordByUID(String identifier) {
    Criteria criteria = getSession().createCriteria(BattleNetChannel.class);

    criteria.add(Restrictions.eq("webServiceUserId", identifier));
    criteria.setProjection(Projections.property("webServicePassword"));

    return (String) criteria.uniqueResult();
}