Example usage for org.hibernate.criterion Restrictions eq

List of usage examples for org.hibernate.criterion Restrictions eq

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. Restrictions
  6. 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.phenotypic.model.dao.PhenotypicDao.java

License:Open Source License

/**
 * check the Custom field category for the data intergrity.
 *///from   w  ww .j a  v  a  2 s. c  o  m
@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);/* w  ww .  j av  a2s.co 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  www  .ja  v a  2 s .c  o  m
 * @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);/* w  w  w . ja v  a2 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);/* w w w .ja  v a  2  s. co 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();

}

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

License:Open Source License

@Override
public List<PhenoDataSetField> getPhenoDataSetFieldsLinkedToPhenoDataSetFieldGroup(
        PhenoDataSetGroup phenoDataSetGroupCriteria) {
    Criteria criteria = getSession().createCriteria(PhenoDataSetFieldDisplay.class);
    criteria.add(Restrictions.eq("phenoDataSetGroup", phenoDataSetGroupCriteria));
    ProjectionList projectionList = Projections.projectionList();
    projectionList.add(Projections.property("phenoDataSetField"));
    criteria.setProjection(projectionList);
    criteria.addOrder(Order.asc("phenoDataSetFiledOrderNumber"));
    List<PhenoDataSetField> fieldsList = criteria.list();
    return fieldsList;
}

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

License:Open Source License

private List<PhenoDataSetFieldDisplay> getPhenoDataSetFieldDisplayForPhenoDataSetFieldGrroup(
        PhenoDataSetGroup phenoDataSetGroup) {
    Criteria criteria = getSession().createCriteria(PhenoDataSetFieldDisplay.class);
    criteria.add(Restrictions.eq("phenoDataSetGroup", phenoDataSetGroup));
    criteria.addOrder(Order.asc("phenoDataSetFiledOrderNumber"));
    return criteria.list();
}

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

License:Open Source License

@Override
public PhenoDataSetFieldDisplay getPhenoDataSetFieldDisplayByPhenoDataSetFieldAndGroup(
        PhenoDataSetField phenoDataSetField, PhenoDataSetGroup phenoDataSetGroup) {
    Criteria criteria = getSession().createCriteria(PhenoDataSetFieldDisplay.class);
    criteria.add(Restrictions.eq("phenoDataSetField", phenoDataSetField));
    criteria.add(Restrictions.eq("phenoDataSetGroup", phenoDataSetGroup));
    criteria.setMaxResults(1);/* ww w .  j  a  v  a 2  s  .c  o  m*/
    return (PhenoDataSetFieldDisplay) criteria.uniqueResult();
}