public static CriteriaBuilder buildFrom(Class<?> clazz, QueryParameters queryParameters) { Objects.requireNonNull(clazz); Objects.requireNonNull(queryParameters); CriteriaBuilder criteriaBuilder = new CriteriaBuilder(clazz); applyQueryParameters(criteriaBuilder, queryParameters); return criteriaBuilder; }
public static CriteriaBuilder buildFrom(Class<?> clazz, QueryParameters queryParameters) { Objects.requireNonNull(clazz); Objects.requireNonNull(queryParameters); CriteriaBuilder criteriaBuilder = new CriteriaBuilder(clazz); applyQueryParameters(criteriaBuilder, queryParameters); return criteriaBuilder; }
private List<OnmsNode> getNodes(List<Integer> ids) { if (ids == null || ids.isEmpty()) { return new ArrayList<>(); } final List<OnmsNode> nodes = nodeDao.findMatching(new CriteriaBuilder(OnmsNode.class).in("id", ids).toCriteria()); return nodes; }
private List<OnmsNode> getNodes(List<Integer> ids) { if (ids == null || ids.isEmpty()) { return new ArrayList<>(); } final List<OnmsNode> nodes = nodeDao.findMatching(new CriteriaBuilder(OnmsNode.class).in("id", ids).toCriteria()); return nodes; }
@Override public Long getNodeCount() { final CriteriaBuilder criteriaBuilder = new CriteriaBuilder(OnmsNode.class); return sessionUtils.withReadOnlyTransaction(() -> (long)nodeDao.countMatching(criteriaBuilder.toCriteria())); }
@Override @Transactional public List<OnmsAcknowledgment> getAcknowledgments(int alarmId) { CriteriaBuilder cb = new CriteriaBuilder(OnmsAcknowledgment.class); cb.eq("refId", alarmId); cb.eq("ackType", AckType.ALARM); return m_ackDao.findMatching(cb.toCriteria()); }
@Override public Long getSnmpInterfaceCount() { final CriteriaBuilder criteriaBuilder = new CriteriaBuilder(OnmsSnmpInterface.class); return sessionUtils.withReadOnlyTransaction(() -> (long)snmpInterfaceDao.countMatching(criteriaBuilder.toCriteria())); }
@Override @Transactional public Optional<OnmsAcknowledgment> findLatestAckForRefId(Integer refId) { CriteriaBuilder builder = new CriteriaBuilder(OnmsAcknowledgment.class) .eq("refId", refId) .limit(1) .orderBy("ackTime").desc() .orderBy("id").desc(); List<OnmsAcknowledgment> acks = findMatching(builder.toCriteria()); return acks.size() == 1 ? Optional.of(acks.get(0)) : Optional.empty(); } }
@Override public Long getAlarmCount() { final CriteriaBuilder criteriaBuilder = new CriteriaBuilder(OnmsAlarm.class); return sessionUtils.withReadOnlyTransaction(() -> (long)alarmDao.countMatching(criteriaBuilder.toCriteria())); }
public OnmsAlarm getAlarm(int nodeId) { CriteriaBuilder builder = new CriteriaBuilder(OnmsAlarm.class); builder.alias("node", "node"); builder.ne("severity", OnmsSeverity.CLEARED); builder.orderBy("severity").desc(); builder.eq("node.id", nodeId); builder.limit(Integer.valueOf(1)); List<OnmsAlarm> alarms = alarmDao.findMatching(builder.toCriteria()); return alarms == null || alarms.isEmpty() ? null : alarms.get(0); } }
@Override public List<OnmsNode> findAllByVarCharAssetColumn(final String columnName, final String columnValue) { final CriteriaBuilder builder = new CriteriaBuilder(OnmsNode.class); builder.alias("assetRecord", "assets"); builder.eq("assets." + columnName, columnValue); return findMatching(builder.toCriteria()); }
public OnmsAlarm getAlarm(int nodeId) { CriteriaBuilder builder = new CriteriaBuilder(OnmsAlarm.class); builder.alias("node", "node"); builder.ne("severity", OnmsSeverity.CLEARED); builder.orderBy("severity").desc(); builder.eq("node.id", nodeId); builder.limit(Integer.valueOf(1)); List<OnmsAlarm> alarms = alarmDao.findMatching(builder.toCriteria()); return alarms == null || alarms.isEmpty() ? null : alarms.get(0); } }
@Override public List<Rule> findAllEnabledRules() { return findMatching( new CriteriaBuilder(Rule.class) .alias("group", "group") .eq("group.enabled", true) .toCriteria()); }
@Override public List<OnmsNode> findAllByVarCharAssetColumn(final String columnName, final String columnValue) { final CriteriaBuilder builder = new CriteriaBuilder(OnmsNode.class); builder.alias("assetRecord", "assets"); builder.eq("assets." + columnName, columnValue); return findMatching(builder.toCriteria()); }
@Override public Set<VertexRef> getVertices() { CriteriaBuilder bldr = new CriteriaBuilder(OnmsIpInterface.class); bldr.iplike("ipAddr", m_ipQuery); List<OnmsIpInterface> ips = ipInterfaceProvider.findMatching(bldr.toCriteria()); Set<VertexRef> vertices = new TreeSet<VertexRef>(new RefComparator()); for (OnmsIpInterface ip : ips) { OnmsNode node = ip.getNode(); vertices.add(new DefaultVertexRef("nodes", String.valueOf(node.getId()), node.getLabel())); } return vertices; }
@Override public List<OnmsIpInterface> getPollableNodes() { CriteriaBuilder builder = new CriteriaBuilder(OnmsIpInterface.class); builder.eq("isSnmpPrimary", PrimaryType.PRIMARY).eq("isManaged", "M"); return getIpInterfaceDao().findMatching(builder.toCriteria()); }
@Override public void deleteRules(int groupId) { CriteriaBuilder criteriaBuilder = new CriteriaBuilder(Rule.class).alias("group", "group"); criteriaBuilder.eq("group.id", groupId); runInTransaction(status -> { final Criteria criteria = criteriaBuilder.toCriteria(); classificationRuleDao.findMatching(criteria).forEach(r -> classificationRuleDao.delete(r)); classificationEngine.reload(); return null; }); }
@Override public List<OnmsIpInterface> getPollableNodesByIp(String ipaddr) { CriteriaBuilder builder = new CriteriaBuilder(OnmsIpInterface.class); builder.eq("ipAddress", InetAddressUtils.addr(ipaddr)).eq("isSnmpPrimary", PrimaryType.PRIMARY).eq("isManaged", "M"); return getIpInterfaceDao().findMatching(builder.toCriteria()); }
/** {@inheritDoc} */ @Override public List<OnmsSnmpInterface> get(int nodeId, String criteria) { CriteriaBuilder builder = new CriteriaBuilder(OnmsSnmpInterface.class); builder.sql(criteria).eq("node.id", nodeId).eq("poll", "P"); builder.alias("ipInterfaces", "ipInterface", JoinType.LEFT_JOIN); return getSnmpInterfaceDao().findMatching(builder.toCriteria()); }
private List<OnmsAlarm> findAlarms() { CriteriaBuilder bldr = new CriteriaBuilder(OnmsAlarm.class); String query = getSearchResult().getQuery(); if (isSeverityQuery()) { bldr.eq("severity", OnmsSeverity.get(query)); } else { bldr.eq("id", getSearchResult().getAlarmId()); } return alarmProvider.findMatchingAlarms(bldr.toCriteria()); }