/** * <p>getAll</p> * * @return a {@link java.util.List} object. */ @Override public List<ReportCatalogEntry> getAll() { final Criteria onmsCrit = new Criteria(ReportCatalogEntry.class); onmsCrit.setOrders(Arrays.asList(new Order[] { Order.desc("date") })); return m_reportCatalogDao.findMatching(onmsCrit); }
/** * <p>getAll</p> * * @return a {@link java.util.List} object. */ @Override public List<ReportCatalogEntry> getAll() { final Criteria onmsCrit = new Criteria(ReportCatalogEntry.class); onmsCrit.setOrders(Arrays.asList(new Order[] { Order.desc("date") })); return m_reportCatalogDao.findMatching(onmsCrit); }
private static <T, X> Response createResponse(CriteriaBuilder criteriaBuilder, MatchingDelegate<T> matchingDelegate, CountDelegate countDelegate, Function<List<T>, List<X>> transform) { Objects.requireNonNull(criteriaBuilder); Objects.requireNonNull(matchingDelegate); Objects.requireNonNull(countDelegate); Objects.requireNonNull(transform); final Criteria criteria = criteriaBuilder.toCriteria(); final List<T> entities = matchingDelegate.findMatching(criteria); if (entities.isEmpty()) { return Response.noContent().build(); } // Reset any offset/limits and orders in order to count properly criteria.setOrders(new ArrayList<>()); criteria.setOffset(null); criteria.setLimit(null); // build response final List responseBody = transform.apply(entities); final int offset = (criteria.getOffset() == null ? 0 : criteria.getOffset()); final long totalCount = countDelegate.countMatching(criteria); return ResponseUtils.createResponse(responseBody, offset, totalCount); }
private static <T, X> Response createResponse(CriteriaBuilder criteriaBuilder, MatchingDelegate<T> matchingDelegate, CountDelegate countDelegate, Function<List<T>, List<X>> transform) { Objects.requireNonNull(criteriaBuilder); Objects.requireNonNull(matchingDelegate); Objects.requireNonNull(countDelegate); Objects.requireNonNull(transform); final Criteria criteria = criteriaBuilder.toCriteria(); final List<T> entities = matchingDelegate.findMatching(criteria); if (entities.isEmpty()) { return Response.noContent().build(); } // Reset any offset/limits and orders in order to count properly criteria.setOrders(new ArrayList<>()); criteria.setOffset(null); criteria.setLimit(null); // build response final List responseBody = transform.apply(entities); final int offset = (criteria.getOffset() == null ? 0 : criteria.getOffset()); final long totalCount = countDelegate.countMatching(criteria); return ResponseUtils.createResponse(responseBody, offset, totalCount); }
.addRestriction(new EqRestriction("node.id", (int)nodeId)) .addRestriction(new LikeRestriction("entPhysicalName", likeQuery)) .setOrders(Arrays.asList(new Order[] { Order.desc("id") }));
.addRestriction(new EqRestriction("node.id", (int)nodeId)) .addRestriction(new LikeRestriction("entPhysicalName", likeQuery)) .setOrders(Arrays.asList(new Order[] { Order.desc("id") }));
public Criteria toCriteria() { final Criteria criteria = new Criteria(m_class, m_rootAlias); criteria.setOrders(m_orderBuilder.getOrderCollection()); criteria.setAliases(m_aliasBuilder.getAliasCollection()); criteria.setFetchTypes(m_fetch); criteria.setDistinct(m_distinct); criteria.setLimit(m_limit); criteria.setOffset(m_offset); if ("any".equals(m_matchType)) { criteria.setRestrictions(Collections.singleton(Restrictions.any(m_restrictions.toArray(EMPTY_RESTRICTION_ARRAY)))); } else { criteria.setRestrictions(m_restrictions); } return criteria; }
/** * Creates a {@link Criteria} object to get data from database. * If considerPaging is set Limit and offset values are added as restriction. * @param page * @param doOrder * @return */ protected Criteria getCriteria(Page page, boolean doOrder) { Criteria tmpCriteria = new Criteria(getItemClass()); for (Restriction eachRestriction : m_restrictions) { tmpCriteria.addRestriction(eachRestriction); } if (doOrder) { tmpCriteria.setOrders(m_orders); } if (page != null) { tmpCriteria.setOffset(page.offset); tmpCriteria.setLimit(page.length); } addAdditionalCriteriaOptions(tmpCriteria, page, doOrder); LOG.debug("query criteria: {}", tmpCriteria); return tmpCriteria; }
public Criteria toCriteria() { final Criteria criteria = new Criteria(m_class, m_rootAlias); criteria.setOrders(m_orderBuilder.getOrderCollection()); criteria.setAliases(m_aliasBuilder.getAliasCollection()); criteria.setFetchTypes(m_fetch); criteria.setDistinct(m_distinct); criteria.setLimit(m_limit); criteria.setOffset(m_offset); if ("any".equals(m_matchType)) { criteria.setRestrictions(Collections.singleton(Restrictions.any(m_restrictions.toArray(EMPTY_RESTRICTION_ARRAY)))); } else { criteria.setRestrictions(m_restrictions); } return criteria; }
/** * Creates a {@link Criteria} object to get data from database. * If considerPaging is set Limit and offset values are added as restriction. * @param page * @param doOrder * @return */ protected Criteria getCriteria(Page page, boolean doOrder) { Criteria tmpCriteria = new Criteria(getItemClass()); for (Restriction eachRestriction : m_restrictions) { tmpCriteria.addRestriction(eachRestriction); } if (doOrder) { tmpCriteria.setOrders(m_orders); } if (page != null) { tmpCriteria.setOffset(page.offset); tmpCriteria.setLimit(page.length); } addAdditionalCriteriaOptions(tmpCriteria, page, doOrder); LOG.debug("query criteria: {}", tmpCriteria); return tmpCriteria; }
/** * Creates a {@link Criteria} object to get data from database. * If considerPaging is set Limit and offset values are added as restriction. * @param page * @param doOrder * @return */ protected Criteria getCriteria(Page page, boolean doOrder) { Criteria tmpCriteria = new Criteria(getItemClass()); for (Restriction eachRestriction : m_restrictions) { tmpCriteria.addRestriction(eachRestriction); } if (doOrder) { tmpCriteria.setOrders(m_orders); } if (page != null) { tmpCriteria.setOffset(page.offset); tmpCriteria.setLimit(page.length); } addAdditionalCriteriaOptions(tmpCriteria, page, doOrder); LOG.debug("query criteria: {}", tmpCriteria); return tmpCriteria; }
@Override public List<OnmsNode> findByIpAddressAndService(InetAddress ipAddress, String serviceName) { final org.opennms.core.criteria.Criteria criteria = new org.opennms.core.criteria.Criteria(OnmsNode.class) .setAliases(Arrays.asList(new Alias[] { new Alias("ipInterfaces","ipInterfaces", JoinType.LEFT_JOIN), new Alias("ipInterfaces.monitoredServices","monitoredServices", JoinType.LEFT_JOIN), new Alias("monitoredServices.serviceType","serviceType", JoinType.LEFT_JOIN) })) .addRestriction(new EqRestriction("ipInterfaces.ipAddress", ipAddress)) //TODO: Replace D with a constant .addRestriction(new NeRestriction("ipInterfaces.isManaged", "D")) .addRestriction(new EqRestriction("serviceType.name", serviceName)) .setOrders(Arrays.asList(new Order[] { Order.desc("id") })); return findMatching(criteria); }
@Override public final Criteria clone() { Criteria retval = new Criteria(getCriteriaClass()); retval.setAliases(getAliases()); retval.setDistinct(isDistinct()); retval.setFetchTypes(getFetchTypes()); retval.setLimit(getLimit()); retval.setOffset(getOffset()); retval.setOrders(getOrders()); retval.setRestrictions(getRestrictions()); return retval; } }
@Override public final Criteria clone() { Criteria retval = new Criteria(getCriteriaClass()); retval.setAliases(getAliases()); retval.setDistinct(isDistinct()); retval.setFetchTypes(getFetchTypes()); retval.setLimit(getLimit()); retval.setOffset(getOffset()); retval.setOrders(getOrders()); retval.setRestrictions(getRestrictions()); return retval; } }