Sample 0109 - Pizza Orders Tracker with Persistent Tables

Introduction

This sample demonstrates how to track orders and delivery information of a pizza shop. It keeps track of pizza orders and their delivery information, and to sends notifications when the delivery is done within a given time period. It uses Event Tables that facilitate storing and querying of events, and time windows for buffering events temporarily for a short time period. This sample uses wso2event as inputs and outputs.

The query used in this sample is as follows:

define table pizza_deliveries
(deliveredTime long, order_id string) from ('datasource.name'='cepSampleDataSource', 'table.name'='cepSampleTable');

Using the above query, define a table (in-memory event table) that stores two attributes named deliveredTime and order_id.

from deliveryStream 
select time, orderNo
insert into pizza_deliveries;

Insert the time and orderNo attribute values of each event received through the deliveryStream to the pizza_deliveries table defined earlier.

from orderStream#window.time(30 seconds) 
insert into overdueDeliveries for expired-events;

A separate stream named orderStream receives order information. In this sample, we buffer them for 30 seconds (in a real business scenario, the buffer time can be much longer). Then we send the buffered information out to trigger the final query (given below), which handles the actual notification. We put out only expired events to the overdueDeliveries so that the overdueDeliveries stream always receives events 30 seconds after the actual order is placed. We can use these events to trigger other queries that analyze whether the pizza is delivered within 30 seconds.

from overdueDeliveries as overdueStream unidirectional join pizza_deliveries 
on pizza_deliveries.order_id == overdueStream.orderNo 
select count(overdueStream.orderNo) as sumOrderId, overdueStream.customerName
insert into deliveredOrders;

The above query,

Joins pizza_deliveries table with the overdueDeliveries stream (the alias overdueStream is used for convenience here)
Uses a join operation to compare each event in the event table (pizza_deliveries) with each incoming event from overdueDeliveries stream
Note that,
- Events received through the overdueDeliveries arrive 30 seconds after the actual order happens
- A result of this join operation indicates (since we match the order ids) that the order is already delivered within 30 seconds
Inserts the successful delivery information to the deliveredOrders stream, which can be used to monitor the status of orders

Prerequisites

See Prerequisites in CEP Samples Setup page.

Before starting the server, you need to add the MySQL JDBC driver Download it and place the jar inside <CEP_HOME>/repository/components/lib. You also need to have MySQL installed and running before executing this sample. Create a new database in MySQL which is to be used when creating the cepSampleDataSource below.

Start the server normally and create a new data source named 'cepSampleDataSource' using the Configure --> Data Sources page in the management console. for more information on adding a datasource see Adding Datasources. Once this is done, shutdown the server. (Here cepSampleDataSource ponits to the newly created or already existing database)

Building the sample

Start the WSO2 CEP server with the sample configuration numbered 0109. For instructions, see Starting sample CEP configurations. This sample configuration does the following:

Creates <CEP_HOME>/repository/conf/data-bridge/stream-definitions.xml file, which is used to create the stream definitions for the sample.
Points the default Axis2 repo to <CEP_HOME>/sample/artifacts/0109 (by default, the Axis2 repo is <CEP_HOME>/repository/deployment/server).

Executing the sample

Open a terminal, go to <CEP_HOME>/samples/consumers/wso2-event and run ant from there.

It builds the sample wso2event consumer and executes it.

Do not close this terminal. It is required to keep the server running and receiving events.
Open another terminal, go to <CEP_HOME>/samples/producers/pizza-shop and run the following command:
```
ant pizzaPublisherClient
```
It builds and runs the wso2event producer, which sends sample pizza orders and delivery data to the CEP server.
From the terminal opened in step 2, see the details of the events sent. Note that it takes around 30 seconds to complete sending the events as we do time-based analysis in this sample.

To configure host, port, username, password and No. of events use -Dhost=xxxx -Dport=xxxx -Dusername=xxxx -Dpassword=xxxx -Devents=xx.
For example : ant -Devents=10

For example, given below is part of the console output of the consumer when sending events from the producer.

4. Log in to MySQL check the database created when setting up the sample. It should contain a new table named 'cepSampleTable' with a few events stored inside it.