RemoteIdle.java

package org.voltdb.regressionsuites.specexecprocs;

import org.apache.log4j.Logger;
import org.voltdb.ProcInfo;
import org.voltdb.SQLStmt;
import org.voltdb.VoltProcedure;
import org.voltdb.VoltTable;

import edu.brown.benchmark.tm1.TM1Constants;
import edu.brown.utils.ThreadUtil;

@ProcInfo(
    partitionParam = 0,
    singlePartition = false
)
public class RemoteIdle extends VoltProcedure {
    private static final Logger LOG = Logger.getLogger(RemoteIdle.class);
    
    public final SQLStmt getLocal = new SQLStmt(
        "SELECT S_ID " +
        "  FROM " + TM1Constants.TABLENAME_SUBSCRIBER +
        " WHERE S_ID != ?"
    );
    
    public final SQLStmt getRemote = new SQLStmt(
        "SELECT AVG(S_ID) AS a " +
        "  FROM " + TM1Constants.TABLENAME_CALL_FORWARDING
    );
    
    public VoltTable[] run(int partition, long sleep) {
        VoltTable results[] = null;
        
        // First execute a remote query
        voltQueueSQL(getRemote);
        results = voltExecuteSQL();
        assert(results.length == 1);
        LOG.info("RESULTS:\n" + results[0]);

        // Then sleep for a bit
        LOG.info(String.format("Sleeping for %.01f seconds", sleep / 1000d));
        ThreadUtil.sleep(sleep);
        LOG.info("Awake!");

        voltQueueSQL(getLocal, partition);
        results = voltExecuteSQL();
        assert(results.length == 1);

        return (results);
    }

}