Example usage for org.hibernate.criterion Restrictions ne

Introduction

In this page you can find the example usage for org.hibernate.criterion Restrictions ne.

Prototype

public static SimpleExpression ne(String propertyName, Object value)

Source Link

Document

Apply a "not equal" constraint to the named property

Usage

From source file:org.kaaproject.kaa.server.common.dao.impl.sql.HibernateCtlSchemaMetaInfoDao.java

License:Apache License

@Override
public List<CtlSchemaMetaInfo> findSiblingsByFqnTenantIdAndApplicationId(String fqn, String tenantId,
        String applicationId) {//w  w w .  ja v a2s .  c  o  m
    LOG.debug("Searching siblings of ctl by fqn [{}], tenantId [{}] and applicationId [{}]", fqn, tenantId,
            applicationId);
    List<CtlSchemaMetaInfo> ctlSchemaMetaInfos;
    if (isNotBlank(fqn) && isNotBlank(tenantId) && isNotBlank(applicationId)) {
        ctlSchemaMetaInfos = findListByCriterion(Restrictions.and(
                Restrictions.eq(CTL_SCHEMA_META_INFO_FQN, fqn),
                Restrictions.eq(CTL_SCHEMA_META_INFO_TENANT_ID_ALIAS, Long.valueOf(tenantId)),
                Restrictions.isNotNull(CTL_SCHEMA_META_INFO_APPLICATION_ID_ALIAS),
                Restrictions.ne(CTL_SCHEMA_META_INFO_APPLICATION_ID_ALIAS, Long.valueOf(applicationId))));
    } else {
        ctlSchemaMetaInfos = Collections.emptyList();
    }
    if (LOG.isTraceEnabled()) {
        LOG.trace("[{}][{}][{}] Search result: [{}].", fqn, tenantId, applicationId,
                Arrays.toString(ctlSchemaMetaInfos.toArray()));
    } else {
        LOG.debug("[{}][{}][{}] Search result: [{}].", fqn, tenantId, applicationId, ctlSchemaMetaInfos.size());
    }
    return ctlSchemaMetaInfos;
}

From source file:org.kaaproject.kaa.server.common.dao.impl.sql.HibernateCtlSchemaMetaInfoDao.java

License:Apache License

@Override
public List<CtlSchemaMetaInfo> findOthersByFqnAndTenantId(String fqn, String tenantId, String excludingId) {
    LOG.debug("Searching other ctl schema meta infos by fqn [{}], " + "tenant id [{}] and excluding id [{}]",
            fqn, tenantId, excludingId);
    List<CtlSchemaMetaInfo> availableSchemas = findListByCriterion(
            Restrictions.and(Restrictions.ne(ID_PROPERTY, Long.valueOf(excludingId)),
                    Restrictions.eq(CTL_SCHEMA_META_INFO_FQN, fqn),
                    Restrictions.or(/*  ww w. j  av  a2 s .c om*/
                            Restrictions.eq(CTL_SCHEMA_META_INFO_TENANT_ID_ALIAS, Long.valueOf(tenantId)),
                            Restrictions.isNull(CTL_SCHEMA_META_INFO_TENANT_ID_ALIAS))));
    if (LOG.isTraceEnabled()) {
        LOG.trace("[{}][{}][{}] Search result: [{}].", fqn, tenantId, excludingId,
                Arrays.toString(availableSchemas.toArray()));
    } else {
        LOG.debug("[{}][{}][{}] Search result: [{}].", fqn, tenantId, excludingId, availableSchemas.size());
    }
    return availableSchemas;
}

From source file:org.kaaproject.kaa.server.common.dao.impl.sql.HibernateEventClassFamilyDao.java

License:Apache License

@Override
public boolean validateName(String tenantId, String ecfId, String name) {
    LOG.debug("Validating by tenant id [{}], ecf id [{}], name [{}]", tenantId, ecfId, name);
    Criteria criteria = getCriteria();/*  w  w w  .  j  a v  a 2  s  .c  o  m*/
    criteria.createAlias(TENANT_PROPERTY, TENANT_ALIAS);
    criteria.add(Restrictions.and(Restrictions.eq(TENANT_REFERENCE, Long.valueOf(tenantId)),
            Restrictions.eq(NAME_PROPERTY, name)));
    if (isNotBlank(ecfId)) {
        criteria = criteria.add(Restrictions.ne(ID_PROPERTY, Long.valueOf(ecfId)));
    }
    List<EventClassFamily> eventClassFamilies = findListByCriteria(criteria);
    boolean result = eventClassFamilies == null || eventClassFamilies.isEmpty();
    LOG.debug("[{},{},{}] Validating result: {}", tenantId, ecfId, name, result);
    return result;
}

From source file:org.kaaproject.kaa.server.common.dao.impl.sql.HibernateEventClassFamilyDao.java

License:Apache License

@Override
public boolean validateClassName(String tenantId, String ecfId, String className) {
    LOG.debug("Validating fqn, tenant id [{}], ecf id [{}], className [{}]", tenantId, ecfId, className);
    Criteria criteria = getCriteria();//from w ww  . jav a  2s. com
    criteria.createAlias(TENANT_PROPERTY, TENANT_ALIAS);
    criteria.add(Restrictions.and(Restrictions.eq(TENANT_REFERENCE, Long.valueOf(tenantId)),
            Restrictions.eq(CLASS_NAME_PROPERTY, className)));
    if (isNotBlank(ecfId)) {
        criteria = criteria.add(Restrictions.ne(ID_PROPERTY, Long.valueOf(ecfId)));
    }
    List<EventClassFamily> eventClassFamilies = findListByCriteria(criteria);
    boolean result = eventClassFamilies == null || eventClassFamilies.isEmpty();
    LOG.debug("[{},{},{}] Validating result: {}", tenantId, ecfId, className, result);
    return result;
}

From source file:org.kaaproject.kaa.server.common.dao.impl.sql.HibernateProfileFilterDao.java

License:Apache License

@Override
public List<ProfileFilter> findActualByEndpointGroupId(String groupId) {
    LOG.debug("Searching actual profile filters by endpoint group id [{}] ", groupId);
    List<ProfileFilter> filters = Collections.emptyList();
    if (isNotBlank(groupId)) {
        filters = findListByCriterionWithAlias(ENDPOINT_GROUP_PROPERTY, ENDPOINT_GROUP_ALIAS,
                Restrictions.and(Restrictions.eq(ENDPOINT_GROUP_REFERENCE, Long.valueOf(groupId)),
                        Restrictions.ne(STATUS_PROPERTY, UpdateStatus.DEPRECATED)));
    }/*w  ww.j a v a  2  s. c o m*/
    if (LOG.isTraceEnabled()) {
        LOG.trace("[{}] Search result: {}.", groupId, Arrays.toString(filters.toArray()));
    } else {
        LOG.debug("[{}] Search result: {}.", groupId, filters.size());
    }
    return filters;
}

From source file:org.kaaproject.kaa.server.common.dao.impl.sql.HibernateProfileFilterDao.java

License:Apache License

@Override
public List<ProfileFilter> findActualBySchemaIdAndGroupId(String endpointProfileSchemaId,
        String serverProfileSchemaId, String groupId) {
    LOG.debug(//w ww .  j  a va  2s .c o m
            "Searching actual profile filters by endpoint schema id [{}], "
                    + "server schema id [{}] and group id [{}] ",
            endpointProfileSchemaId, serverProfileSchemaId, groupId);
    List<ProfileFilter> filters = Collections.emptyList();
    if (isNotBlank(groupId)) {
        Criteria criteria = getCriteria();
        criteria.createAlias(ENDPOINT_GROUP_PROPERTY, ENDPOINT_GROUP_ALIAS);
        criteria.createAlias(ENDPOINT_PROFILE_SCHEMA_PROPERTY, ENDPOINT_PROFILE_SCHEMA_ALIAS,
                JoinType.LEFT_OUTER_JOIN);
        criteria.createAlias(SERVER_PROFILE_SCHEMA_PROPERTY, SERVER_PROFILE_SCHEMA_ALIAS,
                JoinType.LEFT_OUTER_JOIN);
        criteria.add(Restrictions.and(Restrictions.eq(ENDPOINT_GROUP_REFERENCE, Long.valueOf(groupId)),
                buildEqIdCriterion(ENDPOINT_PROFILE_SCHEMA_REFERENCE, endpointProfileSchemaId),
                buildEqIdCriterion(SERVER_PROFILE_SCHEMA_REFERENCE, serverProfileSchemaId),
                Restrictions.ne(STATUS_PROPERTY, UpdateStatus.DEPRECATED)));
        filters = findListByCriteria(criteria);
    }
    if (LOG.isTraceEnabled()) {
        LOG.trace("[{},{},{}] Search result: {}.", endpointProfileSchemaId, serverProfileSchemaId, groupId,
                Arrays.toString(filters.toArray()));
    } else {
        LOG.debug("[{},{},{}] Search result: {}.", endpointProfileSchemaId, serverProfileSchemaId, groupId,
                filters.size());
    }
    return filters;
}

From source file:org.LexGrid.LexBIG.caCore.dao.orm.translators.GridCQLToDetachedCriteria.java

License:Open Source License

private Criterion processAttribute(Attribute att, String parentAlias) {
    String attName = null;/*from  www  .jav  a2 s.  c o m*/

    if (prefixCastorUnderscore) {
        attName = addCastorUnderscore(att.getName());
    } else {
        attName = att.getName();
    }

    String name = parentAlias + "." + attName;
    String value = att.getValue();
    Criterion restriction = null;

    Predicate attPredicate = att.getPredicate();

    if (attPredicate.equals(Predicate.EQUAL_TO)) {
        restriction = Restrictions.eq(name, value);
    }
    if (attPredicate.equals(Predicate.LIKE)) {
        restriction = Restrictions.like(name, value);
    }
    if (attPredicate.equals(Predicate.GREATER_THAN)) {
        restriction = Restrictions.gt(name, value);
    }
    if (attPredicate.equals(Predicate.GREATER_THAN_EQUAL_TO)) {
        restriction = Restrictions.ge(name, value);
    }
    if (attPredicate.equals(Predicate.LESS_THAN)) {
        restriction = Restrictions.lt(name, value);
    }
    if (attPredicate.equals(Predicate.LESS_THAN_EQUAL_TO)) {
        restriction = Restrictions.le(name, value);
    }
    if (attPredicate.equals(Predicate.IS_NULL)) {
        restriction = Restrictions.isNull(name);
    }
    if (attPredicate.equals(Predicate.IS_NOT_NULL)) {
        restriction = Restrictions.isNotNull(name);
    }
    if (attPredicate.equals(Predicate.NOT_EQUAL_TO)) {
        restriction = Restrictions.ne(name, value);
    }
    return restriction;
}

From source file:org.LexGrid.LexBIG.caCore.dao.orm.translators.SDKCQLToDetachedCriteria.java

License:Open Source License

private Criterion processAttribute(CQLAttribute att, String parentAlias) {
    String name = parentAlias + "." + att.getName();
    String value = att.getValue();
    Criterion restriction = null;//from  w  w  w  .j  a v a2  s.  c o  m

    CQLPredicate attPredicate = att.getPredicate();

    if (attPredicate.equals(CQLPredicate.EQUAL_TO)) {
        restriction = Restrictions.eq(name, value);
    }
    if (attPredicate.equals(CQLPredicate.LIKE)) {
        restriction = Restrictions.like(name, value);
    }
    if (attPredicate.equals(CQLPredicate.GREATER_THAN)) {
        restriction = Restrictions.gt(name, value);
    }
    if (attPredicate.equals(CQLPredicate.GREATER_THAN_EQUAL_TO)) {
        restriction = Restrictions.ge(name, value);
    }
    if (attPredicate.equals(CQLPredicate.LESS_THAN)) {
        restriction = Restrictions.lt(name, value);
    }
    if (attPredicate.equals(CQLPredicate.LESS_THAN_EQUAL_TO)) {
        restriction = Restrictions.le(name, value);
    }
    if (attPredicate.equals(CQLPredicate.IS_NULL)) {
        restriction = Restrictions.isNull(name);
    }
    if (attPredicate.equals(CQLPredicate.IS_NOT_NULL)) {
        restriction = Restrictions.isNotNull(name);
    }
    if (attPredicate.equals(CQLPredicate.NOT_EQUAL_TO)) {
        restriction = Restrictions.ne(name, value);
    }
    return restriction;
}

From source file:org.libreplan.business.orders.daos.OrderDAO.java

License:Open Source License

@Override
public List<Order> getOrdersWithNotEmptyCustomersReferences() {
    return getSession().createCriteria(Order.class).add(Restrictions.isNotNull("customerReference"))
            .add(Restrictions.ne("customerReference", "")).list();
}

From source file:org.libreplan.business.scenarios.daos.ScenarioDAO.java

License:Open Source License

@Override
public List<Scenario> getAllExcept(Scenario scenario) {
    return getSession().createCriteria(Scenario.class).add(Restrictions.ne("name", scenario.getName())).list();
}