/* *************************************************************************************** * Copyright (C) 2006 EsperTech, Inc. All rights reserved. * * http://www.espertech.com/esper * * http://www.espertech.com * * ---------------------------------------------------------------------------------- * * The software in this package is published under the terms of the GPL license * * a copy of which has been included with this distribution in the license.txt file. * *************************************************************************************** */ package com.espertech.esper.regression.nwtable; import com.espertech.esper.client.Configuration; import com.espertech.esper.client.EPServiceProvider; import com.espertech.esper.client.EPServiceProviderManager; import com.espertech.esper.client.EPStatement; import com.espertech.esper.client.scopetest.SupportUpdateListener; import com.espertech.esper.supportregression.bean.SupportBean; import com.espertech.esper.supportregression.bean.SupportBean_S0; import com.espertech.esper.supportregression.client.SupportConfigFactory; import junit.framework.TestCase; import org.slf4j.Logger; import org.slf4j.LoggerFactory; public class TestTableMTGroupedSubqueryReadInsertIntoWriteConcurr extends TestCase { private static final Logger log = LoggerFactory.getLogger(TestTableMTGroupedSubqueryReadInsertIntoWriteConcurr.class); private EPServiceProvider epService; public void setUp() { Configuration config = SupportConfigFactory.getConfiguration(); config.addEventType(SupportBean.class); config.addEventType(SupportBean_S0.class); epService = EPServiceProviderManager.getDefaultProvider(config); epService.initialize(); } /** * Primary key is single: {id} * For a given number of seconds: * Single writer insert-into such as {0} to {N}. * Single reader subquery-selects the count all rows. */ public void testMT() throws Exception { tryMT(3); } private void tryMT(int numSeconds) throws Exception { String eplCreateVariable = "create table MyTable (pkey string primary key)"; epService.getEPAdministrator().createEPL(eplCreateVariable); String eplInsertInto = "insert into MyTable select theString as pkey from SupportBean"; epService.getEPAdministrator().createEPL(eplInsertInto); // seed with count 1 epService.getEPRuntime().sendEvent(new SupportBean("E0", 0)); // select/read String eplSubselect = "select (select count(*) from MyTable) as c0 from SupportBean_S0"; EPStatement stmtSubselect = epService.getEPAdministrator().createEPL(eplSubselect); SupportUpdateListener listener = new SupportUpdateListener(); stmtSubselect.addListener(listener); WriteRunnable writeRunnable = new WriteRunnable(epService); ReadRunnable readRunnable = new ReadRunnable(epService, listener); // start Thread writeThread = new Thread(writeRunnable); Thread readThread = new Thread(readRunnable); writeThread.start(); readThread.start(); // wait Thread.sleep(numSeconds * 1000); // shutdown writeRunnable.setShutdown(true); readRunnable.setShutdown(true); // join log.info("Waiting for completion"); writeThread.join(); readThread.join(); assertNull(writeRunnable.getException()); assertNull(readRunnable.getException()); assertTrue(writeRunnable.numLoops > 100); assertTrue(readRunnable.numQueries > 100); System.out.println("Send " + writeRunnable.numLoops + " and performed " + readRunnable.numQueries + " reads"); } public static class WriteRunnable implements Runnable { private final EPServiceProvider epService; private RuntimeException exception; private boolean shutdown; private int numLoops; public WriteRunnable(EPServiceProvider epService) { this.epService = epService; } public void setShutdown(boolean shutdown) { this.shutdown = shutdown; } public void run() { log.info("Started event send for write"); try { while(!shutdown) { epService.getEPRuntime().sendEvent(new SupportBean("E" + numLoops + 1, 0)); numLoops++; } } catch (RuntimeException ex) { log.error("Exception encountered: " + ex.getMessage(), ex); exception = ex; } log.info("Completed event send for write"); } public RuntimeException getException() { return exception; } } public static class ReadRunnable implements Runnable { private final EPServiceProvider epService; private final SupportUpdateListener listener; private int numQueries; private RuntimeException exception; private boolean shutdown; public ReadRunnable(EPServiceProvider epService, SupportUpdateListener listener) { this.epService = epService; this.listener = listener; } public void setShutdown(boolean shutdown) { this.shutdown = shutdown; } public void run() { log.info("Started event send for read"); try { while(!shutdown) { epService.getEPRuntime().sendEvent(new SupportBean_S0(0)); Object value = listener.assertOneGetNewAndReset().get("c0"); assertTrue((Long) value >= 1); numQueries++; } } catch (RuntimeException ex) { log.error("Exception encountered: " + ex.getMessage(), ex); exception = ex; } log.info("Completed event send for read"); } public RuntimeException getException() { return exception; } public int getNumQueries() { return numQueries; } } }