/*
* Copyright (c) 2016, WSO2 Inc. (http://www.wso2.org) All Rights Reserved.
*
* WSO2 Inc. licenses this file to you under the Apache License,
* Version 2.0 (the "License"); you may not use this file except
* in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing,
* software distributed under the License is distributed on an
* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
* KIND, either express or implied. See the License for the
* specific language governing permissions and limitations
* under the License.
*/
package org.wso2.siddhi.extension.table.rdbms;
import org.apache.log4j.Logger;
import org.junit.Assert;
import org.junit.Before;
import org.junit.Test;
import org.wso2.siddhi.core.ExecutionPlanRuntime;
import org.wso2.siddhi.core.SiddhiManager;
import org.wso2.siddhi.core.event.Event;
import org.wso2.siddhi.core.query.output.callback.QueryCallback;
import org.wso2.siddhi.core.stream.input.InputHandler;
import org.wso2.siddhi.core.util.EventPrinter;
import java.sql.Connection;
import java.sql.SQLException;
import javax.sql.DataSource;
public class JoinRDBMSTableTestCase {
private static final Logger log = Logger.getLogger(JoinRDBMSTableTestCase.class);
private int inEventCount;
private int removeEventCount;
private boolean eventArrived;
private DataSource dataSource = new BasicDataSource();
@Before
public void init() {
inEventCount = 0;
removeEventCount = 0;
eventArrived = false;
}
@Test
public void testTableJoinQuery1() throws InterruptedException {
log.info("testTableJoinQuery1 - OUT 2");
SiddhiManager siddhiManager = new SiddhiManager();
siddhiManager.setDataSource(RDBMSTestConstants.DATA_SOURCE_NAME, dataSource);
try (Connection connection = dataSource.getConnection()) {
if (connection != null) {
DBConnectionHelper.getDBConnectionHelperInstance().clearDatabaseTable(dataSource, RDBMSTestConstants
.TABLE_NAME);
String streams = "" +
"define stream StockStream (symbol string, price float, volume long); " +
"define stream CheckStockStream (symbol string); " +
"@store(type = 'rdbms' ,datasource.name = '" + RDBMSTestConstants.DATA_SOURCE_NAME + "' " +
", table.name = '" + RDBMSTestConstants.TABLE_NAME + "') " +
"define table StockTable (symbol string, price float, volume long); ";
String query = "" +
"@info(name = 'query1') " +
"from StockStream " +
"insert into StockTable ;" +
"" +
"@info(name = 'query2') " +
"from CheckStockStream#window.length(1) join StockTable " +
"select CheckStockStream.symbol as checkSymbol, StockTable.symbol as symbol, StockTable" +
".volume as volume " +
"insert into OutputStream ;";
ExecutionPlanRuntime executionPlanRuntime = siddhiManager.createExecutionPlanRuntime(streams + query);
executionPlanRuntime.addCallback("query2", new QueryCallback() {
@Override
public void receive(long timeStamp, Event[] inEvents, Event[] removeEvents) {
EventPrinter.print(timeStamp, inEvents, removeEvents);
if (inEvents != null) {
for (Event event : inEvents) {
inEventCount++;
switch (inEventCount) {
case 1:
Assert.assertArrayEquals(new Object[]{"WSO2", "WSO2", 100l}, event.getData());
break;
case 2:
Assert.assertArrayEquals(new Object[]{"WSO2", "IBM", 10l}, event.getData());
break;
default:
Assert.assertSame(2, inEventCount);
}
}
eventArrived = true;
}
if (removeEvents != null) {
removeEventCount = removeEventCount + removeEvents.length;
}
eventArrived = true;
}
});
InputHandler stockStream = executionPlanRuntime.getInputHandler("StockStream");
InputHandler checkStockStream = executionPlanRuntime.getInputHandler("CheckStockStream");
executionPlanRuntime.start();
stockStream.send(new Object[]{"WSO2", 55.6f, 100l});
stockStream.send(new Object[]{"IBM", 75.6f, 10l});
checkStockStream.send(new Object[]{"WSO2"});
Thread.sleep(1000);
Assert.assertEquals("Number of success events", 2, inEventCount);
Assert.assertEquals("Number of remove events", 0, removeEventCount);
Assert.assertEquals("Event arrived", true, eventArrived);
executionPlanRuntime.shutdown();
}
} catch (SQLException e) {
log.info("Test case ignored due to DB connection unavailability");
}
}
@Test
public void testTableJoinQuery2() throws InterruptedException {
log.info("testTableJoinQuery2 - OUT 1");
SiddhiManager siddhiManager = new SiddhiManager();
siddhiManager.setDataSource(RDBMSTestConstants.DATA_SOURCE_NAME, dataSource);
try (Connection connection = dataSource.getConnection()) {
if (connection != null) {
DBConnectionHelper.getDBConnectionHelperInstance().clearDatabaseTable(dataSource, RDBMSTestConstants
.TABLE_NAME);
String streams = "" +
"define stream StockStream (symbol string, price float, volume long); " +
"define stream CheckStockStream (symbol string); " +
"@store(type = 'rdbms' ,datasource.name = '" + RDBMSTestConstants.DATA_SOURCE_NAME + "' " +
", table.name = '" + RDBMSTestConstants.TABLE_NAME + "') " +
"define table StockTable (symbol string, price float, volume long); ";
String query = "" +
"@info(name = 'query1') " +
"from StockStream " +
"insert into StockTable ;" +
"" +
"@info(name = 'query2') " +
"from CheckStockStream#window.length(1) join StockTable " +
" on CheckStockStream.symbol==StockTable.symbol " +
"select CheckStockStream.symbol as checkSymbol, StockTable.symbol as symbol, StockTable" +
".volume as volume " +
"insert into OutputStream ;";
ExecutionPlanRuntime executionPlanRuntime = siddhiManager.createExecutionPlanRuntime(streams + query);
executionPlanRuntime.addCallback("query2", new QueryCallback() {
@Override
public void receive(long timeStamp, Event[] inEvents, Event[] removeEvents) {
EventPrinter.print(timeStamp, inEvents, removeEvents);
if (inEvents != null) {
for (Event event : inEvents) {
inEventCount++;
switch (inEventCount) {
case 1:
Assert.assertArrayEquals(new Object[]{"WSO2", "WSO2", 100l}, event.getData());
break;
default:
Assert.assertSame(1, inEventCount);
}
}
eventArrived = true;
}
if (removeEvents != null) {
removeEventCount = removeEventCount + removeEvents.length;
}
eventArrived = true;
}
});
InputHandler stockStream = executionPlanRuntime.getInputHandler("StockStream");
InputHandler checkStockStream = executionPlanRuntime.getInputHandler("CheckStockStream");
executionPlanRuntime.start();
stockStream.send(new Object[]{"WSO2", 55.6f, 100l});
stockStream.send(new Object[]{"IBM", 75.6f, 10l});
checkStockStream.send(new Object[]{"WSO2"});
Thread.sleep(1000);
Assert.assertEquals("Number of success events", 1, inEventCount);
Assert.assertEquals("Number of remove events", 0, removeEventCount);
Assert.assertEquals("Event arrived", true, eventArrived);
executionPlanRuntime.shutdown();
}
} catch (SQLException e) {
log.info("Test case ignored due to DB connection unavailability");
}
}
@Test
public void testTableJoinQuery3() throws InterruptedException {
log.info("testTableJoinQuery3 - OUT 1");
SiddhiManager siddhiManager = new SiddhiManager();
siddhiManager.setDataSource(RDBMSTestConstants.DATA_SOURCE_NAME, dataSource);
try (Connection connection = dataSource.getConnection()) {
if (connection != null) {
DBConnectionHelper.getDBConnectionHelperInstance().clearDatabaseTable(dataSource, RDBMSTestConstants
.TABLE_NAME);
String streams = "" +
"define stream StockStream (symbol string, price float, volume long); " +
"define stream CheckStockStream (symbol1 string); " +
"@store(type = 'rdbms' ,datasource.name = '" + RDBMSTestConstants.DATA_SOURCE_NAME + "' " +
", table.name = '" + RDBMSTestConstants.TABLE_NAME + "') " +
"define table StockTable (symbol string, price float, volume long); ";
String query = "" +
"@info(name = 'query1') " +
"from StockStream " +
"insert into StockTable ;" +
"" +
"@info(name = 'query2') " +
"from CheckStockStream#window.length(1) join StockTable " +
" on symbol1== symbol " +
"select symbol1 as checkSymbol, symbol as symbol, volume as volume " +
"insert into OutputStream ;";
ExecutionPlanRuntime executionPlanRuntime = siddhiManager.createExecutionPlanRuntime(streams + query);
executionPlanRuntime.addCallback("query2", new QueryCallback() {
@Override
public void receive(long timeStamp, Event[] inEvents, Event[] removeEvents) {
EventPrinter.print(timeStamp, inEvents, removeEvents);
if (inEvents != null) {
for (Event event : inEvents) {
inEventCount++;
switch (inEventCount) {
case 1:
Assert.assertArrayEquals(new Object[]{"WSO2", "WSO2", 100l}, event.getData());
break;
default:
Assert.assertSame(1, inEventCount);
}
}
eventArrived = true;
}
if (removeEvents != null) {
removeEventCount = removeEventCount + removeEvents.length;
}
eventArrived = true;
}
});
InputHandler stockStream = executionPlanRuntime.getInputHandler("StockStream");
InputHandler checkStockStream = executionPlanRuntime.getInputHandler("CheckStockStream");
executionPlanRuntime.start();
stockStream.send(new Object[]{"WSO2", 55.6f, 100l});
stockStream.send(new Object[]{"IBM", 75.6f, 10l});
checkStockStream.send(new Object[]{"WSO2"});
Thread.sleep(1000);
Assert.assertEquals("Number of success events", 1, inEventCount);
Assert.assertEquals("Number of remove events", 0, removeEventCount);
Assert.assertEquals("Event arrived", true, eventArrived);
executionPlanRuntime.shutdown();
}
} catch (SQLException e) {
log.info("Test case ignored due to DB connection unavailability");
}
}
@Test
public void testTableJoinQuery4() throws InterruptedException {
log.info("testTableJoinQuery4 - OUT 1");
SiddhiManager siddhiManager = new SiddhiManager();
siddhiManager.setDataSource(RDBMSTestConstants.DATA_SOURCE_NAME, dataSource);
try (Connection connection = dataSource.getConnection()) {
if (connection != null) {
DBConnectionHelper.getDBConnectionHelperInstance().clearDatabaseTable(dataSource, RDBMSTestConstants
.TABLE_NAME);
String streams = "" +
"define stream StockStream (symbol string, price float, volume long); " +
"define stream CheckStockStream (symbol string); " +
"@store(type = 'rdbms' ,datasource.name = '" + RDBMSTestConstants.DATA_SOURCE_NAME + "' " +
", table.name = '" + RDBMSTestConstants.TABLE_NAME + "') " +
"define table StockTable (symbol string, price float, volume long); ";
String query = "" +
"@info(name = 'query1') " +
"from StockStream " +
"insert into StockTable ;" +
"" +
"@info(name = 'query2') " +
"from CheckStockStream#window.length(1) as c join StockTable as s " +
" on c.symbol==s.symbol " +
"select c.symbol as checkSymbol, s.symbol as symbol, s.volume as volume " +
"insert into OutputStream ;";
ExecutionPlanRuntime executionPlanRuntime = siddhiManager.createExecutionPlanRuntime(streams + query);
executionPlanRuntime.addCallback("query2", new QueryCallback() {
@Override
public void receive(long timeStamp, Event[] inEvents, Event[] removeEvents) {
EventPrinter.print(timeStamp, inEvents, removeEvents);
if (inEvents != null) {
for (Event event : inEvents) {
inEventCount++;
switch (inEventCount) {
case 1:
Assert.assertArrayEquals(new Object[]{"WSO2", "WSO2", 100l}, event.getData());
break;
default:
Assert.assertSame(1, inEventCount);
}
}
eventArrived = true;
}
if (removeEvents != null) {
removeEventCount = removeEventCount + removeEvents.length;
}
eventArrived = true;
}
});
InputHandler stockStream = executionPlanRuntime.getInputHandler("StockStream");
InputHandler checkStockStream = executionPlanRuntime.getInputHandler("CheckStockStream");
executionPlanRuntime.start();
stockStream.send(new Object[]{"WSO2", 55.6f, 100l});
stockStream.send(new Object[]{"IBM", 75.6f, 10l});
checkStockStream.send(new Object[]{"WSO2"});
Thread.sleep(1000);
Assert.assertEquals("Number of success events", 1, inEventCount);
Assert.assertEquals("Number of remove events", 0, removeEventCount);
Assert.assertEquals("Event arrived", true, eventArrived);
executionPlanRuntime.shutdown();
}
} catch (SQLException e) {
log.info("Test case ignored due to DB connection unavailability");
}
}
@Test
public void testTableJoinQuery5() throws InterruptedException {
log.info("testTableJoinQuery5 - OUT 1");
SiddhiManager siddhiManager = new SiddhiManager();
siddhiManager.setDataSource(RDBMSTestConstants.DATA_SOURCE_NAME, dataSource);
try (Connection connection = dataSource.getConnection()) {
if (connection != null) {
DBConnectionHelper.getDBConnectionHelperInstance().clearDatabaseTable(dataSource, RDBMSTestConstants
.TABLE_NAME);
String streams = "" +
"define stream StockStream (symbol string, price float, volume long); " +
"define stream CheckStockStream (symbol string); " +
"@store(type = 'rdbms' ,datasource.name = '" + RDBMSTestConstants.DATA_SOURCE_NAME + "' " +
", table.name = '" + RDBMSTestConstants.TABLE_NAME + "') " +
"define table StockTable (symbol string, price float, volume long); ";
String query = "" +
"@info(name = 'query1') " +
"from StockStream " +
"insert into StockTable ;" +
"" +
"@info(name = 'query2') " +
"from CheckStockStream#window.length(1) join StockTable as s " +
" on CheckStockStream.symbol==s.symbol " +
"select CheckStockStream.symbol as checkSymbol, s.symbol as symbol, s.volume as volume " +
"insert into OutputStream ;";
ExecutionPlanRuntime executionPlanRuntime = siddhiManager.createExecutionPlanRuntime(streams + query);
executionPlanRuntime.addCallback("query2", new QueryCallback() {
@Override
public void receive(long timeStamp, Event[] inEvents, Event[] removeEvents) {
EventPrinter.print(timeStamp, inEvents, removeEvents);
if (inEvents != null) {
for (Event event : inEvents) {
inEventCount++;
switch (inEventCount) {
case 1:
Assert.assertArrayEquals(new Object[]{"WSO2", "WSO2", 100l}, event.getData());
break;
default:
Assert.assertSame(1, inEventCount);
}
}
eventArrived = true;
}
if (removeEvents != null) {
removeEventCount = removeEventCount + removeEvents.length;
}
eventArrived = true;
}
});
InputHandler stockStream = executionPlanRuntime.getInputHandler("StockStream");
InputHandler checkStockStream = executionPlanRuntime.getInputHandler("CheckStockStream");
executionPlanRuntime.start();
stockStream.send(new Object[]{"WSO2", 55.6f, 100l});
stockStream.send(new Object[]{"IBM", 75.6f, 10l});
checkStockStream.send(new Object[]{"WSO2"});
Thread.sleep(1000);
Assert.assertEquals("Number of success events", 1, inEventCount);
Assert.assertEquals("Number of remove events", 0, removeEventCount);
Assert.assertEquals("Event arrived", true, eventArrived);
executionPlanRuntime.shutdown();
}
} catch (SQLException e) {
log.info("Test case ignored due to DB connection unavailability");
}
}
@Test
public void testTableJoinQuery6() throws InterruptedException {
log.info("testTableJoinQuery6 - OUT 1");
SiddhiManager siddhiManager = new SiddhiManager();
siddhiManager.setDataSource(RDBMSTestConstants.DATA_SOURCE_NAME, dataSource);
try (Connection connection = dataSource.getConnection()) {
if (connection != null) {
DBConnectionHelper.getDBConnectionHelperInstance().clearDatabaseTable(dataSource, RDBMSTestConstants
.TABLE_NAME);
String streams = "" +
"define stream StockStream (symbol string, price float, volume long); " +
"define stream CheckStockStream (symbol string); " +
"@store(type = 'rdbms' ,datasource.name = '" + RDBMSTestConstants.DATA_SOURCE_NAME + "' " +
", table.name = '" + RDBMSTestConstants.TABLE_NAME + "', cache='lru', cache.size='1000') " +
"define table StockTable (symbol string, price float, volume long); ";
String query = "" +
"@info(name = 'query1') " +
"from StockStream " +
"insert into StockTable ;" +
"" +
"@info(name = 'query2') " +
"from CheckStockStream#window.length(1) join StockTable as s " +
" on CheckStockStream.symbol==s.symbol " +
"select CheckStockStream.symbol as checkSymbol, s.symbol as symbol, s.volume as volume " +
"insert into OutputStream ;";
ExecutionPlanRuntime executionPlanRuntime = siddhiManager.createExecutionPlanRuntime(streams + query);
executionPlanRuntime.addCallback("query2", new QueryCallback() {
@Override
public void receive(long timeStamp, Event[] inEvents, Event[] removeEvents) {
EventPrinter.print(timeStamp, inEvents, removeEvents);
if (inEvents != null) {
for (Event event : inEvents) {
inEventCount++;
switch (inEventCount) {
case 1:
Assert.assertArrayEquals(new Object[]{"WSO2", "WSO2", 100l}, event.getData());
break;
default:
Assert.assertSame(1, inEventCount);
}
}
eventArrived = true;
}
if (removeEvents != null) {
removeEventCount = removeEventCount + removeEvents.length;
}
eventArrived = true;
}
});
InputHandler stockStream = executionPlanRuntime.getInputHandler("StockStream");
InputHandler checkStockStream = executionPlanRuntime.getInputHandler("CheckStockStream");
executionPlanRuntime.start();
stockStream.send(new Object[]{"WSO2", 55.6f, 100l});
stockStream.send(new Object[]{"IBM", 75.6f, 10l});
checkStockStream.send(new Object[]{"WSO2"});
Thread.sleep(1000);
Assert.assertEquals("Number of success events", 1, inEventCount);
Assert.assertEquals("Number of remove events", 0, removeEventCount);
Assert.assertEquals("Event arrived", true, eventArrived);
executionPlanRuntime.shutdown();
}
} catch (SQLException e) {
log.info("Test case ignored due to DB connection unavailability");
}
}
@Test
public void testTableJoinQuery7() throws InterruptedException {
log.info("testTableJoinQuery7 - OUT 1");
SiddhiManager siddhiManager = new SiddhiManager();
siddhiManager.setDataSource(RDBMSTestConstants.DATA_SOURCE_NAME, dataSource);
try (Connection connection = dataSource.getConnection()) {
if (connection != null) {
DBConnectionHelper.getDBConnectionHelperInstance().clearDatabaseTable(dataSource, RDBMSTestConstants
.TABLE_NAME);
String streams = "" +
"define stream StockStream (symbol string, price float, volume long); " +
"define stream CheckStockStream (symbol string); " +
"@store(type = 'rdbms' ,datasource.name = '" + RDBMSTestConstants.DATA_SOURCE_NAME + "' " +
", table.name = '" + RDBMSTestConstants.TABLE_NAME + "') " +
"define table StockTable (symbol string, price float, volume long); ";
String query = "" +
"@info(name = 'query1') " +
"from StockStream " +
"insert into StockTable ;" +
"" +
"@info(name = 'query2') " +
"from CheckStockStream#window.length(1) join StockTable " +
" on StockTable.symbol==CheckStockStream.symbol " +
"select CheckStockStream.symbol as checkSymbol, StockTable.symbol as symbol, StockTable" +
".volume as volume " +
"insert into OutputStream ;";
ExecutionPlanRuntime executionPlanRuntime = siddhiManager.createExecutionPlanRuntime(streams + query);
executionPlanRuntime.addCallback("query2", new QueryCallback() {
@Override
public void receive(long timeStamp, Event[] inEvents, Event[] removeEvents) {
EventPrinter.print(timeStamp, inEvents, removeEvents);
if (inEvents != null) {
for (Event event : inEvents) {
inEventCount++;
switch (inEventCount) {
case 1:
Assert.assertArrayEquals(new Object[]{"WSO2", "WSO2", 100l}, event.getData());
break;
default:
Assert.assertSame(1, inEventCount);
}
}
eventArrived = true;
}
if (removeEvents != null) {
removeEventCount = removeEventCount + removeEvents.length;
}
eventArrived = true;
}
});
InputHandler stockStream = executionPlanRuntime.getInputHandler("StockStream");
InputHandler checkStockStream = executionPlanRuntime.getInputHandler("CheckStockStream");
executionPlanRuntime.start();
stockStream.send(new Object[]{"WSO2", 55.6f, 100l});
stockStream.send(new Object[]{"IBM", 75.6f, 10l});
checkStockStream.send(new Object[]{"WSO2"});
Thread.sleep(1000);
Assert.assertEquals("Number of success events", 1, inEventCount);
Assert.assertEquals("Number of remove events", 0, removeEventCount);
Assert.assertEquals("Event arrived", true, eventArrived);
executionPlanRuntime.shutdown();
}
} catch (SQLException e) {
log.info("Test case ignored due to DB connection unavailability");
}
}
@Test
public void testTableJoinQuery8() throws InterruptedException {
log.info("testTableJoinQuery8 - OUT 1");
SiddhiManager siddhiManager = new SiddhiManager();
siddhiManager.setDataSource(RDBMSTestConstants.DATA_SOURCE_NAME, dataSource);
try (Connection connection = dataSource.getConnection()) {
if (connection != null) {
DBConnectionHelper.getDBConnectionHelperInstance().clearDatabaseTable(dataSource, "table2");
String streams = "" +
"define stream StockStream (symbol string, price float); " +
"define stream CheckStockStream (symbol string); " +
"@store(type = 'rdbms' ,datasource.name = '" + RDBMSTestConstants.DATA_SOURCE_NAME + "' " +
", table.name = 'table2') " +
"define table StockTable (symbol string, price float); ";
String query = "" +
"@info(name = 'query1') " +
"from StockStream " +
"insert into StockTable ;" +
"" +
"@info(name = 'query2') " +
"from CheckStockStream#window.length(1) join StockTable " +
" on StockTable.symbol==CheckStockStream.symbol " +
"select CheckStockStream.symbol as checkSymbol, StockTable.symbol as symbol " +
"insert into OutputStream ;";
ExecutionPlanRuntime executionPlanRuntime = siddhiManager.createExecutionPlanRuntime(streams + query);
executionPlanRuntime.addCallback("query2", new QueryCallback() {
@Override
public void receive(long timeStamp, Event[] inEvents, Event[] removeEvents) {
EventPrinter.print(timeStamp, inEvents, removeEvents);
if (inEvents != null) {
for (Event event : inEvents) {
inEventCount++;
switch (inEventCount) {
case 1:
Assert.assertArrayEquals(new Object[]{"WSO2", "WSO2"}, event.getData());
break;
default:
Assert.assertSame(1, inEventCount);
}
}
eventArrived = true;
}
if (removeEvents != null) {
removeEventCount = removeEventCount + removeEvents.length;
}
eventArrived = true;
}
});
InputHandler stockStream = executionPlanRuntime.getInputHandler("StockStream");
InputHandler checkStockStream = executionPlanRuntime.getInputHandler("CheckStockStream");
executionPlanRuntime.start();
stockStream.send(new Object[]{"WSO2", 55.6f});
stockStream.send(new Object[]{"IBM", 75.6f});
checkStockStream.send(new Object[]{"WSO2"});
Thread.sleep(1000);
Assert.assertEquals("Number of success events", 1, inEventCount);
Assert.assertEquals("Number of remove events", 0, removeEventCount);
Assert.assertEquals("Event arrived", true, eventArrived);
executionPlanRuntime.shutdown();
}
} catch (SQLException e) {
log.info("Test case ignored due to DB connection unavailability");
}
}
//----------------------------------------------- Connection Properties
// ----------------------------------------------------------
@Test
public void testTableJoinQuery9() throws InterruptedException {
log.info("testTableJoinQuery9 - OUT 2");
SiddhiManager siddhiManager = new SiddhiManager();
siddhiManager.setDataSource(RDBMSTestConstants.DATA_SOURCE_NAME, dataSource);
try (Connection connection = dataSource.getConnection()) {
if (connection != null) {
DBConnectionHelper.getDBConnectionHelperInstance().clearDatabaseTable(dataSource, RDBMSTestConstants
.TABLE_NAME);
String streams = "" +
"define stream StockStream (symbol string, price float, volume long); " +
"define stream CheckStockStream (symbol string); " +
"@store(type = 'rdbms' , jdbc.url = 'jdbc:mysql://localhost:3306/cepdb' , username = " +
"'root' , password = 'root' , driver.name = 'com.mysql.jdbc.Driver' , table.name = '" +
RDBMSTestConstants.TABLE_NAME + "') " +
"@connection(maxWait = '4000')" +
"define table StockTable (symbol string, price float, volume long); ";
String query = "" +
"@info(name = 'query1') " +
"from StockStream " +
"insert into StockTable ;" +
"" +
"@info(name = 'query2') " +
"from CheckStockStream#window.length(1) join StockTable " +
"select CheckStockStream.symbol as checkSymbol, StockTable.symbol as symbol, StockTable" +
".volume as volume " +
"insert into OutputStream ;";
ExecutionPlanRuntime executionPlanRuntime = siddhiManager.createExecutionPlanRuntime(streams + query);
executionPlanRuntime.addCallback("query2", new QueryCallback() {
@Override
public void receive(long timeStamp, Event[] inEvents, Event[] removeEvents) {
EventPrinter.print(timeStamp, inEvents, removeEvents);
if (inEvents != null) {
for (Event event : inEvents) {
inEventCount++;
switch (inEventCount) {
case 1:
Assert.assertArrayEquals(new Object[]{"WSO2", "WSO2", 100l}, event.getData());
break;
case 2:
Assert.assertArrayEquals(new Object[]{"WSO2", "IBM", 10l}, event.getData());
break;
default:
Assert.assertSame(2, inEventCount);
}
}
eventArrived = true;
}
if (removeEvents != null) {
removeEventCount = removeEventCount + removeEvents.length;
}
eventArrived = true;
}
});
InputHandler stockStream = executionPlanRuntime.getInputHandler("StockStream");
InputHandler checkStockStream = executionPlanRuntime.getInputHandler("CheckStockStream");
executionPlanRuntime.start();
stockStream.send(new Object[]{"WSO2", 55.6f, 100l});
stockStream.send(new Object[]{"IBM", 75.6f, 10l});
checkStockStream.send(new Object[]{"WSO2"});
Thread.sleep(1000);
Assert.assertEquals("Number of success events", 2, inEventCount);
Assert.assertEquals("Number of remove events", 0, removeEventCount);
Assert.assertEquals("Event arrived", true, eventArrived);
executionPlanRuntime.shutdown();
}
} catch (SQLException e) {
log.info("Test case ignored due to DB connection unavailability");
}
}
}