@Test
public void testPaging() {
JPA.bootstrap(path());
int total = 15;
JPA.transaction(
() -> {
for (int i = 0; i < total; i++) {
Book book = JPA.insert(new Book("b" + i));
notNull(book.getId());
}
});
JPA.transaction(
() -> {
eq(JPA.getAllEntities().size(), total);
eq(JPA.count(Book.class), total);
eq(JPA.of(Book.class).all().size(), total);
List<Book> first3 = JPA.of(Book.class).page(0, 3);
eq(first3.size(), 3);
eq(Do.map(first3).to(Book::getTitle), U.list("b0", "b1", "b2"));
List<Book> next5 = JPA.of(Book.class).page(3, 5);
eq(Do.map(next5).to(Book::getTitle), U.list("b3", "b4", "b5", "b6", "b7"));
List<Book> last2 = JPA.of(Book.class).page(13, 2);
eq(Do.map(last2).to(Book::getTitle), U.list("b13", "b14"));
});
}
