Example usage for org.hibernate.criterion Restrictions isNull

Introduction

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

Prototype

public static Criterion isNull(String propertyName)

Source Link

Document

Apply an "is null" constraint to the named property

Usage

From source file:com.hypersocket.permissions.PermissionRepositoryImpl.java

License:Open Source License

@Override
@Transactional(readOnly = true)/*from ww w  .  j  av a  2s  .c  o  m*/
public Long countRoles(final Realm realm, String searchPattern) {
    return getCount(Role.class, "name", searchPattern, new CriteriaConfiguration() {

        @Override
        public void configure(Criteria criteria) {
            criteria.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
            criteria.add(Restrictions.eq("personalRole", false));
            criteria.add(Restrictions.eq("hidden", false));
            criteria.add(Restrictions.or(Restrictions.eq("realm", realm), Restrictions.isNull("realm")));
        }
    });
}

From source file:com.hypersocket.properties.NullValueRestriction.java

License:Open Source License

@Override
public void configure(DetachedCriteria criteria) {
    criteria.add(Restrictions.isNull(column));
}

From source file:com.hypersocket.realm.RealmRestriction.java

License:Open Source License

@Override
public void configure(DetachedCriteria criteria) {
    if (realm == null) {
        criteria.add(Restrictions.isNull(column));
    } else {/*from w  ww .  j a v a 2  s .  c  om*/
        criteria.add(Restrictions.eq(column, realm));
    }
}

From source file:com.hypersocket.resource.ResourceRestriction.java

License:Open Source License

@Override
public void configure(DetachedCriteria criteria) {
    if (resource == null) {
        criteria.add(Restrictions.isNull(column));
    } else {/* w  ww .ja va  2  s  . co m*/
        criteria.add(Restrictions.eq(column, resource.getId()));
    }
}

From source file:com.hypersocket.session.SessionRepositoryImpl.java

License:Open Source License

@Override
public List<Session> getActiveSessions() {
    return allEntities(Session.class, new CriteriaConfiguration() {
        @Override//from  w  ww .j a  v  a 2  s  .  c  o  m
        public void configure(Criteria criteria) {
            criteria.add(Restrictions.isNull("signedOut"));
            criteria.add(Restrictions.eq("system", false));
        }
    });
}

From source file:com.hypersocket.session.SessionRepositoryImpl.java

License:Open Source License

@Override
public Long getActiveSessionCount(boolean distinctUsers) {
    Criteria criteria = createCriteria(Session.class);

    criteria.add(Restrictions.isNull("signedOut"));
    criteria.add(Restrictions.eq("system", false));

    criteria.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);

    if (distinctUsers) {
        criteria.setProjection(Projections.countDistinct("principal"));
    } else {//w  w  w.j av a 2  s.  c o  m
        criteria.setProjection(Projections.rowCount());
    }
    return (long) criteria.uniqueResult();
}

From source file:com.hypersocket.session.SessionRepositoryImpl.java

License:Open Source License

@Override
public Long getSessionCount(final Date startDate, final Date endDate, final boolean distinctUsers) {

    Criteria criteria = createCriteria(Session.class);

    criteria.add(Restrictions.or(/*w  w w  .  j  a  v  a  2s  .  co m*/
            Restrictions.and(Restrictions.ge("created", startDate), Restrictions.lt("created", endDate)),
            Restrictions.and(Restrictions.lt("created", startDate), Restrictions
                    .or(Restrictions.ge("signedOut", startDate), Restrictions.isNull("signedOut")))));

    criteria.add(Restrictions.eq("system", false));

    criteria.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);

    if (distinctUsers) {
        criteria.setProjection(Projections.countDistinct("principal"));
    } else {
        criteria.setProjection(Projections.rowCount());
    }
    return (long) criteria.uniqueResult();
}

From source file:com.hypersocket.session.SessionRepositoryImpl.java

License:Open Source License

@Override
public List<Session> getSystemSessions() {
    return allEntities(Session.class, new CriteriaConfiguration() {
        @Override/*from   w  w  w  .  j a va2 s .com*/
        public void configure(Criteria criteria) {
            criteria.add(Restrictions.isNull("signedOut"));
            criteria.add(Restrictions.eq("system", true));
        }
    });
}

From source file:com.hypersocket.session.SessionRepositoryImpl.java

License:Open Source License

@Override
@Transactional(readOnly = true)//from www  . j  a  v  a 2 s  .c o  m
public List<Session> search(Realm realm, final String searchPattern, int start, int length,
        ColumnSort[] sorting, CriteriaConfiguration... configs) {
    return super.search(getEntityClass(), "uuid", "", start, length, sorting,
            ArrayUtils.addAll(configs, new RealmOrSystemRealmCriteria(realm), new CriteriaConfiguration() {

                @Override
                public void configure(Criteria criteria) {
                    criteria.add(Restrictions.eq("system", false));
                    criteria.add(Restrictions.isNull("signedOut"));

                    if (StringUtils.isNotEmpty(searchPattern)) {
                        criteria = criteria.createCriteria("principal");
                        criteria.add(Restrictions.ilike("name", searchPattern));
                    }

                }
            }));
}

From source file:com.hypersocket.session.SessionRepositoryImpl.java

License:Open Source License

@Override
@Transactional(readOnly = true)/*from w w w.j  a v  a 2s  .  c om*/
public long getResourceCount(Realm realm, final String searchPattern, CriteriaConfiguration... configs) {
    return getCount(getEntityClass(), "uuid", "",
            ArrayUtils.addAll(configs, new RealmOrSystemRealmCriteria(realm), new CriteriaConfiguration() {

                @Override
                public void configure(Criteria criteria) {
                    criteria.add(Restrictions.eq("system", false));
                    criteria.add(Restrictions.isNull("signedOut"));

                    if (StringUtils.isNotEmpty(searchPattern)) {
                        criteria = criteria.createCriteria("principal");
                        criteria.add(Restrictions.ilike("name", searchPattern));
                    }
                }
            }));
}