### Question:
JDBCBranchQueries extends JDBCQueriesHelper implements BranchQueries { public String idFromCommitQueryStatement(int projectId, Commit commit) { return "SELECT branch.id FROM branch " + "RIGHT JOIN branch_commit ON branch.id = branch_commit.branch_id " + "LEFT JOIN commit_entry ON commit_entry.id = branch_commit.commit_id " + "WHERE commit_entry.sha1 = '" + commit.sha + "' AND commit_entry.project_id = '" + projectId + "'"; } 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);  }### Answer:
@Test public void testIdFromCommitQueryStatement() { List<Map<String, Object>> result; Commit branchCommit = prepareCommit("sha", 0); Commit anotherCommit = prepareCommit("another", 4); result = persistence.query(queries.idFromCommitQueryStatement(projectId, branchCommit)); assertTrue(result.isEmpty()); int firstBranchID = insertBranch(projectId, 4, originCommit, mergedIntoCommit); int secondBranchID = insertBranch(projectId, 5, mergedIntoCommit, originCommit); result = persistence.query(queries.idFromCommitQueryStatement(projectId, originCommit)); assertTrue(result.isEmpty()); result = persistence.query(queries.idFromCommitQueryStatement(projectId, mergedIntoCommit)); assertTrue(result.isEmpty()); persistence.execute(queries.branchCommitInsertionQuery(projectId, 4, branchCommit.sha, 0)); persistence.execute(queries.branchCommitInsertionQuery(projectId, 4, anotherCommit.sha, 1)); result = persistence.query(queries.idFromCommitQueryStatement(projectId, branchCommit)); assertEquals(firstBranchID, result.get(0).get("id")); result = persistence.query(queries.idFromCommitQueryStatement(projectId, anotherCommit)); assertEquals(firstBranchID, result.get(0).get("id")); persistence.execute(queries.branchCommitInsertionQuery(projectId, 5, branchCommit.sha, 2)); result = persistence.query(queries.idFromCommitQueryStatement(projectId, branchCommit)); assertEquals(firstBranchID, result.get(0).get("id")); }