Examples with SortOperation org.springframework.data.mongodb.core.aggregation.SortOperation used on opensource projects

Example 1 with SortOperation

use of org.springframework.data.mongodb.core.aggregation.SortOperation in project tutorials by eugenp.

the class ZipsAggregationLiveTest method whenStatesHavePopGrtrThan10MillionAndSorted_thenSuccess.

@Test
public void whenStatesHavePopGrtrThan10MillionAndSorted_thenSuccess() {
    GroupOperation groupByStateAndSumPop = group("state").sum("pop").as("statePop");
    MatchOperation filterStates = match(new Criteria("statePop").gt(10000000));
    SortOperation sortByPopDesc = sort(new Sort(Direction.DESC, "statePop"));
    Aggregation aggregation = newAggregation(groupByStateAndSumPop, filterStates, sortByPopDesc);
    AggregationResults<StatePopulation> result = mongoTemplate.aggregate(aggregation, "zips", StatePopulation.class);
    /*
         * Assert that all states have population
         * greater than 10000000
         */
    result.forEach(statePop -> {
        assertTrue(statePop.getStatePop() > 10000000);
    });
    /*
         * Assert that states fetched are in sorted by
         * decreasing population
         */
    List<StatePopulation> actualList = StreamSupport.stream(result.spliterator(), false).collect(Collectors.toList());
    List<StatePopulation> expectedList = new ArrayList<>(actualList);
    Collections.sort(expectedList, (sp1, sp2) -> sp2.getStatePop() - sp1.getStatePop());
    assertEquals(expectedList, actualList);
}

Example 2 with SortOperation

use of org.springframework.data.mongodb.core.aggregation.SortOperation in project tutorials by eugenp.

the class ZipsAggregationLiveTest method whenStateWithLowestAvgCityPopIsND_theSuccess.

@Test
public void whenStateWithLowestAvgCityPopIsND_theSuccess() {
    GroupOperation sumTotalCityPop = group("state", "city").sum("pop").as("cityPop");
    GroupOperation averageStatePop = group("_id.state").avg("cityPop").as("avgCityPop");
    SortOperation sortByAvgPopAsc = sort(new Sort(Direction.ASC, "avgCityPop"));
    ProjectionOperation projectToMatchModel = project().andExpression("_id").as("state").andExpression("avgCityPop").as("statePop");
    LimitOperation limitToOnlyFirstDoc = limit(1);
    Aggregation aggregation = newAggregation(sumTotalCityPop, averageStatePop, sortByAvgPopAsc, limitToOnlyFirstDoc, projectToMatchModel);
    AggregationResults<StatePopulation> result = mongoTemplate.aggregate(aggregation, "zips", StatePopulation.class);
    StatePopulation smallestState = result.getUniqueMappedResult();
    assertEquals("ND", smallestState.getState());
    assertTrue(smallestState.getStatePop().equals(1645));
}

Example 3 with SortOperation

use of org.springframework.data.mongodb.core.aggregation.SortOperation in project tutorials by eugenp.

the class ZipsAggregationLiveTest method whenMaxTXAndMinDC_theSuccess.

@Test
public void whenMaxTXAndMinDC_theSuccess() {
    GroupOperation sumZips = group("state").count().as("zipCount");
    SortOperation sortByCount = sort(Direction.ASC, "zipCount");
    GroupOperation groupFirstAndLast = group().first("_id").as("minZipState").first("zipCount").as("minZipCount").last("_id").as("maxZipState").last("zipCount").as("maxZipCount");
    Aggregation aggregation = newAggregation(sumZips, sortByCount, groupFirstAndLast);
    AggregationResults<DBObject> result = mongoTemplate.aggregate(aggregation, "zips", DBObject.class);
    DBObject dbObject = result.getUniqueMappedResult();
    assertEquals("DC", dbObject.get("minZipState"));
    assertEquals(24, dbObject.get("minZipCount"));
    assertEquals("TX", dbObject.get("maxZipState"));
    assertEquals(1671, dbObject.get("maxZipCount"));
}