Example usage for org.hibernate.transform Transformers aliasToBean

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

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.transform.*
  5. Transformers
  6. aliasToBean

Introduction

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

Prototype

public static ResultTransformer aliasToBean(Class target)

Source Link

Document

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

Usage

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

License:Open Source License

@SuppressWarnings("unchecked")
public List<CourseOfferingContribution> getServiceCourseContributionForProgramOutomce(
        ProgramOutcome programOutcome, Program program) {
    Session session = HibernateUtil.getSessionFactory().getCurrentSession();
    session.beginTransaction();/*  w ww.j av a  2 s.  c  om*/
    List<CourseOfferingContribution> toReturn = new ArrayList<CourseOfferingContribution>();
    try {
        StringBuffer sql = new StringBuffer();
        sql.append(
                " SELECT lccpo.course_id AS courseOfferingId, cov.calculation_value AS contributionObject, mov.calculation_value AS masteryObject ");
        sql.append("   from link_course_contribution_program_outcome lccpo");
        sql.append("      , link_program_program_outcome lppo ");
        sql.append("      , contribution_option_value cov ");
        sql.append("      , mastery_option_value mov ");
        sql.append("  WHERE lccpo.link_program_program_outcome_id = lppo.id ");
        sql.append("    AND lccpo.contribution_option_id = cov.id");
        sql.append("    AND lccpo.mastery_option_id = mov.id");
        sql.append("    AND lppo.program_id=:programId");
        sql.append("    AND lppo.program_outcome_id = :programOutcomeId");
        sql.append("    AND (cov.calculation_value + mov.calculation_value)  > 0 ");
        logger.debug("getServiceCourseContributionForProgramOutomce " + sql.toString());
        List<CourseOfferingContribution> fromCourses = (List<CourseOfferingContribution>) session
                .createSQLQuery(sql.toString())
                .setResultTransformer(Transformers.aliasToBean(CourseOfferingContribution.class))
                .setParameter("programId", program.getId())
                .setParameter("programOutcomeId", programOutcome.getId()).list();

        toReturn.addAll(fromCourses);
        session.getTransaction().commit();
    } catch (Exception e) {
        HibernateUtil.logException(logger, e);
    }
    return toReturn;
}

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

License:Open Source License

@SuppressWarnings("unchecked")
public List<ProgramOutcomeCourseContribution> getProgramOutcomeCoreCourseContributionForProgram(
        Program program) {/*  www  .j a va 2  s .  co  m*/
    Session session = HibernateUtil.getSessionFactory().getCurrentSession();
    session.beginTransaction();
    List<ProgramOutcomeCourseContribution> toReturn = new ArrayList<ProgramOutcomeCourseContribution>();
    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.course_id AS courseId, lppo.program_outcome_id AS programOutcomeId, sum(cov.calculation_value) AS contributionSumObject,  sum(mov.calculation_value) AS masterySumObject  ");

        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 co.course_id = lcp.course_id");
        sql.append("   AND co.id = lcopo.course_offering_id");
        sql.append("   AND lcopo.link_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("   GROUP BY  co.course_id, lppo.program_outcome_id");
        logger.debug("getProgramOutcomeCoreCourseContributionForProgram Core contributions:" + sql.toString());
        List<ProgramOutcomeCourseContribution> fromOfferings = (List<ProgramOutcomeCourseContribution>) session
                .createSQLQuery(sql.toString())
                .setResultTransformer(Transformers.aliasToBean(ProgramOutcomeCourseContribution.class))
                .setParameter("programId", program.getId()).list();
        toReturn.addAll(fromOfferings);
        session.getTransaction().commit();
    } catch (Exception e) {
        HibernateUtil.logException(logger, e);
    }
    return toReturn;
}

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

License:Open Source License

@SuppressWarnings("unchecked")
public List<ProgramOutcomeCourseContribution> getProgramOutcomeServiceCourseContributionForProgram(
        Program program) {/*from w  w w.  j ava  2s.c  o  m*/
    Session session = HibernateUtil.getSessionFactory().getCurrentSession();
    session.beginTransaction();
    List<ProgramOutcomeCourseContribution> toReturn = new ArrayList<ProgramOutcomeCourseContribution>();
    try {
        StringBuffer sql = new StringBuffer();
        sql.append(
                " SELECT lccpo.course_id AS courseId, lppo.program_outcome_id AS programOutcomeId, cov.calculation_value AS contributionSum, mov.calculation_value AS masterySum ");
        sql.append("   from link_course_contribution_program_outcome lccpo");
        sql.append("      , link_program_program_outcome lppo ");
        sql.append("      , contribution_option_value cov ");
        sql.append("      , mastery_option_value mov ");
        sql.append("  WHERE lccpo.link_program_program_outcome_id = lppo.id ");
        sql.append("    AND lccpo.contribution_option_id = cov.id");
        sql.append("    AND lccpo.mastery_option_id = mov.id");
        sql.append("    AND lppo.program_id=:programId");
        logger.debug("getProgramOutcomeServiceCourseContributionForProgram :" + sql.toString());
        List<ProgramOutcomeCourseContribution> fromCourses = (List<ProgramOutcomeCourseContribution>) session
                .createSQLQuery(sql.toString())
                .setResultTransformer(Transformers.aliasToBean(ProgramOutcomeCourseContribution.class))
                .setParameter("programId", program.getId()).list();

        toReturn.addAll(fromCourses);
        session.getTransaction().commit();
    } catch (Exception e) {
        HibernateUtil.logException(logger, e);
    }
    return toReturn;
}

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

License:Open Source License

@SuppressWarnings("unchecked")
public List<CourseAssessmentOption> getProgramCourseAssessmentOptions(Program program, List<String> terms) {
    Session session = HibernateUtil.getSessionFactory().getCurrentSession();
    session.beginTransaction();//from www  .  jav a2s  .com
    List<CourseAssessmentOption> toReturn = new ArrayList<CourseAssessmentOption>();
    try {
        StringBuffer sql = new StringBuffer();
        sql.append(
                " select sum(lcoa.weight) as weight, ato.display_index as optionId, co.course_id as courseId  ");
        sql.append("    from course_offering co ");
        sql.append("        ,link_course_offering_assessment lcoa ");
        sql.append("        ,link_course_program lcp ");
        sql.append("        ,assessment_time_option ato ");
        sql.append("  WHERE ");
        sql.append(HibernateUtil.getListAsString("co.term", terms, true));
        sql.append("        lcp.program_id = :programId ");
        sql.append("    AND lcp.course_id = co.course_id ");
        sql.append("    AND co.id = lcoa.course_offering_id ");
        sql.append("    AND ato.id =  lcoa.assessment_time_option_id ");
        sql.append("group by co.course_id, ato.display_index  ");
        sql.append("order by co.course_id, ato.display_index ");
        //one record for each course that is part of the program.  Each record contains courseid, sum of weights for each time-option and the number of course_offerings for each.
        List<CourseAssessmentOption> fromOfferings = (List<CourseAssessmentOption>) session
                .createSQLQuery(sql.toString())
                .setResultTransformer(Transformers.aliasToBean(CourseAssessmentOption.class))
                .setParameter("programId", program.getId()).list();
        toReturn.addAll(fromOfferings);
        session.getTransaction().commit();
    } catch (Exception e) {
        HibernateUtil.logException(logger, e);
    }
    return toReturn;
}

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

License:Open Source License

@SuppressWarnings("unchecked")
public List<CourseTeachingMethodOption> getProgramCourseTeachingMethodOptions(Program program,
        List<String> terms) {
    Session session = HibernateUtil.getSessionFactory().getCurrentSession();
    session.beginTransaction();/*from  www  . j ava  2s. c o m*/
    List<CourseTeachingMethodOption> toReturn = new ArrayList<CourseTeachingMethodOption>();
    try {
        StringBuffer sql = new StringBuffer();
        sql.append(
                "  select sum(tmpo.comparative_value) as weight, tm.display_index as teachingMethodIndex, count(distinct lctm.course_offering_id) as offeringCount, co.course_id as courseId  ");
        sql.append("    from course_offering co ");
        sql.append("        ,link_course_offering_teaching_method lctm ");
        sql.append("        ,link_course_program lcp ");
        sql.append("        ,teaching_method tm ");
        sql.append("        ,teaching_method_portion_option tmpo ");
        sql.append("  WHERE ");
        sql.append(HibernateUtil.getListAsString("co.term", terms, true));
        sql.append(" lcp.program_id = :programId ");
        sql.append("    AND lcp.course_id = co.course_id ");
        sql.append("    AND co.id = lctm.course_offering_id ");
        sql.append("    AND lctm.teaching_method_id = tm.id ");
        sql.append("    AND lctm.teaching_method_portion_option_id = tmpo.id ");
        sql.append("group by co.course_id, tm.display_index  ");
        sql.append("order by co.course_id, tm.display_index ");
        //one record for each course that is part of the program.  Each record contains courseid, sum of weights for each time-option and the number of course_offerings for each.
        List<CourseTeachingMethodOption> fromOfferings = (List<CourseTeachingMethodOption>) session
                .createSQLQuery(sql.toString())
                .setResultTransformer(Transformers.aliasToBean(CourseTeachingMethodOption.class))
                .setParameter("programId", program.getId()).list();
        toReturn.addAll(fromOfferings);
        session.getTransaction().commit();
    } catch (Exception e) {
        HibernateUtil.logException(logger, e);
    }
    return toReturn;
}

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

License:Open Source License

@SuppressWarnings("unchecked")
public List<CourseAssessmentOption> getProgramAssessmentGroups(Program program, List<String> terms) {
    Session session = HibernateUtil.getSessionFactory().getCurrentSession();
    session.beginTransaction();//from  www  . ja  v a2s  .c  o  m
    List<CourseAssessmentOption> toReturn = new ArrayList<CourseAssessmentOption>();
    try {
        StringBuffer sql = new StringBuffer();
        sql.append(
                " select co.course_id as courseId,gr.display_index as optionId, sum(lcoa.weight) as weight ");
        sql.append("  from assessment_group gr ");
        sql.append("     , assessment a ");
        sql.append("     , link_course_offering_assessment lcoa ");
        sql.append("     , course_offering co ");
        sql.append("     , link_course_program lcp ");
        sql.append("where  ");
        sql.append(HibernateUtil.getListAsString("co.term", terms, true));
        sql.append("lcp.program_id=:programId  ");
        sql.append("  and lcp.course_id = co.course_id ");
        sql.append("  and co.id = lcoa.course_offering_id ");
        sql.append("  and lcoa.assessment_id = a.id ");
        sql.append("  and a.assessment_group_id = gr.id ");
        sql.append("  group by co.course_id,gr.display_index ");
        //one record for each course that is part of the program.  Each record contains courseid, sum of weights for each time-option and the number of course_offerings for each.
        List<CourseAssessmentOption> fromOfferings = (List<CourseAssessmentOption>) session
                .createSQLQuery(sql.toString())
                .setResultTransformer(Transformers.aliasToBean(CourseAssessmentOption.class))
                .setParameter("programId", program.getId()).list();
        toReturn.addAll(fromOfferings);
        session.getTransaction().commit();
    } catch (Exception e) {
        HibernateUtil.logException(logger, e);
    }
    return toReturn;
}

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

License:Open Source License

public Map<String, Integer> getCourseOfferingCounts(Program p, List<String> terms) {

    Session session = HibernateUtil.getSessionFactory().getCurrentSession();
    session.beginTransaction();//from www. ja  v a 2  s. c om
    Map<String, Integer> toReturn = new TreeMap<String, Integer>();
    try {
        StringBuffer sql = new StringBuffer();
        sql.append("  select co.course_id as a, count( distinct co.id) as b");
        sql.append(" from course_offering co ");
        sql.append("    , link_course_program lcp ");
        sql.append("where ");
        sql.append(HibernateUtil.getListAsString("co.term", terms, true));
        sql.append(" lcp.program_id = :programId ");
        sql.append(" and lcp.course_id = co.course_id ");
        sql.append(" and co.id in (select course_offering_id from link_course_offering_assessment) ");
        sql.append(" group by co.course_id; ");

        @SuppressWarnings("unchecked")
        List<Pair> counts = (List<Pair>) session.createSQLQuery(sql.toString())
                .setResultTransformer(Transformers.aliasToBean(Pair.class)).setParameter("programId", p.getId())
                .list();
        for (Pair pair : counts) {
            toReturn.put("" + pair.getA(), pair.getB());
        }
        session.getTransaction().commit();
    } catch (Exception e) {
        HibernateUtil.logException(logger, e);
    }
    return toReturn;
}

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

License:Open Source License

public Map<String, Integer> getProgramOutcomeContributions(Program p, List<String> terms) {

    Session session = HibernateUtil.getSessionFactory().getCurrentSession();
    session.beginTransaction();//from  ww  w . ja  v  a2s .c  o m
    Map<String, Integer> toReturn = new TreeMap<String, Integer>();
    try {

        StringBuffer sql = new StringBuffer();
        sql.append("   SELECT a.outcome,a.course,sum(a.calc)/count(section) as value FROM ");
        sql.append("   (");
        sql.append(
                "   select cov.calculation_value as calc, po.id as outcome, co.course_id as course, co.id as section");
        sql.append("   from link_course_offering_contribution_program_outcome lcocpo");
        sql.append("   , link_program_program_outcome lppo");
        sql.append("   , program_outcome po");
        sql.append("   , contribution_option_value cov");
        sql.append("   , course_offering co");
        sql.append("   WHERE lppo.id = lcocpo.link_program_program_outcome_id");
        sql.append("     AND po.id=lppo.program_outcome_id");
        sql.append("     AND cov.id = lcocpo.contribution_option_id ");
        sql.append("     AND co.id = lcocpo.course_offering_id");
        sql.append("     AND lppo.program_id=");
        sql.append(p.getId());
        sql.append("    UNION  ");
        sql.append(
                "   select cov.calculation_value as calc, po.id as outcome, lccpo.course_id as course, -1 as section");
        sql.append("   from link_course_contribution_program_outcome lccpo");
        sql.append("   , link_program_program_outcome lppo");
        sql.append("   , program_outcome po");
        sql.append("   , contribution_option_value cov");
        sql.append("   WHERE lppo.id = lccpo.link_program_program_outcome_id");
        sql.append("     AND po.id=lppo.program_outcome_id");
        sql.append("     AND cov.id = lccpo.contribution_option_id ");
        sql.append("     AND lppo.program_id=");
        sql.append(p.getId());
        sql.append("     ) a");
        sql.append("    group by a.outcome,a.course");
        sql.append("    order by a.outcome,a.course");

        @SuppressWarnings("unchecked")
        List<Pair> counts = (List<Pair>) session.createSQLQuery(sql.toString())
                .setResultTransformer(Transformers.aliasToBean(Pair.class)).setParameter("programId", p.getId())
                .list();
        for (Pair pair : counts) {
            toReturn.put("" + pair.getA(), pair.getB());
        }
        session.getTransaction().commit();
    } catch (Exception e) {
        HibernateUtil.logException(logger, e);
    }
    return toReturn;
}

From source file:cognition.pipeline.data.CoordinatesDao.java

License:Apache License

/**
 *
 * @return A list of all coordinates to be processed. Coordinates are retreieved
 * via the named-query "getCoordinates".
 *//* w  w  w  .j  av  a 2 s. c  om*/
public List<DNCWorkCoordinate> getCoordinates() {
    SessionWrapper session = createSourceSession();
    try {
        Query getCoordinates = session.getNamedQuery("getCoordinates");
        List<DNCWorkCoordinate> coordinateList = getCoordinates
                .setResultTransformer(Transformers.aliasToBean(DNCWorkCoordinate.class)).list();
        return coordinateList;
    } catch (Exception ex) {
        logger.error("Error loading coordinates. Please check getCoordinates query. " + ex.getMessage());
        return new ArrayList<>();
    } finally {
        session.closeSession();
    }
}

From source file:cognition.pipeline.data.PatientDao.java

License:Apache License

/**
 * Returns the patient with the given id.
 * Returns the patient from the cache if it's been fetched once.
 *
 * @param id//  w w  w  .  jav a  2 s.  co m
 * @return a patient object of the patient with the given id.
 */
@Cacheable(value = "patients", key = "#id")
public Individual getPatient(Long id) {
    SessionWrapper sessionWrapper = createSourceSession();
    try {
        Query getPatient = sessionWrapper.getNamedQuery("getPatient");
        getPatient.setParameter("patientId", id);
        logger.info("Loading patient " + id);
        Individual individual = (Individual) getPatient.setFirstResult(0).setMaxResults(1)
                .setResultTransformer(Transformers.aliasToBean(Individual.class)).uniqueResult();

        setNames(individual);
        setPhoneNumbers(individual);
        setAddresses(individual);
        setCarers(individual);
        setNhsNumbers(individual);
        setDateOfBirths(individual);

        return individual;
    } finally {
        sessionWrapper.closeSession();
    }
}