import org.voltdb.*;
public class SignIn extends VoltProcedure {
public final SQLStmt getuser = new SQLStmt(
"SELECT H.HELLO, U.FIRSTNAME " +
"FROM USERACCOUNT AS U, HELLOWORLD AS H " +
"WHERE U.EMAIL = ? AND U.DIALECT = H.DIALECT;"
);
public final SQLStmt updatesignin = new SQLStmt(
"UPDATE USERACCOUNT SET lastlogin=? " +
"WHERE EMAIL = ?;"
);
public VoltTable[] run( String id, long signintime)
throws VoltAbortException {
voltQueueSQL( getuser, EXPECT_ONE_ROW, id );
voltQueueSQL( updatesignin, signintime, id );
return voltExecuteSQL();
}
}