Fix PurgeDao for SQLServer - first attempt

1 files changed, 15 insertions, 0 deletions

diff --git a/sonar-core/src/main/resources/org/sonar/core/purge/PurgeVendorMapper-mssql.xml b/sonar-core/src/main/resources/org/sonar/core/purge/PurgeVendorMapper-mssql.xml
new file mode 100644
index 00000000000..7f086c79613
--- /dev/null
+++ b/sonar-core/src/main/resources/org/sonar/core/purge/PurgeVendorMapper-mssql.xml
@@ -0,0 +1,15 @@
+<?xml version="1.0" encoding="UTF-8" ?>
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+
+<mapper namespace="org.sonar.core.purge.PurgeVendorMapper">
+
+  <delete id="deleteResourceReviewComments" parameterType="long">
+    delete from review_comments rc inner join reviews r on rc.review_id=r.id where r.resource_id=#{id}
+  </delete>
+
+  <delete id="deleteResourceActionPlansReviews" parameterType="long">
+    delete from action_plans_reviews apr inner join action_plans ap on ap.id=apr.action_plan_id where ap.project_id=#{id}
+  </delete>
+
+</mapper>
+