org.generationcp.middleware.dao.NumericLevelDAO.java Source code

Introduction

Here is the source code for org.generationcp.middleware.dao.NumericLevelDAO.java

Source

/*******************************************************************************
 * Copyright (c) 2012, All Rights Reserved.
 * 
 * Generation Challenge Programme (GCP)
 * 
 * 
 * This software is licensed for use under the terms of the GNU General Public
 * License (http://bit.ly/8Ztv8M) and the provisions of Part F of the Generation
 * Challenge Programme Amended Consortium Agreement (http://bit.ly/KQX1nL)
 * 
 *******************************************************************************/

package org.generationcp.middleware.dao;

import java.math.BigInteger;
import java.util.ArrayList;
import java.util.List;

import org.generationcp.middleware.exceptions.MiddlewareQueryException;
import org.generationcp.middleware.pojos.DatasetCondition;
import org.generationcp.middleware.pojos.Factor;
import org.generationcp.middleware.pojos.NumericLevel;
import org.generationcp.middleware.pojos.NumericLevelElement;
import org.generationcp.middleware.pojos.NumericLevelPK;
import org.generationcp.middleware.pojos.StudyInfo;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.SQLQuery;

public class NumericLevelDAO extends GenericDAO<NumericLevel, NumericLevelPK> {

    @SuppressWarnings("rawtypes")
    public List<NumericLevelElement> getValuesByOunitIDList(List<Integer> ounitIdList)
            throws MiddlewareQueryException {

        List<NumericLevelElement> levelValues = new ArrayList<NumericLevelElement>();

        if (ounitIdList == null || ounitIdList.isEmpty()) {
            return levelValues;
        }

        try {
            SQLQuery query = getSession().createSQLQuery(NumericLevel.GET_BY_OUNIT_ID_LIST);
            query.setParameterList("ounitIdList", ounitIdList);

            List results = query.list();
            for (Object o : results) {
                Object[] result = (Object[]) o;
                if (result != null) {
                    Integer ounitId = (Integer) result[0];
                    Integer factorId = (Integer) result[1];
                    String factorName = (String) result[2];
                    Double value = (Double) result[3];

                    NumericLevelElement levelElement = new NumericLevelElement(ounitId, factorId, factorName,
                            value);

                    levelValues.add(levelElement);
                }
            }

            return levelValues;
        } catch (HibernateException e) {
            throw new MiddlewareQueryException("Error with getValuesByOunitIDList(ounitIdList=" + ounitIdList
                    + ") query from NumericLevel " + e.getMessage(), e);
        }
    }

    @SuppressWarnings("rawtypes")
    public List<DatasetCondition> getConditionAndValueByFactorIdAndLevelNo(Integer factorId, Integer levelNo)
            throws MiddlewareQueryException {
        try {
            List<DatasetCondition> toreturn = new ArrayList<DatasetCondition>();

            SQLQuery query = getSession().createSQLQuery(NumericLevel.GET_CONDITION_AND_VALUE);
            query.setParameter("factorid", factorId);
            query.setParameter("levelno", levelNo);

            List results = query.list();
            for (Object o : results) {
                Object[] result = (Object[]) o;
                String name = (String) result[0];
                Double value = (Double) result[1];
                Integer traitid = (Integer) result[2];
                Integer scaleid = (Integer) result[3];
                Integer methodid = (Integer) result[4];
                String type = (String) result[5];

                DatasetCondition condition = new DatasetCondition(factorId, name, value, traitid, scaleid, methodid,
                        type);
                toreturn.add(condition);
            }

            return toreturn;
        } catch (HibernateException e) {
            throw new MiddlewareQueryException("Error with getConditionAndValueByFactorIdAndLevelNo(factorId="
                    + factorId + ", levelNo=" + levelNo + ") query: " + e.getMessage(), e);
        }
    }

    public long countStudyInformationByGID(Long gid) throws MiddlewareQueryException {
        try {
            Query query = getSession().createSQLQuery(NumericLevel.COUNT_STUDIES_BY_GID);
            query.setParameter("gid", gid);

            BigInteger count = (BigInteger) query.uniqueResult();
            return count.longValue();
        } catch (Exception ex) {
            throw new MiddlewareQueryException("Error with countStudyInformationByGID(gid=" + gid
                    + ") query from NumericLevel " + ex.getMessage(), ex);
        }
    }

    @SuppressWarnings("rawtypes")
    public List<StudyInfo> getStudyInformationByGID(Long gid) throws MiddlewareQueryException {
        try {
            List<StudyInfo> toreturn = new ArrayList<StudyInfo>();
            Query query = getSession().createSQLQuery(NumericLevel.GET_STUDIES_BY_GID);
            query.setParameter("gid", gid);

            List results = query.list();
            for (Object o : results) {
                Object[] result = (Object[]) o;
                Integer studyid = (Integer) result[0];
                String name = (String) result[1];
                String title = (String) result[2];
                String objective = (String) result[3];
                BigInteger rowCount = (BigInteger) result[4];

                StudyInfo info = new StudyInfo(studyid, name.trim(), title.trim(), objective.trim(),
                        rowCount.intValue());
                toreturn.add(info);
            }

            return toreturn;

        } catch (Exception ex) {
            throw new MiddlewareQueryException("Error with getStudyInformationByGID(gid=" + gid
                    + ") query from NumericLevel " + ex.getMessage(), ex);
        }
    }

    @SuppressWarnings("unchecked")
    public List<NumericLevel> getByFactorAndDatasetID(Factor factor, Integer datasetId)
            throws MiddlewareQueryException {
        try {
            SQLQuery query = getSession().createSQLQuery(NumericLevel.GET_BY_FACTOR_AND_REPRESNO);
            query.setParameter("factorid", factor.getFactorId());
            query.setParameter("labelid", factor.getId());
            query.setParameter("represno", datasetId);

            query.addEntity("ln", NumericLevel.class);

            return query.list();
        } catch (HibernateException e) {
            throw new MiddlewareQueryException("Error with getByFactorAndDatasetID(factor=" + factor
                    + ", datasetId=" + datasetId + ") query from NumericLevel: " + e.getMessage(), e);
        }
    }
}