public EPFireAndForgetQueryResult executeQuery(EPCompiled compiled) { return runtime.getFireAndForgetService().executeQuery(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); }
private static void tryInvalidlyParameterized(RegressionEnvironment env, EPCompiled compiled, Consumer<EPFireAndForgetPreparedQueryParameterized> query, String message) { EPFireAndForgetPreparedQueryParameterized parameterized = env.runtime().getFireAndForgetService().prepareQueryWithParameters(compiled); query.accept(parameterized); try { env.runtime().getFireAndForgetService().executeQuery(parameterized); fail(); } catch (EPException ex) { SupportMessageAssertUtil.assertMessage(ex.getMessage(), message); } }
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(); } }
private static EPFireAndForgetPreparedQuery prepare(RegressionEnvironment env, RegressionPath path, String queryText) { EPCompiled compiled = env.compileFAF(queryText, path); return env.runtime().getFireAndForgetService().prepareQuery(compiled); }
public void runWork() throws InterruptedException { String epl = "delete from MyTable where key = cast(?, int)"; EPCompiled compiled = env.compileFAF(epl, path); EPFireAndForgetPreparedQueryParameterized q = env.runtime().getFireAndForgetService().prepareQueryWithParameters(compiled); while (true) { int id = stageInput.take(); process(q, id); if (id == -1) { break; } } }
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(); } }
EPFireAndForgetPreparedQueryParameterized prepared = env.runtime().getFireAndForgetService().prepareQueryWithParameters(compiled); long start = System.currentTimeMillis(); String[] fields = "id".split(","); prepared.setObject(3, 5d); prepared.setObject(4, 5d); EventBean[] events = env.runtime().getFireAndForgetService().executeQuery(prepared).getArray(); Object[][] expected = SupportSpatialUtil.getExpected(points, x, y, 5, 5); EPAssertionUtil.assertPropsPerRowAnyOrder(events, fields, expected);
EPFireAndForgetPreparedQuery onDemandQuery = runtime.getFireAndForgetService().prepareQuery(onDemandQueryCompiled);
public void runWork() throws InterruptedException { String epl = "select p0 from MyTable where key = cast(?, int)"; EPCompiled compiled = env.compileFAF(epl, path); EPFireAndForgetPreparedQueryParameterized q = env.runtime().getFireAndForgetService().prepareQueryWithParameters(compiled); while (true) { int id = stageInput.take(); process(q, id); if (id == -1) { break; } } }
private void process(EPFireAndForgetPreparedQueryParameterized q, int id) { q.setObject(1, id); env.runtime().getFireAndForgetService().executeQuery(q); stageOutput.add(id); numberOfOperations++; } }
env.runtime().getFireAndForgetService().executeQuery(compiled); fail(); } catch (EPException ex) { env.runtime().getFireAndForgetService().prepareQuery(compiled); fail(); } catch (EPException ex) {
public Object call() throws Exception { String selectQuery = "select * from MyWindow where theString='" + threadKey + "' and longPrimitive=?::int"; EPCompiled compiled = env.compileFAF(selectQuery, path); EPFireAndForgetPreparedQueryParameterized prepared = env.runtime().getFireAndForgetService().prepareQueryWithParameters(compiled); try { long total = 0; for (int loop = 0; loop < numRepeats; loop++) { // Insert event into named window sendMarketBean(threadKey, loop); total++; prepared.setObject(1, loop); EPFireAndForgetQueryResult queryResult = env.runtime().getFireAndForgetService().executeQuery(prepared); Assert.assertEquals(1, queryResult.getArray().length); Assert.assertEquals(threadKey, queryResult.getArray()[0].get("theString")); Assert.assertEquals((long) loop, queryResult.getArray()[0].get("longPrimitive")); } } catch (Exception ex) { log.error("Error in thread " + Thread.currentThread().getId(), ex); return false; } return true; }
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 runWork() throws InterruptedException { String epl = "update MyTable set p0 = 99999999 where key = cast(?, int)"; EPCompiled compiled = env.compileFAF(epl, path); EPFireAndForgetPreparedQueryParameterized q = env.runtime().getFireAndForgetService().prepareQueryWithParameters(compiled); while (true) { int id = stageInput.take(); process(q, id); if (id == -1) { break; } } }
private void process(EPFireAndForgetPreparedQueryParameterized q, int id) { q.setObject(1, id); env.runtime().getFireAndForgetService().executeQuery(q); stageOutput.add(id); numberOfOperations++; } }
EPFireAndForgetPreparedQueryParameterized preparedDelete = env.runtime().getFireAndForgetService().prepareQueryWithParameters(deleteQuery); env.runtime().getFireAndForgetService().executeQuery(preparedDelete); log.info("Checkpoint at " + points.size()); env.milestoneInc(milestone); preparedDelete = env.runtime().getFireAndForgetService().prepareQueryWithParameters(deleteQuery);
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(); } }
private static EPFireAndForgetPreparedQueryParameterized compilePrepare(String faf, RegressionPath path, RegressionEnvironment env) { EPCompiled compiled = env.compileFAF(faf, path); return env.runtime().getFireAndForgetService().prepareQueryWithParameters(compiled); }
private static void tryInvalidRuntimeQuery(RegressionEnvironment env, RegressionPath path, ContextPartitionSelector[] selectors, String epl, String expected) { EPCompiled faf = env.compileFAF(epl, path); try { env.runtime().getFireAndForgetService().executeQuery(faf, selectors); fail(); } catch (IllegalArgumentException ex) { assertEquals(ex.getMessage(), expected); } }