public void testCoalesceLong_OM() throws Exception {
String viewExpr =
"select coalesce(longBoxed, intBoxed, shortBoxed) as result"
+ " from "
+ SupportBean.class.getName()
+ ".win:length(1000)";
EPStatementObjectModel model = new EPStatementObjectModel();
model.setSelectClause(
SelectClause.create()
.add(Expressions.coalesce("longBoxed", "intBoxed", "shortBoxed"), "result"));
model.setFromClause(
FromClause.create(
FilterStream.create(SupportBean.class.getName())
.addView("win", "length", Expressions.constant(1000))));
model = (EPStatementObjectModel) SerializableObjectCopier.copy(model);
assertEquals(viewExpr, model.toEPL());
epService.initialize();
selectTestView = epService.getEPAdministrator().create(model);
selectTestView.addListener(testListener);
assertEquals(Long.class, selectTestView.getEventType().getPropertyType("result"));
runCoalesceLong();
}
@Test
public void testSODA() {
// should say fieldsTypes, maybe with object/component prefix
Map<String, Object> eventTypes = new HashMap<>();
eventTypes.put(LITERAL_SYMBOL, String.class);
eventTypes.put(LITERAL_PRICE, Integer.class);
EPStatementObjectModel model = new EPStatementObjectModel();
model.setInsertInto(InsertIntoClause.create(LITERAL_RETURN_OBJ));
model.setSelectClause(
SelectClause.create().add(Expressions.avg(LITERAL_PRICE), LITERAL_AVG).add(LITERAL_PRICE));
Filter filter = Filter.create("quotes_default", Expressions.eq(LITERAL_SYMBOL, "A"));
model.setFromClause(
FromClause.create(
FilterStream.create(filter).addView("win", "length", Expressions.constant(2))));
model.setHavingClause(
Expressions.gt(Expressions.avg(LITERAL_PRICE), Expressions.constant(60.0)));
TopologyBuilder builder = new TopologyBuilder();
builder.setSpout(LITERAL_QUOTES, new RandomSentenceSpout());
builder
.setBolt(
LITERAL_ESPER,
(new EsperBolt())
.addEventTypes(eventTypes)
.addOutputTypes(
Collections.singletonMap(
LITERAL_RETURN_OBJ, Arrays.asList(LITERAL_AVG, LITERAL_PRICE)))
.addObjectStatemens(Collections.singleton(model)))
.shuffleGrouping(LITERAL_QUOTES);
builder.setBolt("print", new PrinterBolt()).shuffleGrouping(LITERAL_ESPER, LITERAL_RETURN_OBJ);
Config conf = new Config();
LocalCluster cluster = new LocalCluster();
cluster.submitTopology("test", conf, builder.createTopology());
Utils.sleep(10000);
cluster.shutdown();
assertEquals(resultSODA.get(100), new Double(75.0));
assertEquals(resultSODA.get(50), new Double(75.0));
}
public void testUnfilteredStreamPrior_OM() throws Exception {
EPStatementObjectModel subquery = new EPStatementObjectModel();
subquery.setSelectClause(SelectClause.create().add(Expressions.prior(0, "id")));
subquery.setFromClause(
FromClause.create(
FilterStream.create("S1").addView("win", "length", Expressions.constant(1000))));
EPStatementObjectModel model = new EPStatementObjectModel();
model.setSelectClause(SelectClause.create().add(Expressions.subquery(subquery), "idS1"));
model.setFromClause(FromClause.create(FilterStream.create("S0")));
model = (EPStatementObjectModel) SerializableObjectCopier.copy(model);
String stmtText = "select (select prior(0, id) from S1.win:length(1000)) as idS1 from S0";
assertEquals(stmtText, model.toEPL());
EPStatement stmt = epService.getEPAdministrator().create(model);
runUnfilteredStreamPrior(stmt);
}
public void testMinMaxWindowStats_OM() throws Exception {
String viewExpr =
"select max(longBoxed, intBoxed) as myMax, "
+ "max(longBoxed, intBoxed, shortBoxed) as myMaxEx, "
+ "min(longBoxed, intBoxed) as myMin, "
+ "min(longBoxed, intBoxed, shortBoxed) as myMinEx"
+ " from "
+ SupportBean.class.getName()
+ ".win:length(3)";
EPStatementObjectModel model = new EPStatementObjectModel();
model.setSelectClause(
SelectClause.create()
.add(Expressions.max("longBoxed", "intBoxed"), "myMax")
.add(
Expressions.max(
Expressions.property("longBoxed"),
Expressions.property("intBoxed"),
Expressions.property("shortBoxed")),
"myMaxEx")
.add(Expressions.min("longBoxed", "intBoxed"), "myMin")
.add(
Expressions.min(
Expressions.property("longBoxed"),
Expressions.property("intBoxed"),
Expressions.property("shortBoxed")),
"myMinEx"));
model.setFromClause(
FromClause.create(
FilterStream.create(SupportBean.class.getName())
.addView("win", "length", Expressions.constant(3))));
model = (EPStatementObjectModel) SerializableObjectCopier.copy(model);
assertEquals(viewExpr, model.toEPL());
selectTestView = epService.getEPAdministrator().create(model);
selectTestView.addListener(testListener);
testListener.reset();
runMinMaxWindowStats();
}
public void testVariantOneOMToStmt() throws Exception {
EPStatementObjectModel model = new EPStatementObjectModel();
model.setInsertInto(InsertIntoClause.create("Event_1", "delta", "product"));
model.setSelectClause(
SelectClause.create()
.add(Expressions.minus("intPrimitive", "intBoxed"), "deltaTag")
.add(Expressions.multiply("intPrimitive", "intBoxed"), "productTag"));
model.setFromClause(
FromClause.create(
FilterStream.create(SupportBean.class.getName())
.addView(View.create("win", "length", Expressions.constant(100)))));
model = (EPStatementObjectModel) SerializableObjectCopier.copy(model);
EPStatement stmt = runAsserts(null, model);
String epl =
"insert into Event_1(delta, product) "
+ "select intPrimitive - intBoxed as deltaTag, intPrimitive * intBoxed as productTag "
+ "from "
+ SupportBean.class.getName()
+ ".win:length(100)";
assertEquals(epl, model.toEPL());
assertEquals(epl, stmt.getText());
}