Example usage 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)

Source Link

Document

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

Usage

From source file:dao.DrugGraphDataDao.java

public List<DrugGraphData> getPatientAdmissionYearMonth() {
    List<DrugGraphData> objects = null;
    SQLQuery sqlq = null;//ww w.ja  v  a2s.c o  m

    try {
        tx = session.beginTransaction();
        sqlq = session.createSQLQuery(
                "select c.name as CompoundName,count(*) as CompoundUsedNumber From Drug_has_Compound dhc join Compound c on\n"
                        + " c.idCompound=dhc.idCompound Group BY dhc.idCompound");
        objects = sqlq.setResultTransformer(Transformers.aliasToBean(DrugGraphData.class)).list();
        //            System.out.println(objects.size());
        tx.commit();
    } catch (HibernateException e) {
        tx.rollback();
    }
    return objects;
}

From source file:dao.JoinSeletedCompoundDao.java

public List<JoinSelectedCompound> findCompoundByDrugNumber(String str) {
    List<JoinSelectedCompound> objects = null;
    SQLQuery sqlq = null;//from  w ww.ja va 2s. c  om

    try {
        tx = session.beginTransaction();
        sqlq = session.createSQLQuery("call selectedCompoundJionCompound(:str)");
        sqlq.setString("str", str);
        objects = sqlq.setResultTransformer(Transformers.aliasToBean(JoinSelectedCompound.class)).list();
        tx.commit();
    } catch (HibernateException e) {
        tx.rollback();
    }
    return objects;
}

From source file:dao.PatientGraphDataDao.java

public List<PatientGraphData> getPatientAdmissionYearMonth() {
    List<PatientGraphData> objects = null;
    SQLQuery sqlq = null;/*from www .  j  av a  2  s.co  m*/

    try {
        tx = session.beginTransaction();
        sqlq = session.createSQLQuery(
                "SELECT extract(year from registration_date) as year, extract(month from registration_date) as month, \n"
                        + "COUNT(*) as patientNum  FROM patients GROUP BY extract(year from registration_date), extract(month from registration_date) \n"
                        + "ORDER BY Year,MONTH");
        objects = sqlq.setResultTransformer(Transformers.aliasToBean(PatientGraphData.class)).list();
        //            System.out.println(objects.size());
        tx.commit();
    } catch (HibernateException e) {
        tx.rollback();
    }
    return objects;
}

From source file:Data.Dao.Implementations.CategoryRepository.java

@Override
public List<CategoryDto> FilterByDescription(String description) {
    try {/*from  www.  j  a  v  a2  s  .com*/
        beginOperation();
        Query qu = sesion.getNamedQuery("Category.FindByDescription").setString("description",
                "%" + description + "%");
        List<CategoryDto> categories = qu.setResultTransformer(Transformers.aliasToBean(CategoryDto.class))
                .list();
        sesion.close();
        return categories;
    } catch (Exception ex) {
        this.LogSever(ex);
        return null;
    }
}

From source file:Data.Dao.Implementations.CategoryRepository.java

@Override
public List<CategoryDto> ListAll() {
    try {//ww w. j a v  a2s . c  o  m
        beginOperation();
        Query qu = sesion.getNamedQuery("Category.FindByDescription").setString("description", "%%");
        List<CategoryDto> categories = qu.setResultTransformer(Transformers.aliasToBean(CategoryDto.class))
                .list();
        sesion.close();
        return categories;
    } catch (Exception ex) {
        this.LogSever(ex);
        return null;
    }
}

From source file:debop4k.data.orm.hibernate.dao.HibernateDao.java

License:Apache License

private <P> Criteria buildProjectionCriteria(@NonNull Class<P> projectClass, @NonNull Criteria criteria,
        @NonNull Projection projections, boolean distinctResult) {
    if (distinctResult)
        criteria.setProjection(Projections.distinct(projections));
    else//from  w w w  .j a  v  a2  s.  c  o  m
        criteria.setProjection(projections);

    return criteria.setResultTransformer(Transformers.aliasToBean(projectClass));
}

From source file:edu.monash.merc.dao.DSVersionDAO.java

License:Open Source License

/**
 * {@inheritDoc}//from ww  w  .j a v a2  s  .  com
 */
@SuppressWarnings("unchecked")
public List<DBVersionBean> getLatestDBSVersionByChromosome(ChromType chromType) {
    Criteria dsvCriteria = this.session().createCriteria(this.persistClass);
    dsvCriteria.add(Restrictions.eq("chromosome", chromType.chm()));
    dsvCriteria.setProjection(
            Projections.projectionList().add(Projections.groupProperty("dbSource").as("dbSource"))
                    .add(Projections.max("id").as("id")).add(Projections.max("createdTime").as("createdTime"))
                    .add(Projections.max("versionNo").as("versionNo")));
    dsvCriteria.addOrder(Order.asc("dbSource"));
    return dsvCriteria.setResultTransformer(Transformers.aliasToBean(DBVersionBean.class)).list();
}

From source file:edu.monash.merc.dao.TPBVersionDAO.java

License:Open Source License

/**
 * {@inheritDoc}//w w  w . j  ava 2  s .  c  om
 */
@SuppressWarnings("unchecked")
public List<MaxDsTPBVersion> getAllChromosomeTPBVersionByMaxCombinatedDs() {
    Criteria tpbVCriteria = this.session().createCriteria(this.persistClass);
    tpbVCriteria.setProjection(
            Projections.projectionList().add(Projections.groupProperty("chromosome").as("chromosome"))
                    .add(Projections.max("id").as("id")).add(Projections.max("trackToken").as("trackToken"))
                    .add(Projections.max("versionNo").as("versionNo")));
    List<MaxDsTPBVersion> maxDsTPBVersions = tpbVCriteria
            .setResultTransformer(Transformers.aliasToBean(MaxDsTPBVersion.class)).list();
    //        System.out.println("======= max ds tpb versions size: " + maxDsTPBVersions.size());
    //        for(MaxDsTPBVersion maxDsTPBVersion : maxDsTPBVersions){
    //            System.out.println("========= > " +maxDsTPBVersion.getId() + " -- " + maxDsTPBVersion.getChromosome() + " -- " + maxDsTPBVersion.getTrackToken() + " -- " + maxDsTPBVersion.getVersionNo());
    //        }
    return maxDsTPBVersions;
}

From source file:ee.ria.xroad.opmonitordaemon.OperationalDataRecordManager.java

License:Open Source License

private static void setProjectionList(Criteria criteria, Set<String> fields) {
    ProjectionList projList = Projections.projectionList();
    HashSet<String> fieldSet = new HashSet<>(fields);

    // Necessary for searching the records.
    fieldSet.add(MONITORING_DATA_TS);/*from   w  w w  .  ja v  a2  s. c  om*/

    log.trace("setProjectionList(): {}", fieldSet);

    fieldSet.forEach(i -> projList.add(Projections.property(i), i));

    criteria.setProjection(projList);
    criteria.setResultTransformer(Transformers.aliasToBean(OperationalDataRecord.class));
}