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.scopix.periscope.extractionplanmanagement.dao.ExtractionPlanCustomizingDAOImpl.java

License:Open Source License

@Override
public List<Metric> getFreeMetricList(Metric metric) {
    List<Metric> metrics = null;
    Session session = this.getSession();
    try {/*from   w w w  . j av  a2  s .  com*/
        Criteria criteria = session.createCriteria(Metric.class);
        criteria.addOrder(Order.asc("id"));
        if (metric != null) {
            if (metric.getArea() != null && metric.getArea().getId() != null && metric.getArea().getId() > 0) {
                criteria.add(Restrictions.eq("area.id", metric.getArea().getId()));
            }
            if (metric.getMetricOrder() != null && metric.getMetricOrder() >= 0) {
                criteria.add(Restrictions.eq("metricOrder", metric.getMetricOrder()));
            }
            if (metric.getMetricTemplate() != null && metric.getMetricTemplate().getId() != null
                    && metric.getMetricTemplate().getId() > 0) {
                criteria.add(Restrictions.eq("metricTemplate.id", metric.getMetricTemplate().getId()));
            }
            if (metric.getSituation() != null && metric.getSituation().getId() != null
                    && metric.getSituation().getId() > 0) {
                criteria.add(Restrictions.eq("metricTemplate.id", metric.getMetricTemplate().getId()));
            }
            if (metric.getSituation() != null && metric.getSituation().getSituationTemplate() != null
                    && metric.getSituation().getSituationTemplate().getId() != null
                    && metric.getSituation().getSituationTemplate().getId() > 0) {
                SituationTemplate st = HibernateSupport.getInstance().findGenericDAO()
                        .get(metric.getSituation().getSituationTemplate().getId(), SituationTemplate.class);
                List<Integer> ids = new ArrayList<Integer>();
                for (MetricTemplate mt : st.getMetricTemplate()) {
                    ids.add(mt.getId());
                }
                criteria.add(Restrictions.in("metricTemplate.id", ids));
            }
        }
        criteria.add(Restrictions.isNull("situation"));
        metrics = criteria.list();
    } catch (HibernateException e) {
        log.error(e, e);
    } finally {
        this.releaseSession(session);
    }
    return metrics;
}

From source file:com.scopix.periscope.extractionplanmanagement.EServerDAO.java

License:Open Source License

/**
 * @deprecated se debe utilizar getExtractionPlanEnable(String storeName)
 */// w  w w  .jav  a 2s.  c om
public ExtractionPlan getExtractionPlanEnable() {
    ExtractionPlan extractionPlan = null;
    Criteria criteria = this.getSession().createCriteria(ExtractionPlan.class);
    criteria.addOrder(Order.desc("id"));
    criteria.add(Restrictions.isNull("expirationDate"));
    List<ExtractionPlan> extractionPlans = criteria.list();
    if (extractionPlans != null && !extractionPlans.isEmpty()) {
        extractionPlan = extractionPlans.get(0);
    }
    return extractionPlan;
}

From source file:com.scopix.periscope.extractionplanmanagement.EServerDAO.java

License:Open Source License

public ExtractionPlan getExtractionPlanEnable(String storeName) {
    ExtractionPlan extractionPlan = null;
    Criteria criteria = this.getSession().createCriteria(ExtractionPlan.class);
    criteria.addOrder(Order.desc("id"));
    criteria.add(Restrictions.isNull("expirationDate"));
    criteria.add(Restrictions.eq("storeName", storeName));
    List<ExtractionPlan> extractionPlans = criteria.list();
    if (extractionPlans != null && !extractionPlans.isEmpty()) {
        extractionPlan = extractionPlans.get(0);
    }//from   ww  w . jav a2s .c  o  m
    return extractionPlan;
}

From source file:com.scopix.periscope.extractionplanmanagement.EServerDAO.java

License:Open Source License

public List<ExtractionPlan> getExtractionPlanListForADate(Date date, String storeName) {
    Criteria criteria = this.getSession().createCriteria(ExtractionPlan.class);
    criteria.addOrder(Order.asc("expirationDate"));
    criteria.add(/*from w  w  w. j ava 2s . co m*/
            Restrictions.or(Restrictions.isNull("expirationDate"), Restrictions.gt("expirationDate", date)));
    criteria.add(Restrictions.eq("storeName", storeName));
    List<ExtractionPlan> eps = criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY).list();
    return eps;
}

From source file:com.scopix.periscope.extractionservicesserversmanagement.dao.EvidenceExtractionServicesServerDAO.java

License:Open Source License

/**
 * Metodo que retorna el evidence extraction a partir del id existente en business services.
 *
 * @param eessId/*from w  w w .  ja v a 2s.  co m*/
 * @return
 */
public EvidenceExtractionServicesServer getEvidenceExtractionServicesServerByEvidenceExtractionServicesIdInBusinessServices(
        Integer eessId, String storeName) {
    EvidenceExtractionServicesServer evidenceExtractionServicesServer = null;

    Criteria criteria = this.getSession().createCriteria(EvidenceExtractionServicesServer.class);
    criteria.add(Restrictions.eq("idAtBusinessServices", eessId));
    Criteria criteriaExtractionPlans = criteria.createCriteria("extractionPlans");
    criteriaExtractionPlans.add(Restrictions.isNull("expiration"));
    criteriaExtractionPlans.add(Restrictions.eq("storeName", storeName));

    List<EvidenceExtractionServicesServer> evidenceExtractionServicesServers = criteria.list();
    if (evidenceExtractionServicesServers != null && !evidenceExtractionServicesServers.isEmpty()) {
        evidenceExtractionServicesServer = evidenceExtractionServicesServers.get(0);
    }
    return evidenceExtractionServicesServer;
}

From source file:com.scopix.periscope.extractionservicesserversmanagement.dao.EvidenceExtractionServicesServerDAO.java

License:Open Source License

public EvidenceExtractionServicesServer getEvidenceExtractionServicesServerByServerId(Integer serverId) {
    EvidenceExtractionServicesServer evidenceExtractionServicesServer = null;
    Criteria criteria = this.getSession().createCriteria(EvidenceExtractionServicesServer.class);
    criteria.add(Restrictions.eq("serverId", serverId));
    criteria.createCriteria("extractionPlans").add(Restrictions.isNull("expiration"));
    List<EvidenceExtractionServicesServer> evidenceExtractionServicesServers = criteria.list();
    if (evidenceExtractionServicesServers != null && !evidenceExtractionServicesServers.isEmpty()) {
        evidenceExtractionServicesServer = evidenceExtractionServicesServers.get(0);
    }/*from  w w w  . ja  v  a2  s  . c  o m*/
    return evidenceExtractionServicesServer;

}

From source file:com.scopix.periscope.extractionservicesserversmanagement.dao.EvidenceExtractionServicesServerDAO.java

License:Open Source License

public List<EvidenceExtractionServicesServer> getAllEvidenceExtractionServicesServerEnabled() {
    Criteria criteria = this.getSession().createCriteria(EvidenceExtractionServicesServer.class);
    criteria.createCriteria("extractionPlans").add(Restrictions.isNull("expiration"));
    List<EvidenceExtractionServicesServer> evidenceExtractionServicesServers = criteria.list();
    return evidenceExtractionServicesServers;

}

From source file:com.scopix.periscope.extractionservicesserversmanagement.dao.EvidenceExtractionServicesServerDAO.java

License:Open Source License

public List<EvidenceRequest> getEvidenceRequestEnabled() {
    Criteria criteria = this.getSession().createCriteria(EvidenceRequest.class);
    criteria.addOrder(Order.asc("id"));
    criteria.createCriteria("extractionPlanDetail").createCriteria("extractionPlan")
            .add(Restrictions.isNull("expiration"));
    List<EvidenceRequest> list = criteria.list();
    return list;//w ww  . java2 s  . c o m
}

From source file:com.scopix.periscope.extractionservicesserversmanagement.dao.ExtractionPlanDetailDAO.java

License:Open Source License

public ExtractionPlan getExtractionPlanEnable(Integer evidenceExtractionServicesServerId) {
    log.info("start");
    ExtractionPlan extractionPlan = null;
    Criteria criteria = this.getSession().createCriteria(ExtractionPlan.class);
    criteria.addOrder(Order.desc("id"));
    criteria.add(Restrictions.isNull("expiration"));
    criteria.createCriteria("evidenceExtractionServicesServer")
            .add(Restrictions.eq("serverId", evidenceExtractionServicesServerId));
    List<ExtractionPlan> extractionPlans = criteria.list();
    if (extractionPlans != null && !extractionPlans.isEmpty()) {
        extractionPlan = extractionPlans.get(0);
    }//www .j  a va 2  s . c o  m
    log.info("end");
    return extractionPlan;
}

From source file:com.scopix.periscope.extractionservicesserversmanagement.dao.ExtractionPlanDetailDAO.java

License:Open Source License

public List<ExtractionPlan> getExtractionPlanByExpirationDate(Date dateStart) {

    Criteria criteria = this.getSession().createCriteria(ExtractionPlan.class);
    criteria.add(Restrictions.or(Restrictions.gt("expiration", dateStart), Restrictions.isNull("expiration")));
    criteria.addOrder(Order.asc("expiration"));
    List<ExtractionPlan> extractionPlans = criteria.list();
    return extractionPlans;
}