diff options
| author | simonbrandhof <simon.brandhof@gmail.com> | 2010-10-20 21:11:41 +0000 |
|---|---|---|
| committer | simonbrandhof <simon.brandhof@gmail.com> | 2010-10-20 21:11:41 +0000 |
| commit | d6910162656f1af6f54fbf8496cf7492248cc2d1 (patch) | |
| tree | a67aecc8d58295b68bd17fb00d84c73a1a59c8a5 | |
| parent | cc06e000c3f2ac3028362d80ba1e0add2e3d28cf (diff) | |
| download | sonarqube-d6910162656f1af6f54fbf8496cf7492248cc2d1.tar.gz sonarqube-d6910162656f1af6f54fbf8496cf7492248cc2d1.zip | |
SONAR-1881 delete orphan active rules
| -rw-r--r-- | sonar-core/src/main/java/org/sonar/jpa/entity/SchemaMigration.java | 2 | ||||
| -rw-r--r-- | sonar-server/src/main/webapp/WEB-INF/db/migrate/142_delete_active_rules_orphans.rb | 29 | ||||
| -rw-r--r-- | sonar-server/src/main/webapp/WEB-INF/db/migrate/150_add_plugins_child_first_classloader_column.rb (renamed from sonar-server/src/main/webapp/WEB-INF/db/migrate/142_add_plugins_child_first_classloader_column.rb) | 0 |
3 files changed, 30 insertions, 1 deletions
diff --git a/sonar-core/src/main/java/org/sonar/jpa/entity/SchemaMigration.java b/sonar-core/src/main/java/org/sonar/jpa/entity/SchemaMigration.java index c6d4e942160..60f57295f39 100644 --- a/sonar-core/src/main/java/org/sonar/jpa/entity/SchemaMigration.java +++ b/sonar-core/src/main/java/org/sonar/jpa/entity/SchemaMigration.java @@ -30,7 +30,7 @@ import java.sql.Statement; public class SchemaMigration { public final static int VERSION_UNKNOWN = -1; - public static final int LAST_VERSION = 142; + public static final int LAST_VERSION = 150; public final static String TABLE_NAME = "schema_migrations"; diff --git a/sonar-server/src/main/webapp/WEB-INF/db/migrate/142_delete_active_rules_orphans.rb b/sonar-server/src/main/webapp/WEB-INF/db/migrate/142_delete_active_rules_orphans.rb new file mode 100644 index 00000000000..8c56dc3caf3 --- /dev/null +++ b/sonar-server/src/main/webapp/WEB-INF/db/migrate/142_delete_active_rules_orphans.rb @@ -0,0 +1,29 @@ + # + # Sonar, entreprise quality control tool. + # Copyright (C) 2009 SonarSource SA + # mailto:contact AT sonarsource DOT com + # + # Sonar is free software; you can redistribute it and/or + # modify it under the terms of the GNU Lesser General Public + # License as published by the Free Software Foundation; either + # version 3 of the License, or (at your option) any later version. + # + # Sonar is distributed in the hope that it will be useful, + # but WITHOUT ANY WARRANTY; without even the implied warranty of + # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU + # Lesser General Public License for more details. + # + # You should have received a copy of the GNU Lesser General Public + # License along with Sonar; if not, write to the Free Software + # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02 + # +class DeleteActiveRulesOrphans < ActiveRecord::Migration + + def self.up + # see http://jira.codehaus.org/browse/SONAR-1881 + orphans=ActiveRule.find_by_sql "SELECT ar.* FROM active_rules ar WHERE NOT EXISTS (SELECT * FROM rules_profiles pr WHERE pr.id=ar.profile_id)" + orphans.each do |orphan| + orphan.destroy + end + end +end
\ No newline at end of file diff --git a/sonar-server/src/main/webapp/WEB-INF/db/migrate/142_add_plugins_child_first_classloader_column.rb b/sonar-server/src/main/webapp/WEB-INF/db/migrate/150_add_plugins_child_first_classloader_column.rb index 14842ab96a6..14842ab96a6 100644 --- a/sonar-server/src/main/webapp/WEB-INF/db/migrate/142_add_plugins_child_first_classloader_column.rb +++ b/sonar-server/src/main/webapp/WEB-INF/db/migrate/150_add_plugins_child_first_classloader_column.rb |