/*
 ***************************************************************************************
 *  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.resultset;

import com.espertech.esper.client.EPServiceProvider;
import com.espertech.esper.client.EPServiceProviderManager;
import com.espertech.esper.client.EPStatement;
import com.espertech.esper.client.Configuration;
import com.espertech.esper.client.scopetest.EPAssertionUtil;
import com.espertech.esper.metrics.instrumentation.InstrumentationHelper;
import com.espertech.esper.supportregression.client.SupportConfigFactory;
import junit.framework.TestCase;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

public class TestOrderBySelfJoin extends TestCase
{
	private static final Logger log = LoggerFactory.getLogger(TestOrderBySelfJoin.class);
	private EPServiceProvider epService;

    public void setUp()
    {
        Configuration config = SupportConfigFactory.getConfiguration();
        epService = EPServiceProviderManager.getDefaultProvider(config);
        epService.initialize();
        if (InstrumentationHelper.ENABLED) { InstrumentationHelper.startTest(epService, this.getClass(), getName());}
    }

    public void tearDown() {
        if (InstrumentationHelper.ENABLED) { InstrumentationHelper.endTest();}
    }

    public void testOrderedSelfJoin()
	{
        String[] fields = new String[] {"prio", "cnt"};
        String statementString = "select c1.event_criteria_id as ecid, " +
                    "c1.priority as priority, " +
                    "c2.priority as prio, cast(count(*), int) as cnt from " +
    	            SupportHierarchyEvent.class.getName() + "#lastevent as c1, " +
    	            SupportHierarchyEvent.class.getName() + "#groupwin(event_criteria_id)#lastevent as c2, " +
    	            SupportHierarchyEvent.class.getName() + "#groupwin(event_criteria_id)#lastevent as p " +
                    "where c2.event_criteria_id in (c1.event_criteria_id,2,1) " +
                    "and p.event_criteria_id in (c1.parent_event_criteria_id, c1.event_criteria_id) " +
                    "order by c2.priority asc";
        EPStatement statement = epService.getEPAdministrator().createEPL(statementString);

        sendEvent(1, 1, null);
        sendEvent(3, 2, 2);
        sendEvent(3, 2, 2);
        EPAssertionUtil.assertPropsPerRow(statement.iterator(), fields, new Object[][]{{1, 2}, {2, 2}});
    }

    private void sendEvent(Integer ecid, Integer priority, Integer parent)
	{
	    SupportHierarchyEvent ev = new SupportHierarchyEvent(ecid,priority,parent);
	    epService.getEPRuntime().sendEvent(ev);
	}

    public static class SupportHierarchyEvent {
        private Integer event_criteria_id;
        private Integer priority;
        private Integer parent_event_criteria_id;

        public SupportHierarchyEvent(Integer event_criteria_id, Integer priority, Integer parent_event_criteria_id)
        {
            this.event_criteria_id = event_criteria_id;
            this.priority = priority;
            this.parent_event_criteria_id = parent_event_criteria_id;
        }

        public Integer getEvent_criteria_id()
        {
            return event_criteria_id;
        }

        public Integer getPriority()
        {
            return priority;
        }

        public Integer getParent_event_criteria_id()
        {
            return parent_event_criteria_id;
        }

        public String toString()
        {
            return "ecid=" + event_criteria_id +
                   " prio=" + priority +
                   " parent=" + parent_event_criteria_id;
        }
    }

}