From 78e5033d8c535a357ef5e166afd1a00717aac5df Mon Sep 17 00:00:00 2001
From: Evgeny Mandrikov <mandrikov@gmail.com>
Date: Sat, 29 Oct 2011 01:05:02 +0400
Subject: SONAR-2642 Support Oracle DB for cross-project CPD

---
 .../persistence/model/DuplicationMapper-oracle.xml | 24 ++++++++++++++++++++++
 1 file changed, 24 insertions(+)
 create mode 100644 sonar-core/src/main/resources/org/sonar/persistence/model/DuplicationMapper-oracle.xml

(limited to 'sonar-core')

diff --git a/sonar-core/src/main/resources/org/sonar/persistence/model/DuplicationMapper-oracle.xml b/sonar-core/src/main/resources/org/sonar/persistence/model/DuplicationMapper-oracle.xml
new file mode 100644
index 00000000000..659281dac7f
--- /dev/null
+++ b/sonar-core/src/main/resources/org/sonar/persistence/model/DuplicationMapper-oracle.xml
@@ -0,0 +1,24 @@
+<?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.persistence.model.DuplicationMapper">
+
+  <select id="selectCandidates" parameterType="map" resultType="DuplicationUnit">
+    SELECT DISTINCT to_blocks.hash hash, res.kee resourceKey, to_blocks.index_in_file indexInFile, to_blocks.start_line startLine, to_blocks.end_line endLine
+    FROM duplications_index to_blocks, duplications_index from_blocks, snapshots snapshot, projects res
+    WHERE from_blocks.snapshot_id = #{resource_snapshot_id}
+    AND to_blocks.hash = from_blocks.hash
+    AND to_blocks.snapshot_id = snapshot.id
+    AND snapshot.islast = TRUE
+    AND snapshot.project_id = res.id
+    <if test="last_project_snapshot_id != null">
+      AND to_blocks.project_snapshot_id != #{last_project_snapshot_id}
+    </if>
+  </select>
+
+  <insert id="insert" parameterType="DuplicationUnit" keyColumn="id" useGeneratedKeys="true">
+    INSERT INTO duplications_index (id, snapshot_id, project_snapshot_id, hash, index_in_file, start_line, end_line)
+    VALUES (select DUPLICATIONS_INDEX_SEQ.nextval, #{snapshotId}, #{projectSnapshotId}, #{hash}, #{indexInFile}, #{startLine}, #{endLine})
+  </insert>
+
+</mapper>
-- 
cgit v1.2.3