use of org.ballerinalang.siddhi.query.api.execution.query.Query in project ballerina by ballerina-lang.
the class SimpleQueryTestCase method testCreatingReturnFilterQueryLimitAndSortError2.
@Test(expectedExceptions = UnsupportedAttributeTypeException.class)
public void testCreatingReturnFilterQueryLimitAndSortError2() {
Query query = Query.query();
query.from(InputStream.stream("StockStream"));
query.select(Selector.selector().select("symbol", Expression.variable("symbol")).orderBy(Expression.variable("avgPrice")).limit(Expression.value(5.0F)));
}
use of org.ballerinalang.siddhi.query.api.execution.query.Query in project ballerina by ballerina-lang.
the class SimpleQueryTestCase method testCreatingFilterQuery.
// from StockStream[ 7+9.5>price AND 100>=volume]
// insert into OutStockStream symbol, avg(price) as avgPrice
// group by symbol
// having avgPrice>50
@Test
public void testCreatingFilterQuery() {
Query query = Query.query();
query.from(InputStream.stream("StockStream").filter(Expression.and(Expression.compare(Expression.add(Expression.value(7), Expression.value(9.5)), Compare.Operator.GREATER_THAN, Expression.variable("price")), Expression.compare(Expression.value(100), Compare.Operator.GREATER_THAN_EQUAL, Expression.variable("volume")))));
query.select(Selector.selector().select("symbol", Expression.variable("symbol")).select("avgPrice", Expression.function("avg", Expression.variable("symbol"))).groupBy(Expression.variable("symbol")).having(Expression.compare(Expression.variable("avgPrice"), Compare.Operator.GREATER_THAN_EQUAL, Expression.value(50))));
query.insertInto("OutStockStream");
SiddhiApp.siddhiApp("test").addQuery(query);
}
use of org.ballerinalang.siddhi.query.api.execution.query.Query in project ballerina by ballerina-lang.
the class SimpleQueryTestCase method testQuery2.
@Test
public void testQuery2() {
Query query = Query.query();
query.from(InputStream.stream("StockStream").filter(Expression.and(Expression.compare(Expression.add(Expression.value(7), Expression.value(9.5)), Compare.Operator.GREATER_THAN, Expression.variable("price")), Expression.compare(Expression.value(100), Compare.Operator.GREATER_THAN_EQUAL, Expression.variable("volume")))).window("length", Expression.value(50)).filter(Expression.compare(Expression.variable("symbol"), Compare.Operator.EQUAL, Expression.value("WSO2"))));
query.select(Selector.selector().select("symbol", Expression.variable("symbol")).select("avgPrice", Expression.function("avg", Expression.variable("price"))).groupBy(Expression.variable("symbol")).having(Expression.compare(Expression.variable("avgPrice"), Compare.Operator.GREATER_THAN_EQUAL, Expression.value(50))));
query.insertInto("OutStockStream");
}
use of org.ballerinalang.siddhi.query.api.execution.query.Query in project ballerina by ballerina-lang.
the class SimpleQueryTestCase method testCreatingReturnFilterQueryLimitAndSort.
@Test
public void testCreatingReturnFilterQueryLimitAndSort() {
Query query = Query.query();
query.from(InputStream.stream("StockStream").filter(Expression.and(Expression.compare(Expression.function("FooBarCond", Expression.value(7), Expression.value(9.5)), Compare.Operator.GREATER_THAN, Expression.variable("price")), Expression.function("BarCond", Expression.value(100), Expression.variable("volume")))).function("ext", "Foo", Expression.value(67), Expression.value(89)).window("ext", "lengthFirst10", Expression.value(50)));
query.select(Selector.selector().select("symbol", Expression.variable("symbol")).select("avgPrice", Expression.function("ext", "avg", Expression.variable("symbol"))).orderBy(Expression.variable("avgPrice"), OrderByAttribute.Order.DESC).limit(Expression.value(5)));
}
use of org.ballerinalang.siddhi.query.api.execution.query.Query in project ballerina by ballerina-lang.
the class SimpleQueryTestCase method testCreatingReturnFilterQueryLimitAndSortError3.
@Test(expectedExceptions = UnsupportedAttributeTypeException.class)
public void testCreatingReturnFilterQueryLimitAndSortError3() {
Query query = Query.query();
query.from(InputStream.stream("StockStream"));
query.select(Selector.selector().select("symbol", Expression.variable("symbol")).orderBy(Expression.variable("avgPrice")).limit(Expression.value(true)));
}
Aggregations