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.phenotypic.model.dao.PhenotypicDao.java

License:Open Source License

protected Criteria buildGeneralPhenoDataSetCategoryCritera(PhenoDataSetCategory phenoDataSetCategory) {
    Criteria criteria = getSession().createCriteria(PhenoDataSetCategory.class);

    // Must be constrained on study and function
    criteria.add(Restrictions.eq("study", phenoDataSetCategory.getStudy()));

    criteria.add(Restrictions.eq("arkFunction", phenoDataSetCategory.getArkFunction()));

    if (phenoDataSetCategory.getId() != null) {
        criteria.add(Restrictions.eq("id", phenoDataSetCategory.getId()));
    }//from   w w  w  . j a v  a  2 s.c  o  m

    if (phenoDataSetCategory.getName() != null) {
        criteria.add(Restrictions.ilike("name", phenoDataSetCategory.getName(), MatchMode.ANYWHERE));
    }
    if (phenoDataSetCategory.getDescription() != null) {
        criteria.add(
                Restrictions.ilike("description", phenoDataSetCategory.getDescription(), MatchMode.ANYWHERE));
    }
    /*if (phenoDataSetCategory.getParentCategory() != null) {
       criteria.add(Restrictions.eq("parentCategory", phenoDataSetCategory.getParentCategory()));
    }
    if (phenoDataSetCategory.getOrderNumber() != null) {
       criteria.add(Restrictions.eq("orderNumber", phenoDataSetCategory.getOrderNumber()));
    }*/
    return criteria;
}

From source file:au.org.theark.phenotypic.model.dao.PhenotypicDao.java

License:Open Source License

@Override
public List<PhenoDataSetCategory> getAvailableAllCategoryListExceptThis(Study study, ArkFunction arkFunction,
        PhenoDataSetCategory thisPhenoDataSetCategory) throws ArkSystemException {
    Criteria criteria = getSession().createCriteria(PhenoDataSetCategory.class);
    criteria.add(Restrictions.ne("id", thisPhenoDataSetCategory.getId()));
    criteria.add(Restrictions.eq("arkFunction", arkFunction));
    criteria.add(Restrictions.eq("study", study));
    List<PhenoDataSetCategory> phenoDataSetCategoryList = (List<PhenoDataSetCategory>) criteria.list();
    return phenoDataSetCategoryList;
}

From source file:au.org.theark.phenotypic.model.dao.PhenotypicDao.java

License:Open Source License

@Override
public boolean isPhenoDataSetCategoryUnique(String phenoDataSetCategoryName, Study study,
        PhenoDataSetCategory phenoDataSetCategoryToUpdate) {
    boolean isUnique = true;
    StatelessSession stateLessSession = getStatelessSession();
    Criteria criteria = stateLessSession.createCriteria(CustomFieldCategory.class);
    criteria.add(Restrictions.eq("name", phenoDataSetCategoryName));
    criteria.add(Restrictions.eq("study", study));
    criteria.add(Restrictions.eq("arkFunction", phenoDataSetCategoryToUpdate.getArkFunction()));
    criteria.setMaxResults(1);/*from  w ww.  j a  va 2 s  .c  om*/

    PhenoDataSetCategory existingPhenoDataSetCategory = (PhenoDataSetCategory) criteria.uniqueResult();

    if ((phenoDataSetCategoryToUpdate.getId() != null && phenoDataSetCategoryToUpdate.getId() > 0)) {

        if (existingPhenoDataSetCategory != null
                && !phenoDataSetCategoryToUpdate.getId().equals(existingPhenoDataSetCategory.getId())) {
            isUnique = false;
        }
    } else {
        if (existingPhenoDataSetCategory != null) {
            isUnique = false;
        }
    }
    stateLessSession.close();
    return isUnique;
}

From source file:au.org.theark.phenotypic.model.dao.PhenotypicDao.java

License:Open Source License

/**
 * check the Custom field category for the data intergrity.
 *//*from  w  w  w. j a va  2 s . c  om*/
@Override
public boolean isPhenoDataSetCategoryAlreadyUsed(PhenoDataSetCategory phenoDataSetCategory) {
    /**
     * if a phenoDatasetCategory been used by the system it should be at least one or more of this table.
     * PickedPhenoDataSetCategory
     * LinkPhenoDataSetCategoryField
     * PhenoDataSetFieldDisplay
     *  
     */
    Boolean status1 = false, status2 = false, status3 = false;

    StatelessSession stateLessSessionOne = getStatelessSession();
    Criteria criteria = stateLessSessionOne.createCriteria(PickedPhenoDataSetCategory.class);
    ArkFunction arkFunction = iArkCommonService
            .getArkFunctionByName(au.org.theark.core.Constants.FUNCTION_KEY_VALUE_PHENO_COLLECTION);
    criteria.add(Restrictions.eq("arkFunction", arkFunction));
    criteria.add(Restrictions.eq("study", phenoDataSetCategory.getStudy()));
    criteria.add(Restrictions.eq("phenoDataSetCategory", phenoDataSetCategory));
    List<PickedPhenoDataSetCategory> phenoDataSetCategories = (List<PickedPhenoDataSetCategory>) criteria
            .list();
    if (phenoDataSetCategories.size() > 0) {
        status1 = true;
    } else {
        status1 = false;
    }
    StatelessSession stateLessSessionTwo = getStatelessSession();
    Criteria criteriaTwo = stateLessSessionTwo.createCriteria(LinkPhenoDataSetCategoryField.class);
    criteriaTwo.add(Restrictions.eq("arkFunction", arkFunction));
    criteriaTwo.add(Restrictions.eq("study", phenoDataSetCategory.getStudy()));
    criteriaTwo.add(Restrictions.eq("phenoDataSetCategory", phenoDataSetCategory));
    List<LinkPhenoDataSetCategoryField> linkPhenoDataSetCategoryFields = (List<LinkPhenoDataSetCategoryField>) criteriaTwo
            .list();
    if (linkPhenoDataSetCategoryFields.size() > 0) {
        status2 = true;
    } else {
        status2 = false;
    }
    StatelessSession stateLessSessionThree = getStatelessSession();
    Criteria criteriaThree = stateLessSessionThree.createCriteria(PhenoDataSetFieldDisplay.class);
    criteriaThree.createAlias("phenoDataSetGroup", "phenoDSG");
    criteriaThree.add(Restrictions.eq("phenoDSG.arkFunction", arkFunction));
    criteriaThree.add(Restrictions.eq("phenoDSG.study", phenoDataSetCategory.getStudy()));
    criteriaThree.add(Restrictions.eq("phenoDataSetCategory", phenoDataSetCategory));
    List<PhenoDataSetFieldDisplay> phenoDataSetFieldDisplays = (List<PhenoDataSetFieldDisplay>) criteriaThree
            .list();
    if (phenoDataSetFieldDisplays.size() > 0) {
        status3 = true;
    } else {
        status3 = false;
    }
    return status1 || status2 || status3;
}

From source file:au.org.theark.phenotypic.model.dao.PhenotypicDao.java

License:Open Source License

public PhenoDataSetField getPhenoDataSetField(Long id) {
    Criteria criteria = getSession().createCriteria(PhenoDataSetField.class);
    criteria.add(Restrictions.eq("id", id));
    criteria.setMaxResults(1);//from w w  w. j a  va  2 s .c  o m
    return (PhenoDataSetField) criteria.uniqueResult();
}

From source file:au.org.theark.phenotypic.model.dao.PhenotypicDao.java

License:Open Source License

/**
 * Search method to the  fileds.//from  w w w .  j  av a2  s. c  om
 * @param phenoDataSet
 * @return
 */
protected Criteria buildGeneralPhenoFieldCritera(PhenoDataSetField phenoDataSetField) {
    Criteria criteria = getSession().createCriteria(PhenoDataSetField.class);

    criteria.add(Restrictions.eq("study", phenoDataSetField.getStudy()));
    criteria.add(Restrictions.eq("arkFunction", phenoDataSetField.getArkFunction()));

    if (phenoDataSetField.getFieldType() != null) {
        criteria.add(Restrictions.eq("fieldType", phenoDataSetField.getFieldType()));
    }
    if (phenoDataSetField.getId() != null) {
        criteria.add(Restrictions.eq("id", phenoDataSetField.getId()));
    }
    if (phenoDataSetField.getName() != null) {
        criteria.add(Restrictions.ilike("name", phenoDataSetField.getName(), MatchMode.ANYWHERE));
    }
    if (phenoDataSetField.getDescription() != null) {
        criteria.add(Restrictions.ilike("description", phenoDataSetField.getDescription(), MatchMode.ANYWHERE));
    }
    if (phenoDataSetField.getUnitType() != null && phenoDataSetField.getUnitType().getName() != null
            && phenoDataSetField.getUnitTypeInText() != null) {
        criteria.createAlias("unitType", "ut");
        criteria.add(
                Restrictions.ilike("ut.name", phenoDataSetField.getUnitType().getName(), MatchMode.ANYWHERE));
    }
    if (phenoDataSetField.getUnitTypeInText() != null) {
        criteria.add(Restrictions.ilike("unitTypeInText", phenoDataSetField.getUnitTypeInText(),
                MatchMode.ANYWHERE));
    }
    if (phenoDataSetField.getMinValue() != null) {
        criteria.add(Restrictions.ilike("minValue", phenoDataSetField.getMinValue(), MatchMode.ANYWHERE));
    }
    if (phenoDataSetField.getMaxValue() != null) {
        criteria.add(Restrictions.ilike("maxValue", phenoDataSetField.getMaxValue(), MatchMode.ANYWHERE));
    }
    return criteria;
}

From source file:au.org.theark.phenotypic.model.dao.PhenotypicDao.java

License:Open Source License

public PhenoDataSetFieldDisplay getPhenoDataSetFieldDisplayByPhenoDataSet(
        PhenoDataSetField pheDataSetFieldCriteria) {
    Criteria criteria = getSession().createCriteria(PhenoDataSetFieldDisplay.class);
    criteria.add(Restrictions.eq("phenoDataSetField.id", pheDataSetFieldCriteria.getId()));
    criteria.setMaxResults(1);/* www.  ja  v  a 2  s.c  om*/
    return (PhenoDataSetFieldDisplay) criteria.uniqueResult();
}

From source file:au.org.theark.phenotypic.model.dao.PhenotypicDao.java

License:Open Source License

@Override
public List<PhenoDataSetCategory> getAvailableAllCategoryListInStudy(Study study, ArkFunction arkFunction)
        throws ArkSystemException {
    Criteria criteria = getSession().createCriteria(PhenoDataSetCategory.class);
    criteria.add(Restrictions.eq("arkFunction", arkFunction));
    criteria.add(Restrictions.eq("study", study));
    List<PhenoDataSetCategory> phenoFiedCategoryList = (List<PhenoDataSetCategory>) criteria.list();
    return phenoFiedCategoryList;

}

From source file:au.org.theark.phenotypic.model.dao.PhenotypicDao.java

License:Open Source License

public boolean isPhenoDataSetFieldUnqiue(String phenoFieldName, Study study,
        PhenoDataSetField phenoFieldToUpdate) {
    boolean isUnique = true;
    StatelessSession stateLessSession = getStatelessSession();
    Criteria criteria = stateLessSession.createCriteria(PhenoDataSetField.class);
    criteria.add(Restrictions.eq("name", phenoFieldName));
    criteria.add(Restrictions.eq("study", study));
    criteria.add(Restrictions.eq("arkFunction", phenoFieldToUpdate.getArkFunction()));
    criteria.setMaxResults(1);//from w w  w  .j  av a2  s  .c  o  m

    PhenoDataSetField existingField = (PhenoDataSetField) criteria.uniqueResult();

    if ((phenoFieldToUpdate.getId() != null && phenoFieldToUpdate.getId() > 0)) {

        if (existingField != null && !phenoFieldToUpdate.getId().equals(existingField.getId())) {
            isUnique = false;
        }
    } else {
        if (existingField != null) {
            isUnique = false;
        }
    }
    stateLessSession.close();
    return isUnique;
}

From source file:au.org.theark.phenotypic.model.dao.PhenotypicDao.java

License:Open Source License

public List<PhenoDataSetCategory> getAllSubCategoriesOfThisCategory(Study study, ArkFunction arkFunction,
        PhenoDataSetCategory parentphenoDataSetFieldCategory) {
    Criteria criteria = getSession().createCriteria(PhenoDataSetCategory.class);
    criteria.add(Restrictions.eq("study", study));
    criteria.add(Restrictions.eq("arkFunction", arkFunction));
    criteria.add(Restrictions.eq("parentCategory", parentphenoDataSetFieldCategory));
    return (List<PhenoDataSetCategory>) criteria.list();

}