public void TestTimeBatchOM()
{
String[] fields = ALL_FIELDS.Split(',');
String sql = "select " + ALL_FIELDS + " from mytesttable where ${IntPrimitive} = mytesttable.mybigint";
var model = new EPStatementObjectModel();
model.SelectClause = SelectClause.Create(fields);
FromClause fromClause = FromClause.Create(
SQLStream.Create("MyDB", sql, "s0"),
FilterStream.Create(typeof(SupportBean).FullName, "s1").AddView(View.Create("win", "time_batch",
Expressions.Constant(10))
));
model.FromClause = fromClause;
SerializableObjectCopier.Copy(model);
Assert.AreEqual(
"select mybigint, myint, myvarchar, mychar, mybool, mynumeric, mydecimal, mydouble, myreal from sql:MyDB[\"select mybigint, myint, myvarchar, mychar, mybool, mynumeric, mydecimal, mydouble, myreal from mytesttable where ${IntPrimitive} = mytesttable.mybigint\"] as s0, com.espertech.esper.support.bean.SupportBean.win:time_batch(10) as s1",
model.ToEPL());
EPStatement stmt = _epService.EPAdministrator.Create(model);
RuntestTimeBatch(stmt);
stmt = _epService.EPAdministrator.CreateEPL(model.ToEPL());
}
public void Run(RegressionEnvironment env)
{
var fields = ALL_FIELDS.SplitCsv();
var sql = "select " + ALL_FIELDS + " from mytesttable where ${IntPrimitive} = mytesttable.myBigint";
var model = new EPStatementObjectModel();
model.SelectClause = SelectClause.Create(fields);
var fromClause = FromClause.Create(
SQLStream.Create("MyDBWithRetain", sql, "s0"),
FilterStream.Create(typeof(SupportBean).Name, "s1")
.AddView(
View.Create("time_batch", Expressions.Constant(10))
));
model.FromClause = fromClause;
env.CopyMayFail(model);
Assert.AreEqual(
"select myBigint, myint, myvarchar, mychar, mybool, mynumeric, mydecimal, mydouble, myreal from sql:MyDBWithRetain[\"select myBigint, myint, myvarchar, mychar, mybool, mynumeric, mydecimal, mydouble, myreal from mytesttable where ${IntPrimitive} = mytesttable.myBigint\"] as S0, " +
"SupportBean#time_batch(10) as S1",
model.ToEPL());
model.Annotations = Collections.SingletonList(AnnotationPart.NameAnnotation("s0"));
env.CompileDeploy(model).AddListener("s0");
RuntestTimeBatch(env);
}
private void RunAssertionTimeBatchOM(EPServiceProvider epService)
{
string[] fields = ALL_FIELDS.Split(',');
string sql = "select " + ALL_FIELDS + " from mytesttable where ${IntPrimitive} = mytesttable.mybigint";
var model = new EPStatementObjectModel();
model.SelectClause = SelectClause.Create(fields);
FromClause fromClause = FromClause.Create(
SQLStream.Create("MyDB", sql, "s0"),
FilterStream.Create(typeof(SupportBean).FullName, "s1").AddView(View.Create("time_batch", Expressions.Constant(10))
));
model.FromClause = fromClause;
SerializableObjectCopier.Copy(epService.Container, model);
Assert.AreEqual("select mybigint, myint, myvarchar, mychar, mybool, mynumeric, mydecimal, mydouble, myreal from sql:MyDB[\"select mybigint, myint, myvarchar, mychar, mybool, mynumeric, mydecimal, mydouble, myreal from mytesttable where ${IntPrimitive} = mytesttable.mybigint\"] as s0, " + typeof(SupportBean).FullName + "#time_batch(10) as s1",
model.ToEPL());
EPStatement stmt = epService.EPAdministrator.Create(model);
RuntestTimeBatch(epService, stmt);
epService.EPAdministrator.CreateEPL(model.ToEPL()).Dispose();
}