Examples with Query org.wso2.siddhi.query.api.execution.query.Query used on opensource projects

Example 96 with Query

use of org.wso2.siddhi.query.api.execution.query.Query in project siddhi by wso2.

the class OrderByLimitTestCase method limitTest9.

@Test
public void limitTest9() throws InterruptedException {
    SiddhiManager siddhiManager = new SiddhiManager();
    String cseEventStream = "define stream cseEventStream (symbol string, price float, volume int);";
    String query = "" + "@info(name = 'query1') " + "from cseEventStream#window.length(4) " + "select symbol, price, volume " + "group by symbol " + "order by price " + "limit 2 " + "insert into outputStream ;";
    SiddhiAppRuntime siddhiAppRuntime = siddhiManager.createSiddhiAppRuntime(cseEventStream + query);
    siddhiAppRuntime.addCallback("query1", new QueryCallback() {

        @Override
        public void receive(long timestamp, Event[] inEvents, Event[] removeEvents) {
            EventPrinter.print(timestamp, inEvents, removeEvents);
            Assert.assertEquals(1, inEvents.length);
            inEventCount = inEventCount + inEvents.length;
            eventArrived = true;
        }
    });
    InputHandler inputHandler = siddhiAppRuntime.getInputHandler("cseEventStream");
    siddhiAppRuntime.start();
    inputHandler.send(new Object[] { "IBM", 700f, 0 });
    inputHandler.send(new Object[] { "IBM", 60.5f, 1 });
    inputHandler.send(new Object[] { "WSO2", 60.5f, 2 });
    inputHandler.send(new Object[] { "XYZ", 60.5f, 3 });
    inputHandler.send(new Object[] { "IBM", 700f, 4 });
    inputHandler.send(new Object[] { "WSO2", 60.5f, 5 });
    inputHandler.send(new Object[] { "WSO2", 60.5f, 6 });
    inputHandler.send(new Object[] { "WSO2", 60.5f, 7 });
    Thread.sleep(500);
    AssertJUnit.assertEquals(8, inEventCount);
    AssertJUnit.assertTrue(eventArrived);
    siddhiAppRuntime.shutdown();
}

Example 97 with Query

use of org.wso2.siddhi.query.api.execution.query.Query in project siddhi by wso2.

the class OrderByLimitTestCase method limitTest11.

@Test
public void limitTest11() throws InterruptedException {
    SiddhiManager siddhiManager = new SiddhiManager();
    String cseEventStream = "define stream cseEventStream (symbol string, price float, volume int);";
    String query = "" + "@info(name = 'query1') " + "from cseEventStream#window.length(4) " + "select symbol, price, volume " + "order by price asc " + "limit 2 " + "insert into outputStream ;";
    SiddhiAppRuntime siddhiAppRuntime = siddhiManager.createSiddhiAppRuntime(cseEventStream + query);
    siddhiAppRuntime.addCallback("query1", new QueryCallback() {

        @Override
        public void receive(long timestamp, Event[] inEvents, Event[] removeEvents) {
            EventPrinter.print(timestamp, inEvents, removeEvents);
            Assert.assertEquals(1, inEvents.length);
            inEventCount = inEventCount + inEvents.length;
            eventArrived = true;
        }
    });
    InputHandler inputHandler = siddhiAppRuntime.getInputHandler("cseEventStream");
    siddhiAppRuntime.start();
    inputHandler.send(new Object[] { "IBM", 700f, 0 });
    inputHandler.send(new Object[] { "IBM", 60.5f, 1 });
    inputHandler.send(new Object[] { "WSO2", 60.5f, 2 });
    inputHandler.send(new Object[] { "XYZ", 60.5f, 3 });
    inputHandler.send(new Object[] { "IBM", 700f, 4 });
    inputHandler.send(new Object[] { "WSO2", 60.5f, 5 });
    inputHandler.send(new Object[] { "WSO2", 60.5f, 6 });
    inputHandler.send(new Object[] { "WSO2", 60.5f, 7 });
    Thread.sleep(500);
    AssertJUnit.assertEquals(8, inEventCount);
    AssertJUnit.assertTrue(eventArrived);
    siddhiAppRuntime.shutdown();
}

Example 98 with Query

use of org.wso2.siddhi.query.api.execution.query.Query in project siddhi by wso2.

the class OrderByLimitTestCase method limitTest3.

@Test
public void limitTest3() throws InterruptedException {
    SiddhiManager siddhiManager = new SiddhiManager();
    String cseEventStream = "define stream cseEventStream (symbol string, price float, volume int);";
    String query = "" + "@info(name = 'query1') " + "from cseEventStream#window.lengthBatch(4) " + "select symbol, sum(price) as totalPrice, volume " + "limit 2 " + "insert into outputStream ;";
    SiddhiAppRuntime siddhiAppRuntime = siddhiManager.createSiddhiAppRuntime(cseEventStream + query);
    siddhiAppRuntime.addCallback("query1", new QueryCallback() {

        @Override
        public void receive(long timestamp, Event[] inEvents, Event[] removeEvents) {
            EventPrinter.print(timestamp, inEvents, removeEvents);
            Assert.assertEquals(1, inEvents.length);
            Assert.assertTrue(inEvents[0].getData(2).equals(3) || inEvents[0].getData(2).equals(7));
            inEventCount = inEventCount + inEvents.length;
            eventArrived = true;
        }
    });
    InputHandler inputHandler = siddhiAppRuntime.getInputHandler("cseEventStream");
    siddhiAppRuntime.start();
    inputHandler.send(new Object[] { "IBM", 700f, 0 });
    inputHandler.send(new Object[] { "WSO2", 60.5f, 1 });
    inputHandler.send(new Object[] { "WSO2", 60.5f, 2 });
    inputHandler.send(new Object[] { "WSO2", 60.5f, 3 });
    inputHandler.send(new Object[] { "IBM", 700f, 4 });
    inputHandler.send(new Object[] { "WSO2", 60.5f, 5 });
    inputHandler.send(new Object[] { "WSO2", 60.5f, 6 });
    inputHandler.send(new Object[] { "WSO2", 60.5f, 7 });
    Thread.sleep(500);
    AssertJUnit.assertEquals(2, inEventCount);
    AssertJUnit.assertTrue(eventArrived);
    siddhiAppRuntime.shutdown();
}

Example 99 with Query

use of org.wso2.siddhi.query.api.execution.query.Query in project siddhi by wso2.

the class OrderByLimitTestCase method limitTest7.

@Test
public void limitTest7() throws InterruptedException {
    SiddhiManager siddhiManager = new SiddhiManager();
    String cseEventStream = "define stream cseEventStream (symbol string, price float, volume int);";
    String query = "" + "@info(name = 'query1') " + "from cseEventStream#window.lengthBatch(4) " + "select symbol, price, volume " + "group by symbol " + "order by price " + "limit 2 " + "insert into outputStream ;";
    SiddhiAppRuntime siddhiAppRuntime = siddhiManager.createSiddhiAppRuntime(cseEventStream + query);
    siddhiAppRuntime.addCallback("query1", new QueryCallback() {

        @Override
        public void receive(long timestamp, Event[] inEvents, Event[] removeEvents) {
            EventPrinter.print(timestamp, inEvents, removeEvents);
            Assert.assertEquals(2, inEvents.length);
            Assert.assertTrue(inEvents[0].getData(2).equals(1) || inEvents[0].getData(2).equals(7));
            inEventCount = inEventCount + inEvents.length;
            eventArrived = true;
        }
    });
    InputHandler inputHandler = siddhiAppRuntime.getInputHandler("cseEventStream");
    siddhiAppRuntime.start();
    inputHandler.send(new Object[] { "IBM", 700f, 0 });
    inputHandler.send(new Object[] { "IBM", 60.5f, 1 });
    inputHandler.send(new Object[] { "WSO2", 60.5f, 2 });
    inputHandler.send(new Object[] { "XYZ", 60.5f, 3 });
    inputHandler.send(new Object[] { "IBM", 700f, 4 });
    inputHandler.send(new Object[] { "WSO2", 60.5f, 5 });
    inputHandler.send(new Object[] { "WSO2", 60.5f, 6 });
    inputHandler.send(new Object[] { "WSO2", 60.5f, 7 });
    Thread.sleep(500);
    AssertJUnit.assertEquals(4, inEventCount);
    AssertJUnit.assertTrue(eventArrived);
    siddhiAppRuntime.shutdown();
}

Example 100 with Query

use of org.wso2.siddhi.query.api.execution.query.Query in project siddhi by wso2.

the class OrderByLimitTestCase method limitTest5.

@Test
public void limitTest5() throws InterruptedException {
    SiddhiManager siddhiManager = new SiddhiManager();
    String cseEventStream = "define stream cseEventStream (symbol string, price float, volume int);";
    String query = "" + "@info(name = 'query1') " + "from cseEventStream#window.lengthBatch(4) " + "select symbol, sum(volume) as totalVolume, volume, price " + "group by symbol " + "order by price, totalVolume " + "limit 2 " + "insert into outputStream ;";
    SiddhiAppRuntime siddhiAppRuntime = siddhiManager.createSiddhiAppRuntime(cseEventStream + query);
    siddhiAppRuntime.addCallback("query1", new QueryCallback() {

        @Override
        public void receive(long timestamp, Event[] inEvents, Event[] removeEvents) {
            EventPrinter.print(timestamp, inEvents, removeEvents);
            Assert.assertEquals(2, inEvents.length);
            Assert.assertTrue(inEvents[0].getData(2).equals(0) || inEvents[0].getData(2).equals(4));
            inEventCount = inEventCount + inEvents.length;
            eventArrived = true;
        }
    });
    InputHandler inputHandler = siddhiAppRuntime.getInputHandler("cseEventStream");
    siddhiAppRuntime.start();
    inputHandler.send(new Object[] { "IBM", 60.5f, 0 });
    inputHandler.send(new Object[] { "WSO2", 60.5f, 1 });
    inputHandler.send(new Object[] { "WSO2", 60.5f, 2 });
    inputHandler.send(new Object[] { "XYZ", 60.5f, 3 });
    inputHandler.send(new Object[] { "IBM", 60.5f, 4 });
    inputHandler.send(new Object[] { "WSO2", 60.5f, 5 });
    inputHandler.send(new Object[] { "WSO2", 60.5f, 6 });
    inputHandler.send(new Object[] { "WSO2", 60.5f, 7 });
    Thread.sleep(500);
    AssertJUnit.assertEquals(4, inEventCount);
    AssertJUnit.assertTrue(eventArrived);
    siddhiAppRuntime.shutdown();
}