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.lims.model.dao.BiospecimenDao.java

License:Open Source License

public Double getQuantityAvailable(Biospecimen biospecimen) {
    Criteria criteria = getSession().createCriteria(BioTransaction.class);
    criteria.add(Restrictions.eq("biospecimen", biospecimen));
    criteria.setProjection(Projections.sum("quantity"));
    Double sum = (Double) criteria.uniqueResult();
    return sum;/*www  .ja v a 2  s . c o m*/
}

From source file:au.org.theark.lims.model.dao.BiospecimenDao.java

License:Open Source License

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

From source file:au.org.theark.lims.model.dao.BiospecimenDao.java

License:Open Source License

protected BiospecimenUidSequence getBiospecimenUidSequence(Study study) {
    // Stateless sessions should be used to avoid locking the record for future update
    // by getSession(), which relies on the "open session filter" mechanism
    StatelessSession session = getStatelessSession();
    Criteria criteria = session.createCriteria(BiospecimenUidSequence.class);
    criteria.add(Restrictions.eq(Constants.SUBJECTUIDSEQ_STUDYNAMEID, study.getName()));
    criteria.setMaxResults(1);//w  w  w . j  a  v  a  2 s .co  m
    BiospecimenUidSequence result = (BiospecimenUidSequence) criteria.uniqueResult();
    session.close();
    return result;
}

From source file:au.org.theark.lims.model.dao.BiospecimenDao.java

License:Open Source License

public boolean studyHasBiospecimens(Study study) {
    Criteria criteria = getSession().createCriteria(Biospecimen.class);
    criteria.add(Restrictions.eq("study", study));
    criteria.setProjection(Projections.count("id"));
    Long count = (Long) criteria.uniqueResult();
    return count > 0;
}

From source file:au.org.theark.lims.model.dao.BiospecimenDao.java

License:Open Source License

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

From source file:au.org.theark.lims.model.dao.BiospecimenDao.java

License:Open Source License

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

From source file:au.org.theark.lims.model.dao.BiospecimenDao.java

License:Open Source License

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

From source file:au.org.theark.lims.model.dao.BiospecimenDao.java

License:Open Source License

public List<Biospecimen> getBiospecimenByBioCollection(BioCollection bioCollection) {
    Criteria criteria = getSession().createCriteria(Biospecimen.class);
    criteria.add(Restrictions.eq("bioCollection", bioCollection));
    return criteria.list();
}

From source file:au.org.theark.lims.model.dao.BiospecimenDao.java

License:Open Source License

public Biospecimen getBiospecimenByUid(String biospecimenUid, final Study study) {
    Criteria criteria = getSession().createCriteria(Biospecimen.class);
    criteria.add(Restrictions.eq("biospecimenUid", biospecimenUid));
    if (study != null) {
        criteria.add(Restrictions.eq("study", study));
    }// ww  w.ja  v a  2s  .  co  m
    return (Biospecimen) criteria.uniqueResult();
}

From source file:au.org.theark.lims.model.dao.BiospecimenDao.java

License:Open Source License

public List<Biospecimen> getRootBiospecimensForBiocollection(BioCollection bc) {
    Criteria criteria = getSession().createCriteria(Biospecimen.class);
    criteria.add(Restrictions.eq("bioCollection", bc));
    criteria.add(Restrictions.isNull("parent"));
    //criteria.setFetchMode("invBlah", FetchMode.JOIN);
    List<Biospecimen> list = criteria.list();
    return list;/*from   www  .j a  v a2s .c o m*/
}