Package org.springframework.data.domain.Sort

Examples of org.springframework.data.domain.Sort.Order

319
320
321
322
323
324
325
326
327
328
329
    //given
    jdbc.update("INSERT INTO USERS VALUES (?, ?, ?, ?)", "john3", SOME_DATE_OF_BIRTH, SOME_REPUTATION, true);
    jdbc.update("INSERT INTO USERS VALUES (?, ?, ?, ?)", "john5", SOME_DATE_OF_BIRTH, SOME_REPUTATION + 1, true);
    jdbc.update("INSERT INTO USERS VALUES (?, ?, ?, ?)", "john4", SOME_DATE_OF_BIRTH, SOME_REPUTATION + 1, true);
    jdbc.update("INSERT INTO USERS VALUES (?, ?, ?, ?)", "john6", SOME_DATE_OF_BIRTH, SOME_REPUTATION - 1, true);
    final Sort sort = new Sort(new Order(DESC, "reputation"), new Order(ASC, "user_name"));

    //when
    final List<User> all = repository.findAll(sort);

    //then
View Full Code Here
99
100
101
102
103
104
105
106
107
108
109
110
    repository.save(new BoardingPass("BAR-100", 1, "Gordon", "D03"));

    //when
    final List<BoardingPass> all = repository.findAll(
        new Sort(
            new Order(ASC, "flight_no"),
            new Order(DESC, "seq_no")
        )
    );

    //then
    assertThat(all).containsExactly(
View Full Code Here
125
126
127
128
129
130
131
132
133
134
135
136
    //when
    final Page<BoardingPass> page = repository.findAll(
        new PageRequest(0, 3,
            new Sort(
                new Order(ASC, "flight_no"),
                new Order(DESC, "seq_no")
            )
        ));

    //then
    assertThat(page.getTotalElements()).isEqualTo(4);
View Full Code Here
152
153
154
155
156
157
158
159
160
161
162
163
    //when
    final Page<BoardingPass> page = repository.findAll(
        new PageRequest(1, 3,
            new Sort(
                new Order(ASC, "flight_no"),
                new Order(DESC, "seq_no")
            )
        ));

    //then
    assertThat(page.getContent()).containsExactly(new BoardingPass("FOO-100", 1, "Smith", "B01"));
View Full Code Here
230
231
232
233
234
235
236
237
238
239
240
  @Test
  public void returnsAllIgnoreCaseSortedCorrectly() throws Exception {

    flushTestUsers();

    Order order = new Order(ASC, "firstname").ignoreCase();
    List<User> result = repository.findAll(new Sort(order));

    assertThat(result, is(notNullValue()));
    assertThat(result.size(), is(4));
    assertThat(result.get(0), is(thirdUser));
View Full Code Here
130
131
132
133
134
135
136
137
138
139
140
   * @see DATAJPA-296
   */
  @Test
  public void appliesIgnoreCaseOrdering() {

    Sort sort = new Sort(new Order(Direction.DESC, "lastname").ignoreCase(), new Order(Direction.ASC, "firstname"));

    Page<User> result = repository.findAll(user.lastname.contains("e"), new PageRequest(0, 2, sort));

    assertThat(result.getContent(), hasSize(2));
    assertThat(result.getContent().get(0), is(dave));
View Full Code Here
198
199
200
201
202
203
204
205
206
207
208
  @Test
  public void findBySpecificationWithSortByOrderIgnoreCaseBySingularPropertyInPageableShouldUseSortNullValuesFirst() {

    QUser user = QUser.user;

    Page<User> page = repository.findAll(user.firstname.isNotNull(), new PageRequest(0, 10, new Sort(new Order(
        Sort.Direction.ASC, "firstname").ignoreCase())));

    assertThat(page.getContent(), hasSize(3));
    assertThat(page.getContent(), hasItems(carter, dave, oliver));
  }
View Full Code Here
97
98
99
100
101
102
103
104
105
106
  public void shouldBuildSpringDataSortFromSortColumnAndSortAscending() throws Exception {
    given(this.delegate.getSortColumn()).willReturn("column");
    given(this.delegate.isSortAscending()).willReturn(true);
    Sort sort = this.request.getSort();
    Iterator<Order> orderIterator = sort.iterator();
    Order order = orderIterator.next();
    assertThat("Sort should only conain a single item", orderIterator.hasNext(), is(false));
    assertThat(order.getDirection(), is(Sort.Direction.ASC));
    assertThat(order.getProperty(), is("column"));
  }
View Full Code Here
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
    if(user==null){
      throw new RuntimeException("Invalid user id : " + id);
    }
    Pageable pageable = new PageRequest(Math.max(no, 0),
        ApplicationConfig.masonryPageSize,
        new Sort(new Order(Direction.DESC, "updatedAt")));
    Page<FollowShip> fss = followShipRepository.findByTargetAndStatus(id, 0, pageable);
    pageable = new PageRequest(Math.max(no, 0),
        ApplicationConfig.masonryThumbPageSize,
        new Sort(new Order(Direction.DESC, "updatedAt")));
    List<PinUserVo> pins = new ArrayList<PinUserVo>();
    if(fss!=null){
      for(FollowShip fs : fss){
        if(fs.getFollowed()==null) continue;
        Page<Spot> spots = spotRepository.findByCreatedBy(fs.getFollowed().getId(), pageable);
View Full Code Here
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
    if(user==null){
      throw new RuntimeException("Invalid user id : " + id);
    }
    Pageable pageable = new PageRequest(Math.max(no, 0),
        ApplicationConfig.masonryPageSize,
        new Sort(new Order(Direction.DESC, "updatedAt")));
    Page<FollowShip> fss = followShipRepository.findByFollowedAndStatus(id, 0, pageable);
    pageable = new PageRequest(Math.max(no, 0),
        ApplicationConfig.masonryThumbPageSize,
        new Sort(new Order(Direction.DESC, "updatedAt")));
    List<PinUserVo> pins = new ArrayList<PinUserVo>();
    if(fss!=null){
      for(FollowShip fs : fss){
        if(fs.getFollowed()==null) continue;
        Page<Spot> spots = spotRepository.findByCreatedBy(fs.getTarget().getId(), pageable);
View Full Code Here
TOP

Related Classes of org.springframework.data.domain.Sort.Order

  • com.nurkiewicz.jdbcrepository.JdbcRepositoryCompoundPkTest
  • com.nurkiewicz.jdbcrepository.JdbcRepositoryManualKeyTest
  • net.baguajie.web.mvc.controllers.GetSpotsFromCategoryController
  • net.baguajie.web.mvc.controllers.SearchProfilesController
  • net.baguajie.web.mvc.controllers.SearchSpotsController
  • net.baguajie.web.mvc.controllers.ViewActivitiesForUserController
  • net.baguajie.web.mvc.controllers.ViewActivityCommentsController
  • net.baguajie.web.mvc.controllers.ViewActivityForwardsController
  • net.baguajie.web.mvc.controllers.ViewUserActivitiesController
  • net.baguajie.web.mvc.controllers.ViewUserRelationsController
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.