@Override protected void addAdditionalCriteriaOptions(Criteria criteria, Page page, boolean doOrder) { // we join table node, to be able eto sort by node.label criteria.setAliases(Arrays.asList(new Alias[] { new Alias("node", "node", JoinType.LEFT_JOIN) })); }
@Override protected void addAdditionalCriteriaOptions(Criteria criteria, Page page, boolean doOrder) { // we join table node, to be able eto sort by node.label criteria.setAliases(Arrays.asList(new Alias[] { new Alias("node", "node", JoinType.LEFT_JOIN) })); }
@Override protected void addAdditionalCriteriaOptions(Criteria criteria, Page page, boolean doOrder) { if (!doOrder) return; // We join the ipInterfaces table, to be able to sort on ipInterfaces.ipAddress. criteria.setAliases(Arrays.asList(new Alias[] { new Alias("ipInterfaces", "ipInterfaces", Alias.JoinType.LEFT_JOIN, new EqRestriction("ipInterfaces.isSnmpPrimary", PrimaryType.PRIMARY)) })); }
@Override protected void addAdditionalCriteriaOptions(Criteria criteria, Page page, boolean doOrder) { if (!doOrder) return; // We join the ipInterfaces table, to be able to sort on ipInterfaces.ipAddress. criteria.setAliases(Arrays.asList(new Alias[] { new Alias("ipInterfaces", "ipInterfaces", Alias.JoinType.LEFT_JOIN, new EqRestriction("ipInterfaces.isSnmpPrimary", PrimaryType.PRIMARY)) })); }
protected InetAddress getNodeIpAddress(OnmsNode node) { final Criteria criteria = new Criteria(OnmsIpInterface.class) .setAliases(Arrays.asList(new Alias[] { new Alias("node", "node", JoinType.LEFT_JOIN) })) .addRestriction(new EqRestriction("node.id", node.getId())); List<OnmsIpInterface> matchingIfaces = getIpInterfaceDao().findMatching(criteria); return matchingIfaces.get(0).getIpAddress(); }
parm, nodeId, likeQuery); Criteria criteria = new Criteria(OnmsHwEntity.class) .setAliases(Arrays.asList(new Alias[] { new Alias("node","node", JoinType.LEFT_JOIN), }))
parm, nodeId, likeQuery); Criteria criteria = new Criteria(OnmsHwEntity.class) .setAliases(Arrays.asList(new Alias[] { new Alias("node","node", JoinType.LEFT_JOIN), }))
@Override public List<String[]> getNodeServices(int nodeId){ final LinkedList<String[]> servicemap = new LinkedList<>(); Criteria criteria = new Criteria(OnmsMonitoredService.class); criteria.setAliases(Arrays.asList(new Alias[] { new Alias("ipInterface", "ipInterface", JoinType.LEFT_JOIN), new Alias("ipInterface.node", "node", JoinType.LEFT_JOIN) })); criteria.addRestriction(new EqRestriction("node.id", nodeId)); criteria.addRestriction(new NeRestriction("status", "F")); // Ignore forced-unmanaged for (OnmsMonitoredService service : m_monitoredServiceDao.findMatching(criteria)) { servicemap.add(new String[] { service.getIpAddressAsString(), service.getServiceName() }); } return servicemap; }
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; }
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; }
@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 List<Node> findAllSnmpNode() { final List<Node> nodes = new ArrayList<Node>(); final Criteria criteria = new Criteria(OnmsNode.class); criteria.setAliases(Arrays.asList(new Alias[] { new Alias( "ipInterfaces", "iface", JoinType.LEFT_JOIN) })); criteria.addRestriction(new EqRestriction("type", NodeType.ACTIVE)); criteria.addRestriction(new EqRestriction("iface.isSnmpPrimary", PrimaryType.PRIMARY)); for (final OnmsNode node : m_nodeDao.findMatching(criteria)) { nodes.add(new Node(node.getId(), node.getLabel(), node.getPrimaryInterface().getIpAddress(), node.getSysObjectId(), node.getSysName(),node.getLocation() == null ? null : node.getLocation().getLocationName())); } return nodes; }
@Override public Node getSnmpNode(final int nodeid) { final Criteria criteria = new Criteria(OnmsNode.class); criteria.setAliases(Arrays.asList(new Alias[] { new Alias( "ipInterfaces", "iface", JoinType.LEFT_JOIN) })); criteria.addRestriction(new EqRestriction("type", NodeType.ACTIVE)); criteria.addRestriction(new EqRestriction("iface.isSnmpPrimary", PrimaryType.PRIMARY)); criteria.addRestriction(new EqRestriction("id", nodeid)); final List<OnmsNode> nodes = m_nodeDao.findMatching(criteria); if (nodes.size() > 0) { final OnmsNode node = nodes.get(0); return new Node(node.getId(), node.getLabel(), node.getPrimaryInterface().getIpAddress(), node.getSysObjectId(), node.getSysName(),node.getLocation() == null ? null : node.getLocation().getLocationName()); } else { return null; } }
.setAliases(Arrays.asList(new Alias[] { new Alias("ipInterface","ipInterface", JoinType.INNER_JOIN) }))
/** * <p>closeOutagesForNode</p> * * @param closeDate a {@link java.util.Date} object. * @param eventId a int. * @param nodeId a int. */ @Override public void closeOutagesForNode(Date closeDate, int eventId, int nodeId) { Criteria criteria = new Criteria(OnmsOutage.class); criteria.setAliases(Arrays.asList(new Alias[] { new Alias("monitoredService.ipInterface", "ipInterface", JoinType.LEFT_JOIN), new Alias("ipInterface.node", "node", JoinType.LEFT_JOIN) })); criteria.addRestriction(new EqRestriction("node.id", nodeId)); criteria.addRestriction(new NullRestriction("ifRegainedService")); List<OnmsOutage> outages = m_outageDao.findMatching(criteria); for (OnmsOutage outage : outages) { outage.setIfRegainedService(closeDate); outage.setServiceRegainedEvent(m_eventDao.get(eventId)); m_outageDao.update(outage); } }
Date closeDate = new java.util.Date(); Criteria criteria = new Criteria(OnmsOutage.class); criteria.setAliases(Arrays.asList(new Alias[] { new Alias("monitoredService", "monitoredService", JoinType.LEFT_JOIN) })); criteria.setAliases(Arrays.asList(new Alias[] { new Alias("monitoredService.ipInterface", "ipInterface", JoinType.LEFT_JOIN) }));
public void closeOutagesForService(Date closeDate, int eventId, int nodeId, String ipAddr, String serviceName) { Criteria criteria = new Criteria(OnmsOutage.class); criteria.setAliases(Arrays.asList(new Alias[] { new Alias("monitoredService.ipInterface", "ipInterface", JoinType.LEFT_JOIN), new Alias("monitoredService.serviceType", "serviceType", JoinType.LEFT_JOIN),
/** * <p>closeOutagesForInterface</p> * * @param closeDate a {@link java.util.Date} object. * @param eventId a int. * @param nodeId a int. * @param ipAddr a {@link java.lang.String} object. */ @Override public void closeOutagesForInterface(Date closeDate, int eventId, int nodeId, String ipAddr) { Criteria criteria = new Criteria(OnmsOutage.class); criteria.setAliases(Arrays.asList(new Alias[] { new Alias("monitoredService.ipInterface", "ipInterface", JoinType.LEFT_JOIN), new Alias("ipInterface.node", "node", JoinType.LEFT_JOIN) })); criteria.addRestriction(new EqRestriction("node.id", nodeId)); criteria.addRestriction(new EqRestriction("ipInterface.ipAddress", addr(ipAddr))); criteria.addRestriction(new NullRestriction("ifRegainedService")); List<OnmsOutage> outages = m_outageDao.findMatching(criteria); for (OnmsOutage outage : outages) { outage.setIfRegainedService(closeDate); outage.setServiceRegainedEvent(m_eventDao.get(eventId)); m_outageDao.update(outage); } }
@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; } }