@Test @Features("issues/292") public void testLruGlobalSqlStats() throws Exception { Sniffy.getGlobalSqlStats().clear(); for (int i = 0; i < Sniffy.TOP_SQL_CAPACITY; i++) { executeSelectStatements(i, 2 + i % 100); } assertEquals(Sniffy.TOP_SQL_CAPACITY, Sniffy.getGlobalSqlStats().size()); assertNotNull(Sniffy.getGlobalSqlStats().get(String.format("SELECT %d FROM DUAL", 0))); executeSelectStatements(Sniffy.TOP_SQL_CAPACITY + 1000, 1); assertEquals(Sniffy.TOP_SQL_CAPACITY, Sniffy.getGlobalSqlStats().size()); assertTrue(Sniffy.getGlobalSqlStats().containsKey(String.format("SELECT %d FROM DUAL", Sniffy.TOP_SQL_CAPACITY + 1000))); assertTrue(Sniffy.getGlobalSqlStats().containsKey(String.format("SELECT %d FROM DUAL", 0))); assertFalse(Sniffy.getGlobalSqlStats().containsKey(String.format("SELECT %d FROM DUAL", 1))); }
@Test @Features("issues/292") public void testGetGlobalSqlStats() throws Exception { Sniffy.getGlobalSqlStats().clear(); executeStatements(3); ConcurrentMap<String, Timer> globalSqlStats = Sniffy.getGlobalSqlStats(); assertEquals(1, globalSqlStats.size()); Map.Entry<String, Timer> entry = globalSqlStats.entrySet().iterator().next(); assertEquals("SELECT 1 FROM DUAL", entry.getKey()); assertEquals(3, entry.getValue().getCount()); }
Sniffy.getGlobalSqlStats().clear(); for (Map.Entry<String, Timer> entry : Sniffy.getGlobalSqlStats().entrySet()) {
Sniffy.getGlobalSqlStats().clear(); for (Map.Entry<String, Timer> entry : Sniffy.getGlobalSqlStats().entrySet()) {
@Test @Features("issues/292") public void testGlobalSqlStatsDisabled() throws Exception { int topSqlCapacity = SniffyConfiguration.INSTANCE.getTopSqlCapacity(); try { Sniffy.getGlobalSqlStats().clear(); SniffyConfiguration.INSTANCE.setTopSqlCapacity(0); executeStatements(3); assertTrue(Sniffy.getGlobalSqlStats().isEmpty()); } finally { SniffyConfiguration.INSTANCE.setTopSqlCapacity(topSqlCapacity); } }