JDBCBranchQueries extends JDBCQueriesHelper implements BranchQueries { @Override public String idFromOrdinalQueryStatement(int projectId, int branchOrdinal) { return "SELECT id FROM branch WHERE project_id='" + projectId + "' AND ordinal=" + branchOrdinal; } JDBCBranchQueries(CommitQueries commitQueries, SmellQueries smellQueries); @Override String branchInsertionStatement(int projectId, int ordinal, Commit parentCommit, Commit mergedInto); @Override String branchCommitInsertionQuery(int projectId, int branchOrdinal, String commitSha, int ordinal); @Override String idFromOrdinalQueryStatement(int projectId, int branchOrdinal); String idFromCommitQueryStatement(int projectId, Commit commit); @Override String parentCommitSmellsQuery(int projectId, int branchId, String smellType); @Override String lastCommitSmellsQuery(int projectId, Commit merge, String smellType); @Override String mergedBranchIdQuery(int projectId, Commit commit); @Override String shaFromOrdinalQuery(int projectId, int branchId, int ordinal); @Override String shaFromOrdinalQuery(int projectId, int branchId, int ordinal, boolean paprikaOnly); @Override String parentCommitIdQuery(int projectId, int branchId); @Override String parentCommitShaQuery(int projectId, int branchId); @Override String lastCommitShaQuery(int projectId, int branchId); @Override String lastCommitIdQuery(int projectId, int branchId); @Override String commitOrdinalQuery(int projectId, int branchId, Commit commit);  }
@Test public void testIdFromOrdinalQueryStatement() { List<Map<String, Object>> result; result = persistence.query(queries.idFromOrdinalQueryStatement(projectId, 0)); assertTrue(result.isEmpty()); int firstBranchID = insertBranch(projectId, 4, originCommit, mergedIntoCommit); int secondBranchID = insertBranch(projectId, 5, mergedIntoCommit, originCommit); result = persistence.query(queries.idFromOrdinalQueryStatement(projectId, 0)); assertTrue(result.isEmpty()); result = persistence.query(queries.idFromOrdinalQueryStatement(projectId, 4)); assertEquals(firstBranchID, result.get(0).get("id")); result = persistence.query(queries.idFromOrdinalQueryStatement(projectId, 5)); assertEquals(secondBranchID, result.get(0).get("id")); }