diff options
| author | Jacek <jacek.poreda@sonarsource.com> | 2021-11-08 12:15:28 +0100 |
|---|---|---|
| committer | sonartech <sonartech@sonarsource.com> | 2021-11-09 20:03:16 +0000 |
| commit | 0031271ee4f383ee0e19d6f01944cbd8f29e58c9 (patch) | |
| tree | 4fe5e9eb39c0387d72e0787b0b7e0c426036f0bd | |
| parent | 411f4d9dcb09fefc23c03da7a108d090592e3fb9 (diff) | |
| download | sonarqube-0031271ee4f383ee0e19d6f01944cbd8f29e58c9.tar.gz sonarqube-0031271ee4f383ee0e19d6f01944cbd8f29e58c9.zip | |
Make new portfolio queries oracle compliant
| -rw-r--r-- | server/sonar-db-dao/src/main/resources/org/sonar/db/portfolio/PortfolioMapper.xml | 64 |
1 files changed, 52 insertions, 12 deletions
diff --git a/server/sonar-db-dao/src/main/resources/org/sonar/db/portfolio/PortfolioMapper.xml b/server/sonar-db-dao/src/main/resources/org/sonar/db/portfolio/PortfolioMapper.xml index 85db3d297fa..64eff0fb448 100644 --- a/server/sonar-db-dao/src/main/resources/org/sonar/db/portfolio/PortfolioMapper.xml +++ b/server/sonar-db-dao/src/main/resources/org/sonar/db/portfolio/PortfolioMapper.xml @@ -294,7 +294,7 @@ AND source.root_uuid = #{rootUuid,jdbcType=VARCHAR}) </select> - <delete id="deletePortfolio" parameterType="String"> + <sql id="deletePortfolioQuery"> DELETE FROM portfolio_proj_branches WHERE portfolio_project_uuid in (select uuid FROM portfolio_projects WHERE portfolio_uuid = #{uuid,jdbcType=VARCHAR}); @@ -302,6 +302,16 @@ WHERE portfolio_uuid = #{uuid,jdbcType=VARCHAR}; DELETE FROM portfolios WHERE uuid = #{uuid,jdbcType=VARCHAR}; + </sql> + + <delete id="deletePortfolio" parameterType="String"> + <include refid="deletePortfolioQuery"/> + </delete> + + <delete id="deletePortfolio" parameterType="String" databaseId="oracle"> + BEGIN + <include refid="deletePortfolioQuery"/> + END; </delete> <delete id="deleteReferencesByPortfolioOrReferenceUuids" parameterType="String"> @@ -319,9 +329,19 @@ DELETE FROM portfolio_references </delete> - <delete id="deleteAllProjects" parameterType="String"> + <sql id="deleteAllProjectsQuery"> DELETE FROM portfolio_projects; - DELETE FROM portfolio_proj_branches + DELETE FROM portfolio_proj_branches; + </sql> + + <delete id="deleteAllProjects" parameterType="String"> + <include refid="deleteAllProjectsQuery"/> + </delete> + + <delete id="deleteAllProjects" parameterType="String" databaseId="oracle"> + BEGIN + <include refid="deleteAllProjectsQuery"/> + END; </delete> <insert id="insertReference" parameterType="PortfolioReference"> @@ -352,26 +372,46 @@ WHERE reference_uuid = #{referenceUuid,jdbcType=VARCHAR} </delete> - <delete id="deleteProjects" parameterType="String"> + <sql id="deleteProjectsQuery"> DELETE FROM portfolio_proj_branches WHERE portfolio_project_uuid in - (SELECT uuid FROM portfolio_projects - WHERE portfolio_uuid = #{portfolioUuid,jdbcType=VARCHAR}); + (SELECT uuid FROM portfolio_projects + WHERE portfolio_uuid = #{portfolioUuid,jdbcType=VARCHAR}); DELETE FROM portfolio_projects - WHERE portfolio_uuid = #{portfolioUuid,jdbcType=VARCHAR} + WHERE portfolio_uuid = #{portfolioUuid,jdbcType=VARCHAR}; + </sql> + + <delete id="deleteProjects" parameterType="String"> + <include refid="deleteProjectsQuery"/> </delete> - <delete id="deleteProject" parameterType="map"> + <delete id="deleteProjects" parameterType="String" databaseId="oracle"> + BEGIN + <include refid="deleteProjectsQuery"/> + END; + </delete> + + <sql id="deleteProjectQuery"> DELETE FROM portfolio_proj_branches WHERE portfolio_project_uuid = - (SELECT uuid FROM portfolio_projects - WHERE portfolio_uuid = #{portfolioUuid,jdbcType=VARCHAR} - AND project_uuid = #{projectUuid,jdbcType=VARCHAR}); + (SELECT uuid FROM portfolio_projects + WHERE portfolio_uuid = #{portfolioUuid,jdbcType=VARCHAR} + AND project_uuid = #{projectUuid,jdbcType=VARCHAR}); DELETE FROM portfolio_projects WHERE portfolio_uuid = #{portfolioUuid,jdbcType=VARCHAR} - AND project_uuid = #{projectUuid,jdbcType=VARCHAR} + AND project_uuid = #{projectUuid,jdbcType=VARCHAR}; + </sql> + + <delete id="deleteProject" parameterType="map"> + <include refid="deleteProjectQuery"/> + </delete> + + <delete id="deleteProject" parameterType="map" databaseId="oracle"> + BEGIN + <include refid="deleteProjectQuery"/> + END; </delete> <insert id="insertProject" parameterType="map"> |