From add64436be2fc275aa2578dc6a4eeab427b41208 Mon Sep 17 00:00:00 2001
From: Simon Brandhof <simon.brandhof@sonarsource.com>
Date: Mon, 15 Sep 2014 15:54:45 +0200
Subject: SONAR-5580 Migration issue to SQ 4.4 when the quality profile used to
 analyze the last version of a project has been removed before the migration

---
 .../java/org/sonar/core/persistence/DatabaseVersion.java     |  2 +-
 .../core/persistence/migration/v44/Migration44Mapper.java    |  4 ++++
 .../core/persistence/migration/v44/Migration44Mapper.xml     | 12 ++++++++++++
 .../main/resources/org/sonar/core/persistence/rows-h2.sql    |  1 +
 4 files changed, 18 insertions(+), 1 deletion(-)

(limited to 'sonar-core')

diff --git a/sonar-core/src/main/java/org/sonar/core/persistence/DatabaseVersion.java b/sonar-core/src/main/java/org/sonar/core/persistence/DatabaseVersion.java
index ee7e376fa52..105c8c5b58f 100644
--- a/sonar-core/src/main/java/org/sonar/core/persistence/DatabaseVersion.java
+++ b/sonar-core/src/main/java/org/sonar/core/persistence/DatabaseVersion.java
@@ -33,7 +33,7 @@ import java.util.List;
  */
 public class DatabaseVersion implements BatchComponent, ServerComponent {
 
-  public static final int LAST_VERSION = 583;
+  public static final int LAST_VERSION = 584;
 
   public static enum Status {
     UP_TO_DATE, REQUIRES_UPGRADE, REQUIRES_DOWNGRADE, FRESH_INSTALL
diff --git a/sonar-core/src/main/java/org/sonar/core/persistence/migration/v44/Migration44Mapper.java b/sonar-core/src/main/java/org/sonar/core/persistence/migration/v44/Migration44Mapper.java
index 19075d6e9db..8bffe19dd17 100644
--- a/sonar-core/src/main/java/org/sonar/core/persistence/migration/v44/Migration44Mapper.java
+++ b/sonar-core/src/main/java/org/sonar/core/persistence/migration/v44/Migration44Mapper.java
@@ -40,6 +40,8 @@ public interface Migration44Mapper {
 
   void updateProfileMeasure(@Param("measureId") long measureId, @Param("json") String json);
 
+  void deleteProfileMeasure(long profileMeasureId);
+
   @CheckForNull
   QProfileDto44 selectProfileById(int id);
 
@@ -56,4 +58,6 @@ public interface Migration44Mapper {
 
   // migrate changeLog to Activities
   List<ChangeLog> selectActiveRuleChange(@Nullable @Param("enabled") Boolean enabled);
+
+  List<Long> selectMeasuresOnDeletedQualityProfiles();
 }
diff --git a/sonar-core/src/main/resources/org/sonar/core/persistence/migration/v44/Migration44Mapper.xml b/sonar-core/src/main/resources/org/sonar/core/persistence/migration/v44/Migration44Mapper.xml
index f2c0c203b09..eeb24110187 100644
--- a/sonar-core/src/main/resources/org/sonar/core/persistence/migration/v44/Migration44Mapper.xml
+++ b/sonar-core/src/main/resources/org/sonar/core/persistence/migration/v44/Migration44Mapper.xml
@@ -35,6 +35,18 @@
     where id=#{measureId}
   </update>
 
+  <delete id="deleteProfileMeasure" parameterType="long">
+    delete from project_measures where id=#{id}
+  </delete>
+
+  <select id="selectMeasuresOnDeletedQualityProfiles" resultType="long">
+     select pm.id from project_measures pm
+      inner join snapshots as s on s.id=pm.snapshot_id and s.islast=${_true}
+      where
+        pm.metric_id=(select id from metrics where name='quality_profiles')
+        and pm.value is not null
+  </select>
+
   <select id="selectProfileUpdatedAt" resultType="date" parameterType="int">
     select max(change_date) from active_rule_changes
     where profile_id=#{id}
diff --git a/sonar-core/src/main/resources/org/sonar/core/persistence/rows-h2.sql b/sonar-core/src/main/resources/org/sonar/core/persistence/rows-h2.sql
index 9634897e73f..d9ea9b3d667 100644
--- a/sonar-core/src/main/resources/org/sonar/core/persistence/rows-h2.sql
+++ b/sonar-core/src/main/resources/org/sonar/core/persistence/rows-h2.sql
@@ -253,6 +253,7 @@ INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('580');
 INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('581');
 INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('582');
 INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('583');
+INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('584');
 
 INSERT INTO USERS(ID, LOGIN, NAME, EMAIL, CRYPTED_PASSWORD, SALT, CREATED_AT, UPDATED_AT, REMEMBER_TOKEN, REMEMBER_TOKEN_EXPIRES_AT) VALUES (1, 'admin', 'Administrator', '', 'a373a0e667abb2604c1fd571eb4ad47fe8cc0878', '48bc4b0d93179b5103fd3885ea9119498e9d161b', '2011-09-26 22:27:48.0', '2011-09-26 22:27:48.0', null, null);
 ALTER TABLE USERS ALTER COLUMN ID RESTART WITH 2;
-- 
cgit v1.2.3