Package edu.brown.benchmark.voter

Examples of edu.brown.benchmark.voter.VoterProjectBuilder.addStmtProcedure()

287
288
289
290
291
292
293
294
295
296
297
        // build up a project builder for the TPC-C app
        VoterProjectBuilder project = new VoterProjectBuilder();
        project.addAllDefaults();
        project.markTableEvictable(VoterConstants.TABLENAME_VOTES);
        project.markTableEvictable(VoterConstants.TABLENAME_CONTESTANTS);
        project.addStmtProcedure("GetVote",
                                 "SELECT * FROM " + VoterConstants.TABLENAME_VOTES + " WHERE vote_id = ?");
        project.addStmtProcedure("GetAllVotes",
                                 "SELECT * FROM " + VoterConstants.TABLENAME_VOTES);
        project.addStmtProcedure("GetVoteJoin",
                String.format("SELECT phone_number, contestant_number FROM %s, %s " +
View Full Code Here
289
290
291
292
293
294
295
296
297
298
299
        project.addAllDefaults();
        project.markTableEvictable(VoterConstants.TABLENAME_VOTES);
        project.markTableEvictable(VoterConstants.TABLENAME_CONTESTANTS);
        project.addStmtProcedure("GetVote",
                                 "SELECT * FROM " + VoterConstants.TABLENAME_VOTES + " WHERE vote_id = ?");
        project.addStmtProcedure("GetAllVotes",
                                 "SELECT * FROM " + VoterConstants.TABLENAME_VOTES);
        project.addStmtProcedure("GetVoteJoin",
                String.format("SELECT phone_number, contestant_number FROM %s, %s " +
                              " WHERE vote_id = ? " +
                              "   AND %s.contestant_number = %s.contestant_number",
View Full Code Here
291
292
293
294
295
296
297
298
299
300
301
        project.markTableEvictable(VoterConstants.TABLENAME_CONTESTANTS);
        project.addStmtProcedure("GetVote",
                                 "SELECT * FROM " + VoterConstants.TABLENAME_VOTES + " WHERE vote_id = ?");
        project.addStmtProcedure("GetAllVotes",
                                 "SELECT * FROM " + VoterConstants.TABLENAME_VOTES);
        project.addStmtProcedure("GetVoteJoin",
                String.format("SELECT phone_number, contestant_number FROM %s, %s " +
                              " WHERE vote_id = ? " +
                              "   AND %s.contestant_number = %s.contestant_number",
                              VoterConstants.TABLENAME_VOTES, VoterConstants.TABLENAME_CONTESTANTS,
                              VoterConstants.TABLENAME_VOTES, VoterConstants.TABLENAME_CONTESTANTS));
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.