diff options
3 files changed, 20 insertions, 0 deletions
diff --git a/server/sonar-db-dao/src/main/java/org/sonar/db/sca/ScaIssuesReleasesDetailsDao.java b/server/sonar-db-dao/src/main/java/org/sonar/db/sca/ScaIssuesReleasesDetailsDao.java index 9b10ac5435b..31a0d5dd611 100644 --- a/server/sonar-db-dao/src/main/java/org/sonar/db/sca/ScaIssuesReleasesDetailsDao.java +++ b/server/sonar-db-dao/src/main/java/org/sonar/db/sca/ScaIssuesReleasesDetailsDao.java @@ -38,6 +38,13 @@ public class ScaIssuesReleasesDetailsDao implements Dao { } /** + * Retrieves all issues with a specific release UUID, no other filtering is done by this method. + */ + public List<ScaIssueReleaseDetailsDto> selectByReleaseUuid(DbSession dbSession, String releaseUuid) { + return mapper(dbSession).selectByReleaseUuid(releaseUuid); + } + + /** * Counts all issues with a specific branch UUID, no other filtering is done by this method. */ public int countByBranchUuid(DbSession dbSession, String branchUuid) { diff --git a/server/sonar-db-dao/src/main/java/org/sonar/db/sca/ScaIssuesReleasesDetailsMapper.java b/server/sonar-db-dao/src/main/java/org/sonar/db/sca/ScaIssuesReleasesDetailsMapper.java index 6a62af645d3..35d6608322d 100644 --- a/server/sonar-db-dao/src/main/java/org/sonar/db/sca/ScaIssuesReleasesDetailsMapper.java +++ b/server/sonar-db-dao/src/main/java/org/sonar/db/sca/ScaIssuesReleasesDetailsMapper.java @@ -28,6 +28,8 @@ public interface ScaIssuesReleasesDetailsMapper { ScaIssueReleaseDetailsDto selectByScaIssueReleaseUuid(String scaIssueReleaseUuid); + List<ScaIssueReleaseDetailsDto> selectByReleaseUuid(String releaseUuid); + int countByBranchUuid(String branchUuid); List<ScaIssueReleaseDetailsDto> selectByQuery(@Param("query") ScaIssuesReleasesDetailsQuery query, @Param("pagination") Pagination pagination); diff --git a/server/sonar-db-dao/src/main/resources/org/sonar/db/sca/ScaIssuesReleasesDetailsMapper.xml b/server/sonar-db-dao/src/main/resources/org/sonar/db/sca/ScaIssuesReleasesDetailsMapper.xml index ba6f5e5f675..b884961612b 100644 --- a/server/sonar-db-dao/src/main/resources/org/sonar/db/sca/ScaIssuesReleasesDetailsMapper.xml +++ b/server/sonar-db-dao/src/main/resources/org/sonar/db/sca/ScaIssuesReleasesDetailsMapper.xml @@ -57,11 +57,22 @@ where sir.uuid = #{scaIssueReleaseUuid,jdbcType=VARCHAR} </sql> + <sql id="sqlSelectByReleaseUuid"> + <include refid="sqlBaseJoins"/> + where sr.uuid = #{releaseUuid,jdbcType=VARCHAR} + </sql> + <sql id="sqlSelectByBranchUuid"> <include refid="sqlBaseJoins"/> where c.branch_uuid = #{branchUuid,jdbcType=VARCHAR} </sql> + <select id="selectByReleaseUuid" parameterType="map" resultMap="scaIssueReleaseDetailsResultMap"> + select <include refid="issuesWithScaColumns"/> + <include refid="sqlSelectByReleaseUuid"/> + ORDER BY <include refid="sqlIdentityOrderColumns"/> + </select> + <select id="selectByBranchUuid" parameterType="map" resultMap="scaIssueReleaseDetailsResultMap"> select <include refid="issuesWithScaColumns"/> <include refid="sqlSelectByBranchUuid"/> |