public void RunAssertionSplitPremptiveNamedWindow(EventRepresentationEnum eventRepresentationEnum)
{
_epService.EPAdministrator.CreateEPL(eventRepresentationEnum.GetAnnotationText() + " create schema TypeTwo(col2 int)");
_epService.EPAdministrator.CreateEPL(eventRepresentationEnum.GetAnnotationText() + " create schema TypeTrigger(trigger int)");
_epService.EPAdministrator.CreateEPL(eventRepresentationEnum.GetAnnotationText() + " create window WinTwo.win:keepall() as TypeTwo");
var stmtOrigText = "on TypeTrigger " +
"insert into OtherStream select 1 " +
"insert into WinTwo(col2) select 2 " +
"output all";
_epService.EPAdministrator.CreateEPL(stmtOrigText);
var stmt = _epService.EPAdministrator.CreateEPL("on OtherStream select col2 from WinTwo");
stmt.Events += _listener.Update;
// populate WinOne
_epService.EPRuntime.SendEvent(new SupportBean("E1", 2));
// fire trigger
if (eventRepresentationEnum.IsObjectArrayEvent())
{
_epService.EPRuntime.GetEventSender("TypeTrigger").SendEvent(new Object[] { null });
}
else
{
_epService.EPRuntime.GetEventSender("TypeTrigger").SendEvent(new DataMapImpl());
}
Assert.AreEqual(2, _listener.AssertOneGetNewAndReset().Get("col2"));
_epService.Initialize();
}
public void RunAssertionEventTypeColumnDef(EventRepresentationEnum eventRepresentationEnum)
{
var stmtSchema = _epService.EPAdministrator.CreateEPL(eventRepresentationEnum.GetAnnotationText() + " create schema SchemaOne(col1 int, col2 int)");
Assert.AreEqual(eventRepresentationEnum.GetOutputClass(), stmtSchema.EventType.UnderlyingType);
var stmt = _epService.EPAdministrator.CreateEPL(eventRepresentationEnum.GetAnnotationText() + " create window SchemaWindow.std:lastevent() as (s1 SchemaOne)");
Assert.AreEqual(eventRepresentationEnum.GetOutputClass(), stmt.EventType.UnderlyingType);
stmt.AddListener(_listenerWindow);
_epService.EPAdministrator.CreateEPL("insert into SchemaWindow (s1) select sone from SchemaOne as sone");
IDictionary <String, object> theEvent = new LinkedHashMap <string, object>();
theEvent.Put("col1", 10);
theEvent.Put("col2", 11);
if (eventRepresentationEnum.IsObjectArrayEvent())
{
_epService.EPRuntime.SendEvent(theEvent.Values.ToArray(), "SchemaOne");
}
else
{
_epService.EPRuntime.SendEvent(theEvent, "SchemaOne");
}
EPAssertionUtil.AssertProps(_listenerWindow.AssertOneGetNewAndReset(), "s1.col1,s1.col2".Split(','), new object[] { 10, 11 });
_epService.EPAdministrator.DestroyAllStatements();
_epService.EPAdministrator.Configuration.RemoveEventType("SchemaOne", true);
_epService.EPAdministrator.Configuration.RemoveEventType("SchemaWindow", true);
}
public void RunAssertionCreateSchemaModelAfter(EventRepresentationEnum eventRepresentationEnum)
{
_epService.EPAdministrator.CreateEPL(eventRepresentationEnum.GetAnnotationText() + " create schema EventTypeOne (hsi int)");
_epService.EPAdministrator.CreateEPL(eventRepresentationEnum.GetAnnotationText() + " create schema EventTypeTwo (event EventTypeOne)");
var stmt = _epService.EPAdministrator.CreateEPL(eventRepresentationEnum.GetAnnotationText() + " create window NamedWindow.std:unique(event.hsi) as EventTypeTwo");
_epService.EPAdministrator.CreateEPL("on EventTypeOne as ev insert into NamedWindow select ev as event");
IDictionary <String, object> theEvent = new LinkedHashMap <string, object>();
theEvent.Put("hsi", 10);
if (eventRepresentationEnum.IsObjectArrayEvent())
{
_epService.EPRuntime.SendEvent(theEvent.Values.ToArray(), "EventTypeOne");
}
else
{
_epService.EPRuntime.SendEvent(theEvent, "EventTypeOne");
}
var result = stmt.First();
var getter = result.EventType.GetGetter("event.hsi");
Assert.AreEqual(10, getter.Get(result));
_epService.Initialize();
}
public void RunAssertionDocExample(EventRepresentationEnum eventRepresentationEnum)
{
string baseModule = eventRepresentationEnum.GetAnnotationText() + " create schema OrderEvent as (orderId string, productId string, price double, quantity int, deletedFlag boolean)";
_epService.EPAdministrator.DeploymentAdmin.ParseDeploy(baseModule, null, null, null);
string appModuleOne = eventRepresentationEnum.GetAnnotationText() + " create schema ProductTotalRec as (productId string, totalPrice double);" +
"" +
eventRepresentationEnum.GetAnnotationText() + " @Name('nwProd') create window ProductWindow.std:unique(productId) as ProductTotalRec;" +
"" +
"on OrderEvent oe\n" +
"merge ProductWindow pw\n" +
"where pw.productId = oe.productId\n" +
"when matched\n" +
"then update set totalPrice = totalPrice + oe.price\n" +
"when not matched\n" +
"then insert select productId, price as totalPrice;";
_epService.EPAdministrator.DeploymentAdmin.ParseDeploy(appModuleOne, null, null, null);
string appModuleTwo = eventRepresentationEnum.GetAnnotationText() + " @Name('nwOrd') create window OrderWindow.win:keepall() as OrderEvent;" +
"" +
"on OrderEvent oe\n" +
" merge OrderWindow pw\n" +
" where pw.orderId = oe.orderId\n" +
" when not matched \n" +
" then insert select *\n" +
" when matched and oe.deletedFlag=true\n" +
" then delete\n" +
" when matched\n" +
" then update set pw.quantity = oe.quantity, pw.price = oe.price";
_epService.EPAdministrator.DeploymentAdmin.ParseDeploy(appModuleTwo, null, null, null);
SendOrderEvent(eventRepresentationEnum, "O1", "P1", 10, 100, false);
SendOrderEvent(eventRepresentationEnum, "O1", "P1", 11, 200, false);
SendOrderEvent(eventRepresentationEnum, "O2", "P2", 3, 300, false);
EPAssertionUtil.AssertPropsPerRowAnyOrder(_epService.EPAdministrator.GetStatement("nwProd").GetEnumerator(), "productId,totalPrice".Split(','), new object[][] { new object[] { "P1", 21d }, new object[] { "P2", 3d } });
EPAssertionUtil.AssertPropsPerRowAnyOrder(_epService.EPAdministrator.GetStatement("nwOrd").GetEnumerator(), "orderId,quantity".Split(','), new object[][] { new object[] { "O1", 200 }, new object[] { "O2", 300 } });
string module = "create schema StreetCarCountSchema (streetid string, carcount int);" +
" create schema StreetChangeEvent (streetid string, action string);" +
" create window StreetCarCountWindow.std:unique(streetid) as StreetCarCountSchema;" +
" on StreetChangeEvent ce merge StreetCarCountWindow w where ce.streetid = w.streetid\n" +
" when not matched and ce.action = 'ENTER' then insert select streetid, 1 as carcount\n" +
" when matched and ce.action = 'ENTER' then update set StreetCarCountWindow.carcount = carcount + 1\n" +
" when matched and ce.action = 'LEAVE' then update set StreetCarCountWindow.carcount = carcount - 1;" +
" select * from StreetCarCountWindow;";
_epService.EPAdministrator.DeploymentAdmin.ParseDeploy(module, null, null, null);
_epService.EPAdministrator.DestroyAllStatements();
foreach (string name in "OrderEvent,OrderWindow,StreetCarCountSchema,StreetCarCountWindow,StreetChangeEvent,ProductWindow,ProductTotalRec".Split(','))
{
_epService.EPAdministrator.Configuration.RemoveEventType(name, true);
}
}
public void RunAssertionFragment(EventRepresentationEnum eventRepresentationEnum)
{
_epService.EPAdministrator.CreateEPL(
eventRepresentationEnum.GetAnnotationText()
+ " create schema InnerSchema as (key string)");
_epService.EPAdministrator.CreateEPL(
eventRepresentationEnum.GetAnnotationText()
+ " create schema MySchema as (inside InnerSchema, insidearr InnerSchema[])");
var fields = new String[] { "t0", "t1" };
String stmtText = eventRepresentationEnum.GetAnnotationText()
+ " select Typeof(s0.inside) as t0, Typeof(s0.insidearr) as t1 from MySchema as s0";
EPStatement stmt = _epService.EPAdministrator.CreateEPL(stmtText);
stmt.Events += _listener.Update;
if (eventRepresentationEnum.IsObjectArrayEvent())
{
_epService.EPRuntime.SendEvent(new Object[2], "MySchema");
}
else
{
_epService.EPRuntime.SendEvent(new Dictionary <String, Object>(),
"MySchema");
}
EPAssertionUtil.AssertProps(_listener.AssertOneGetNewAndReset(), fields, new Object[] { null, null });
if (eventRepresentationEnum.IsObjectArrayEvent())
{
_epService.EPRuntime.SendEvent(new Object[] { new Object[2], null }, "MySchema");
}
else
{
var theEvent = new Dictionary <String, Object>();
theEvent["inside"] = new Dictionary <String, Object>();
_epService.EPRuntime.SendEvent(theEvent, "MySchema");
}
EPAssertionUtil.AssertProps(_listener.AssertOneGetNewAndReset(), fields, new Object[] { "InnerSchema", null });
if (eventRepresentationEnum.IsObjectArrayEvent())
{
_epService.EPRuntime.SendEvent(new Object[] { null, new Object[2][] }, "MySchema");
}
else
{
var theEvent = new Dictionary <String, Object>();
theEvent["insidearr"] = new IDictionary <string, object> [0];
_epService.EPRuntime.SendEvent(theEvent, "MySchema");
}
EPAssertionUtil.AssertProps(_listener.AssertOneGetNewAndReset(), fields, new Object[] { null, "InnerSchema[]" });
_epService.EPAdministrator.DestroyAllStatements();
_epService.EPAdministrator.Configuration.RemoveEventType("InnerSchema", true);
_epService.EPAdministrator.Configuration.RemoveEventType("MySchema", true);
}
private void RunAssertionCreateStreamTwo(EventRepresentationEnum eventRepresentationEnum)
{
_epService.EPAdministrator.CreateEPL(
eventRepresentationEnum.GetAnnotationText()
+ " create schema MyEvent(myId int)");
_epService.EPAdministrator.CreateEPL(
eventRepresentationEnum.GetAnnotationText()
+ " create schema AllMyEvent as (myEvent MyEvent, class String, reverse boolean)");
_epService.EPAdministrator.CreateEPL(
eventRepresentationEnum.GetAnnotationText()
+ " create schema SuspectMyEvent as (myEvent MyEvent, class String)");
var stmtOne = _epService.EPAdministrator.CreateEPL(
"insert into AllMyEvent "
+ "select c as myEvent, 'test' as class, false as reverse "
+ "from MyEvent(myId=1) c");
stmtOne.Events += _listener.Update;
Assert.AreEqual(eventRepresentationEnum.GetOutputClass(),
stmtOne.EventType.UnderlyingType);
var stmtTwo = _epService.EPAdministrator.CreateEPL(
"insert into SuspectMyEvent "
+ "select c.myEvent as myEvent, class "
+ "from AllMyEvent(not reverse) c");
var listenerTwo = new SupportUpdateListener();
stmtTwo.Events += listenerTwo.Update;
if (eventRepresentationEnum.IsObjectArrayEvent())
{
_epService.EPRuntime.SendEvent(MakeEvent(1).Values.ToArray(), "MyEvent");
}
else
{
_epService.EPRuntime.SendEvent(MakeEvent(1), "MyEvent");
}
var resultOne = _listener.AssertOneGetNewAndReset();
Assert.IsTrue(resultOne.Get("myEvent") is EventBean);
Assert.AreEqual(1, ((EventBean)resultOne.Get("myEvent")).Get("myId"));
Assert.NotNull(stmtOne.EventType.GetFragmentType("myEvent"));
var resultTwo = listenerTwo.AssertOneGetNewAndReset();
Assert.IsTrue(resultTwo.Get("myEvent") is EventBean);
Assert.AreEqual(1, ((EventBean)resultTwo.Get("myEvent")).Get("myId"));
Assert.NotNull(stmtTwo.EventType.GetFragmentType("myEvent"));
_epService.Initialize();
}
private void RunAssertionInsertWhereOMStaggered(EventRepresentationEnum eventRepresentationEnum)
{
IDictionary <String, object> dataType = MakeMap(new object[][] { new object[] { "a", typeof(string) }, new object[] { "b", typeof(int) } });
epService.EPAdministrator.Configuration.AddEventType("MyMap", dataType);
string stmtTextCreateOne = eventRepresentationEnum.GetAnnotationText() + " create window MyWindow.win:keepall() as select a, b from MyMap";
EPStatement stmtCreateOne = epService.EPAdministrator.CreateEPL(stmtTextCreateOne);
Assert.AreEqual(eventRepresentationEnum.GetOutputClass(), stmtCreateOne.EventType.UnderlyingType);
stmtCreateOne.AddListener(listeners[0]);
// create insert into
string stmtTextInsertOne = "insert into MyWindow select a, b from MyMap";
epService.EPAdministrator.CreateEPL(stmtTextInsertOne);
// populate some data
epService.EPRuntime.SendEvent(MakeMap(new object[][] { new object[] { "a", "E1" }, new object[] { "b", 2 } }), "MyMap");
epService.EPRuntime.SendEvent(MakeMap(new object[][] { new object[] { "a", "E2" }, new object[] { "b", 10 } }), "MyMap");
epService.EPRuntime.SendEvent(MakeMap(new object[][] { new object[] { "a", "E3" }, new object[] { "b", 10 } }), "MyMap");
// create window with keep-all using OM
EPStatementObjectModel model = new EPStatementObjectModel();
eventRepresentationEnum.AddAnnotation(model);
Expression where = Expressions.Eq("b", 10);
model.CreateWindow = CreateWindowClause.Create("MyWindowTwo", View.Create("win", "keepall")).SetInsert(true).SetInsertWhereClause(where);
model.SelectClause = SelectClause.CreateWildcard();
model.FromClause = FromClause.Create(FilterStream.Create("MyWindow"));
string text = eventRepresentationEnum.GetAnnotationText() + " create window MyWindowTwo.win:keepall() as select * from MyWindow insert where b=10";
Assert.AreEqual(text.Trim(), model.ToEPL());
EPStatementObjectModel modelTwo = epService.EPAdministrator.CompileEPL(text);
Assert.AreEqual(text.Trim(), modelTwo.ToEPL());
EPStatement stmt = epService.EPAdministrator.Create(modelTwo);
EPAssertionUtil.AssertPropsPerRow(stmt.GetEnumerator(), "a,b".Split(','), new object[][] { new object[] { "E2", 10 }, new object[] { "E3", 10 } });
// test select individual fields and from an insert-from named window
stmt = epService.EPAdministrator.CreateEPL(eventRepresentationEnum.GetAnnotationText() + " create window MyWindowThree.win:keepall() as select a from MyWindowTwo insert where a = 'E2'");
EPAssertionUtil.AssertPropsPerRow(stmt.GetEnumerator(), "a".Split(','), new object[][] { new object[] { "E2" } });
epService.EPAdministrator.DestroyAllStatements();
epService.EPAdministrator.Configuration.RemoveEventType("MyWindow", true);
epService.EPAdministrator.Configuration.RemoveEventType("MyWindowTwo", true);
epService.EPAdministrator.Configuration.RemoveEventType("MyWindowThree", true);
}
public void RunAssertionNestableMapArray(EventRepresentationEnum eventRepresentationEnum)
{
EPStatement stmtInner = _epService.EPAdministrator.CreateEPL(eventRepresentationEnum.GetAnnotationText() + " create schema MyInnerType as (col1 string[], col2 int[])");
EventType inner = stmtInner.EventType;
Assert.AreEqual(typeof(string[]), inner.GetPropertyType("col1"));
Assert.IsTrue(inner.GetPropertyDescriptor("col1").IsIndexed);
Assert.AreEqual(typeof(int[]), inner.GetPropertyType("col2"));
Assert.IsTrue(inner.GetPropertyDescriptor("col2").IsIndexed);
Assert.AreEqual(eventRepresentationEnum.GetOutputClass(), inner.UnderlyingType);
EPStatement stmtOuter = _epService.EPAdministrator.CreateEPL(eventRepresentationEnum.GetAnnotationText() + " create schema MyOuterType as (col1 MyInnerType, col2 MyInnerType[])");
FragmentEventType type = stmtOuter.EventType.GetFragmentType("col1");
Assert.AreEqual("MyInnerType", type.FragmentType.Name);
Assert.IsFalse(type.IsIndexed);
Assert.IsFalse(type.IsNative);
type = stmtOuter.EventType.GetFragmentType("col2");
Assert.AreEqual("MyInnerType", type.FragmentType.Name);
Assert.IsTrue(type.IsIndexed);
Assert.IsFalse(type.IsNative);
EPStatement stmtSelect = _epService.EPAdministrator.CreateEPL("select * from MyOuterType");
stmtSelect.Events += _listener.Update;
Assert.AreEqual(eventRepresentationEnum.GetOutputClass(), stmtSelect.EventType.UnderlyingType);
if (eventRepresentationEnum.IsObjectArrayEvent())
{
Object[] innerData = { "abc,def".Split(','), new int[] { 1, 2 } };
Object[] outerData = { innerData, new Object[] { innerData, innerData } };
_epService.EPRuntime.SendEvent(outerData, "MyOuterType");
}
else
{
IDictionary <String, Object> innerData = new Dictionary <String, Object>();
innerData.Put("col1", "abc,def".Split(','));
innerData.Put("col2", new int[] { 1, 2 });
IDictionary <String, Object> outerData = new Dictionary <String, Object>();
outerData.Put("col1", innerData);
outerData.Put("col2", new DataMap[] { innerData, innerData });
_epService.EPRuntime.SendEvent(outerData, "MyOuterType");
}
EPAssertionUtil.AssertProps(_listener.AssertOneGetNewAndReset(), "col1.col1[1],col2[1].col2[1]".Split(','), new Object[] { "def", 2 });
_epService.EPAdministrator.Configuration.RemoveEventType("MyInnerType", true);
_epService.EPAdministrator.Configuration.RemoveEventType("MyOuterType", true);
_epService.EPAdministrator.DestroyAllStatements();
}
private void RunAssertionObjectArrayDelivery(EventRepresentationEnum eventRepresentationEnum)
{
var subscriber = new MySubscriberRowByRowObjectArr();
EPStatement stmt = _epService.EPAdministrator.CreateEPL(
eventRepresentationEnum.GetAnnotationText()
+ " select TheString, IntPrimitive from SupportBean.std:unique(TheString)");
stmt.Subscriber = subscriber;
Assert.AreEqual(eventRepresentationEnum.GetOutputClass(),
stmt.EventType.UnderlyingType);
_epService.EPRuntime.SendEvent(new SupportBean("E1", 1));
EPAssertionUtil.AssertEqualsAnyOrder(
subscriber.GetAndResetIndicate()[0], new Object[]
{
"E1", 1
}
);
_epService.EPRuntime.SendEvent(new SupportBean("E2", 10));
EPAssertionUtil.AssertEqualsAnyOrder(
subscriber.GetAndResetIndicate()[0], new Object[]
{
"E2", 10
}
);
_epService.EPAdministrator.DestroyAllStatements();
}
private void RunAssertionOutputLimitNoJoin(EventRepresentationEnum eventRepresentationEnum)
{
var subscriber = new MySubscriberRowByRowSpecific();
EPStatement stmt = _epService.EPAdministrator.CreateEPL(
eventRepresentationEnum.GetAnnotationText()
+ " select TheString, IntPrimitive from SupportBean output every 2 events");
stmt.Subscriber = subscriber;
Assert.AreEqual(eventRepresentationEnum.GetOutputClass(),
stmt.EventType.UnderlyingType);
_epService.EPRuntime.SendEvent(new SupportBean("E1", 1));
Assert.AreEqual(0, subscriber.GetAndResetIndicate().Count);
_epService.EPRuntime.SendEvent(new SupportBean("E2", 2));
EPAssertionUtil.AssertEqualsExactOrder(new Object[][]
{
new Object[]
{
"E1", 1
}
,
new Object[]
{
"E2", 2
}
}
, subscriber.GetAndResetIndicate());
_epService.EPAdministrator.DestroyAllStatements();
}
private void RunAssertionWidening(EventRepresentationEnum eventRepresentationEnum)
{
var subscriber = new MySubscriberRowByRowSpecific();
EPStatement stmt = _epService.EPAdministrator.CreateEPL(
eventRepresentationEnum.GetAnnotationText()
+ " select BytePrimitive, IntPrimitive, LongPrimitive, FloatPrimitive from SupportBean(TheString='E1')");
stmt.Subscriber = subscriber;
Assert.AreEqual(eventRepresentationEnum.GetOutputClass(),
stmt.EventType.UnderlyingType);
var bean = new SupportBean();
bean.TheString = "E1";
bean.BytePrimitive = 1;
bean.IntPrimitive = 2;
bean.LongPrimitive = 3;
bean.FloatPrimitive = 4;
_epService.EPRuntime.SendEvent(bean);
EPAssertionUtil.AssertEqualsExactOrder(new Object[]
{
1, 2L, 3d, 4d
}
, subscriber.GetAndResetIndicate()[0]);
_epService.EPAdministrator.DestroyAllStatements();
}
private void RunAssertionPerformance(bool namedWindow, EventRepresentationEnum outputType)
{
string eplCreate = namedWindow ?
outputType.GetAnnotationText() + " create window MyWindow.win:keepall() as (c1 string, c2 int)" :
"create table MyWindow(c1 string primary key, c2 int)";
EPStatement stmtNamedWindow = _epService.EPAdministrator.CreateEPL(eplCreate);
Assert.AreEqual(outputType.GetOutputClass(), stmtNamedWindow.EventType.UnderlyingType);
// preload events
EPStatement stmt = _epService.EPAdministrator.CreateEPL("insert into MyWindow select TheString as c1, IntPrimitive as c2 from SupportBean");
int totalUpdated = 5000;
for (int i = 0; i < totalUpdated; i++)
{
_epService.EPRuntime.SendEvent(new SupportBean("E" + i, 0));
}
stmt.Dispose();
string epl = "on SupportBean sb merge MyWindow nw where nw.c1 = sb.TheString " +
"when matched then update set nw.c2=sb.IntPrimitive";
stmt = _epService.EPAdministrator.CreateEPL(epl);
stmt.AddListener(_mergeListener);
// prime
for (int i = 0; i < 100; i++)
{
_epService.EPRuntime.SendEvent(new SupportBean("E" + i, 1));
}
var delta = PerformanceObserver.TimeMillis(
() =>
{
for (int i = 0; i < totalUpdated; i++)
{
_epService.EPRuntime.SendEvent(new SupportBean("E" + i, 1));
}
});
// verify
IEnumerator <EventBean> events = stmtNamedWindow.GetEnumerator();
int count = 0;
while (events.MoveNext())
{
EventBean next = events.Current;
Assert.AreEqual(1, next.Get("c2"));
count++;
}
Assert.AreEqual(totalUpdated, count);
Assert.IsTrue(delta < 500, "Delta=" + delta);
_epService.EPAdministrator.DestroyAllStatements();
_epService.EPAdministrator.Configuration.RemoveEventType("MyWindow", true);
}
public void RunAssertionDispatchBackQueue(EventRepresentationEnum eventRepresentationEnum)
{
_epService.EPAdministrator.CreateEPL(eventRepresentationEnum.GetAnnotationText() + " create schema StartValueEvent as (dummy string)");
_epService.EPAdministrator.CreateEPL(eventRepresentationEnum.GetAnnotationText() + " create schema TestForwardEvent as (prop1 string)");
_epService.EPAdministrator.CreateEPL(eventRepresentationEnum.GetAnnotationText() + " create schema TestInputEvent as (dummy string)");
_epService.EPAdministrator.CreateEPL("insert into TestForwardEvent select'V1' as prop1 from TestInputEvent");
_epService.EPAdministrator.CreateEPL(eventRepresentationEnum.GetAnnotationText() + " create window NamedWin.std:unique(prop1) (prop1 string, prop2 string)");
_epService.EPAdministrator.CreateEPL("insert into NamedWin select 'V1' as prop1, 'O1' as prop2 from StartValueEvent");
_epService.EPAdministrator.CreateEPL("on TestForwardEvent update NamedWin as work set prop2 = 'U1' where work.prop1 = 'V1'");
string[] fields = "prop1,prop2".Split(',');
string eplSelect = "select irstream prop1, prop2 from NamedWin";
_epService.EPAdministrator.CreateEPL(eplSelect).AddListener(_listener);
if (eventRepresentationEnum.IsObjectArrayEvent())
{
_epService.EPRuntime.SendEvent(new object[] { "dummyValue" }, "StartValueEvent");
}
else
{
_epService.EPRuntime.SendEvent(new Dictionary <string, object>(), "StartValueEvent");
}
EPAssertionUtil.AssertProps(_listener.AssertOneGetNewAndReset(), fields, new object[] { "V1", "O1" });
if (eventRepresentationEnum.IsObjectArrayEvent())
{
_epService.EPRuntime.SendEvent(new object[] { "dummyValue" }, "TestInputEvent");
}
else
{
_epService.EPRuntime.SendEvent(new Dictionary <string, object>(), "TestInputEvent");
}
EPAssertionUtil.AssertProps(_listener.LastOldData[0], fields, new object[] { "V1", "O1" });
EPAssertionUtil.AssertProps(_listener.GetAndResetLastNewData()[0], fields, new object[] { "V1", "U1" });
_epService.Initialize();
}
public void RunAssertionInheritance(EventRepresentationEnum eventRepresentationEnum)
{
_epService.EPAdministrator.CreateEPL(
eventRepresentationEnum.GetAnnotationText()
+ " create schema BaseEvent as (b1 string)");
_epService.EPAdministrator.CreateEPL(
eventRepresentationEnum.GetAnnotationText()
+ " create schema SubEvent as (s1 string) inherits BaseEvent");
_epService.EPAdministrator.CreateEPL(
eventRepresentationEnum.GetAnnotationText()
+ " create schema OuterEvent as (bases BaseEvent[], subs SubEvent[])");
EPStatement stmt = _epService.EPAdministrator.CreateEPL(
eventRepresentationEnum.GetAnnotationText()
+ " select bases.union(subs) as val from OuterEvent");
stmt.Events += _listener.Update;
if (eventRepresentationEnum.IsObjectArrayEvent())
{
_epService.EPRuntime.SendEvent(
new Object[] {
new Object[][] { new Object[] { "b10" } },
new Object[][] { new Object[] { "b10", "s10" } }
}, "OuterEvent");
}
else
{
IDictionary <String, Object> baseEvent = MakeMap("b1", "b10");
IDictionary <String, Object> subEvent = MakeMap("s1", "s10");
IDictionary <String, Object> outerEvent = MakeMap(
"bases", new Map[] { baseEvent },
"subs", new Map[] { subEvent });
_epService.EPRuntime.SendEvent(outerEvent, "OuterEvent");
}
var result = (ICollection <object>)_listener.AssertOneGetNewAndReset().Get("val");
Assert.AreEqual(2, result.Count);
_epService.Initialize();
}
private void RunAssertionScoringUseCase(EventRepresentationEnum eventRepresentationEnum)
{
var fields = "userId,keyword,sumScore".Split(',');
var epl =
eventRepresentationEnum.GetAnnotationText() + " create schema ScoreCycle (userId string, keyword string, productId string, score long);\n" +
eventRepresentationEnum.GetAnnotationText() + " create schema UserKeywordTotalStream (userId string, keyword string, sumScore long);\n" +
"\n" +
eventRepresentationEnum.GetAnnotationText() + " create context HashByUserCtx as " +
"coalesce by Consistent_hash_crc32(userId) from ScoreCycle, " +
"consistent_hash_crc32(userId) from UserKeywordTotalStream " +
"granularity 1000000;\n" +
"\n" +
"context HashByUserCtx create window ScoreCycleWindow.std:unique(productId, keyword) as ScoreCycle;\n" +
"\n" +
"context HashByUserCtx insert into ScoreCycleWindow select * from ScoreCycle;\n" +
"\n" +
"@Name('outOne') context HashByUserCtx insert into UserKeywordTotalStream \n" +
"select userId, keyword, Sum(score) as sumScore from ScoreCycleWindow group by keyword;\n" +
"\n" +
"@Name('outTwo') context HashByUserCtx on UserKeywordTotalStream(sumScore > 10000) delete from ScoreCycleWindow;\n";
_epService.EPAdministrator.DeploymentAdmin.ParseDeploy(epl);
_epService.EPAdministrator.GetStatement("outOne").Events += _listener.Update;
MakeSendScoreEvent("ScoreCycle", eventRepresentationEnum, "Pete", "K1", "P1", 100);
EPAssertionUtil.AssertProps(_listener.AssertOneGetNewAndReset(), fields, new Object[] { "Pete", "K1", 100L });
MakeSendScoreEvent("ScoreCycle", eventRepresentationEnum, "Pete", "K1", "P2", 15);
EPAssertionUtil.AssertProps(_listener.AssertOneGetNewAndReset(), fields, new Object[] { "Pete", "K1", 115L });
MakeSendScoreEvent("ScoreCycle", eventRepresentationEnum, "Joe", "K1", "P2", 30);
EPAssertionUtil.AssertProps(_listener.AssertOneGetNewAndReset(), fields, new Object[] { "Joe", "K1", 30L });
MakeSendScoreEvent("ScoreCycle", eventRepresentationEnum, "Joe", "K2", "P1", 40);
EPAssertionUtil.AssertProps(_listener.AssertOneGetNewAndReset(), fields, new Object[] { "Joe", "K2", 40L });
MakeSendScoreEvent("ScoreCycle", eventRepresentationEnum, "Joe", "K1", "P1", 20);
EPAssertionUtil.AssertProps(_listener.AssertOneGetNewAndReset(), fields, new Object[] { "Joe", "K1", 50L });
_epService.Initialize();
}
private void RunAssertionMapTranspose(EventRepresentationEnum eventRepresentationEnum)
{
IDictionary <String, object> innerTypeOne = new Dictionary <string, object>();
innerTypeOne.Put("i1", typeof(int));
IDictionary <String, object> innerTypeTwo = new Dictionary <string, object>();
innerTypeTwo.Put("i2", typeof(int));
IDictionary <String, object> outerType = new Dictionary <string, object>();
outerType.Put("one", "T1");
outerType.Put("two", "T2");
_epService.EPAdministrator.Configuration.AddEventType("T1", innerTypeOne);
_epService.EPAdministrator.Configuration.AddEventType("T2", innerTypeTwo);
_epService.EPAdministrator.Configuration.AddEventType("OuterType", outerType);
// create window
var stmtTextCreate = eventRepresentationEnum.GetAnnotationText() + " create window MyWindow.win:keepall() as select one, two from OuterType";
var stmtCreate = _epService.EPAdministrator.CreateEPL(stmtTextCreate);
Assert.AreEqual(eventRepresentationEnum.GetOutputClass(), stmtCreate.EventType.UnderlyingType);
stmtCreate.AddListener(_listenerWindow);
EPAssertionUtil.AssertEqualsAnyOrder(stmtCreate.EventType.PropertyNames, new string[] { "one", "two" });
var eventType = stmtCreate.EventType;
Assert.AreEqual("T1", eventType.GetFragmentType("one").FragmentType.Name);
Assert.AreEqual("T2", eventType.GetFragmentType("two").FragmentType.Name);
// create insert into
var stmtTextInsertOne = "insert into MyWindow select one, two from OuterType";
_epService.EPAdministrator.CreateEPL(stmtTextInsertOne);
IDictionary <String, object> innerDataOne = new Dictionary <string, object>();
innerDataOne.Put("i1", 1);
IDictionary <String, object> innerDataTwo = new Dictionary <string, object>();
innerDataTwo.Put("i2", 2);
IDictionary <String, object> outerData = new Dictionary <string, object>();
outerData.Put("one", innerDataOne);
outerData.Put("two", innerDataTwo);
_epService.EPRuntime.SendEvent(outerData, "OuterType");
EPAssertionUtil.AssertProps(_listenerWindow.AssertOneGetNewAndReset(), "one.i1,two.i2".Split(','), new object[] { 1, 2 });
_epService.EPAdministrator.DestroyAllStatements();
_epService.EPAdministrator.Configuration.RemoveEventType("MyWindow", true);
}
private void RunAssertionObjectArrayDelivery(EventRepresentationEnum eventRepresentationEnum, SupportSubscriberRowByRowObjectArrayBase subscriber)
{
var stmt = _epService.EPAdministrator.CreateEPL(eventRepresentationEnum.GetAnnotationText() + " select TheString, IntPrimitive from SupportBean.std:unique(TheString)");
stmt.Subscriber = subscriber;
Assert.AreEqual(eventRepresentationEnum.GetOutputClass(), stmt.EventType.UnderlyingType);
_epService.EPRuntime.SendEvent(new SupportBean("E1", 1));
subscriber.AssertOneAndReset(stmt, new object[] { "E1", 1 });
_epService.EPRuntime.SendEvent(new SupportBean("E2", 10));
subscriber.AssertOneAndReset(stmt, new object[] { "E2", 10 });
stmt.Dispose();
}
private void RunAssertionOutputLimitNoJoin(EventRepresentationEnum eventRepresentationEnum, SupportSubscriberRowByRowSpecificBase subscriber)
{
var stmt = _epService.EPAdministrator.CreateEPL(eventRepresentationEnum.GetAnnotationText() + " select TheString, IntPrimitive from SupportBean output every 2 events");
stmt.Subscriber = subscriber;
Assert.AreEqual(eventRepresentationEnum.GetOutputClass(), stmt.EventType.UnderlyingType);
_epService.EPRuntime.SendEvent(new SupportBean("E1", 1));
subscriber.AssertNoneReceived();
_epService.EPRuntime.SendEvent(new SupportBean("E2", 2));
subscriber.AssertMultipleReceivedAndReset(stmt, new object[][] { new object[] { "E1", 1 }, new object[] { "E2", 2 } });
stmt.Dispose();
}
private void RunAssertionCreateStream(EventRepresentationEnum eventRepresentationEnum)
{
_epService.EPAdministrator.CreateEPL(
eventRepresentationEnum.GetAnnotationText()
+ " create schema MyEvent(myId int)");
_epService.EPAdministrator.CreateEPL(
eventRepresentationEnum.GetAnnotationText()
+ " create schema CompositeEvent(c1 MyEvent, c2 MyEvent, rule string)");
_epService.EPAdministrator.CreateEPL(
"insert into MyStream select c, 'additionalValue' as value from MyEvent c");
_epService.EPAdministrator.CreateEPL(
"insert into CompositeEvent select e1.c as c1, e2.c as c2, '4' as rule "
+ "from pattern [e1=MyStream -> e2=MyStream]");
_epService.EPAdministrator.CreateEPL(
eventRepresentationEnum.GetAnnotationText()
+ " @Name('Target') select * from CompositeEvent");
_epService.EPAdministrator.GetStatement("Target").Events += _listener.Update;
if (eventRepresentationEnum.IsObjectArrayEvent())
{
_epService.EPRuntime.SendEvent(MakeEvent(10).Values.ToArray(), "MyEvent");
_epService.EPRuntime.SendEvent(MakeEvent(11).Values.ToArray(), "MyEvent");
}
else
{
_epService.EPRuntime.SendEvent(MakeEvent(10), "MyEvent");
_epService.EPRuntime.SendEvent(MakeEvent(11), "MyEvent");
}
var theEvent = _listener.AssertOneGetNewAndReset();
Assert.AreEqual(10, theEvent.Get("c1.myId"));
Assert.AreEqual(11, theEvent.Get("c2.myId"));
Assert.AreEqual("4", theEvent.Get("rule"));
_epService.Initialize();
}
private void RunAssertionInnerJoinLateStart(EventRepresentationEnum eventRepresentationEnum)
{
var stmtOne = _epService.EPAdministrator.CreateEPL(eventRepresentationEnum.GetAnnotationText() + " create schema Product (product string, size int)");
Assert.AreEqual(eventRepresentationEnum.GetOutputClass(), stmtOne.EventType.UnderlyingType);
_epService.EPAdministrator.CreateEPL(eventRepresentationEnum.GetAnnotationText() + " create schema Portfolio (portfolio string, product string)");
var stmtTwo = _epService.EPAdministrator.CreateEPL(eventRepresentationEnum.GetAnnotationText() + " create window ProductWin.win:keepall() as Product");
Assert.AreEqual(eventRepresentationEnum.GetOutputClass(), stmtTwo.EventType.UnderlyingType);
_epService.EPAdministrator.CreateEPL("insert into ProductWin select * from Product");
_epService.EPAdministrator.CreateEPL(eventRepresentationEnum.GetAnnotationText() + " create window PortfolioWin.win:keepall() as Portfolio");
_epService.EPAdministrator.CreateEPL("insert into PortfolioWin select * from Portfolio");
SendProduct(eventRepresentationEnum, "productA", 1);
SendProduct(eventRepresentationEnum, "productB", 2);
SendPortfolio(eventRepresentationEnum, "Portfolio", "productA");
var stmtText = "@Name(\"Query2\") select portfolio, ProductWin.product, size " +
"from PortfolioWin unidirectional inner join ProductWin on PortfolioWin.product=ProductWin.product";
var stmt = _epService.EPAdministrator.CreateEPL(stmtText);
stmt.AddListener(_listenerStmtOne);
SendPortfolio(eventRepresentationEnum, "Portfolio", "productB");
EPAssertionUtil.AssertProps(_listenerStmtOne.AssertOneGetNewAndReset(), new string[] { "portfolio", "ProductWin.product", "size" }, new object[] { "Portfolio", "productB", 2 });
SendPortfolio(eventRepresentationEnum, "Portfolio", "productC");
_listenerStmtOne.Reset();
SendProduct(eventRepresentationEnum, "productC", 3);
SendPortfolio(eventRepresentationEnum, "Portfolio", "productC");
EPAssertionUtil.AssertProps(_listenerStmtOne.AssertOneGetNewAndReset(), new string[] { "portfolio", "ProductWin.product", "size" }, new object[] { "Portfolio", "productC", 3 });
_epService.Initialize();
}
private void RunAssertionGetDynamicWObjectArr(EventRepresentationEnum eventRepresentationEnum)
{
String stmtText = eventRepresentationEnum.GetAnnotationText()
+ " select item.id? as myid from "
+ typeof (SupportBeanDynRoot).FullName;
using (var stmt = _epService.EPAdministrator.CreateEPL(stmtText))
{
stmt.Events += _listener.Update;
// check type
Assert.AreEqual(typeof (object), stmt.EventType.GetPropertyType("myid"));
// check value with an object that has the property as an int
var runtime = _epService.EPRuntime;
runtime.SendEvent(
new SupportBeanDynRoot(new SupportBean_S0(101)));
Assert.AreEqual(101, _listener.AssertOneGetNewAndReset().Get("myid"));
// check value with an object that doesn't have the property
runtime.SendEvent(new SupportBeanDynRoot("abc"));
Assert.AreEqual(null, _listener.AssertOneGetNewAndReset().Get("myid"));
// check value with an object that has the property as a string
runtime.SendEvent(
new SupportBeanDynRoot(new SupportBean_A("e1")));
Assert.AreEqual("e1", _listener.AssertOneGetNewAndReset().Get("myid"));
runtime.SendEvent(
new SupportBeanDynRoot(new SupportBean_B("e2")));
Assert.AreEqual("e2", _listener.AssertOneGetNewAndReset().Get("myid"));
runtime.SendEvent(
new SupportBeanDynRoot(new SupportBean_S1(102)));
Assert.AreEqual(102, _listener.AssertOneGetNewAndReset().Get("myid"));
if (eventRepresentationEnum.IsObjectArrayEvent())
{
Assert.AreEqual(typeof (object[]), stmt.EventType.UnderlyingType);
}
else
{
Assert.AreEqual(typeof (IDictionary<string, object>), stmt.EventType.UnderlyingType);
}
}
}
private void RunAssertionWidening(EventRepresentationEnum eventRepresentationEnum, SupportSubscriberRowByRowSpecificBase subscriber)
{
var stmt = _epService.EPAdministrator.CreateEPL(eventRepresentationEnum.GetAnnotationText() + " select BytePrimitive, IntPrimitive, LongPrimitive, FloatPrimitive from SupportBean(TheString='E1')");
stmt.Subscriber = subscriber;
Assert.AreEqual(eventRepresentationEnum.GetOutputClass(), stmt.EventType.UnderlyingType);
var bean = new SupportBean();
bean.TheString = "E1";
bean.BytePrimitive = (byte)1;
bean.IntPrimitive = 2;
bean.LongPrimitive = 3;
bean.FloatPrimitive = 4;
_epService.EPRuntime.SendEvent(bean);
subscriber.AssertOneReceivedAndReset(stmt, new object[] { 1, 2L, 3d, 4d });
stmt.Dispose();
}
private void RunAssertionNamedWindow(EventRepresentationEnum eventRepresentationEnum)
{
String[] fields = "key,value".Split(',');
SubscriberMap subscriberNamedWindow = new SubscriberMap();
String stmtTextCreate = eventRepresentationEnum.GetAnnotationText()
+ " create window MyWindow.win:keepall() as select TheString as key, IntPrimitive as value from SupportBean";
EPStatement stmt = _epService.EPAdministrator.CreateEPL(stmtTextCreate);
stmt.Subscriber = subscriberNamedWindow;
SubscriberFields subscriberInsertInto = new SubscriberFields();
String stmtTextInsertInto = "insert into MyWindow select TheString as key, IntPrimitive as value from SupportBean";
stmt = _epService.EPAdministrator.CreateEPL(stmtTextInsertInto);
stmt.Subscriber = subscriberInsertInto;
_epService.EPRuntime.SendEvent(new SupportBean("E1", 1));
EPAssertionUtil.AssertPropsMap(subscriberNamedWindow.GetAndResetIndicate()[0], fields, new Object[] { "E1", 1 });
EPAssertionUtil.AssertEqualsExactOrder(new Object[][] { new Object[] { "E1", 1 } }, subscriberInsertInto.GetAndResetIndicate());
// test on-delete
SubscriberMap subscriberDelete = new SubscriberMap();
String stmtTextDelete = "on SupportMarketDataBean s0 delete from MyWindow s1 where s0.Symbol = s1.key";
stmt = _epService.EPAdministrator.CreateEPL(stmtTextDelete);
stmt.Subscriber = subscriberDelete;
_epService.EPRuntime.SendEvent(new SupportMarketDataBean("E1", 0, 1L, ""));
EPAssertionUtil.AssertPropsMap(subscriberDelete.GetAndResetIndicate()[0], fields, new Object[] { "E1", 1 });
// test on-select
SubscriberMap subscriberSelect = new SubscriberMap();
String stmtTextSelect = "on SupportMarketDataBean s0 select key, value from MyWindow s1";
stmt = _epService.EPAdministrator.CreateEPL(stmtTextSelect);
stmt.Subscriber = subscriberSelect;
_epService.EPRuntime.SendEvent(new SupportBean("E2", 2));
_epService.EPRuntime.SendEvent(new SupportMarketDataBean("M1", 0, 1L, ""));
EPAssertionUtil.AssertPropsMap(subscriberSelect.GetAndResetIndicate()[0], fields, new Object[] { "E2", 2 });
}
private void RunAssertionBindMap(EventRepresentationEnum eventRepresentationEnum, SupportSubscriberMultirowMapBase subscriber)
{
var stmtText = eventRepresentationEnum.GetAnnotationText() + " select irstream TheString, IntPrimitive from " + typeof(SupportBean).FullName + ".win:length_batch(2)";
var stmt = _epService.EPAdministrator.CreateEPL(stmtText);
stmt.Subscriber = subscriber;
Assert.AreEqual(eventRepresentationEnum.GetOutputClass(), stmt.EventType.UnderlyingType);
_epService.EPRuntime.SendEvent(new SupportBean("E1", 1));
subscriber.AssertNoneReceived();
_epService.EPRuntime.SendEvent(new SupportBean("E2", 2));
subscriber.AssertOneReceivedAndReset(stmt, _fields, new object[][] { new object[] { "E1", 1 }, new object[] { "E2", 2 } }, null);
_epService.EPRuntime.SendEvent(new SupportBean("E3", 3));
subscriber.AssertNoneReceived();
_epService.EPRuntime.SendEvent(new SupportBean("E4", 4));
subscriber.AssertOneReceivedAndReset(stmt, _fields, new object[][] { new object[] { "E3", 3 }, new object[] { "E4", 4 } }, new object[][] { new object[] { "E1", 1 }, new object[] { "E2", 2 } });
stmt.Dispose();
}
private void RunAssertionInvalid(EventRepresentationEnum eventRepresentationEnum)
{
TryInvalid(eventRepresentationEnum.GetAnnotationText() + " create schema MyEventType as (col1 xxxx)",
"Error starting statement: Nestable type configuration encountered an unexpected property type name 'xxxx' for property 'col1', expected Type or DataMap or the name of a previously-declared Map or ObjectArray type [");
TryInvalid(eventRepresentationEnum.GetAnnotationText() + " create schema MyEventType as (col1 int, col1 string)",
"Error starting statement: Duplicate column name 'col1' [");
_epService.EPAdministrator.CreateEPL(eventRepresentationEnum.GetAnnotationText() + " create schema MyEventType as (col1 string)");
TryInvalid("create schema MyEventType as (col1 string, col2 string)",
"Error starting statement: Event type named 'MyEventType' has already been declared with differing column name or type information: Type by name 'MyEventType' expects 1 properties but receives 2 properties [");
TryInvalid(eventRepresentationEnum.GetAnnotationText() + " create schema MyEventType as () inherit ABC",
"Error in expression: Expected 'inherits', 'starttimestamp', 'endtimestamp' or 'copyfrom' keyword after create-schema clause but encountered 'inherit' [");
TryInvalid(eventRepresentationEnum.GetAnnotationText() + " create schema MyEventType as () inherits ABC",
"Error starting statement: Supertype by name 'ABC' could not be found [");
TryInvalid(eventRepresentationEnum.GetAnnotationText() + " create schema MyEventType as () inherits",
"Incorrect syntax near end-of-input expecting an identifier but found end-of-input at line 1 column ");
_epService.EPAdministrator.Configuration.RemoveEventType("MyEventType", true);
}
private void RunAssertionBindObjectArr(EventRepresentationEnum eventRepresentationEnum)
{
var subscriber = new MySubscriberMultirowObjectArr();
String stmtText = eventRepresentationEnum.GetAnnotationText()
+ " select irstream TheString, IntPrimitive from "
+ typeof(SupportBean).FullName + ".win:length_batch(2)";
EPStatement stmt = _epService.EPAdministrator.CreateEPL(stmtText);
stmt.Subscriber = subscriber;
Assert.AreEqual(eventRepresentationEnum.GetOutputClass(),
stmt.EventType.UnderlyingType);
_epService.EPRuntime.SendEvent(new SupportBean("E1", 1));
Assert.AreEqual(0, subscriber.IndicateArr.Count);
_epService.EPRuntime.SendEvent(new SupportBean("E2", 2));
Assert.AreEqual(1, subscriber.IndicateArr.Count);
UniformPair <Object[][]> result = subscriber.GetAndResetIndicateArr()[0];
Assert.IsNull(result.Second);
Assert.AreEqual(2, result.First.Length);
EPAssertionUtil.AssertEqualsExactOrder(
result.First, _fields,
new Object[][]
{
new Object[]
{
"E1", 1
}
,
new Object[]
{
"E2", 2
}
}
);
_epService.EPRuntime.SendEvent(new SupportBean("E3", 3));
Assert.AreEqual(0, subscriber.IndicateArr.Count);
_epService.EPRuntime.SendEvent(new SupportBean("E4", 4));
Assert.AreEqual(1, subscriber.IndicateArr.Count);
result = subscriber.GetAndResetIndicateArr()[0];
Assert.AreEqual(2, result.First.Length);
Assert.AreEqual(2, result.Second.Length);
EPAssertionUtil.AssertEqualsExactOrder(
result.First, _fields,
new Object[][]
{
new Object[]
{
"E3", 3
}
,
new Object[]
{
"E4", 4
}
}
);
EPAssertionUtil.AssertEqualsExactOrder(
result.Second, _fields,
new Object[][]
{
new Object[]
{
"E1", 1
}
,
new Object[]
{
"E2", 2
}
}
);
_epService.EPAdministrator.DestroyAllStatements();
}
private void RunAssertionArrayMapInsert(EventRepresentationEnum eventRepresentationEnum)
{
_epService.EPAdministrator.CreateEPL(eventRepresentationEnum.GetAnnotationText() + " create schema EventOne(id string)");
_epService.EPAdministrator.CreateEPL(eventRepresentationEnum.GetAnnotationText() + " create schema EventTwo(id string, val int)");
_epService.EPAdministrator.CreateEPL(eventRepresentationEnum.GetAnnotationText() + " create schema FinalEventValid (startEvent EventOne, endEvent EventTwo[])");
_epService.EPAdministrator.CreateEPL(eventRepresentationEnum.GetAnnotationText() + " create schema FinalEventInvalidNonArray (startEvent EventOne, endEvent EventTwo)");
_epService.EPAdministrator.CreateEPL(eventRepresentationEnum.GetAnnotationText() + " create schema FinalEventInvalidArray (startEvent EventOne, endEvent EventTwo)");
_epService.EPRuntime.SendEvent(new CurrentTimeEvent(0));
// Test valid case of array insert
var validEpl = "INSERT INTO FinalEventValid SELECT s as startEvent, e as endEvent FROM PATTERN [" +
"every s=EventOne -> e=EventTwo(id=s.id) until timer:interval(10 sec)]";
var stmt = _epService.EPAdministrator.CreateEPL(validEpl);
stmt.Events += _listener.Update;
SendEventOne(_epService, eventRepresentationEnum, "G1");
SendEventTwo(_epService, eventRepresentationEnum, "G1", 2);
SendEventTwo(_epService, eventRepresentationEnum, "G1", 3);
_epService.EPRuntime.SendEvent(new CurrentTimeEvent(10000));
EventBean startEventOne;
EventBean endEventOne;
EventBean endEventTwo;
if (eventRepresentationEnum.IsObjectArrayEvent())
{
var outArray = ((Object[])_listener.AssertOneGetNewAndReset().Underlying);
startEventOne = (EventBean)outArray[0];
endEventOne = ((EventBean[])outArray[1])[0];
endEventTwo = ((EventBean[])outArray[1])[1];
}
else
{
var outMap = ((IDictionary <string, object>)_listener.AssertOneGetNewAndReset().Underlying);
startEventOne = (EventBean)outMap.Get("startEvent");
endEventOne = ((EventBean[])outMap.Get("endEvent"))[0];
endEventTwo = ((EventBean[])outMap.Get("endEvent"))[1];
}
Assert.AreEqual("G1", startEventOne.Get("id"));
Assert.AreEqual(2, endEventOne.Get("val"));
Assert.AreEqual(3, endEventTwo.Get("val"));
// Test invalid case of non-array destination insert
var invalidEpl = "INSERT INTO FinalEventInvalidNonArray SELECT s as startEvent, e as endEvent FROM PATTERN [" +
"every s=EventOne -> e=EventTwo(id=s.id) until timer:interval(10 sec)]";
try {
_epService.EPAdministrator.CreateEPL(invalidEpl);
Assert.Fail();
}
catch (EPException ex) {
Assert.AreEqual("Error starting statement: Event type named 'FinalEventInvalidNonArray' has already been declared with differing column name or type information: Type by name 'FinalEventInvalidNonArray' in property 'endEvent' expected event type 'EventTwo' but receives event type 'EventTwo[]' [INSERT INTO FinalEventInvalidNonArray SELECT s as startEvent, e as endEvent FROM PATTERN [every s=EventOne -> e=EventTwo(id=s.id) until timer:interval(10 sec)]]", ex.Message);
}
// Test invalid case of array destination insert from non-array var
var invalidEplTwo = "INSERT INTO FinalEventInvalidArray SELECT s as startEvent, e as endEvent FROM PATTERN [" +
"every s=EventOne -> e=EventTwo(id=s.id) until timer:interval(10 sec)]";
try {
_epService.EPAdministrator.CreateEPL(invalidEplTwo);
Assert.Fail();
}
catch (EPException ex) {
Assert.AreEqual("Error starting statement: Event type named 'FinalEventInvalidArray' has already been declared with differing column name or type information: Type by name 'FinalEventInvalidArray' in property 'endEvent' expected event type 'EventTwo' but receives event type 'EventTwo[]' [INSERT INTO FinalEventInvalidArray SELECT s as startEvent, e as endEvent FROM PATTERN [every s=EventOne -> e=EventTwo(id=s.id) until timer:interval(10 sec)]]", ex.Message);
}
_epService.Initialize();
}
private void RunAssertionSingleRowSplitAndType(EventRepresentationEnum eventRepresentationEnum)
{
if (eventRepresentationEnum.IsObjectArrayEvent())
{
_epService.EPAdministrator.Configuration.AddPlugInSingleRowFunction("splitSentence", GetType().FullName, "SplitSentenceMethodReturnObjectArray");
_epService.EPAdministrator.Configuration.AddPlugInSingleRowFunction("splitSentenceBean", GetType().FullName, "SplitSentenceBeanMethodReturnObjectArray");
_epService.EPAdministrator.Configuration.AddPlugInSingleRowFunction("splitWord", GetType().FullName, "SplitWordMethodReturnObjectArray");
}
else
{
_epService.EPAdministrator.Configuration.AddPlugInSingleRowFunction("splitSentence", GetType().FullName, "SplitSentenceMethodReturnMap");
_epService.EPAdministrator.Configuration.AddPlugInSingleRowFunction("splitSentenceBean", GetType().FullName, "SplitSentenceBeanMethodReturnMap");
_epService.EPAdministrator.Configuration.AddPlugInSingleRowFunction("splitWord", GetType().FullName, "SplitWordMethodReturnMap");
}
_epService.EPAdministrator.Configuration.AddPlugInSingleRowFunction("invalidSentence", GetType().FullName, "InvalidSentenceMethod");
_epService.EPAdministrator.CreateEPL(eventRepresentationEnum.GetAnnotationText() + " create schema SentenceEvent(sentence String)");
_epService.EPAdministrator.CreateEPL(eventRepresentationEnum.GetAnnotationText() + " create schema WordEvent(word String)");
_epService.EPAdministrator.CreateEPL(eventRepresentationEnum.GetAnnotationText() + " create schema CharacterEvent(char String)");
string stmtText;
EPStatement stmt;
var fields = "word".Split(',');
// test single-row method
stmtText = "select * from SentenceEvent[splitSentence(sentence)@type(WordEvent)]";
stmt = _epService.EPAdministrator.CreateEPL(stmtText);
stmt.AddListener(_listener);
Assert.AreEqual("WordEvent", stmt.EventType.Name);
Assert.AreEqual(eventRepresentationEnum.GetOutputClass(), stmt.EventType.UnderlyingType);
SendSentenceEvent(eventRepresentationEnum, "I am testing this code");
EPAssertionUtil.AssertPropsPerRow(
_listener.GetAndResetLastNewData(), fields,
new object[][]
{
new object[] { "I" },
new object[] { "am" },
new object[] { "testing" },
new object[] { "this" },
new object[] { "code" }
});
SendSentenceEvent(eventRepresentationEnum, "the second event");
EPAssertionUtil.AssertPropsPerRow(
_listener.GetAndResetLastNewData(), fields,
new object[][]
{
new object[] { "the" },
new object[] { "second" },
new object[] { "event" }
});
stmt.Dispose();
// test SODA
var model = _epService.EPAdministrator.CompileEPL(stmtText);
Assert.AreEqual(stmtText, model.ToEPL());
stmt = _epService.EPAdministrator.Create(model);
Assert.AreEqual(stmtText, stmt.Text);
stmt.AddListener(_listener);
SendSentenceEvent(eventRepresentationEnum, "the third event");
EPAssertionUtil.AssertPropsPerRow(
_listener.GetAndResetLastNewData(), fields,
new object[][]
{
new object[] { "the" },
new object[] { "third" },
new object[] { "event" }
});
stmt.Dispose();
// test script
if (!eventRepresentationEnum.IsObjectArrayEvent())
{
stmtText = "expression com.espertech.esper.support.collections.ISupportDataMapCollection js:splitSentenceJS(sentence) [" +
" var words = clr.New('com.espertech.esper.support.collections.SupportDataMapList',[]);" +
" var factory = clr.New('com.espertech.esper.support.collections.SupportDataMapFactory',[]);" +
" words.Add(factory.Create('word', 'wordOne'));" +
" words.Add(factory.Create('word', 'wordTwo'));" +
" words;" +
"]" +
"select * from SentenceEvent[splitSentenceJS(sentence)@type(WordEvent)]";
stmt = _epService.EPAdministrator.CreateEPL(stmtText).AddListener(_listener);
Assert.AreEqual("WordEvent", stmt.EventType.Name);
_epService.EPRuntime.SendEvent(Collections.EmptyDataMap, "SentenceEvent");
EPAssertionUtil.AssertPropsPerRowAnyOrder(
_listener.GetAndResetLastNewData(), fields,
new object[][]
{
new object[] { "wordOne" },
new object[] { "wordTwo" }
});
stmt.Dispose();
}
// test multiple splitters
stmtText = "select * from SentenceEvent[splitSentence(sentence)@type(WordEvent)][splitWord(word)@type(CharacterEvent)]";
stmt = _epService.EPAdministrator.CreateEPL(stmtText);
stmt.AddListener(_listener);
Assert.AreEqual("CharacterEvent", stmt.EventType.Name);
SendSentenceEvent(eventRepresentationEnum, "I am");
EPAssertionUtil.AssertPropsPerRowAnyOrder(
_listener.GetAndResetLastNewData(), "char".Split(','),
new object[][]
{
new object[] { "I" },
new object[] { "a" },
new object[] { "m" }
});
stmt.Dispose();
// test wildcard parameter
stmtText = "select * from SentenceEvent[splitSentenceBean(*)@type(WordEvent)]";
stmt = _epService.EPAdministrator.CreateEPL(stmtText);
stmt.AddListener(_listener);
Assert.AreEqual("WordEvent", stmt.EventType.Name);
SendSentenceEvent(eventRepresentationEnum, "another test sentence");
EPAssertionUtil.AssertPropsPerRowAnyOrder(
_listener.GetAndResetLastNewData(), fields,
new object[][]
{
new object[] { "another" },
new object[] { "test" },
new object[] { "sentence" }
});
stmt.Dispose();
// test property returning untyped collection
if (eventRepresentationEnum.IsObjectArrayEvent())
{
_epService.EPAdministrator.Configuration.AddEventType(typeof(ObjectArrayEvent));
stmtText = eventRepresentationEnum.GetAnnotationText() + " select * from ObjectArrayEvent[someObjectArray@type(WordEvent)]";
stmt = _epService.EPAdministrator.CreateEPL(stmtText);
stmt.AddListener(_listener);
Assert.AreEqual("WordEvent", stmt.EventType.Name);
var rows = new object[][] { new object[] { "this" }, new object[] { "is" }, new object[] { "collection" } };
_epService.EPRuntime.SendEvent(new ObjectArrayEvent(rows));
EPAssertionUtil.AssertPropsPerRow(
_listener.GetAndResetLastNewData(), fields,
new object[][]
{
new object[] { "this" },
new object[] { "is" },
new object[] { "collection" }
});
}
else
{
_epService.EPAdministrator.Configuration.AddEventType <CollectionEvent <IDictionary <string, object> > >("CollectionEvent");
stmtText = eventRepresentationEnum.GetAnnotationText() + " select * from CollectionEvent[someCollection@type(WordEvent)]";
stmt = _epService.EPAdministrator.CreateEPL(stmtText);
stmt.AddListener(_listener);
Assert.AreEqual("WordEvent", stmt.EventType.Name);
var coll = new List <IDictionary <string, object> >();
coll.Add(Collections.SingletonDataMap("word", "this"));
coll.Add(Collections.SingletonDataMap("word", "is"));
coll.Add(Collections.SingletonDataMap("word", "collection"));
_epService.EPRuntime.SendEvent(new CollectionEvent <IDictionary <string, object> >(coll));
EPAssertionUtil.AssertPropsPerRowAnyOrder(
_listener.GetAndResetLastNewData(), fields,
new object[][]
{
new object[] { "this" },
new object[] { "is" },
new object[] { "collection" }
});
}
// invalid: event type not found
TryInvalid("select * from SentenceEvent[splitSentence(sentence)@type(XYZ)]",
"Event type by name 'XYZ' could not be found [select * from SentenceEvent[splitSentence(sentence)@type(XYZ)]]");
// invalid lib-function annotation
TryInvalid("select * from SentenceEvent[splitSentence(sentence)@dummy(WordEvent)]",
"Invalid annotation for property selection, expected 'type' but found 'dummy' in text '[splitSentence(sentence)@dummy(WordEvent)]' [select * from SentenceEvent[splitSentence(sentence)@dummy(WordEvent)]]");
// invalid type assignment to event type
if (eventRepresentationEnum.IsObjectArrayEvent())
{
TryInvalid("select * from SentenceEvent[invalidSentence(sentence)@type(WordEvent)]",
"Event type 'WordEvent' underlying type System.Object[] cannot be assigned a value of type");
}
else
{
TryInvalid("select * from SentenceEvent[invalidSentence(sentence)@type(WordEvent)]",
"Event type 'WordEvent' underlying type " + Name.Of <IDictionary <string, object> >() + " cannot be assigned a value of type");
}
// invalid subquery
TryInvalid("select * from SentenceEvent[splitSentence((select * from SupportBean.win:keepall()))@type(WordEvent)]",
"Invalid contained-event expression 'splitSentence(subselect_0)': Aggregation, sub-select, previous or prior functions are not supported in this context [select * from SentenceEvent[splitSentence((select * from SupportBean.win:keepall()))@type(WordEvent)]]");
_epService.Initialize();
}
private void RunAssertionSetMapProps(EventRepresentationEnum eventRepresentationEnum)
{
// test Update-istream with bean
_epService.EPAdministrator.Configuration.AddEventType(
typeof(MyMapPropEvent));
_epService.EPAdministrator.Configuration.AddEventType(
typeof(SupportBean));
_epService.EPAdministrator.CreateEPL(
"insert into MyStream select * from MyMapPropEvent");
EPStatement stmtUpdOne = _epService.EPAdministrator.CreateEPL(
"update istream MyStream set Props('abc') = 1, Array[2] = 10");
stmtUpdOne.Events += _listener.Update;
_epService.EPRuntime.SendEvent(new MyMapPropEvent());
EPAssertionUtil.AssertProps(
_listener.AssertPairGetIRAndReset(),
"Props('abc'),Array[2]".Split(','),
new Object[]
{
1, 10
},
new Object[]
{
null, null
});
// test Update-istream with map
_epService.EPAdministrator.CreateEPL(
eventRepresentationEnum.GetAnnotationText()
+ " create schema MyMapType(Simple String, MyArray System.Object[], MyMap com.espertech.esper.support.util.QuickMap)");
EPStatement stmtUpdTwo = _epService.EPAdministrator.CreateEPL(
"Update istream MyMapType set Simple='A', MyMap('abc') = 1, MyArray[2] = 10");
stmtUpdTwo.Events += _listener.Update;
if (eventRepresentationEnum.IsObjectArrayEvent())
{
_epService.EPRuntime.SendEvent(
new Object[]
{
null, new Object[10], new Dictionary <String, Object>()
},
"MyMapType");
}
else
{
_epService.EPRuntime.SendEvent(
MakeMapEvent(new Dictionary <String, Object>(), new Object[10]),
"MyMapType");
}
EPAssertionUtil.AssertProps(
_listener.AssertPairGetIRAndReset(),
"Simple,MyMap('abc'),MyArray[2]".Split(','),
new Object[]
{
"A", 1, 10
},
new Object[]
{
null, null, null
});
// test named-window Update
_epService.EPAdministrator.CreateEPL(
eventRepresentationEnum.GetAnnotationText()
+ " create schema MyNWMapType(Simple String, MyArray System.Object[], MyMap com.espertech.esper.support.util.QuickMap)");
EPStatement stmtWin = _epService.EPAdministrator.CreateEPL(
"create window MyWindow.win:keepall() as MyNWMapType");
_epService.EPAdministrator.CreateEPL(
eventRepresentationEnum.GetAnnotationText()
+ " insert into MyWindow select * from MyNWMapType");
if (eventRepresentationEnum.IsObjectArrayEvent())
{
_epService.EPRuntime.SendEvent(
new Object[]
{
null, new Object[10], new Dictionary <String, Object>()
},
"MyNWMapType");
}
else
{
_epService.EPRuntime.SendEvent(
MakeMapEvent(new Dictionary <String, Object>(), new Object[10]),
"MyNWMapType");
}
_epService.EPAdministrator.CreateEPL(
"on SupportBean Update MyWindow set Simple='A', MyMap('abc') = IntPrimitive, MyArray[2] = IntPrimitive");
_epService.EPRuntime.SendEvent(new SupportBean("E1", 10));
EPAssertionUtil.AssertPropsPerRow(
stmtWin.GetEnumerator(),
"Simple,MyMap('abc'),MyArray[2]".Split(','),
new Object[][]
{
new Object[]
{
"A", 10, 10
}
});
// test null and array too small
if (eventRepresentationEnum.IsObjectArrayEvent())
{
_epService.EPRuntime.SendEvent(
new Object[]
{
null, new Object[2], null
},
"MyNWMapType");
}
else
{
_epService.EPRuntime.SendEvent(MakeMapEvent(null, new Object[2]), "MyNWMapType");
}
_epService.EPRuntime.SendEvent(new SupportBean("E2", 20));
EPAssertionUtil.AssertPropsPerRowAnyOrder(
stmtWin.GetEnumerator(),
"Simple,MyMap('abc'),MyArray[2]".Split(','), new Object[][]
{
new Object[]
{
"A", 20, 20
},
new Object[]
{
"A", null, null
}
});
_epService.Initialize();
}
private void RunAssertionFullJoin_2sides_multicolumn(EventRepresentationEnum eventRepresentationEnum)
{
String[] fields = "s0.id, s0.P00, s0.p01, s1.id, s1.p10, s1.p11, s2.id, s2.p20, s2.p21".Split(',');
String joinStatement = eventRepresentationEnum.GetAnnotationText() + " select * from " +
EVENT_S0 + ".win:length(1000) as s0 " +
" full outer join " + EVENT_S1 + ".win:length(1000) as s1 on s0.P00 = s1.p10 and s0.p01 = s1.p11" +
" full outer join " + EVENT_S2 + ".win:length(1000) as s2 on s0.P00 = s2.p20 and s0.p01 = s2.p21";
EPStatement joinView = _epService.EPAdministrator.CreateEPL(joinStatement);
joinView.Events += _updateListener.Update;
_epService.EPRuntime.SendEvent(new SupportBean_S1(10, "A_1", "B_1"));
EPAssertionUtil.AssertProps(_updateListener.AssertOneGetNewAndReset(), fields, new Object[] { null, null, null, 10, "A_1", "B_1", null, null, null });
_epService.EPRuntime.SendEvent(new SupportBean_S1(11, "A_2", "B_1"));
EPAssertionUtil.AssertProps(_updateListener.AssertOneGetNewAndReset(), fields, new Object[] { null, null, null, 11, "A_2", "B_1", null, null, null });
_epService.EPRuntime.SendEvent(new SupportBean_S1(12, "A_1", "B_2"));
EPAssertionUtil.AssertProps(_updateListener.AssertOneGetNewAndReset(), fields, new Object[] { null, null, null, 12, "A_1", "B_2", null, null, null });
_epService.EPRuntime.SendEvent(new SupportBean_S1(13, "A_2", "B_2"));
EPAssertionUtil.AssertProps(_updateListener.AssertOneGetNewAndReset(), fields, new Object[] { null, null, null, 13, "A_2", "B_2", null, null, null });
_epService.EPRuntime.SendEvent(new SupportBean_S2(20, "A_1", "B_1"));
EPAssertionUtil.AssertProps(_updateListener.AssertOneGetNewAndReset(), fields, new Object[] { null, null, null, null, null, null, 20, "A_1", "B_1" });
_epService.EPRuntime.SendEvent(new SupportBean_S2(21, "A_2", "B_1"));
EPAssertionUtil.AssertProps(_updateListener.AssertOneGetNewAndReset(), fields, new Object[] { null, null, null, null, null, null, 21, "A_2", "B_1" });
_epService.EPRuntime.SendEvent(new SupportBean_S2(22, "A_1", "B_2"));
EPAssertionUtil.AssertProps(_updateListener.AssertOneGetNewAndReset(), fields, new Object[] { null, null, null, null, null, null, 22, "A_1", "B_2" });
_epService.EPRuntime.SendEvent(new SupportBean_S2(23, "A_2", "B_2"));
EPAssertionUtil.AssertProps(_updateListener.AssertOneGetNewAndReset(), fields, new Object[] { null, null, null, null, null, null, 23, "A_2", "B_2" });
_epService.EPRuntime.SendEvent(new SupportBean_S0(1, "A_3", "B_3"));
EPAssertionUtil.AssertProps(_updateListener.AssertOneGetNewAndReset(), fields, new Object[] { 1, "A_3", "B_3", null, null, null, null, null, null });
_epService.EPRuntime.SendEvent(new SupportBean_S0(2, "A_1", "B_3"));
EPAssertionUtil.AssertProps(_updateListener.AssertOneGetNewAndReset(), fields, new Object[] { 2, "A_1", "B_3", null, null, null, null, null, null });
_epService.EPRuntime.SendEvent(new SupportBean_S0(3, "A_3", "B_1"));
EPAssertionUtil.AssertProps(_updateListener.AssertOneGetNewAndReset(), fields, new Object[] { 3, "A_3", "B_1", null, null, null, null, null, null });
_epService.EPRuntime.SendEvent(new SupportBean_S0(4, "A_2", "B_2"));
EPAssertionUtil.AssertProps(_updateListener.AssertOneGetNewAndReset(), fields, new Object[] { 4, "A_2", "B_2", 13, "A_2", "B_2", 23, "A_2", "B_2" });
_epService.EPRuntime.SendEvent(new SupportBean_S0(5, "A_2", "B_1"));
EPAssertionUtil.AssertProps(_updateListener.AssertOneGetNewAndReset(), fields, new Object[] { 5, "A_2", "B_1", 11, "A_2", "B_1", 21, "A_2", "B_1" });
_epService.EPRuntime.SendEvent(new SupportBean_S1(14, "A_4", "B_3"));
EPAssertionUtil.AssertProps(_updateListener.AssertOneGetNewAndReset(), fields, new Object[] { null, null, null, 14, "A_4", "B_3", null, null, null });
_epService.EPRuntime.SendEvent(new SupportBean_S1(15, "A_1", "B_3"));
EPAssertionUtil.AssertProps(_updateListener.AssertOneGetNewAndReset(), fields, new Object[] { 2, "A_1", "B_3", 15, "A_1", "B_3", null, null, null });
_epService.EPRuntime.SendEvent(new SupportBean_S2(24, "A_1", "B_3"));
EPAssertionUtil.AssertProps(_updateListener.AssertOneGetNewAndReset(), fields, new Object[] { 2, "A_1", "B_3", 15, "A_1", "B_3", 24, "A_1", "B_3" });
_epService.EPRuntime.SendEvent(new SupportBean_S2(25, "A_2", "B_3"));
EPAssertionUtil.AssertProps(_updateListener.AssertOneGetNewAndReset(), fields, new Object[] { null, null, null, null, null, null, 25, "A_2", "B_3" });
_epService.EPAdministrator.DestroyAllStatements();
}