Example usage for org.hibernate.criterion Restrictions idEq

Introduction

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

Prototype

public static Criterion idEq(Object value)

Source Link

Document

Apply an "equal" constraint to the identifier property

Usage

From source file:org.cast.cwm.data.builders.UserCriteriaBuilder.java

License:Open Source License

@Override
public void buildUnordered(Criteria criteria) {
    if (role != null)
        criteria.add(Restrictions.eq("role", role));
    if (!getAllUsers)
        criteria.add(Restrictions.eq("valid", true));
    if (permissionedOnly)
        criteria.add(Restrictions.eq("permission", true));
    if (username != null)
        criteria.add(Restrictions.eq("username", username).ignoreCase());
    if (email != null)
        criteria.add(Restrictions.eq("email", email).ignoreCase());
    if (subjectId != null)
        criteria.add(Restrictions.eq("subjectId", subjectId).ignoreCase());
    if (firstName != null)
        criteria.add(Restrictions.eq("firstName", firstName).ignoreCase());
    if (lastName != null)
        criteria.add(Restrictions.eq("lastName", lastName).ignoreCase());
    if (period != null && period.getObject() != null)
        criteria.createAlias("periods", "p").add(Restrictions.eq("p.id", period.getObject().getId()));

    if (sites != null && sites.getObject() != null) {
        // Restricted by site membership
        criteria.createAlias("periods", "p");
        if (!sites.getObject().isEmpty())
            criteria.add(Restrictions.in("p.site", sites.getObject().toArray()));
        else//from  w w  w .j ava 2s .  c o m
            criteria.add(Restrictions.idEq(0L)); // no sites selected, return no users
        // TODO should allow queries for users with no site at all, like @EventLog .
    }

    if (cacheResults)
        criteria.setCacheable(true);
}

From source file:org.codehaus.groovy.grails.orm.hibernate.query.AbstractHibernateCriterionAdapter.java

License:Apache License

protected void addSimplePropertyCriterionAdapters() {
    criterionAdaptors.put(Query.IdEquals.class, new CriterionAdaptor() {
        @Override//from  ww w  .j  av a2s. c o m
        public org.hibernate.criterion.Criterion toHibernateCriterion(AbstractHibernateQuery hibernateQuery,
                Query.Criterion criterion, String alias) {
            return Restrictions.idEq(((Query.IdEquals) criterion).getValue());
        }
    });
    criterionAdaptors.put(Query.Equals.class, new CriterionAdaptor<Query.Equals>() {
        @Override
        public Criterion toHibernateCriterion(AbstractHibernateQuery hibernateQuery, Query.Equals criterion,
                String alias) {
            String propertyName = getPropertyName(criterion, alias);
            Object value = criterion.getValue();
            if (value instanceof DetachedCriteria) {
                return Property.forName(propertyName).eq((DetachedCriteria) value);
            }
            return Restrictions.eq(propertyName, value);
        }
    });
    criterionAdaptors.put(Query.NotEquals.class, new CriterionAdaptor<Query.NotEquals>() {
        @Override
        public Criterion toHibernateCriterion(AbstractHibernateQuery hibernateQuery, Query.NotEquals criterion,
                String alias) {
            String propertyName = getPropertyName(criterion, alias);
            Object value = criterion.getValue();
            if (value instanceof DetachedCriteria) {
                return Property.forName(propertyName).ne((DetachedCriteria) value);
            }
            return Restrictions.ne(propertyName, value);
        }
    });
    criterionAdaptors.put(Query.GreaterThan.class, new CriterionAdaptor<Query.GreaterThan>() {
        @Override
        public Criterion toHibernateCriterion(AbstractHibernateQuery hibernateQuery,
                Query.GreaterThan criterion, String alias) {
            String propertyName = getPropertyName(criterion, alias);
            Object value = criterion.getValue();
            if (value instanceof DetachedCriteria) {
                return Property.forName(propertyName).gt((DetachedCriteria) value);
            }
            return Restrictions.gt(propertyName, value);
        }
    });
    criterionAdaptors.put(Query.GreaterThanEquals.class, new CriterionAdaptor<Query.GreaterThanEquals>() {
        @Override
        public Criterion toHibernateCriterion(AbstractHibernateQuery hibernateQuery,
                Query.GreaterThanEquals criterion, String alias) {
            String propertyName = getPropertyName(criterion, alias);
            Object value = criterion.getValue();
            if (value instanceof DetachedCriteria) {
                return Property.forName(propertyName).ge((DetachedCriteria) value);
            }
            return Restrictions.ge(propertyName, value);
        }
    });
    criterionAdaptors.put(Query.LessThan.class, new CriterionAdaptor<Query.LessThan>() {
        @Override
        public Criterion toHibernateCriterion(AbstractHibernateQuery hibernateQuery, Query.LessThan criterion,
                String alias) {
            String propertyName = getPropertyName(criterion, alias);
            Object value = criterion.getValue();
            if (value instanceof DetachedCriteria) {
                return Property.forName(propertyName).lt((DetachedCriteria) value);
            }
            return Restrictions.lt(propertyName, value);
        }
    });
    criterionAdaptors.put(Query.LessThanEquals.class, new CriterionAdaptor<Query.LessThanEquals>() {
        @Override
        public Criterion toHibernateCriterion(AbstractHibernateQuery hibernateQuery,
                Query.LessThanEquals criterion, String alias) {
            String propertyName = getPropertyName(criterion, alias);
            Object value = criterion.getValue();
            if (value instanceof DetachedCriteria) {
                return Property.forName(propertyName).le((DetachedCriteria) value);
            }
            return Restrictions.le(propertyName, value);
        }
    });
}

From source file:org.codehaus.groovy.grails.orm.hibernate.query.AbstractHibernateQuery.java

License:Apache License

@Override
public Query idEq(Object value) {
    addToCriteria(Restrictions.idEq(value));
    return this;
}

From source file:org.codehaus.groovy.grails.orm.hibernate.query.HibernateQuery.java

License:Apache License

@Override
public Query idEq(Object value) {
    criteria.add(Restrictions.idEq(value));
    return this;
}

From source file:org.davidmendoza.irsvped.dao.impl.PartyDaoHibernate.java

License:Open Source License

@Override
public Integer getAllotedSeats(Party party) {
    Criteria criteria = currentSession().createCriteria(Party.class);

    criteria.createCriteria("event").add(Restrictions.idEq(party.getEvent().getId()));
    criteria.setProjection(Projections.sum("seats"));

    Long results = (Long) criteria.uniqueResult();
    log.debug("Results {}", results);
    if (results == null) {
        results = 0L;//from w  w  w .  jav a  2s.com
    }
    return results.intValue();
}

From source file:org.ednovo.gooru.infrastructure.persistence.hibernate.AuthorizationDaoSupport.java

License:Open Source License

public Object get(Class<?> clazz, Serializable id, String... organizationUids) {
    Criteria criteria = getSession().createCriteria(clazz);
    criteria.add(Restrictions.idEq(id));
    if (Resource.class.isAssignableFrom(clazz)) {
        addAuthCriterias(criteria);/*from  w ww.  j  av  a  2s. c  o m*/
    } else if (OrganizationWrapper.class.isAssignableFrom(clazz)) {
        criteria.add(Restrictions.in("organization.partyUid", organizationUids));
    }
    List<?> result = criteria.list();
    return result.size() > 0 ? result.get(0) : null;
}

From source file:org.ednovo.gooru.infrastructure.persistence.hibernate.revision_history.RevisionHistoryRepositoryHibernate.java

License:Open Source License

@Override
public RevisionHistory get(String revisionHistoryUid) {
    return getRecord(getSession().createCriteria(RevisionHistory.class)
            .add(Restrictions.idEq(revisionHistoryUid)).list());
}

From source file:org.egov.infstr.services.PersistenceService.java

License:Open Source License

public T findByIdWithJoinFetch(final ID id, final String joinFetchPropertyName) {
    return (T) getSession().createCriteria(type).setFetchMode(joinFetchPropertyName, FetchMode.JOIN)
            .add(Restrictions.idEq(id)).uniqueResult();
}

From source file:org.egov.services.budget.BudgetDetailService.java

License:Open Source License

private void addBudgetDetailCriteria(final Map<String, Object> map, final Criteria criteria) {
    for (final Entry<String, Object> criterion : map.entrySet())
        if (isIdPresent(criterion.getValue()))
            criteria.createCriteria(criterion.getKey()).add(Restrictions.idEq(criterion.getValue()));
}

From source file:org.egov.services.budget.BudgetDetailService.java

License:Open Source License

private void addBudgetDetailCriteriaIncudingNullRestrictions(final Map<String, Object> map,
        final Criteria criteria) {
    for (final Entry<String, Object> criterion : map.entrySet())
        if (isIdPresent(criterion.getValue()))
            criteria.createCriteria(criterion.getKey()).add(Restrictions.idEq(criterion.getValue()));
        else/*from  w  w w  .j a va2 s . c  o  m*/
            criteria.add(Restrictions.isNull(criterion.getKey()));
}