use of org.ballerinalang.siddhi.query.api.execution.query.Query in project ballerina by ballerina-lang.
the class SimpleQueryTestCase method test4.
@Test
public void test4() throws SiddhiParserException {
Query query = SiddhiCompiler.parseQuery("from AllStockQuotes#window.lenghtBatch(50) " + "select symbol, avg(price) as avgPrice " + "return ;");
AssertJUnit.assertNotNull(query);
Query api = Query.query().from(InputStream.stream("AllStockQuotes").window("lenghtBatch", Expression.value(50))).select(Selector.selector().select("symbol", Expression.variable("symbol")).select("avgPrice", Expression.function("avg", Expression.variable("price")))).returns();
AssertJUnit.assertEquals(api, query);
}
use of org.ballerinalang.siddhi.query.api.execution.query.Query in project ballerina by ballerina-lang.
the class SimpleQueryTestCase method test8.
@Test
public void test8() {
Query query = SiddhiCompiler.parseQuery("from StockStream[7-9.5 > price and 100 >= volume]#window.length(50)" + "#[symbol=='WSO2'] " + "select symbol, avg(price) as avgPrice " + "group by symbol " + "having avgPrice >= 50 " + "insert into OutStockStream ;");
AssertJUnit.assertNotNull(query);
Query api = Query.query();
api.from(InputStream.stream("StockStream").filter(Expression.and(Expression.compare(Expression.subtract(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"))));
api.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))));
api.insertInto("OutStockStream");
AssertJUnit.assertEquals(api, query);
}
use of org.ballerinalang.siddhi.query.api.execution.query.Query in project ballerina by ballerina-lang.
the class SimpleQueryTestCase method test9.
@Test
public void test9() {
Query query = SiddhiCompiler.parseQuery("from StockStream[7-9.5 > price and 100 >= volume]#bar(price)#window" + ".length(50)#foo(67,89)#[10<=price] " + "select symbol, avg(price) as avgPrice " + "group by symbol " + "having avgPrice >= 50 " + "insert into OutStockStream ;");
AssertJUnit.assertNotNull(query);
Query api = Query.query();
api.from(InputStream.stream("StockStream").filter(Expression.and(Expression.compare(Expression.subtract(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")))).function("bar", Expression.variable("price")).window("length", Expression.value(50)).function("foo", Expression.value(67), Expression.value(89)).filter(Expression.compare(Expression.value(10), Compare.Operator.LESS_THAN_EQUAL, Expression.variable("price"))));
api.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))));
api.insertInto("OutStockStream");
AssertJUnit.assertEquals(api, query);
}
use of org.ballerinalang.siddhi.query.api.execution.query.Query in project ballerina by ballerina-lang.
the class SimpleQueryTestCase method testCreatingNestedFilterQuery.
// from (from StockStream[win.length(50)][ price >= 20]
// return symbol, avg(price) as avgPrice
// group by symbol) [symbol=="IBM"]
// insert into IBMOutStockStream symbol, avgPrice
@Test
public void testCreatingNestedFilterQuery() {
Query query1 = SiddhiCompiler.parseQuery("from from StockStream[StockStream.price >= 20][ StockStream.price " + "is null] " + "select symbol, avg(price) as avgPrice " + "return " + "select symbol, avgPrice " + "insert into OutStockStream ;");
AssertJUnit.assertNotNull(query1);
Query query2 = SiddhiCompiler.parseQuery("from ( from StockStream[StockStream.price >= 20][ StockStream" + ".price is null] " + "select symbol, avg(price) as avgPrice " + "return ) " + "select symbol, avgPrice " + "insert into OutStockStream ;");
AssertJUnit.assertNotNull(query2);
Query api = Query.query();
api.from(InputStream.stream(Query.query().from(InputStream.stream("StockStream").filter(Expression.compare(Expression.variable("price").ofStream("StockStream"), Compare.Operator.GREATER_THAN_EQUAL, Expression.value(20))).filter(Expression.isNull(Expression.variable("price").ofStream("StockStream")))).select(Selector.selector().select("symbol", Expression.variable("symbol")).select("avgPrice", Expression.function("avg", Expression.variable("price")))).returns()));
api.select(Selector.selector().select("symbol", Expression.variable("symbol")).select("avgPrice", Expression.variable("avgPrice")));
api.insertInto("OutStockStream");
AssertJUnit.assertEquals(api, query1);
AssertJUnit.assertEquals(api, query2);
}
use of org.ballerinalang.siddhi.query.api.execution.query.Query in project ballerina by ballerina-lang.
the class SimpleQueryTestCase method test2.
@Test
public void test2() throws SiddhiParserException {
Query query = SiddhiCompiler.parseQuery("from StockStream [price >= 20]#window.lengthBatch(50) " + "select symbol, avg(price) as avgPrice " + "group by symbol " + "having avgPrice>50 " + "insert into StockQuote; ");
AssertJUnit.assertNotNull(query);
Query api = Query.query().from(InputStream.stream("StockStream").filter(Expression.compare(Expression.variable("price"), Compare.Operator.GREATER_THAN_EQUAL, Expression.value(20))).window("lengthBatch", Expression.value(50))).select(Selector.selector().select(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, Expression.value(50)))).insertInto("StockQuote");
AssertJUnit.assertEquals(api, query);
}
Aggregations