Example usage for org.hibernate.criterion DetachedCriteria add

Introduction

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

Prototype

public DetachedCriteria add(Criterion criterion)

Source Link

Document

Add a restriction

Usage

From source file:ch.systemsx.cisd.openbis.generic.server.dataaccess.db.ExternalDataDAO.java

License:Apache License

public ExternalDataPE tryToFindFullDataSetByCode(String dataSetCode, boolean withPropertyTypes) {
    assert dataSetCode != null : "Unspecified data set code";

    final String mangledCode = CodeConverter.tryToDatabase(dataSetCode);
    final Criterion codeEq = Restrictions.eq("code", mangledCode);

    final DetachedCriteria criteria = DetachedCriteria.forClass(ENTITY_CLASS);
    criteria.add(codeEq);
    if (withPropertyTypes) {
        criteria.setFetchMode("dataSetType.dataSetTypePropertyTypesInternal", FetchMode.JOIN);
    }//  w ww  .  ja v a2 s .  c om
    criteria.setResultTransformer(DetachedCriteria.DISTINCT_ROOT_ENTITY);
    final List<ExternalDataPE> list = cast(getHibernateTemplate().findByCriteria(criteria));
    final ExternalDataPE entity = tryFindEntity(list, "data set");
    if (operationLog.isDebugEnabled()) {
        operationLog
                .debug(String.format("External data '%s' found for data set code '%s'.", entity, dataSetCode));
    }
    return entity;
}

From source file:ch.systemsx.cisd.openbis.generic.server.dataaccess.db.FilterDAO.java

License:Apache License

public List<FilterPE> listFilters(String gridId) {
    assert gridId != null : "Unspecified grid ID.";

    final DetachedCriteria criteria = DetachedCriteria.forClass(getEntityClass());
    criteria.add(Restrictions.eq("databaseInstance", getDatabaseInstance()));
    criteria.add(Restrictions.eq("gridId", gridId));
    final List<FilterPE> list = cast(getHibernateTemplate().findByCriteria(criteria));
    if (operationLog.isDebugEnabled()) {
        operationLog.debug(String.format("%s(%s): %d filters(s) have been found.",
                MethodUtils.getCurrentMethod().getName(), gridId, list.size()));
    }/*w w  w.  ja v a 2s  .c  o m*/
    return list;
}

From source file:ch.systemsx.cisd.openbis.generic.server.dataaccess.db.GroupDAO.java

License:Apache License

public final List<GroupPE> listGroups(final DatabaseInstancePE databaseInstance) throws DataAccessException {
    assert databaseInstance != null : "Unspecified database instance.";

    final DetachedCriteria criteria = DetachedCriteria.forClass(getEntityClass());
    criteria.add(Restrictions.eq("databaseInstance", databaseInstance));
    final List<GroupPE> list = cast(getHibernateTemplate().findByCriteria(criteria));
    if (operationLog.isDebugEnabled()) {
        operationLog.debug(String.format("%s(%s): %d group(s) have been found.",
                MethodUtils.getCurrentMethod().getName(), databaseInstance, list.size()));
    }//from   w  w  w.java 2  s  . c om
    return list;
}

From source file:ch.systemsx.cisd.openbis.generic.server.dataaccess.db.PermIdDAO.java

License:Apache License

public IEntityInformationHolderDTO tryToFindByPermId(String permId, EntityKind entityKind) {
    assert permId != null : "Unspecified permId";
    final DetachedCriteria criteria = DetachedCriteria.forClass(entityKind.getEntityClass());
    criteria.add(Restrictions.eq("permId", permId));
    final List<IEntityInformationHolderDTO> list = cast(getHibernateTemplate().findByCriteria(criteria));
    final IEntityInformationHolderDTO entity = tryFindEntity(list, entityKind.name());
    if (operationLog.isDebugEnabled()) {
        operationLog.debug(String.format("%s '%s' found for permId '%s'.", entityKind.name(), entity, permId));
    }/* ww w. ja va 2s.  c  o m*/
    return entity;
}

From source file:ch.systemsx.cisd.openbis.generic.server.dataaccess.db.ProjectDAO.java

License:Apache License

public List<ProjectPE> listProjects(final GroupPE group) {
    assert group != null : "Unspecified group.";

    final DetachedCriteria criteria = DetachedCriteria.forClass(ProjectPE.class);
    criteria.add(Restrictions.eq("group", group));
    final List<ProjectPE> list = cast(getHibernateTemplate().findByCriteria(criteria));
    if (operationLog.isDebugEnabled()) {
        operationLog.debug(String.format("%s(%s): %d project(s) have been found.",
                MethodUtils.getCurrentMethod().getName(), group, list.size()));
    }/*from w  w  w  . j av a2s. co  m*/
    return list;
}

From source file:ch.systemsx.cisd.openbis.generic.server.dataaccess.db.RoleAssignmentDAO.java

License:Apache License

public final List<RoleAssignmentPE> listRoleAssignmentsByPerson(final PersonPE person) {
    assert person != null : "Unspecified person.";

    final DetachedCriteria criteria = DetachedCriteria.forClass(ENTITY_CLASS);
    criteria.add(Restrictions.eq("personInternal", person));
    final List<RoleAssignmentPE> list = cast(getHibernateTemplate().findByCriteria(criteria));
    if (operationLog.isDebugEnabled()) {
        operationLog.debug(String.format("%s(%s): %d role assignment(s) have been found.",
                MethodUtils.getCurrentMethod().getName(), person, list.size()));
    }/*from  w ww  .ja  v a2 s. c  o  m*/
    return list;
}

From source file:ch.systemsx.cisd.openbis.generic.server.dataaccess.db.SampleTypeDAO.java

License:Apache License

public final List<SampleTypePE> listSampleTypes() throws DataAccessException {
    final DetachedCriteria criteria = DetachedCriteria.forClass(getEntityClass());
    criteria.add(Restrictions.eq("databaseInstance", getDatabaseInstance()));
    criteria.setFetchMode("sampleTypePropertyTypesInternal", FetchMode.JOIN);
    criteria.setResultTransformer(DetachedCriteria.DISTINCT_ROOT_ENTITY);
    final List<SampleTypePE> list = cast(getHibernateTemplate().findByCriteria(criteria));
    if (operationLog.isDebugEnabled()) {
        operationLog.debug(String.format("%s: %d sample type(s) have been found.",
                MethodUtils.getCurrentMethod().getName(), list.size()));
    }/*from ww w .  j  a v a2  s. co m*/
    return list;
}

From source file:ch.tatool.app.service.impl.TrialDAO.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Trial> getTrials(ModuleSession session, Node node, int maxResults) {
    List<Trial> trials = null;

    DetachedCriteria criteria = DetachedCriteria.forClass(Trial.class);
    // limit the session
    if (session != null) {
        criteria.add(Property.forName("session").eq(session));
    }/*from   ww  w  .  j a  va2 s  . c o m*/
    // limit the element
    if (node != null) {
        criteria.add(Property.forName("nodeId").eq(node.getId()));
    }
    // get the last trial as first
    criteria.addOrder(Order.desc("id"));

    // find the trials
    trials = (List<Trial>) getHibernateTemplate().findByCriteria(criteria, 0, maxResults);

    return trials;
}

From source file:chiron.maxscore.service.impl.ClassServiceImpl.java

private DetachedCriteria makeCriteria(Map<String, Object> condition) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Class.class);

    if (condition == null) {
        return criteria;
    }//from w  w  w  .java  2s  .c o  m

    criteria.createAlias("grade", "g");
    criteria.createAlias("g.specialty", "s");
    criteria.createAlias("s.college", "c");

    if (condition.containsKey("college_id")) {
        criteria.add(Restrictions.eq("c.id", condition.get("college_id")));
    } else if (condition.containsKey("specialty_id")) {
        criteria.add(Restrictions.eq("s.id", condition.get("specialty_id")));
    } else if (condition.containsKey("grade_id")) {
        criteria.add(Restrictions.eq("g.id", condition.get("grade_id")));
    }

    if (condition.containsKey("class_name")) {
        criteria.add(
                Restrictions.ilike("className", condition.get("class_name").toString(), MatchMode.ANYWHERE));
    }

    return criteria;
}

From source file:chiron.maxscore.service.impl.CollegeServiceImpl.java

private DetachedCriteria makeCriteria(Map<String, Object> condition) {
    DetachedCriteria criteria = DetachedCriteria.forClass(College.class);

    if (condition == null) {
        return criteria;
    }/*from   w w w  . j  a  va 2 s  .  c om*/

    if (condition.containsKey("college_name")) {
        criteria.add(Restrictions.ilike("collegeName", condition.get("college_name").toString(),
                MatchMode.ANYWHERE));
    }

    return criteria;
}