From 6382b0d363e1d66c8f5532b158cc259a7e757400 Mon Sep 17 00:00:00 2001
From: Julien Lancelot <julien.lancelot@sonarsource.com>
Date: Mon, 26 Oct 2015 17:12:19 +0100
Subject: [PATCH] Remove no more used SQL query

---
 .../java/org/sonar/db/event/EventMapper.java  |  8 ----
 .../org/sonar/db/event/EventMapper.xml        | 44 -------------------
 2 files changed, 52 deletions(-)

diff --git a/sonar-db/src/main/java/org/sonar/db/event/EventMapper.java b/sonar-db/src/main/java/org/sonar/db/event/EventMapper.java
index 57dee6a9e68..63636e22523 100644
--- a/sonar-db/src/main/java/org/sonar/db/event/EventMapper.java
+++ b/sonar-db/src/main/java/org/sonar/db/event/EventMapper.java
@@ -21,8 +21,6 @@
 package org.sonar.db.event;
 
 import java.util.List;
-import javax.annotation.CheckForNull;
-import org.apache.ibatis.annotations.Param;
 
 public interface EventMapper {
 
@@ -32,10 +30,4 @@ public interface EventMapper {
 
   void delete(long id);
 
-  /**
-   * TODO Used by PastSnapshotFinderByVersion. Should be dropped soon.
-   */
-  @CheckForNull
-  Long findSnapshotIdOfPreviousVersion(@Param("componentId") long componentId, @Param("currentVersion") String currentVersion);
-
 }
diff --git a/sonar-db/src/main/resources/org/sonar/db/event/EventMapper.xml b/sonar-db/src/main/resources/org/sonar/db/event/EventMapper.xml
index fa30a1f766f..e0ad60d0927 100644
--- a/sonar-db/src/main/resources/org/sonar/db/event/EventMapper.xml
+++ b/sonar-db/src/main/resources/org/sonar/db/event/EventMapper.xml
@@ -32,49 +32,5 @@
     DELETE FROM events WHERE id=#{id}
   </delete>
 
-  <select id="findSnapshotIdOfPreviousVersion" parameterType="map" resultType="long">
-    SELECT s.id
-    FROM snapshots s, events e, projects p
-    <where>
-      AND p.id=#{componentId}
-      AND p.uuid=e.component_uuid
-      AND e.name &lt;&gt; #{currentVersion}
-      AND e.category='Version'
-      AND s.id = e.snapshot_id
-    </where>
-    ORDER BY e.event_date DESC
-    LIMIT 1
-  </select>
-
-  <!-- SQL Server -->
-  <select id="findSnapshotIdOfPreviousVersion" parameterType="map" resultType="long" databaseId="mssql">
-    SELECT TOP 1 s.id
-    FROM snapshots s, events e, projects p
-    <where>
-      AND p.id=#{componentId}
-      AND p.uuid=e.component_uuid
-      AND e.name &lt;&gt; #{currentVersion}
-      AND e.category='Version'
-      AND s.id = e.snapshot_id
-    </where>
-    ORDER BY e.event_date DESC
-  </select>
-
-  <!-- Oracle -->
-  <select id="findSnapshotIdOfPreviousVersion" parameterType="map" resultType="long" databaseId="oracle">
-    SELECT * FROM (SELECT s.id
-    FROM snapshots s, events e, projects p
-    <where>
-      AND p.id=#{componentId}
-      AND p.uuid=e.component_uuid
-      AND e.name &lt;&gt; #{currentVersion}
-      AND e.category='Version'
-      AND s.id = e.snapshot_id
-    </where>
-    ORDER BY e.event_date DESC
-    )
-    WHERE ROWNUM &lt;= 1
-  </select>
-
 </mapper>
 
-- 
2.39.5