public OpResult addAlertEvent(AlertPublishEvent event) { Connection connection = null; PreparedStatement statement = null; OpResult result = new OpResult(); try { connection = dataSource.getConnection(); statement = connection.prepareStatement(INSERT_ALERT_STATEMENT); statement.setString(1, event.getAlertId()); statement.setString(2, event.getSiteId()); statement.setString(3, mapper.writeValueAsString(event.getAppIds())); statement.setString(4, event.getPolicyId()); statement.setLong(5, event.getAlertTimestamp()); statement.setString(6, event.getPolicyValue()); statement.setString(7, mapper.writeValueAsString(event.getAlertData())); LOG.info("start to add alert event"); int status = statement.executeUpdate(); result.code = OpResult.SUCCESS; result.message = String.format("add %d records into alert_event successfully", status); } catch (Exception ex) { result.code = OpResult.FAILURE; result.message = ex.getMessage(); } finally { closeResource(null, statement, connection); } LOG.info(result.message); return result; }
Assert.assertEquals("{flag=1, data=0.1, name=namevalue, host=hostvalue, salary=-0.2, value=10, int=1, object={\"name\":\"heap.COMMITTED\", \"Value\":\"175636480\"}}", alertPublishEvent.getAlertData().toString()); Assert.assertEquals(1234, alertPublishEvent.getAlertTimestamp()); Assert.assertEquals(null, alertPublishEvent.getAppIds()); Assert.assertEquals("{flag=1, data=0.1, name=namevalue, host=hostvalue, salary=-0.2, value=10, int=1, object={\"name\":\"heap.COMMITTED\", \"Value\":\"175636480\"}}", alertPublishEvent.getAlertData().toString()); Assert.assertEquals(1234, alertPublishEvent.getAlertTimestamp()); Assert.assertEquals("appId1", alertPublishEvent.getAppIds().get(0)); Assert.assertEquals("appId2", alertPublishEvent.getAppIds().get(1));