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:de.iteratec.iteraplan.persistence.dao.CheckBuildingBlocksWithNoAssociationsHelper.java

License:Open Source License

/**
 * Configures the criteria restrictions//from  w  w w .  j av a 2 s  .c om
 * 
 * @param c
 *          Criteria
 * @param type
 *          The type of building block
 */
public static void configureCriteriaRestrictions(Criteria c, TypeOfBuildingBlock type) {
    String[] associations = getAssociations(type);
    if (associations == null) {
        /**
         * exclude element from result list
         */
        c.add(Restrictions.isNull(ConsistencyCheckDAO.BB_ALIAS + ".id"));
    } else {
        /**
         * add restrictions for all associations and properties
         */
        String[] properties = new String[] {}; // getProperties(type);
        addRestrictionForAssociations(c, ConsistencyCheckDAO.BB_ALIAS, associations, properties);
    }
}

From source file:de.iteratec.iteraplan.persistence.dao.CheckBuildingBlocksWithNoAssociationsHelper.java

License:Open Source License

/**
 * Helper method to add restrictions imposing that all associations of a building block either do
 * not exist (null) or are empty./*from   w  ww.  ja  va2 s .  c  om*/
 * 
 * @param c
 *          the Criteria object
 * @param alias
 *          the alias of the building block
 * @param associations
 *          the set of associations
 * @param properties
 *          the set of properties
 */
public static void addRestrictionForAssociations(Criteria c, String alias, String[] associations,
        String[] properties) {
    for (String association : Arrays.asList(associations)) {
        //path to retrieve associated element
        String associationPath = alias + "." + association;
        //add restriction of this specific association
        c.add(Restrictions.or(Restrictions.isNull(associationPath), Restrictions.isEmpty(associationPath)));
        //mind that several c.add() produced from this iteration are implicitly combined by a logical AND
    }

    for (String property : properties) {
        //add restriction of this specific property
        c.add(Restrictions.or(Restrictions.isNull(property), Restrictions.isEmpty(property)));
    }

}

From source file:de.powerstaff.business.dao.hibernate.ProfileSearchDAOHibernateImpl.java

License:Open Source License

public SavedProfileSearch getSavedSearchForUser(final String aUsername) {
    return (SavedProfileSearch) getHibernateTemplate().execute(new HibernateCallback() {

        public Object doInHibernate(Session aSession) {

            Criteria theCriteria = aSession.createCriteria(SavedProfileSearch.class);
            theCriteria.add(Restrictions.isNull("project")).createCriteria("user")
                    .add(Restrictions.eq("name", aUsername));
            for (Object theRow : theCriteria.list()) {
                return theRow;
            }/*from  w ww . java  2  s . co  m*/
            return null;
        }
    });
}

From source file:de.sub.goobi.forms.SearchForm.java

License:Open Source License

/**
 * Initialise drop down list of user list.
 *//*from ww  w .j av a 2 s  . c o  m*/
protected void initUserList() {
    Session session = Helper.getHibernateSession();
    Criteria crit = session.createCriteria(User.class);
    crit.add(Restrictions.isNull("isVisible"));
    crit.add(Restrictions.eq("istActive", true));
    crit.addOrder(Order.asc("surname"));
    crit.addOrder(Order.asc("name"));
    try {
        this.user.addAll(crit.list());
    } catch (RuntimeException rte) {
        logger.warn("Catched RuntimeException. List of users could be empty!");
    }
}

From source file:de.tuclausthal.submissioninterface.persistence.dao.impl.ParticipationDAO.java

License:Open Source License

@Override
public List<Participation> getParticipationsWithoutGroup(Lecture lecture) {
    return getSession().createCriteria(Participation.class).add(Restrictions.eq("lecture", lecture))
            .add(Restrictions.isNull("group")).createCriteria("user").addOrder(Order.asc("lastName"))
            .addOrder(Order.asc("firstName")).list();
}

From source file:de.tuclausthal.submissioninterface.persistence.dao.impl.SubmissionDAO.java

License:Open Source License

@Override
public List<Submission> getSubmissionsForTaskOfGroupOrdered(Task task, Group group) {
    if (group == null) {
        return getSession().createCriteria(Submission.class, "sub").add(Restrictions.eq("task", task))
                .createCriteria("submitters").add(Restrictions.isNull("group"))
                .addOrder(Order.asc("sub.submissionid")).list();
    } else {//from  w  w  w  .j a va  2  s .co  m
        return getSession().createCriteria(Submission.class, "sub").add(Restrictions.eq("task", task))
                .createCriteria("submitters").add(Restrictions.eq("group", group)).addOrder(Order.asc("group"))
                .addOrder(Order.asc("sub.submissionid")).list();
    }
}

From source file:de.tuclausthal.submissioninterface.persistence.dao.impl.SubmissionDAO.java

License:Open Source License

@Override
public Submission getUngradedSubmission(Task task, int lastSubmissionID) {
    return (Submission) getSession().createCriteria(Submission.class, "sub")
            .add(Restrictions.gt("submissionid", lastSubmissionID)).add(Restrictions.eq("task", task))
            .createCriteria("submitters").add(Restrictions.isNull("sub.points"))
            .addOrder(Order.asc("sub.submissionid")).setMaxResults(1).uniqueResult();
}

From source file:de.tuclausthal.submissioninterface.persistence.dao.impl.SubmissionDAO.java

License:Open Source License

@Override
public Submission getUngradedSubmission(Task task, int lastSubmissionID, Group group) {
    if (group == null) {
        return (Submission) getSession().createCriteria(Submission.class, "sub")
                .add(Restrictions.gt("submissionid", lastSubmissionID)).add(Restrictions.eq("task", task))
                .createCriteria("submitters").add(Restrictions.isNull("group"))
                .add(Restrictions.isNull("sub.points")).addOrder(Order.asc("group"))
                .addOrder(Order.asc("sub.submissionid")).setMaxResults(1).uniqueResult();
    } else {//  w ww.  j  av  a 2 s  .c om
        return (Submission) getSession().createCriteria(Submission.class, "sub")
                .add(Restrictions.gt("submissionid", lastSubmissionID)).add(Restrictions.eq("task", task))
                .createCriteria("submitters").add(Restrictions.eq("group", group))
                .add(Restrictions.isNull("sub.points")).addOrder(Order.asc("group"))
                .addOrder(Order.asc("sub.submissionid")).setMaxResults(1).uniqueResult();
    }
}

From source file:dz.alkhwarizmix.framework.java.dao.impl.RecordDAO.java

License:Open Source License

private Criterion getEqualsParentCriterion(final Record record) {
    return (record.getParent() != null) ? Restrictions.eq(Record.PARENT_ID, record.getParent().getId())
            : Restrictions.isNull(Record.PARENT_ID);
}

From source file:dz.alkhwarizmix.framework.java.services.impl.EMailService.java

License:Open Source License

private DetachedCriteria getPendingEMailsCriteria() {
    final DetachedCriteria result = DetachedCriteria.forClass(EMail.class);
    result.add(Restrictions.isNull("sentAt"));
    return result;
}