package edu.brown.benchmark.users.procedures;
import org.voltdb.*;
@ProcInfo(
partitionParam = 0,
singlePartition = true
)
public class GetComments extends VoltProcedure{
public final SQLStmt GetComments = new SQLStmt("SELECT * FROM COMMENTS WHERE C_A_ID = ? ");
// public final SQLStmt GetUser = new SQLStmt("SELECT * FROM USERS JOIN COMMENTS ON USERS.U_ID = COMMENTS.U_ID WHERE A_ID = ? ");
public VoltTable[] run(long a_id) {
System.out.println("Running procedure Get comments "+a_id);
voltQueueSQL(GetComments, a_id);
return voltExecuteSQL(true);
}
}