@Test public void testCheckNoHeadersAreInserted() throws Exception { setInsertHeadersAndStart(false); IAccessEvent event = createAccessEvent(); appender.append(event); StatusPrinter.print(context.getStatusManager()); // Check that no headers were inserted Statement stmt = connectionSource.getConnection().createStatement(); ResultSet rs = null; rs = stmt.executeQuery("SELECT * FROM access_event_header where EVENT_ID = " + existingEventTableRowCount); assertFalse(rs.next()); rs.close(); stmt.close(); }
@Test public void testAppendMultipleEvents() throws SQLException { setInsertHeadersAndStart(false); String uri = "testAppendMultipleEvents"; for (int i = 0; i < 10; i++) { IAccessEvent event = createAccessEvent(uri); appender.append(event); } StatusPrinter.print(context); Statement stmt = connectionSource.getConnection().createStatement(); ResultSet rs = null; rs = stmt.executeQuery("SELECT * FROM access_event where requestURI='" + uri + "'"); int count = 0; while (rs.next()) { count++; } assertEquals(10, count); rs.close(); stmt.close(); }
appender.append(event); Statement stmt = connectionSource.getConnection().createStatement(); ResultSet rs = null; rs = stmt.executeQuery("SELECT * FROM access_event_header");
@Test public void testAppendAccessEvent() throws SQLException { setInsertHeadersAndStart(false); IAccessEvent event = createAccessEvent(); appender.append(event); Statement stmt = connectionSource.getConnection().createStatement(); ResultSet rs = null; rs = stmt.executeQuery("SELECT * FROM access_event where EVENT_ID = " + existingEventTableRowCount); if (rs.next()) { assertEquals(event.getTimeStamp(), rs.getLong(1)); assertEquals(event.getRequestURI(), rs.getString(2)); assertEquals(event.getRequestURL(), rs.getString(3)); assertEquals(event.getRemoteHost(), rs.getString(4)); assertEquals(event.getRemoteUser(), rs.getString(5)); assertEquals(event.getRemoteAddr(), rs.getString(6)); assertEquals(event.getProtocol(), rs.getString(7)); assertEquals(event.getMethod(), rs.getString(8)); assertEquals(event.getServerName(), rs.getString(9)); assertEquals(event.getRequestContent(), rs.getString(10)); } else { fail("No row was inserted in the database"); } rs.close(); stmt.close(); }
@Before public void setUp() throws SQLException { context = new AccessContext(); context.setName("default"); appender = new DBAppender(); appender.setName("DB"); appender.setContext(context); connectionSource = new DriverManagerConnectionSource(); connectionSource.setContext(context); connectionSource.setDriverClass(DBAppenderHSQLTestFixture.DRIVER_CLASS); connectionSource.setUrl(DB_APPENDER_HSQL_TEST_FIXTURE.url); connectionSource.setUser(DB_APPENDER_HSQL_TEST_FIXTURE.user); connectionSource.setPassword(DB_APPENDER_HSQL_TEST_FIXTURE.password); connectionSource.start(); appender.setConnectionSource(connectionSource); stmt = connectionSource.getConnection().createStatement(); existingEventTableRowCount = existingEventTableRowCount(stmt); }