use of com.github.drinkjava2.jdbpro.handler.Wrap in project jSqlBox by drinkjava2.
the class HandlersTest method testSimpleCacheHandler.
@Test
public void testSimpleCacheHandler() {
for (int i = 0; i < 10; i++) {
// warm up
ctx.nQuery(new Wrap(new EntityListHandler(DemoUser.class), new SimpleCacheHandler()), "select u.** from DemoUser u where u.age>?", 0);
ctx.nQuery(new Wrap(new EntityListHandler(DemoUser.class)), "select u.** from DemoUser u where u.age>?", 0);
}
long start = System.currentTimeMillis();
for (int i = 0; i < 1000; i++) {
List<DemoUser> result = ctx.nQuery(new Wrap(new EntityListHandler(DemoUser.class), new SimpleCacheHandler()), "select u.** from DemoUser u where u.age>?", 0);
Assert.assertTrue(result.size() == 99);
}
long end = System.currentTimeMillis();
String timeused = "" + (end - start) / 1000 + "." + (end - start) % 1000;
System.out.println(String.format("%28s: %6s s", "With Cache", timeused));
start = System.currentTimeMillis();
for (int i = 0; i < 1000; i++) {
List<DemoUser> result = ctx.nQuery(new Wrap(new EntityListHandler(DemoUser.class)), "select u.** from DemoUser u where u.age>?", 0);
Assert.assertTrue(result.size() == 99);
}
end = System.currentTimeMillis();
timeused = "" + (end - start) / 1000 + "." + (end - start) % 1000;
System.out.println(String.format("%28s: %6s s", "No Cache", timeused));
}
use of com.github.drinkjava2.jdbpro.handler.Wrap in project jSqlBox by drinkjava2.
the class HandlersTest method testMyAroundSqlHandler.
@Test
public void testMyAroundSqlHandler() throws SQLException {
List<Map<String, Object>> result2 = ctx.nQuery(new Wrap(new MapListHandler(), new MyAroundSqlHandler()), "select u.* from DemoUser u where u.age>?", 0);
Assert.assertTrue(result2.size() == 99);
}
use of com.github.drinkjava2.jdbpro.handler.Wrap in project jSqlBox by drinkjava2.
the class HandlersTest method testPaginHandler.
@Test
public void testPaginHandler() {
List<Map<String, Object>> result = ctx.nQuery(new Wrap(new EntitySqlMapListHandler(DemoUser.class), new PaginHandler(2, 5)), "select u.** from DemoUser u where u.age>?", 0);
Assert.assertTrue(result.size() == 5);
List<DemoUser> users = ctx.nQuery(new Wrap(new EntityListHandler(DemoUser.class), new PaginHandler(2, 5)), "select u.** from DemoUser u where u.age>?", 0);
Assert.assertTrue(users.size() == 5);
}
use of com.github.drinkjava2.jdbpro.handler.Wrap in project jSqlBox by drinkjava2.
the class HandlersTest method testPrintSqlHandler.
@Test
public void testPrintSqlHandler() throws SQLException {
List<Map<String, Object>> result = ctx.nQuery(new MapListHandler(), "select u.* from DemoUser u where u.age>?", 0);
Assert.assertTrue(result.size() == 99);
List<Map<String, Object>> result2 = ctx.nQuery(new Wrap(new MapListHandler(), new PrintSqlHandler()), "select u.* from DemoUser u where u.age>?", 0);
Assert.assertTrue(result2.size() == 99);
}
use of com.github.drinkjava2.jdbpro.handler.Wrap in project jSqlBox by drinkjava2.
the class HandlersTest method testHandlers.
@Test
public void testHandlers() {
List<DemoUser> result = ctx.nQuery(new Wrap(PrintSqlHandler.class, new EntityListHandler(DemoUser.class), new PaginHandler(1, 5), PrintSqlHandler.class), "select u.** from DemoUser u where u.age>?", 0);
Assert.assertTrue(result.size() == 5);
}
Aggregations