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(); }