Example usage for org.hibernate.criterion Restrictions gt

List of usage examples for org.hibernate.criterion Restrictions gt

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. Restrictions
  6. gt

Introduction

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

Prototype

public static SimpleExpression gt(String propertyName, Object value)

Source Link

Document

Apply a "greater than" constraint to the named property

Usage

From source file:es.tekniker.framework.ktek.questionnaire.mng.db.QuestionnaireManagerDB.java

License:Open Source License

public Ktek_formatquestionnaire getQuestionnaireAssessmentConfiguration(int idquestionnaire) {
    Ktek_formatquestionnaire instance = null;

    PersistentSession session = null;//from w w w .ja  va 2s  .  c  o m
    DAOFactory lDAOFactory = null;
    Ktek_formatquestionnaireDAO instanceDAO = null;
    Ktek_formatquestionnaireCriteria objKtek_formatquestionnaireCriteria = null;
    Ktek_questionnaireCriteria objKtek_fk_questionnaireCriteria = null;
    long nowInMillis = 0;

    try {
        nowInMillis = Utils.getCalendarGMT().getTimeInMillis();

        session = es.tekniker.framework.ktek.questionnaire.KTEKPersistentManager.instance().getSession();
        session.beginTransaction();

        lDAOFactory = es.tekniker.framework.ktek.questionnaire.DAOFactory.getDAOFactory();
        instanceDAO = lDAOFactory.getKtek_formatquestionnaireDAO();

        objKtek_formatquestionnaireCriteria = new Ktek_formatquestionnaireCriteria();
        objKtek_fk_questionnaireCriteria = objKtek_formatquestionnaireCriteria
                .createKtek_fk_questionnaireCriteria();
        objKtek_fk_questionnaireCriteria.ktek_pk_idquestionnaire.eq(idquestionnaire);
        objKtek_fk_questionnaireCriteria.isdeleted.eq((short) 0);
        objKtek_fk_questionnaireCriteria.datevalidfrom.lt(nowInMillis);
        objKtek_fk_questionnaireCriteria.add(Restrictions.or(Restrictions.isNull("datevalidto"),
                Restrictions.gt("datevalidto", nowInMillis)));

        instance = instanceDAO.loadKtek_formatquestionnaireByCriteria(objKtek_formatquestionnaireCriteria);

        session.close();

        if (instance != null) {
            log.debug("getQuestionnaireAssesmentConfiguration is not null ");
        } else {
            log.debug("getQuestionnaireAssesmentConfiguration is null ");
        }

    } catch (Exception e) {
        log.error("getQuestionnaireAssesmentConfiguration Exception " + e.getMessage());
        e.printStackTrace();
        try {
            if (session != null)
                session.close();
        } catch (PersistentException e1) {
            e1.printStackTrace();
        }
    }
    return instance;
}

From source file:es.tekniker.framework.ktek.questionnaire.mng.db.QuestionnaireManagerDB.java

License:Open Source License

public Ktek_questionnairesection[] getQuestionnaireAssessmentSectionList(int idquestionnaire) {
    Ktek_questionnairesection[] instanceArray = null;

    PersistentSession session = null;/*  www.ja  v  a2  s . c o  m*/
    DAOFactory lDAOFactory = null;
    Ktek_questionnairesectionDAO instanceDAO = null;
    Ktek_questionnairesectionCriteria objKtek_questionnairesectionCriteria = null;
    Ktek_qsection_questionnaireCriteria objKtek_qsection_questionnaireCriteria = null;
    Ktek_questionnaireCriteria objKtek_fk_idquestionnaireCriteria = null;
    long nowInMillis = 0;

    try {
        nowInMillis = Utils.getCalendarGMT().getTimeInMillis();

        session = es.tekniker.framework.ktek.questionnaire.KTEKPersistentManager.instance().getSession();
        session.beginTransaction();

        lDAOFactory = es.tekniker.framework.ktek.questionnaire.DAOFactory.getDAOFactory();
        instanceDAO = lDAOFactory.getKtek_questionnairesectionDAO();
        objKtek_questionnairesectionCriteria = new Ktek_questionnairesectionCriteria();
        objKtek_qsection_questionnaireCriteria = objKtek_questionnairesectionCriteria
                .createKtek_qsection_questionnaireCriteria();
        objKtek_qsection_questionnaireCriteria.ktek_fk_idquestionnaire_ktek_pk_idquestionnaire
                .eq(idquestionnaire);

        objKtek_fk_idquestionnaireCriteria = objKtek_qsection_questionnaireCriteria
                .createKtek_fk_idquestionnaireCriteria();
        objKtek_fk_idquestionnaireCriteria.ktek_pk_idquestionnaire.eq(idquestionnaire);
        objKtek_fk_idquestionnaireCriteria.isdeleted.eq((short) 0);
        objKtek_fk_idquestionnaireCriteria.datevalidfrom.lt(nowInMillis);

        objKtek_fk_idquestionnaireCriteria.add(Restrictions.or(Restrictions.isNull("datevalidto"),
                Restrictions.gt("datevalidto", nowInMillis)));

        instanceArray = instanceDAO
                .listKtek_questionnairesectionByCriteria(objKtek_questionnairesectionCriteria);

        session.close();

        if (instanceArray != null) {
            log.debug("getQuestionnaireAssesmentSectionList is not null ");
        } else {
            log.debug("getQuestionnaireAssesmentSectionList is null ");
        }

    } catch (Exception e) {
        log.error("getQuestionnaireAssesmentSectionList Exception " + e.getMessage());
        e.printStackTrace();
        try {
            if (session != null)
                session.close();
        } catch (PersistentException e1) {
            e1.printStackTrace();
        }
    }
    return instanceArray;
}

From source file:es.tekniker.framework.ktek.questionnaire.mng.db.QuestionnaireManagerDB.java

License:Open Source License

public Ktek_questionnaire getQuestionnaire(int idquestionnaire) {
    Ktek_questionnaire instance = null;/*from w ww .j a v  a 2s. c o  m*/
    DAOFactory lDAOFactory = null;
    PersistentSession session = null;
    Ktek_questionnaireDAO instanceDAO = null;
    Ktek_questionnaireCriteria objKtek_questionnaireCriteria = null;
    long nowInMillis = 0;
    try {
        nowInMillis = Utils.getCalendarGMT().getTimeInMillis();
        session = es.tekniker.framework.ktek.questionnaire.KTEKPersistentManager.instance().getSession();

        lDAOFactory = es.tekniker.framework.ktek.questionnaire.DAOFactory.getDAOFactory();
        instanceDAO = lDAOFactory.getKtek_questionnaireDAO();

        objKtek_questionnaireCriteria = new Ktek_questionnaireCriteria();
        objKtek_questionnaireCriteria.ktek_pk_idquestionnaire.eq(idquestionnaire);
        objKtek_questionnaireCriteria.isdeleted.eq((short) 0);
        objKtek_questionnaireCriteria.datevalidfrom.lt(nowInMillis);

        objKtek_questionnaireCriteria.add(Restrictions.or(Restrictions.isNull("datevalidto"),
                Restrictions.gt("datevalidto", nowInMillis)));

        instance = instanceDAO.loadKtek_questionnaireByCriteria(objKtek_questionnaireCriteria);

        if (instance != null)
            log.debug("getQuestionnaire instance is not null");
        else
            log.info("getQuestionnaire instance is null for idquestionnaire " + idquestionnaire);

        session.close();

    } catch (Exception e) {
        log.error("getQuestionnaire Exception " + e.getMessage());
        e.printStackTrace();
        try {
            if (session != null)
                session.close();
        } catch (PersistentException e1) {
            // TODO Auto-generated catch block
            e1.printStackTrace();
        }
    }

    return instance;
}

From source file:es.tekniker.framework.ktek.questionnaire.mng.db.QuestionnaireManagerDB.java

License:Open Source License

public Ktek_questionnaire getQuestionnaire(PersistentSession session, int idquestionnaire) throws Exception {
    Ktek_questionnaire instance = null;/*from w w  w  .j a v  a 2  s . c  o m*/
    DAOFactory lDAOFactory = null;
    Ktek_questionnaireDAO instanceDAO = null;
    Ktek_questionnaireCriteria objKtek_questionnaireCriteria = null;
    long nowInMillis = 0;
    try {
        nowInMillis = Utils.getCalendarGMT().getTimeInMillis();

        lDAOFactory = es.tekniker.framework.ktek.questionnaire.DAOFactory.getDAOFactory();
        instanceDAO = lDAOFactory.getKtek_questionnaireDAO();

        objKtek_questionnaireCriteria = new Ktek_questionnaireCriteria();
        objKtek_questionnaireCriteria.ktek_pk_idquestionnaire.eq(idquestionnaire);
        objKtek_questionnaireCriteria.isdeleted.eq((short) 0);
        objKtek_questionnaireCriteria.datevalidfrom.lt(nowInMillis);

        objKtek_questionnaireCriteria.add(Restrictions.or(Restrictions.isNull("datevalidto"),
                Restrictions.gt("datevalidto", nowInMillis)));

        instance = instanceDAO.loadKtek_questionnaireByCriteria(objKtek_questionnaireCriteria);

        if (instance != null)
            log.debug("getQuestionnaire instance is not null");
        else
            log.info("getQuestionnaire instance is null for idquestionnaire " + idquestionnaire);

    } catch (Exception e) {
        log.error("getQuestionnaire Exception " + e.getMessage());
        e.printStackTrace();
        throw e;
    }

    return instance;
}

From source file:eu.interedition.text.query.RangeOverlapCriterion.java

License:Apache License

@Override
Criterion restrict() {
    return Restrictions.and(Restrictions.lt("target.start", range.getEnd()),
            Restrictions.gt("target.end", range.getStart()));
}

From source file:eu.jangos.manager.utils.Utils.java

License:Apache License

/**
 * Generic method to apply a date filter on an Hibernate query.
 *
 * @param query The query object in its actual state.
 * @param param The name of the parameter in Hibernate configuration.
 * @param filter The filter type for the date.
 * @param from The starting date./*w  w w  .j  a va2 s . c  o  m*/
 * @param to The second date filter.
 * @return The updated query object with the corresponding filter.
 */
public static Criteria applyDateFilter(Criteria query, String param, DateType filter, Date from, Date to) {
    // We first exchange dates if they are invalid.   
    if (from != null && to != null && from.after(to)) {
        Date temp = from;
        from = to;
        to = temp;
    }

    switch (filter) {
    case BEFORE:
        query.add(Restrictions.le(param, from));
        break;
    case AFTER:
        query.add(Restrictions.ge(param, from));
        break;
    case BETWEEN:
        query.add(Restrictions.gt(param, from)).add(Restrictions.lt(param, to));
        break;
    }

    return query;
}

From source file:fi.iot.iiframework.restapi.filters.After.java

License:Apache License

@Override
public Criterion createCriterion(String... filters) throws ArrayIndexOutOfBoundsException {
    long bound = 0;
    try {//from w  w w .  ja  v  a 2  s .c  o  m
        bound = Long.parseLong(filters[0]);
    } catch (NumberFormatException ex) {
        ErrorLogger.log(ErrorType.PARSE_ERROR, ErrorSeverity.LOW,
                "Could not parse long given as a parameter in filter.");
    }

    return Restrictions.gt(getField(), bound);
}

From source file:fi.iot.iiframework.restapi.filters.MoreThan.java

License:Apache License

@Override
public Criterion createCriterion(String... filters) throws ArrayIndexOutOfBoundsException {
    Double bound = 0.0;/*from w  w w  . j a v  a  2  s . co  m*/
    try {
        bound = Double.parseDouble(filters[0]);
    } catch (NumberFormatException ex) {
        ErrorLogger.log(ErrorType.PARSE_ERROR, ErrorSeverity.LOW,
                "Could not parse double given as a parameter in filter.");
    }

    return Restrictions.gt(getField(), bound);
}

From source file:fr.gael.dhus.database.dao.NetworkUsageDao.java

License:Open Source License

public int countDownloadByUserSince(final User user, final Date date) {
    Long result = getHibernateTemplate().execute(new HibernateCallback<Long>() {
        @Override//from   w ww  .  j a  v  a2s. c o m
        public Long doInHibernate(Session session) throws HibernateException, SQLException {
            Criteria criteria = session.createCriteria(NetworkUsage.class);
            criteria.setProjection(Projections.rowCount());
            criteria.add(Restrictions.eq("isDownload", true));
            criteria.add(Restrictions.eq("user", user));
            criteria.add(Restrictions.gt("date", date));
            return (Long) criteria.uniqueResult();
        }
    });
    return (result != null) ? result.intValue() : 0;
}

From source file:fr.gael.dhus.database.dao.NetworkUsageDao.java

License:Open Source License

public long getDownloadedSizeByUserSince(final User user, final Date date) {
    Long result = getHibernateTemplate().execute(new HibernateCallback<Long>() {
        @Override/*from   w  w w.  j a v a 2 s .  c  om*/
        public Long doInHibernate(Session session) throws HibernateException, SQLException {
            Criteria criteria = session.createCriteria(NetworkUsage.class);
            criteria.setProjection(Projections.sum("size"));
            criteria.add(Restrictions.eq("isDownload", true));
            criteria.add(Restrictions.eq("user", user));
            criteria.add(Restrictions.gt("date", date));
            return (Long) criteria.uniqueResult();
        }
    });
    return (result == null) ? 0 : result;
}