Example usage for org.hibernate.criterion Restrictions eq

Introduction

In this page you can find the example usage for org.hibernate.criterion Restrictions eq.

Prototype

public static SimpleExpression eq(String propertyName, Object value)

Source Link

Document

Apply an "equal" constraint to the named property

Usage

From source file:au.org.theark.core.dao.StudyDao.java

License:Open Source License

public BioCollectionUidTemplate getBioCollectionUidTemplate(Study study) {
    Criteria criteria = getSession().createCriteria(BioCollectionUidTemplate.class);
    criteria.add(Restrictions.eq("study", study));
    return (BioCollectionUidTemplate) criteria.uniqueResult();
}

From source file:au.org.theark.core.dao.StudyDao.java

License:Open Source License

public List<SubjectVO> matchSubjectsFromInputFile(FileUpload subjectFileUpload, Study study) {
    List<SubjectVO> subjectVOList = new ArrayList<SubjectVO>();
    List<String> subjectUidList = new ArrayList<String>(0);

    if (subjectFileUpload != null) {
        try {/*  w  w w.j ava2 s  .c  o  m*/
            subjectUidList = CsvListReader.readColumnIntoList(subjectFileUpload.getInputStream());
        } catch (IOException e) {
            log.error("Error in Subject list file");
            return subjectVOList;
        }

        Criteria criteria = getSession().createCriteria(LinkSubjectStudy.class);
        criteria.add(Restrictions.eq("study", study));
        criteria.add(Restrictions.in("subjectUID", subjectUidList));
        List<LinkSubjectStudy> subjectList = criteria.list();

        for (Iterator<LinkSubjectStudy> iterator = subjectList.iterator(); iterator.hasNext();) {
            LinkSubjectStudy linkSubjectStudy = (LinkSubjectStudy) iterator.next();
            // Place the LinkSubjectStudy instance into a SubjectVO and add the SubjectVO into a List
            SubjectVO subject = new SubjectVO();
            subject.setSubjectUID(linkSubjectStudy.getSubjectUID());
            subject.setLinkSubjectStudy(linkSubjectStudy);
            //Person person = subject.getLinkSubjectStudy().getPerson();
            //subject.setSubjectPreviousLastname(getPreviousLastname(person));
            subjectVOList.add(subject);
        }
    }
    return subjectVOList;
}

From source file:au.org.theark.core.dao.StudyDao.java

License:Open Source License

public List<Study> getAssignedChildStudyListForPerson(Study study, Person person) {
    Criteria criteria = getSession().createCriteria(LinkSubjectStudy.class);
    criteria.createAlias("study", "s");
    criteria.add(Restrictions.eq("person", person));
    criteria.add(Restrictions.eq("s.parentStudy", study));
    criteria.add(Restrictions.ne("s.id", study.getId()));
    criteria.add(Restrictions.ne("subjectStatus", getSubjectStatus("Archive")));
    ProjectionList projectionList = Projections.projectionList();
    projectionList.add(Projections.groupProperty("study"), "study");
    criteria.setProjection(projectionList);

    return criteria.list();
}

From source file:au.org.theark.core.dao.StudyDao.java

License:Open Source License

public UploadStatus getUploadStatusFor(String statusFromConstant) {
    Criteria criteria = getSession().createCriteria(UploadStatus.class);
    criteria.add(Restrictions.eq("name", statusFromConstant));
    return (UploadStatus) criteria.uniqueResult();
}

From source file:au.org.theark.core.dao.StudyDao.java

License:Open Source License

@SuppressWarnings("unchecked")
public Collection<UploadType> getUploadTypesForSubject(Study study) {
    Criteria criteria = getSession().createCriteria(UploadType.class);
    criteria.add(Restrictions.eq("arkModule", getArkModuleForSubject()));
    if (study != null && study.getParentStudy() != null) { //i.e. study is a child study
        criteria.add(Restrictions.not(Restrictions.eq("name", "Subject Demographic Data")));
    }/*w  w w .  j a  v a 2s . co  m*/
    return criteria.list();
}

From source file:au.org.theark.core.dao.StudyDao.java

License:Open Source License

@SuppressWarnings("unchecked")
public Collection<UploadType> getUploadTypesForLims() {
    Criteria criteria = getSession().createCriteria(UploadType.class);
    criteria.add(Restrictions.eq("arkModule", getArkModuleForLims()));
    criteria.addOrder(Order.asc("order"));
    return criteria.list();
}

From source file:au.org.theark.core.dao.StudyDao.java

License:Open Source License

public ArkModule getArkModuleForSubject() {
    Criteria criteria = getSession().createCriteria(ArkModule.class);
    criteria.add(Restrictions.eq("name", "Subject"));
    return (ArkModule) criteria.uniqueResult();
}

From source file:au.org.theark.core.dao.StudyDao.java

License:Open Source License

public ArkModule getArkModuleForLims() {
    Criteria criteria = getSession().createCriteria(ArkModule.class);
    criteria.add(Restrictions.eq("name", "LIMS"));
    return (ArkModule) criteria.uniqueResult();
}

From source file:au.org.theark.core.dao.StudyDao.java

License:Open Source License

public YesNo getYes() {
    Criteria criteria = getSession().createCriteria(YesNo.class);
    criteria.add(Restrictions.eq("name", "Yes"));
    return (YesNo) criteria.uniqueResult();
}

From source file:au.org.theark.core.dao.StudyDao.java

License:Open Source License

public YesNo getNo() {
    Criteria criteria = getSession().createCriteria(YesNo.class);
    criteria.add(Restrictions.eq("name", "No"));
    return (YesNo) criteria.uniqueResult();
}