Examples of org.springframework.data.domain.PageRequest

org.springframework.data.domain.PageRequest
Basic Java Bean implementation of {@code Pageable}. @author Oliver Gierke @author Thomas Darimont

  public void shouldReturnPageWithOneItemWhenOneRecordInDatabase() {
    //given
    jdbc.update("INSERT INTO USERS VALUES (?, ?, ?, ?)", "john4", SOME_DATE_OF_BIRTH, SOME_REPUTATION, true);


    //when
    Page<User> page = repository.findAll(new PageRequest(0, 5));


    //then
    assertThat(page).hasSize(1);
    assertThat(page.getTotalElements()).isEqualTo(1);
    assertThat(page.getSize()).isEqualTo(5);

View Full Code Here

  public void shouldReturnNothingWhenOnlyOneRecordInDatabaseButSecondPageRequested() {
    //given
    jdbc.update("INSERT INTO USERS VALUES (?, ?, ?, ?)", "john5", SOME_DATE_OF_BIRTH, SOME_REPUTATION, true);


    //when
    Page<User> page = repository.findAll(new PageRequest(1, 5));


    //then
    assertThat(page).hasSize(0);
    assertThat(page.getTotalElements()).isEqualTo(1);
    assertThat(page.getSize()).isEqualTo(5);

View Full Code Here

  public void shouldReturnPageWithOneItemWithSortingApplied() {
    //given
    jdbc.update("INSERT INTO USERS VALUES (?, ?, ?, ?)", "john6", SOME_DATE_OF_BIRTH, SOME_REPUTATION, true);


    //when
    Page<User> page = repository.findAll(new PageRequest(0, 5, ASC, "user_name"));


    //then
    assertThat(page).hasSize(1);
    assertThat(page.getTotalElements()).isEqualTo(1);
    assertThat(page.getSize()).isEqualTo(5);

View Full Code Here

  public void shouldReturnPageWithOneItemWithSortingAppliedOnTwoProperties() {
    //given
    jdbc.update("INSERT INTO USERS VALUES (?, ?, ?, ?)", "john6", SOME_DATE_OF_BIRTH, SOME_REPUTATION, true);


    //when
    Page<User> page = repository.findAll(new PageRequest(0, 5, new Sort(new Order(DESC, "reputation"), new Order(ASC, "user_name"))));


    //then
    assertThat(page).hasSize(1);
    assertThat(page.getTotalElements()).isEqualTo(1);
    assertThat(page.getSize()).isEqualTo(5);

View Full Code Here

    jdbc.update("INSERT INTO USERS VALUES (?, ?, ?, ?)", "john13", SOME_DATE_OF_BIRTH, SOME_REPUTATION + 2, true);
    jdbc.update("INSERT INTO USERS VALUES (?, ?, ?, ?)", "john14", SOME_DATE_OF_BIRTH, SOME_REPUTATION    , true);
    jdbc.update("INSERT INTO USERS VALUES (?, ?, ?, ?)", "john15", SOME_DATE_OF_BIRTH, SOME_REPUTATION + 1, true);


    //when
    Page<User> page = repository.findAll(new PageRequest(0, 3, new Sort(new Order(DESC, "reputation"), new Order(ASC, "user_name"))));


    //then
    assertThat(page).hasSize(3);
    assertThat(page.getTotalElements()).isEqualTo(5);
    assertThat(page.getSize()).isEqualTo(3);

View Full Code Here

    jdbc.update("INSERT INTO USERS VALUES (?, ?, ?, ?)", "john13", SOME_DATE_OF_BIRTH, SOME_REPUTATION + 2, true);
    jdbc.update("INSERT INTO USERS VALUES (?, ?, ?, ?)", "john14", SOME_DATE_OF_BIRTH, SOME_REPUTATION    , true);
    jdbc.update("INSERT INTO USERS VALUES (?, ?, ?, ?)", "john15", SOME_DATE_OF_BIRTH, SOME_REPUTATION + 1, true);


    //when
    Page<User> page = repository.findAll(new PageRequest(1, 3, new Sort(new Order(DESC, "reputation"), new Order(ASC, "user_name"))));


    //then
    assertThat(page).hasSize(2);
    assertThat(page.getTotalElements()).isEqualTo(5);
    assertThat(page.getSize()).isEqualTo(3);

View Full Code Here

    final CommentWithUser first = repository.save(new CommentWithUser(someUser, "First comment", SOME_TIMESTAMP, 3));
    final CommentWithUser second = repository.save(new CommentWithUser(someUser, "Second comment", SOME_TIMESTAMP, 2));
    repository.save(new CommentWithUser(someUser, "Third comment", SOME_TIMESTAMP, 1));


    //when
    final Page<CommentWithUser> page = repository.findAll(new PageRequest(0, 2, ASC, "contents"));


    //then
    assertThat(page.getTotalElements()).isEqualTo(3);
    assertThat(page.getTotalPages()).isEqualTo(2);
    assertThat(page.getContent()).containsExactly(first, second);

View Full Code Here

    repository.save(new CommentWithUser(someUser, "First comment", SOME_TIMESTAMP, 3));
    repository.save(new CommentWithUser(someUser, "Second comment", SOME_TIMESTAMP, 2));
    final CommentWithUser third = repository.save(new CommentWithUser(someUser, "Third comment", SOME_TIMESTAMP, 1));


    //when
    final Page<CommentWithUser> page = repository.findAll(new PageRequest(1, 2, ASC, "contents"));


    //then
    assertThat(page.getTotalElements()).isEqualTo(3);
    assertThat(page.getTotalPages()).isEqualTo(2);
    assertThat(page.getContent()).containsExactly(third);

View Full Code Here

    repository.save(new BoardingPass("BAR-100", 2, "Who", "E04"));
    repository.save(new BoardingPass("BAR-100", 1, "Gordon", "D03"));


    //when
    final Page<BoardingPass> page = repository.findAll(
        new PageRequest(0, 3,
            new Sort(
                new Order(ASC, "flight_no"),
                new Order(DESC, "seq_no")
            )
        ));

View Full Code Here

    repository.save(new BoardingPass("BAR-100", 2, "Who", "E04"));
    repository.save(new BoardingPass("BAR-100", 1, "Gordon", "D03"));


    //when
    final Page<BoardingPass> page = repository.findAll(
        new PageRequest(1, 3,
            new Sort(
                new Order(ASC, "flight_no"),
                new Order(DESC, "seq_no")
            )
        ));

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.springframework.data.domain.PageRequest

$.TaskService

com.astech.repository.support.CustomRepositoryImpl

com.example.mvc.service.impl.PersonServiceImpl

com.excilys.ebi.bank.service.impl.BankServiceImpl

com.fengjing.framework.springmvc.controller.ContactController

com.infoclinika.mssharing.model.internal.read.DashboardReaderImpl

com.infoclinika.mssharing.model.internal.read.SequestSearchReaderImpl

com.ketayao.ketacustom.util.dwz.PageUtils

com.netflix.genie.server.services.impl.jpa.ApplicationConfigServiceJPAImpl

com.netflix.genie.server.services.impl.jpa.ClusterConfigServiceJPAImpl

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.