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 GenderType getSubjectGenderType(final String subjectUID, final Long studyId) {
    GenderType genderType = null;/*from   ww  w .ja va  2s  .c om*/
    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);/*from   w  w  w.jav a2s  .com*/
        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);//w  w  w.j  ava2 s  . co 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();//from w w  w .ja v a  2s  .com
        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));
    }/*ww w. j av  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   ww w  .j av a 2 s . co 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();
}

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

License:Open Source License

@Override
public List<Search> getSearchesForSearch(Search search) {
    Criteria criteria = getSession().createCriteria(Search.class);
    criteria.add(Restrictions.eq("study", search.getStudy()));
    if (search.getId() != null) {
        criteria.add(Restrictions.eq("id", search.getId()));
    }// ww w .j a v  a2s  . c  o m
    if (search.getName() != null) {
        criteria.add(Restrictions.like("name", search.getName(), MatchMode.ANYWHERE));
    }
    List<Search> searchList = criteria.list();
    return searchList;
}