Examples with OrderProperty org.n52.shetland.filter.OrderProperty used on opensource projects

Example 1 with OrderProperty

use of org.n52.shetland.filter.OrderProperty in project arctic-sea by 52North.

the class ExpandQueryOptionTest method complexExpandOption.

@Test
public void complexExpandOption() {
    init(ODataConstants.QueryOptions.EXPAND + EQ + "Observations($filter=result eq 1;$expand=FeatureOfInterest;$select=id;$orderby=id;" + "$skip=5;$top=10;$count=true),ObservedProperty");
    QueryOptions options = (QueryOptions) parser.queryOptions().accept(new STAQueryOptionVisitor());
    Assertions.assertTrue(options.hasExpandFilter());
    Assertions.assertTrue(options.getExpandFilter() instanceof ExpandFilter);
    Set<ExpandItem> items = (options.getExpandFilter().getItems());
    Assertions.assertNotNull(items);
    Assertions.assertEquals(2, items.size());
    for (ExpandItem obs : items) {
        if (obs.getPath().equals("Observations")) {
            Assertions.assertEquals("Observations", obs.getPath());
            Assertions.assertTrue(obs.getQueryOptions().hasExpandFilter());
            Assertions.assertTrue(obs.getQueryOptions().hasFilterFilter());
            Assertions.assertTrue(obs.getQueryOptions().hasSelectFilter());
            Assertions.assertTrue(obs.getQueryOptions().hasOrderByFilter());
            Assertions.assertTrue(obs.getQueryOptions().hasSkipFilter());
            Assertions.assertTrue(obs.getQueryOptions().hasTopFilter());
            Assertions.assertTrue(obs.getQueryOptions().hasCountFilter());
            Set<FilterClause> filters = new HashSet<>();
            filters.add(new FilterFilter(new ComparisonExpr(FilterConstants.ComparisonOperator.PropertyIsEqualTo, new MemberExpr("result"), new NumericValueExpr("1"))));
            filters.add(new ExpandFilter(new ExpandItem("FeatureOfInterest", new QueryOptions("", null))));
            filters.add(new SelectFilter("id"));
            filters.add(new OrderByFilter(new OrderProperty("id")));
            filters.add(new SkipTopFilter(FilterConstants.SkipTopOperator.Skip, 5L));
            filters.add(new SkipTopFilter(FilterConstants.SkipTopOperator.Top, 10L));
            filters.add(new CountFilter(true));
            Assertions.assertEquals(new QueryOptions("", filters), obs.getQueryOptions());
        } else if (obs.getPath().equals("ObservedProperty")) {
            Assertions.assertEquals("ObservedProperty", obs.getPath());
            Assertions.assertNotNull(obs.getQueryOptions());
            Assertions.assertTrue(obs.getQueryOptions().hasTopFilter());
            Assertions.assertFalse(obs.getQueryOptions().hasExpandFilter());
            Assertions.assertFalse(obs.getQueryOptions().hasFilterFilter());
            Assertions.assertFalse(obs.getQueryOptions().hasSelectFilter());
            Assertions.assertFalse(obs.getQueryOptions().hasOrderByFilter());
            Assertions.assertFalse(obs.getQueryOptions().hasSkipFilter());
            Assertions.assertFalse(obs.getQueryOptions().hasCountFilter());
        } else {
            Assertions.fail("Did not find expected expandItem!");
        }
    }
}

Example 2 with OrderProperty

use of org.n52.shetland.filter.OrderProperty in project arctic-sea by 52North.

the class ExpandQueryOptionTest method testValidExpandOption.

@Test
public void testValidExpandOption() {
    String val, nested;
    ExpandFilter actual, reference;
    QueryOptions defaultQO = new QueryOptions("", null);
    Set<FilterClause> nestedFilters;
    // Simple
    val = "test";
    init(ODataConstants.QueryOptions.EXPAND + EQ + val);
    actual = ((QueryOptions) parser.queryOptions().accept(new STAQueryOptionVisitor())).getExpandFilter();
    reference = new ExpandFilter(new ExpandItem(val, defaultQO));
    Assertions.assertEquals(reference, actual);
    // Resolve nested Expand
    val = "test";
    nested = "nested";
    init(ODataConstants.QueryOptions.EXPAND + EQ + val + "/" + nested);
    actual = ((QueryOptions) parser.queryOptions().accept(new STAQueryOptionVisitor())).getExpandFilter();
    nestedFilters = new HashSet<>();
    nestedFilters.add(new ExpandFilter(new ExpandItem(nested, defaultQO)));
    reference = new ExpandFilter(new ExpandItem(val, new QueryOptions("", nestedFilters)));
    Assertions.assertEquals(reference, actual);
    // Expand with queryOptions
    val = "test";
    String queryOption = "($filter=id eq '2')";
    init(ODataConstants.QueryOptions.EXPAND + EQ + val + queryOption);
    actual = ((QueryOptions) parser.queryOptions().accept(new STAQueryOptionVisitor())).getExpandFilter();
    nestedFilters = new HashSet<>();
    nestedFilters.add(new FilterFilter(new ComparisonExpr(FilterConstants.ComparisonOperator.PropertyIsEqualTo, new MemberExpr("id"), new StringValueExpr("2"))));
    reference = new ExpandFilter(new ExpandItem(val, new QueryOptions("", nestedFilters)));
    Assertions.assertEquals(reference, actual);
    // Expand with queryOptions
    val = "test";
    queryOption = "($top=52)";
    init(ODataConstants.QueryOptions.EXPAND + EQ + val + queryOption);
    actual = ((QueryOptions) parser.queryOptions().accept(new STAQueryOptionVisitor())).getExpandFilter();
    nestedFilters = new HashSet<>();
    nestedFilters.add(new SkipTopFilter(FilterConstants.SkipTopOperator.Top, 52L));
    reference = new ExpandFilter(new ExpandItem(val, new QueryOptions("", nestedFilters)));
    Assertions.assertEquals(reference, actual);
    // Expand with queryOptions
    val = "test";
    queryOption = "($skip=52)";
    init(ODataConstants.QueryOptions.EXPAND + EQ + val + queryOption);
    actual = ((QueryOptions) parser.queryOptions().accept(new STAQueryOptionVisitor())).getExpandFilter();
    nestedFilters = new HashSet<>();
    nestedFilters.add(new SkipTopFilter(FilterConstants.SkipTopOperator.Skip, 52L));
    reference = new ExpandFilter(new ExpandItem(val, new QueryOptions("", nestedFilters)));
    Assertions.assertEquals(reference, actual);
    // Expand with queryOptions
    val = "test";
    queryOption = "($select=id)";
    init(ODataConstants.QueryOptions.EXPAND + EQ + val + queryOption);
    actual = ((QueryOptions) parser.queryOptions().accept(new STAQueryOptionVisitor())).getExpandFilter();
    nestedFilters = new HashSet<>();
    nestedFilters.add(new SelectFilter("id"));
    reference = new ExpandFilter(new ExpandItem(val, new QueryOptions("", nestedFilters)));
    Assertions.assertEquals(reference, actual);
    // Expand with queryOptions
    val = "test";
    queryOption = "($expand=nested)";
    init(ODataConstants.QueryOptions.EXPAND + EQ + val + queryOption);
    actual = ((QueryOptions) parser.queryOptions().accept(new STAQueryOptionVisitor())).getExpandFilter();
    nestedFilters = new HashSet<>();
    nestedFilters.add(new ExpandFilter(new ExpandItem(nested, defaultQO)));
    reference = new ExpandFilter(new ExpandItem(val, new QueryOptions("", nestedFilters)));
    Assertions.assertEquals(reference, actual);
    // Expand with queryOptions
    val = "test";
    queryOption = "($orderby=id asc)";
    init(ODataConstants.QueryOptions.EXPAND + EQ + val + queryOption);
    actual = ((QueryOptions) parser.queryOptions().accept(new STAQueryOptionVisitor())).getExpandFilter();
    nestedFilters = new HashSet<>();
    nestedFilters.add(new OrderByFilter(new OrderProperty("id", FilterConstants.SortOrder.ASC)));
    reference = new ExpandFilter(new ExpandItem(val, new QueryOptions("", nestedFilters)));
    Assertions.assertEquals(reference, actual);
}

Example 3 with OrderProperty

use of org.n52.shetland.filter.OrderProperty in project sensorweb-server-sta by 52North.

the class AbstractSensorThingsEntityServiceImpl method createPageableRequest.

/**
 * Create {@link PageRequest}
 *
 * @param queryOptions {@link QueryOptions} to create {@link PageRequest}
 * @return {@link PageRequest} of type {@link OffsetLimitBasedPageRequest}
 */
OffsetLimitBasedPageRequest createPageableRequest(QueryOptions queryOptions) {
    long offset = queryOptions.hasSkipFilter() ? queryOptions.getSkipFilter().getValue() : 0;
    Sort sort;
    if (queryOptions.hasOrderByFilter()) {
        sort = Sort.unsorted();
        for (OrderProperty sortProperty : queryOptions.getOrderByFilter().getSortProperties()) {
            Sort.Direction direction = sortProperty.isSetSortOrder() && sortProperty.getSortOrder().equals(FilterConstants.SortOrder.DESC) ? Sort.Direction.DESC : Sort.Direction.ASC;
            sort = sort.and(sortProperty.getValueReference().equals(RESULT) ? handleResultSort(direction) : Sort.by(direction, checkPropertyName(sortProperty.getValueReference())));
        }
    } else {
        sort = Sort.by(Sort.Direction.ASC, STAIDENTIFIER);
    }
    return new OffsetLimitBasedPageRequest((int) offset, queryOptions.getTopFilter().getValue().intValue(), sort);
}