Example usage for org.hibernate.transform Transformers aliasToBean

List of usage examples for org.hibernate.transform Transformers aliasToBean

Introduction

In this page you can find the example usage for org.hibernate.transform Transformers aliasToBean.

Prototype

public static ResultTransformer aliasToBean(Class target)

Document

Creates a resulttransformer that will inject aliased values into instances of Class via property methods or fields.

Usage

From source file:br.com.muranodesign.dao.impl.ChamadaDAOImpl.java

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<Chamada> dataPresencaAtual(int id, Date data) {
    Criteria criteria = getSession().createCriteria(Chamada.class);

    ProjectionList projList = Projections.projectionList();
    projList.add(Projections.property("presenca"), "presenca");

    criteria.createAlias("aluno", "aluno");
    criteria.add(Restrictions.eq("aluno.idAluno", id));
    criteria.add(Restrictions.eq("data", data));

    criteria.setProjection(projList).setCacheable(true);
    criteria.setResultTransformer(Transformers.aliasToBean(Chamada.class));

    List<Chamada> result = criteria.list();

    return result;
}

From source file:br.com.muranodesign.dao.impl.ObjetivoDAOImpl.java

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<Objetivo> listAllTeste() {

    Criteria criteria = getSession().createCriteria(Objetivo.class);
    ProjectionList projList = Projections.projectionList();
    projList.add(Projections.property("descricao"), "descricao");
    criteria.createAlias("roteiro", "roteiro");
    projList.add(Projections.property("roteiro.idroteiro"));
    criteria.setProjection(projList).setCacheable(true);
    criteria.setResultTransformer(Transformers.aliasToBean(Objetivo.class));

    List<Objetivo> results = criteria.list();

    return results;

}

From source file:br.com.muranodesign.dao.impl.ProfessorFuncionarioDAOImpl.java

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<ProfessorFuncionario> listAll() {

    Criteria criteria = getSession().createCriteria(ProfessorFuncionario.class);
    ProjectionList projList = Projections.projectionList();
    projList.add(Projections.property("idprofessorFuncionario"), "idprofessorFuncionario");
    projList.add(Projections.property("nome"), "nome");
    criteria.setProjection(projList);/*from   w ww . j a  v a  2  s  .  com*/

    criteria.setResultTransformer(Transformers.aliasToBean(ProfessorFuncionario.class));
    List<ProfessorFuncionario> results = criteria.list();

    return results;
}

From source file:br.com.muranodesign.dao.impl.ProfessorFuncionarioDAOImpl.java

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<ProfessorFuncionario> listarIdNome() {
    Criteria criteria = getSession().createCriteria(ProfessorFuncionario.class);
    ProjectionList projList = Projections.projectionList();
    projList.add(Projections.property("idprofessorFuncionario"), "idprofessorFuncionario");
    projList.add(Projections.property("nome"), "nome");
    criteria.add(Restrictions.eq("ativo", "s"));
    criteria.setProjection(projList);//www.java2  s  .co  m
    criteria.setResultTransformer(Transformers.aliasToBean(ProfessorFuncionario.class));
    List<ProfessorFuncionario> results = criteria.list();

    return results;
}

From source file:br.com.muranodesign.dao.impl.RoteiroDAOImpl.java

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<Roteiro> listRoteiroRange(int primeiro, int ultimo) {
    Criteria criteria = getSession().createCriteria(Roteiro.class);
    ProjectionList projList = Projections.projectionList();

    criteria.setFirstResult(primeiro);/*from   w  ww . ja  v a2 s.c  o  m*/
    criteria.setMaxResults(ultimo);
    projList.add(Projections.property("idroteiro"), "idroteiro");
    projList.add(Projections.property("nome"), "nome");

    criteria.setProjection(projList).setCacheable(true);
    criteria.setResultTransformer(Transformers.aliasToBean(Roteiro.class));

    criteria.addOrder(Order.asc("nome"));
    List<Roteiro> result = criteria.list();

    return result;
}

From source file:br.com.muranodesign.dao.impl.RoteiroDAOImpl.java

License:Creative Commons License

@Override
@SuppressWarnings("unchecked")
public List<Roteiro> listarAnoEstudoLazy(int anoEstudo) {
    Criteria criteria = getSession().createCriteria(Roteiro.class);
    ProjectionList projList = Projections.projectionList();

    criteria.createAlias("anoEstudo", "anoEstudo");
    criteria.add(Restrictions.eq("anoEstudo.idanoEstudo", anoEstudo));
    criteria.add(Restrictions.eqOrIsNull("ativo", 1));
    projList.add(Projections.property("idroteiro"), "idroteiro");
    projList.add(Projections.property("nome"), "nome");
    criteria.setProjection(projList).setCacheable(true);
    criteria.setResultTransformer(Transformers.aliasToBean(Roteiro.class));
    List<Roteiro> result = criteria.list();

    return result;

}

From source file:br.com.muranodesign.dao.impl.TutoriaDAOImpl.java

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<Tutoria> listarDadosPertinentes() {

    Criteria criteria = getSession().createCriteria(Tutoria.class);

    ProjectionList projList = Projections.projectionList();

    projList.add(Projections.property("idtutoria"), "idtutoria");
    projList.add(Projections.property("tutoria"), "tutoria");

    criteria.setProjection(projList).setCacheable(true);

    criteria.setResultTransformer(Transformers.aliasToBean(Tutoria.class));

    List<Tutoria> results = criteria.list();

    return results;
}

From source file:br.com.tcc.service.persistence.QueryHelper.java

private QueryHelper setProjection() {
    Map<String, Type> typeMappings = businessTextQuery.getProjectionTypeMappings();
    if (typeMappings != null) {
        AssertUtils.assertExpression(businessTextQuery.isNativeQuery(),
                "ProjectionTypeMappings s pode ser usado apenas em queries nativas");

        for (Map.Entry<String, Type> entry : typeMappings.entrySet()) {
            ((SQLQuery) query).addScalar(entry.getKey(), entry.getValue());
        }/*from  w  w w .ja va2s .c  o m*/
    }

    if (businessTextQuery.getProjectionValueObjectClass() != null) {
        query.setResultTransformer(Transformers.aliasToBean(businessTextQuery.getProjectionValueObjectClass()));
    }
    return this;
}

From source file:br.ufac.sion.dao.InscricaoFacade.java

@Override
public Map<Date, Long> inscricoesPorData(Concurso concurso, SituacaoInscricao situacao) {
    Session session = em.unwrap(Session.class);
    Criteria criteria = session.createCriteria(Inscricao.class);

    LocalDateTime dataInicial = concurso.getDataInicioInscricao();

    Integer dias = Period.between(concurso.getDataInicioInscricao().toLocalDate(),
            concurso.getDataTerminoIncricao().toLocalDate()).getDays();
    Map<Date, Long> resultado = criaMapaVazio(dias, dataInicial);

    criteria.createAlias("cargoConcurso", "cc")
            .setProjection(Projections.projectionList()
                    .add(Projections.sqlGroupProjection("date(data_inscricao) as data", "date(data_inscricao)",
                            new String[] { "data" }, new Type[] { StandardBasicTypes.DATE }))
                    .add(Projections.count("id").as("quantidade")))
            .add(Restrictions.ge("dataInscricao", dataInicial)).add(Restrictions.eq("cc.concurso", concurso));

    if (situacao != null) {
        criteria.add(Restrictions.eq("status", situacao.CONFIRMADA));
    }//from w ww.  jav a  2  s. c om

    List<DataQuantidade> quantidadesPorData = criteria
            .setResultTransformer(Transformers.aliasToBean(DataQuantidade.class)).list();

    for (DataQuantidade quantidadeData : quantidadesPorData) {
        resultado.put(quantidadeData.getData(), quantidadeData.getQuantidade());
    }

    return resultado;
}

From source file:ca.usask.gmcte.currimap.action.ProgramManager.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<CourseOfferingContribution> getContributionForProgramOutcome(ProgramOutcome programOutcome,
        Program program, List<String> terms) {
    Session session = HibernateUtil.getSessionFactory().getCurrentSession();
    session.beginTransaction();/*from  ww w .j av a 2s  .c  o m*/
    List<CourseOfferingContribution> toReturn = new ArrayList<CourseOfferingContribution>();
    try {
        StringBuffer sql = new StringBuffer();
        //sql.append(" SELECT co.course_id AS {p.courseId}, lppo.program_outcome_id AS {p.programOutcomeId}, sum(cov.calculation_value) AS {p.contributionSum},count( distinct course_offering_id) AS {p.contributionCount} ");
        //   sql.append(" SELECT co.course_id, lppo.program_outcome_id, sum(cov.calculation_value),count( distinct course_offering_id)");
        sql.append(
                " SELECT co.id AS courseOfferingId, cov.calculation_value AS contributionObject, mov.calculation_value as masteryObject");

        sql.append("  FROM course_offering co");
        sql.append("      ,link_course_program lcp");
        sql.append("      ,link_program_program_outcome lppo");
        sql.append("      ,link_course_offering_contribution_program_outcome lcopo");
        sql.append("      ,contribution_option_value cov ");
        sql.append("      ,mastery_option_value mov ");
        sql.append(" WHERE ");
        sql.append(HibernateUtil.getListAsString("co.term", terms, true));
        sql.append("       co.course_id = lcp.course_id");
        sql.append("   AND co.id = lcopo.course_offering_id");
        sql.append("   AND lcopo.link_program_program_outcome_id = lppo.id");
        sql.append("   AND lppo.program_id = lcp.program_id");
        sql.append("   AND lcopo.contribution_option_id = cov.id");
        sql.append("   AND lcopo.mastery_option_id = mov.id");
        sql.append("   AND lcp.program_id = :programId");
        sql.append("   AND lppo.program_outcome_id = :programOutcomeId");
        sql.append("   AND (cov.calculation_value + mov.calculation_value) > 0 ");

        logger.debug("getContributionForProgramOutcome Core contributions:" + programOutcome.getId() + " "
                + program.getId() + " " + sql.toString());
        List<CourseOfferingContribution> fromOfferings = (List<CourseOfferingContribution>) session
                .createSQLQuery(sql.toString())
                .setResultTransformer(Transformers.aliasToBean(CourseOfferingContribution.class))
                .setParameter("programId", program.getId())
                .setParameter("programOutcomeId", programOutcome.getId()).list();
        toReturn.addAll(fromOfferings);
        session.getTransaction().commit();
    } catch (Exception e) {
        HibernateUtil.logException(logger, e);
    }
    return toReturn;
}