com.espertech.esper.regression.nwtable.TestTableMTUngroupedSubqueryReadMergeWriteColumnUpd.java Source code

Java tutorial

Introduction

Here is the source code for com.espertech.esper.regression.nwtable.TestTableMTUngroupedSubqueryReadMergeWriteColumnUpd.java

Source

/*
 * *************************************************************************************
 *  Copyright (C) 2006-2015 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.scopetest.SupportUpdateListener;
import com.espertech.esper.support.bean.SupportBean;
import com.espertech.esper.support.bean.SupportBean_S0;
import com.espertech.esper.support.bean.SupportBean_S1;
import com.espertech.esper.support.client.SupportConfigFactory;
import junit.framework.TestCase;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

public class TestTableMTUngroupedSubqueryReadMergeWriteColumnUpd extends TestCase {
    private static final Log log = LogFactory.getLog(TestTableMTUngroupedSubqueryReadMergeWriteColumnUpd.class);

    private EPServiceProvider epService;

    public void setUp() {
        Configuration config = SupportConfigFactory.getConfiguration();
        config.addEventType(SupportBean.class);
        config.addEventType(SupportBean_S0.class);
        config.addEventType(SupportBean_S1.class);
        epService = EPServiceProviderManager.getDefaultProvider(config);
        epService.initialize();
    }

    /**
     * Tests column-consistency for subquery:
     *   create table MyTable(p0 string, p1 string, ..., p4 string)   (5 props)
     *   Insert row single: MyTable={p0="1", p1="1", p2="1", p3="1", p4="1"}
     *
     *   A writer-thread uses an on-merge statement to update the p0 to p4 columns from "1" to "2", then "2" to "1"
     *   A reader-thread uses a subquery checking ("p1="1" and p2="1" and p3="1" and p4="1")
     */
    public void testMT() throws Exception {
        tryMT(2);
    }

    private void tryMT(int numSeconds) throws Exception {
        String epl = "create table MyTable (p0 string, p1 string, p2 string, p3 string, p4 string);\n"
                + "on SupportBean merge MyTable "
                + "  when not matched then insert select '1' as p0, '1' as p1, '1' as p2, '1' as p3, '1' as p4;\n"
                + "on SupportBean_S0 merge MyTable "
                + "  when matched then update set p0=p00, p1=p00, p2=p00, p3=p00, p4=p00;\n"
                + "@name('out') select " + "(select p0 from MyTable where "
                + "  (p0='1' and p1='1' and p2='1' and p3='1' and p4='1') "
                + "  or (p0='2' and p1='2' and p2='2' and p3='2' and p4='2')) as c0 " + "from SupportBean_S1;\n";
        epService.getEPAdministrator().getDeploymentAdmin().parseDeploy(epl);

        // preload
        epService.getEPRuntime().sendEvent(new SupportBean());

        TestTableMTUngroupedJoinColumnConsistency.Update_1_2_WriteRunnable writeRunnable = new TestTableMTUngroupedJoinColumnConsistency.Update_1_2_WriteRunnable(
                epService);
        ReadRunnable readRunnable = new ReadRunnable(epService);

        // start
        Thread threadWrite = new Thread(writeRunnable);
        Thread threadRead = new Thread(readRunnable);
        threadWrite.start();
        threadRead.start();

        // wait
        Thread.sleep(numSeconds * 1000);

        // shutdown
        writeRunnable.setShutdown(true);
        readRunnable.setShutdown(true);

        // join
        log.info("Waiting for completion");
        threadWrite.join();
        threadRead.join();

        assertNull(writeRunnable.getException());
        assertNull(readRunnable.getException());
        System.out.println("Write loops " + writeRunnable.getNumLoops() + " and performed "
                + readRunnable.numQueries + " reads");
        assertTrue(writeRunnable.getNumLoops() > 1);
        assertTrue(readRunnable.numQueries > 100);
    }

    public static class ReadRunnable implements Runnable {

        private final EPServiceProvider epService;
        private final SupportUpdateListener listener;

        private RuntimeException exception;
        private boolean shutdown;
        private int numQueries;

        public ReadRunnable(EPServiceProvider epService) {
            this.epService = epService;
            listener = new SupportUpdateListener();
            epService.getEPAdministrator().getStatement("out").addListener(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_S1(0, null));
                    Object value = listener.assertOneGetNewAndReset().get("c0");
                    if (value == null) {
                        throw new IllegalStateException("Value is null");
                    }
                    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;
        }
    }
}