public Collection<Outage> getOutages(String criteria, Object... values) { String critSql = (criteria == null ? "" : " and "+criteria); final List<Outage> outages = new LinkedList<>(); Querier loadExisting = new Querier(this, "select * from outages, ifServices, ipInterface, node, service where outages.ifServiceId = ifServices.id and ifServices.ipInterfaceId = ipInterface.id and ipInterface.nodeId = node.nodeId and ifServices.serviceId = service.serviceId"+critSql) { @Override public void processRow(ResultSet rs) throws SQLException { Outage outage = new Outage(rs.getInt("nodeId"), rs.getString("ipAddr"), rs.getInt("serviceId")); outage.setServiceName(rs.getString("serviceName")); outage.setLostEvent(rs.getInt("svcLostEventID"), rs.getTimestamp("ifLostService")); boolean open = (rs.getObject("ifRegainedService") == null); if (!open) { outage.setRegainedEvent(rs.getInt("svcRegainedEventID"), rs.getTimestamp("ifRegainedService")); } outages.add(outage); } }; loadExisting.execute(values); return outages; }
public Collection<Outage> getOutages(String criteria, Object... values) { String critSql = (criteria == null ? "" : " and "+criteria); final List<Outage> outages = new LinkedList<>(); Querier loadExisting = new Querier(this, "select * from outages, ifServices, ipInterface, node, service where outages.ifServiceId = ifServices.id and ifServices.ipInterfaceId = ipInterface.id and ipInterface.nodeId = node.nodeId and ifServices.serviceId = service.serviceId"+critSql) { @Override public void processRow(ResultSet rs) throws SQLException { Outage outage = new Outage(rs.getInt("nodeId"), rs.getString("ipAddr"), rs.getInt("serviceId")); outage.setServiceName(rs.getString("serviceName")); outage.setLostEvent(rs.getInt("svcLostEventID"), rs.getTimestamp("ifLostService")); boolean open = (rs.getObject("ifRegainedService") == null); if (!open) { outage.setRegainedEvent(rs.getInt("svcRegainedEventID"), rs.getTimestamp("ifRegainedService")); } outages.add(outage); } }; loadExisting.execute(values); return outages; }
/** * <p>forEachUserNotification</p> * * @param notifId a int. * @param rp a {@link org.opennms.netmgt.utils.RowProcessor} object. */ public void forEachUserNotification(final int notifId, final RowProcessor rp) { final Querier querier = new Querier(m_dataSource, "select * from usersNotified where notifyId = ? order by notifytime", rp); querier.execute(notifId); }
/** * @param event * @return */ public Collection<Integer> findNoticesForEvent(Event event) { final List<Integer> notifyIds = new LinkedList<>(); Querier loadExisting = new Querier(this, "select notifyId from notifications where eventID = ?") { @Override public void processRow(ResultSet rs) throws SQLException { notifyIds.add(rs.getInt(1)); } }; loadExisting.execute(Integer.valueOf(event.getDbid())); return notifyIds; }
/** * @param event * @return */ public Collection<Integer> findNoticesForEvent(Event event) { final List<Integer> notifyIds = new LinkedList<>(); Querier loadExisting = new Querier(this, "select notifyId from notifications where eventID = ?") { @Override public void processRow(ResultSet rs) throws SQLException { notifyIds.add(rs.getInt(1)); } }; loadExisting.execute(Integer.valueOf(event.getDbid())); return notifyIds; }
/** * <p>getActiveNodes</p> * * @return a {@link java.util.List} object. * @throws java.sql.SQLException if any. */ public List<Integer> getActiveNodes() throws SQLException { final List<Integer> allNodes = new ArrayList<>(); Querier querier = new Querier(m_dataSource, "SELECT n.nodeid FROM node n WHERE n.nodetype != 'D' ORDER BY n.nodelabel", new RowProcessor() { @Override public void processRow(ResultSet rs) throws SQLException { allNodes.add(rs.getInt(1)); } }); querier.execute(new Object[] {}); return allNodes; }
/** * <p>getServiceNames</p> * * @return a {@link java.util.List} object. */ public List<String> getServiceNames() throws SQLException { final List<String> services = new ArrayList<>(); Querier querier = new Querier(m_dataSource, "SELECT servicename FROM service", new RowProcessor() { @Override public void processRow(ResultSet rs) throws SQLException { services.add(rs.getString(1)); } }); querier.execute(new Object[] {}); return services; }
querier.execute(notifId); return parmMap;
querier.execute();
querier.execute(eventid); return event;
querier.execute();