From 88a71950d3c0ce827f450c8b24731ec652e635e9 Mon Sep 17 00:00:00 2001
From: Simon Brandhof <simon.brandhof@sonarsource.com>
Date: Wed, 28 Sep 2016 17:01:24 +0200
Subject: [PATCH] Remove unused QualityProfileDao methods

---
 .../db/qualityprofile/QualityProfileDao.java  | 24 -------------------
 .../qualityprofile/QualityProfileMapper.java  |  5 ----
 .../qualityprofile/QualityProfileMapper.xml   | 18 --------------
 .../qualityprofile/QualityProfileDaoTest.java |  7 ------
 4 files changed, 54 deletions(-)

diff --git a/sonar-db/src/main/java/org/sonar/db/qualityprofile/QualityProfileDao.java b/sonar-db/src/main/java/org/sonar/db/qualityprofile/QualityProfileDao.java
index a537fd9d15d..64e98ccf061 100644
--- a/sonar-db/src/main/java/org/sonar/db/qualityprofile/QualityProfileDao.java
+++ b/sonar-db/src/main/java/org/sonar/db/qualityprofile/QualityProfileDao.java
@@ -237,21 +237,6 @@ public class QualityProfileDao implements Dao {
     }
   }
 
-  @CheckForNull
-  public QualityProfileDto selectParent(DbSession session, String childKey) {
-    return mapper(session).selectParent(childKey);
-  }
-
-  @CheckForNull
-  public QualityProfileDto selectParent(String childKey) {
-    DbSession session = mybatis.openSession(false);
-    try {
-      return selectParent(session, childKey);
-    } finally {
-      MyBatis.closeQuietly(session);
-    }
-  }
-
   @CheckForNull
   public QualityProfileDto selectParentById(DbSession session, int childId) {
     return mapper(session).selectParentById(childId);
@@ -305,15 +290,6 @@ public class QualityProfileDao implements Dao {
     return mapper(session).selectProjects(profileName, language);
   }
 
-  public int countProjects(String profileName, String language) {
-    DbSession session = mybatis.openSession(false);
-    try {
-      return mapper(session).countProjects(profileName, language);
-    } finally {
-      MyBatis.closeQuietly(session);
-    }
-  }
-
   public Map<String, Long> countProjectsByProfileKey() {
     DbSession session = mybatis.openSession(false);
     try {
diff --git a/sonar-db/src/main/java/org/sonar/db/qualityprofile/QualityProfileMapper.java b/sonar-db/src/main/java/org/sonar/db/qualityprofile/QualityProfileMapper.java
index fa16136a8c2..514c61809eb 100644
--- a/sonar-db/src/main/java/org/sonar/db/qualityprofile/QualityProfileMapper.java
+++ b/sonar-db/src/main/java/org/sonar/db/qualityprofile/QualityProfileMapper.java
@@ -56,9 +56,6 @@ public interface QualityProfileMapper {
 
   // INHERITANCE
 
-  @CheckForNull
-  QualityProfileDto selectParent(String childKey);
-
   @CheckForNull
   QualityProfileDto selectParentById(int childId);
 
@@ -68,8 +65,6 @@ public interface QualityProfileMapper {
 
   List<ComponentDto> selectProjects(@Param("profileName") String profileName, @Param("language") String language);
 
-  int countProjects(@Param("profileName") String profileName, @Param("language") String language);
-
   List<QualityProfileProjectCount> countProjectsByProfile();
 
   QualityProfileDto selectByProjectIdAndLanguage(@Param("projectId") Long projectId, @Param("language") String language);
diff --git a/sonar-db/src/main/resources/org/sonar/db/qualityprofile/QualityProfileMapper.xml b/sonar-db/src/main/resources/org/sonar/db/qualityprofile/QualityProfileMapper.xml
index b5a998612c3..ff59efdc417 100644
--- a/sonar-db/src/main/resources/org/sonar/db/qualityprofile/QualityProfileMapper.xml
+++ b/sonar-db/src/main/resources/org/sonar/db/qualityprofile/QualityProfileMapper.xml
@@ -108,13 +108,6 @@
     WHERE p.id=#{id}
   </select>
 
-  <select id="selectParent" parameterType="string" resultType="QualityProfile">
-    SELECT
-    <include refid="profilesColumns"/>
-    FROM rules_profiles p
-    INNER JOIN rules_profiles child ON child.parent_kee=p.kee AND child.kee=#{id}
-  </select>
-
   <select id="selectParentById" parameterType="int" resultType="QualityProfile">
     SELECT
     <include refid="profilesColumns"/>
@@ -201,17 +194,6 @@
     ORDER BY pj.name ASC
   </select>
 
-  <select id="countProjects" parameterType="Integer" resultType="Integer">
-    SELECT count(projects.id)
-    FROM projects projects
-    JOIN project_qprofiles pp ON pp.project_uuid=projects.uuid
-    JOIN rules_profiles prof ON pp.profile_key=prof.kee
-    <where>
-      AND prof.language=#{language}
-      AND prof.name=#{profileName}
-    </where>
-  </select>
-
   <select id="countProjectsByProfile" resultType="org.sonar.db.qualityprofile.QualityProfileProjectCount">
     SELECT pp.profile_key as profileKey, count(projects.id) as projectCount
     FROM projects projects
diff --git a/sonar-db/src/test/java/org/sonar/db/qualityprofile/QualityProfileDaoTest.java b/sonar-db/src/test/java/org/sonar/db/qualityprofile/QualityProfileDaoTest.java
index bd46312f1f9..d9bcf4d278f 100644
--- a/sonar-db/src/test/java/org/sonar/db/qualityprofile/QualityProfileDaoTest.java
+++ b/sonar-db/src/test/java/org/sonar/db/qualityprofile/QualityProfileDaoTest.java
@@ -245,13 +245,6 @@ public class QualityProfileDaoTest {
     assertThat(underTest.selectProjects("Sonar Way", "java")).hasSize(2);
   }
 
-  @Test
-  public void count_projects() {
-    dbTester.prepareDbUnit(getClass(), "projects.xml");
-
-    assertThat(underTest.countProjects("Sonar Way", "java")).isEqualTo(2);
-  }
-
   @Test
   public void count_projects_by_profile() {
     dbTester.prepareDbUnit(getClass(), "projects.xml");
-- 
2.39.5