private static EPFireAndForgetPreparedQuery prepare(RegressionEnvironment env, RegressionPath path, String queryText) { EPCompiled compiled = env.compileFAF(queryText, path); return env.runtime().getFireAndForgetService().prepareQuery(compiled); }
private static void runQuery(RegressionEnvironment env, RegressionPath path, String epl, String fields, Object[][] expected, ContextPartitionSelector[] selectors) { // try FAF without prepare EPCompiled compiled = env.compileFAF(epl, path); EPFireAndForgetQueryResult result = env.runtime().getFireAndForgetService().executeQuery(compiled, selectors); EPAssertionUtil.assertPropsPerRowAnyOrder(result.getArray(), fields.split(","), expected); // test unparameterized prepare and execute EPFireAndForgetPreparedQuery preparedQuery = env.runtime().getFireAndForgetService().prepareQuery(compiled); EPFireAndForgetQueryResult resultPrepared = preparedQuery.execute(selectors); EPAssertionUtil.assertPropsPerRowAnyOrder(resultPrepared.getArray(), fields.split(","), expected); // test unparameterized prepare and execute EPFireAndForgetPreparedQueryParameterized preparedParameterizedQuery = env.runtime().getFireAndForgetService().prepareQueryWithParameters(compiled); EPFireAndForgetQueryResult resultPreparedParameterized = env.runtime().getFireAndForgetService().executeQuery(preparedParameterizedQuery, selectors); EPAssertionUtil.assertPropsPerRowAnyOrder(resultPreparedParameterized.getArray(), fields.split(","), expected); // test SODA prepare and execute EPStatementObjectModel model = env.eplToModel(epl); EPCompiled compiledFromModel = env.compileFAF(model, path); EPFireAndForgetPreparedQuery preparedQueryModel = env.runtime().getFireAndForgetService().prepareQuery(compiledFromModel); EPFireAndForgetQueryResult resultPreparedModel = preparedQueryModel.execute(selectors); EPAssertionUtil.assertPropsPerRowAnyOrder(resultPreparedModel.getArray(), fields.split(","), expected); // test model query result = env.runtime().getFireAndForgetService().executeQuery(compiledFromModel, selectors); EPAssertionUtil.assertPropsPerRowAnyOrder(result.getArray(), fields.split(","), expected); }
EPFireAndForgetPreparedQuery onDemandQuery = runtime.getFireAndForgetService().prepareQuery(onDemandQueryCompiled);
private static void runAssertionFilter(RegressionEnvironment env, RegressionPath path, String query) { String[] fields = "theString,intPrimitive".split(","); EPFireAndForgetQueryResult result = env.compileExecuteFAF(query, path); EPAssertionUtil.assertPropsPerRow(result.iterator(), fields, new Object[][]{{"E3", 5}}); EPCompiled compiled = env.compileFAF(query, path); EPFireAndForgetPreparedQuery prepared = env.runtime().getFireAndForgetService().prepareQuery(compiled); EPAssertionUtil.assertPropsPerRow(prepared.execute().iterator(), fields, new Object[][]{{"E3", 5}}); }
public void run(RegressionEnvironment env) { RegressionPath path = new RegressionPath(); env.compileDeploy("create window W1#unique(s1) as SupportSimpleBeanOne", path); env.compileDeploy("insert into W1 select * from SupportSimpleBeanOne", path); env.compileDeploy("create window W2#unique(s2) as SupportSimpleBeanTwo", path); env.compileDeploy("insert into W2 select * from SupportSimpleBeanTwo", path); for (int i = 0; i < 1000; i++) { env.sendEventBean(new SupportSimpleBeanOne("A" + i, 0, 0, 0)); env.sendEventBean(new SupportSimpleBeanTwo("A" + i, 0, 0, 0)); } long start = System.currentTimeMillis(); EPCompiled compiled = env.compileFAF("select * from W1 as w1, W2 as w2 where w1.s1 = w2.s2", path); EPFireAndForgetPreparedQuery prepared = env.runtime().getFireAndForgetService().prepareQuery(compiled); for (int i = 0; i < 100; i++) { EPFireAndForgetQueryResult result = prepared.execute(); assertEquals(1000, result.getArray().length); } long end = System.currentTimeMillis(); long delta = end - start; System.out.println("Delta=" + delta); assertTrue("Delta=" + delta, delta < 1000); env.undeployAll(); } }
public void run(RegressionEnvironment env) { RegressionPath path = new RegressionPath(); String epl = "create window MyWindowFour#keepall as select * from SupportBean;\n" + "insert into MyWindowFour select * from SupportBean;"; env.compileDeploy(epl, path); env.sendEventBean(new SupportBean("E1", 10)); env.sendEventBean(new SupportBean("E2", 20)); env.sendEventBean(new SupportBean("E3", 30)); env.sendEventBean(new SupportBean("E3", 31)); env.sendEventBean(new SupportBean("E1", 11)); env.sendEventBean(new SupportBean("E1", 12)); EPCompiled qc = env.compileFAF("select first(intPrimitive) as f, window(intPrimitive) as w, last(intPrimitive) as l from MyWindowFour as s", path); EPFireAndForgetPreparedQuery q = env.runtime().getFireAndForgetService().prepareQuery(qc); EPAssertionUtil.assertPropsPerRow(q.execute().getArray(), "f,w,l".split(","), new Object[][]{{10, intArray(10, 20, 30, 31, 11, 12), 12}}); env.sendEventBean(new SupportBean("E1", 13)); EPAssertionUtil.assertPropsPerRow(q.execute().getArray(), "f,w,l".split(","), new Object[][]{{10, intArray(10, 20, 30, 31, 11, 12, 13), 13}}); qc = env.compileFAF("select theString as s, first(intPrimitive) as f, window(intPrimitive) as w, last(intPrimitive) as l from MyWindowFour as s group by theString order by theString asc", path); q = env.runtime().getFireAndForgetService().prepareQuery(qc); Object[][] expected = new Object[][]{ {"E1", 10, intArray(10, 11, 12, 13), 13}, {"E2", 20, intArray(20), 20}, {"E3", 30, intArray(30, 31), 31} }; EPAssertionUtil.assertPropsPerRow(q.execute().getArray(), "s,f,w,l".split(","), expected); EPAssertionUtil.assertPropsPerRow(q.execute().getArray(), "s,f,w,l".split(","), expected); env.undeployAll(); } }
env.runtime().getFireAndForgetService().prepareQuery(compiled); fail(); } catch (EPException ex) {
public void run(RegressionEnvironment env) { RegressionPath path = setupInfra(env, namedWindow); String[] fields = new String[]{"cnt"}; String epl = "select count(*) as cnt from MyInfra"; EPCompiled query = env.compileFAF(epl, path); EPFireAndForgetPreparedQuery prepared = env.runtime().getFireAndForgetService().prepareQuery(query); EPFireAndForgetQueryResult result = env.runtime().getFireAndForgetService().executeQuery(query); EPAssertionUtil.assertPropsPerRow(result.iterator(), fields, new Object[][]{{0L}}); EPAssertionUtil.assertPropsPerRow(prepared.execute().iterator(), fields, new Object[][]{{0L}}); env.sendEventBean(new SupportBean("E1", 1)); result = env.runtime().getFireAndForgetService().executeQuery(query); EPAssertionUtil.assertPropsPerRow(result.iterator(), fields, new Object[][]{{1L}}); EPAssertionUtil.assertPropsPerRow(prepared.execute().iterator(), fields, new Object[][]{{1L}}); result = env.runtime().getFireAndForgetService().executeQuery(query); EPAssertionUtil.assertPropsPerRow(result.iterator(), fields, new Object[][]{{1L}}); EPAssertionUtil.assertPropsPerRow(prepared.execute().iterator(), fields, new Object[][]{{1L}}); env.sendEventBean(new SupportBean("E2", 2)); result = env.runtime().getFireAndForgetService().executeQuery(query); EPAssertionUtil.assertPropsPerRow(result.iterator(), fields, new Object[][]{{2L}}); EPAssertionUtil.assertPropsPerRow(prepared.execute().iterator(), fields, new Object[][]{{2L}}); EPStatementObjectModel model = env.eplToModel(epl); EPCompiled compiledFromModel = env.compileFAF(model, path); result = env.compileExecuteFAF(model, path); EPAssertionUtil.assertPropsPerRow(result.iterator(), fields, new Object[][]{{2L}}); EPAssertionUtil.assertPropsPerRow(prepared.execute().iterator(), fields, new Object[][]{{2L}}); EPFireAndForgetPreparedQuery preparedFromModel = env.runtime().getFireAndForgetService().prepareQuery(compiledFromModel); EPAssertionUtil.assertPropsPerRow(preparedFromModel.execute().iterator(), fields, new Object[][]{{2L}}); env.undeployAll(); } }
public void run(RegressionEnvironment env) { RegressionPath path = setupInfra(env, namedWindow); String query = "select * from MyInfra"; EPCompiled compiled = env.compileFAF(query, path); EPFireAndForgetQueryResult result = env.runtime().getFireAndForgetService().executeQuery(compiled); final String[] fields = new String[]{"theString", "intPrimitive"}; EPAssertionUtil.assertPropsPerRow(result.iterator(), fields, null); EPFireAndForgetPreparedQuery prepared = env.runtime().getFireAndForgetService().prepareQuery(compiled); EPAssertionUtil.assertPropsPerRow(prepared.execute().iterator(), fields, null); env.sendEventBean(new SupportBean("E1", 1)); result = env.runtime().getFireAndForgetService().executeQuery(compiled); EPAssertionUtil.assertPropsPerRow(result.iterator(), fields, new Object[][]{{"E1", 1}}); EPAssertionUtil.assertPropsPerRow(prepared.execute().iterator(), fields, new Object[][]{{"E1", 1}}); env.sendEventBean(new SupportBean("E2", 2)); result = env.runtime().getFireAndForgetService().executeQuery(compiled); EPAssertionUtil.assertPropsPerRowAnyOrder(result.iterator(), fields, new Object[][]{{"E1", 1}, {"E2", 2}}); EPAssertionUtil.assertPropsPerRowAnyOrder(prepared.execute().iterator(), fields, new Object[][]{{"E1", 1}, {"E2", 2}}); env.undeployAll(); } }