Examples with Query org.hypertrace.core.documentstore.query.Query used on opensource projects

Example 1 with Query

use of org.hypertrace.core.documentstore.query.Query in project document-store by hypertrace.

the class MongoQueryExecutorIntegrationTest method testFindWithDuplicateSelections.

@Test
public void testFindWithDuplicateSelections() throws IOException {
    List<SelectionSpec> selectionSpecs = List.of(SelectionSpec.of(IdentifierExpression.of("item")), SelectionSpec.of(IdentifierExpression.of("item")), SelectionSpec.of(IdentifierExpression.of("price")), SelectionSpec.of(IdentifierExpression.of("quantity")), SelectionSpec.of(IdentifierExpression.of("quantity")), SelectionSpec.of(IdentifierExpression.of("date")));
    Selection selection = Selection.builder().selectionSpecs(selectionSpecs).build();
    Filter filter = Filter.builder().expression(RelationalExpression.of(IdentifierExpression.of("item"), NOT_IN, ConstantExpression.ofStrings(List.of("Soap", "Bottle")))).build();
    Query query = Query.builder().setSelection(selection).setFilter(filter).build();
    Iterator<Document> resultDocs = collection.find(query);
    assertDocsEqual(resultDocs, "mongo/simple_filter_response.json");
}

Example 2 with Query

use of org.hypertrace.core.documentstore.query.Query in project document-store by hypertrace.

the class MongoQueryExecutorIntegrationTest method testFindAll.

@Test
public void testFindAll() throws IOException {
    Query query = Query.builder().build();
    Iterator<Document> resultDocs = collection.find(query);
    assertSizeEqual(resultDocs, "mongo/collection_data.json");
}

Example 3 with Query

use of org.hypertrace.core.documentstore.query.Query in project document-store by hypertrace.

the class MongoQueryExecutorIntegrationTest method testAggregateWithUnsupportedExpressionNesting.

@Test
public void testAggregateWithUnsupportedExpressionNesting() {
    Query query = Query.builder().addAggregation(IdentifierExpression.of("item")).addAggregation(IdentifierExpression.of("price")).addSelection(IdentifierExpression.of("item")).addSelection(IdentifierExpression.of("price")).addSelection(AggregateExpression.of(DISTINCT, IdentifierExpression.of("quantity")), "quantities").setAggregationFilter(RelationalExpression.of(ConstantExpression.of(1), GT, FunctionExpression.builder().operator(LENGTH).operand(IdentifierExpression.of("quantities")).build())).addSort(IdentifierExpression.of("item"), DESC).build();
    assertThrows(UnsupportedOperationException.class, () -> collection.aggregate(query));
}

Example 4 with Query

use of org.hypertrace.core.documentstore.query.Query in project document-store by hypertrace.

the class MongoQueryExecutorIntegrationTest method testUnnestAndAggregate.

@Test
public void testUnnestAndAggregate() throws IOException {
    org.hypertrace.core.documentstore.query.Query query = org.hypertrace.core.documentstore.query.Query.builder().addSelection(IdentifierExpression.of("sales.medium.type")).addAggregation(IdentifierExpression.of("sales.medium.type")).addSelection(AggregateExpression.of(SUM, IdentifierExpression.of("sales.medium.volume")), "totalSales").addFromClause(UnnestExpression.of(IdentifierExpression.of("sales"), false)).addFromClause(UnnestExpression.of(IdentifierExpression.of("sales.medium"), false)).addSort(IdentifierExpression.of("totalSales"), DESC).build();
    Iterator<Document> iterator = collection.aggregate(query);
    assertDocsEqual(iterator, "mongo/aggregate_on_nested_array_reponse.json");
}

Example 5 with Query

use of org.hypertrace.core.documentstore.query.Query in project document-store by hypertrace.

the class MongoQueryExecutorIntegrationTest method testFindWithDuplicateSortingAndPagination.

@Test
public void testFindWithDuplicateSortingAndPagination() throws IOException {
    List<SelectionSpec> selectionSpecs = List.of(SelectionSpec.of(IdentifierExpression.of("item")), SelectionSpec.of(IdentifierExpression.of("price")), SelectionSpec.of(IdentifierExpression.of("quantity")), SelectionSpec.of(IdentifierExpression.of("date")));
    Selection selection = Selection.builder().selectionSpecs(selectionSpecs).build();
    Filter filter = Filter.builder().expression(RelationalExpression.of(IdentifierExpression.of("item"), IN, ConstantExpression.ofStrings(List.of("Mirror", "Comb", "Shampoo", "Bottle")))).build();
    Sort sort = Sort.builder().sortingSpec(SortingSpec.of(IdentifierExpression.of("quantity"), DESC)).sortingSpec(SortingSpec.of(IdentifierExpression.of("item"), ASC)).sortingSpec(SortingSpec.of(IdentifierExpression.of("quantity"), DESC)).sortingSpec(SortingSpec.of(IdentifierExpression.of("item"), ASC)).build();
    Pagination pagination = Pagination.builder().offset(1).limit(3).build();
    Query query = Query.builder().setSelection(selection).setFilter(filter).setSort(sort).setPagination(pagination).build();
    Iterator<Document> resultDocs = collection.find(query);
    assertDocsEqual(resultDocs, "mongo/filter_with_sorting_and_pagination_response.json");
}