Example usage for org.hibernate Criteria add

Introduction

In this page you can find the example usage for org.hibernate Criteria add.

Prototype

public Criteria add(Criterion criterion);

Source Link

Document

Add a Criterion restriction to constrain the results to be retrieved.

Usage

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

License:Open Source License

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

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

License:Open Source License

public GenderType getSubjectGenderType(final String subjectUID, final Long studyId) {
    GenderType genderType = null;//from ww  w.j  a  v a 2s .  co  m
    Criteria criteria = getSession().createCriteria(LinkSubjectStudy.class, "lss");
    criteria.createAlias("study", "st", JoinType.INNER_JOIN);
    criteria.createAlias("person", "per", JoinType.INNER_JOIN);
    criteria.createAlias("per.genderType", "gen", JoinType.INNER_JOIN);

    criteria.setFetchMode("person", FetchMode.JOIN);

    criteria.add(Restrictions.eq("st.id", studyId));
    criteria.add(Restrictions.eq("lss.subjectUID", subjectUID));

    List list = criteria.list();
    if (list.size() > 0) {
        LinkSubjectStudy subject = (LinkSubjectStudy) list.get(0);
        genderType = subject.getPerson().getGenderType();
    }
    return genderType;
}

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

License:Open Source License

public List<OtherID> getOtherIDs(Person person) {
    if (person != null) {
        Criteria c = getSession().createCriteria(OtherID.class);
        c.setMaxResults(100);/*w  w w .  ja v a 2s  .co m*/
        c.add(Restrictions.eq("person", person));
        List<OtherID> results = c.list();
        return results;
    } else {
        return new ArrayList<OtherID>();
    }

}

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

License:Open Source License

public Collection<PersonLastnameHistory> getPersonLastnameHistory(Person person) {
    Criteria c = getSession().createCriteria(PersonLastnameHistory.class);
    c.setMaxResults(100);/*from www  .ja  v  a 2  s.c  o m*/
    c.add(Restrictions.eq("person", person));
    Collection<PersonLastnameHistory> results = c.list();
    return results;
}

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

License:Open Source License

public List<UserConfig> getUserConfigs(ArkUser arkUser) {
    List<UserConfig> userConfigs = new ArrayList<UserConfig>();
    Criteria criteria = getSession().createCriteria(UserConfig.class);
    log.info("arkuser: " + arkUser);
    log.info("arkuser.id: " + arkUser.getId());
    if (arkUser != null && arkUser.getId() != null) {
        criteria.add(Restrictions.eq("arkUser", arkUser));
        userConfigs = criteria.list();/*www . ja  v a 2 s.  c o m*/
        log.info("userconfs.size: " + userConfigs.size());
    }
    return userConfigs;
}

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

License:Open Source License

@Override
public UserConfig getUserConfig(ArkUser arkUser, ConfigField configField) {
    Criteria criteria = getSession().createCriteria(UserConfig.class);
    if (arkUser != null && arkUser.getId() != null) {
        criteria.add(Restrictions.eq("arkUser", arkUser));
    }//  www .ja  v a  2  s .  com
    if (configField != null && configField.getId() != null) {
        criteria.add(Restrictions.eq("configField", configField));
    }
    UserConfig userConfig = null;
    try {
        userConfig = (UserConfig) criteria.uniqueResult();
    } catch (HibernateException e) {
        log.error(e.getMessage());
        e.printStackTrace();
        userConfig = new UserConfig();
        userConfig.setArkUser(arkUser);
        userConfig.setConfigField(configField);
        //         userConfig.setValue(configField.getDefaultValue());
    }
    return userConfig;
}

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

License:Open Source License

public ConfigField getConfigFieldByName(String configField) {
    Criteria criteria = getSession().createCriteria(ConfigField.class);
    criteria.add(Restrictions.eq("name", configField));
    return (ConfigField) criteria.uniqueResult();
}

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

License:Open Source License

@Override
public List<Study> getChildStudiesForStudy(Study parentStudy) {
    Criteria criteria = getSession().createCriteria(Study.class);
    criteria.add(Restrictions.eq("parentStudy", parentStudy));
    List<Study> childStudies = criteria.list();
    return childStudies;
}

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

License:Open Source License

@Override
public List<String> getAllFamilyUIDs(Study study) {
    Criteria criteria = getSession().createCriteria(FamilyCustomFieldData.class);
    Set<String> familyUIDSet = new HashSet<String>();
    criteria.add(Restrictions.eq("study", study));
    List<FamilyCustomFieldData> familyCustomFieldDatalst = criteria.list();
    for (FamilyCustomFieldData familyCustomFieldData : familyCustomFieldDatalst) {
        familyUIDSet.add(familyCustomFieldData.getFamilyUid());
    }//from   w  w  w .  jav  a2s .c o  m
    List<String> familyUIDLst = new ArrayList<String>(familyUIDSet);
    return familyUIDLst;
}

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

License:Open Source License

@Override
public UploadType getUploadTypeByModuleAndName(ArkModule arkModule, String name) {
    Criteria criteria = getSession().createCriteria(UploadType.class);
    criteria.add(Restrictions.eq("name", name));
    criteria.add(Restrictions.eq("arkModule", arkModule));
    return (UploadType) criteria.uniqueResult();
}