diff options
| author | Tieg Zaharia <tieg.zaharia@sonarsource.com> | 2025-03-12 16:33:35 -0400 |
|---|---|---|
| committer | sonartech <sonartech@sonarsource.com> | 2025-03-13 20:03:15 +0000 |
| commit | 1722d4a77028e5e2b1ffd74fee3772236edd0080 (patch) | |
| tree | ba42e3d60521b8e21934280766e2bddc047a7f15 | |
| parent | 6de6e05a4cd112c021ae0c8ddbf29078097dbbc1 (diff) | |
| download | sonarqube-1722d4a77028e5e2b1ffd74fee3772236edd0080.tar.gz sonarqube-1722d4a77028e5e2b1ffd74fee3772236edd0080.zip | |
SCA-107 Add new IssueResource to ReleaseResource payload.
Co-authored-by: Havoc Pennington <havoc.pennington@sonarsource.com>
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"/> |