From d6910162656f1af6f54fbf8496cf7492248cc2d1 Mon Sep 17 00:00:00 2001 From: simonbrandhof Date: Wed, 20 Oct 2010 21:11:41 +0000 Subject: SONAR-1881 delete orphan active rules --- ...2_add_plugins_child_first_classloader_column.rb | 28 --------------------- .../db/migrate/142_delete_active_rules_orphans.rb | 29 ++++++++++++++++++++++ ...0_add_plugins_child_first_classloader_column.rb | 28 +++++++++++++++++++++ 3 files changed, 57 insertions(+), 28 deletions(-) delete mode 100644 sonar-server/src/main/webapp/WEB-INF/db/migrate/142_add_plugins_child_first_classloader_column.rb create mode 100644 sonar-server/src/main/webapp/WEB-INF/db/migrate/142_delete_active_rules_orphans.rb create mode 100644 sonar-server/src/main/webapp/WEB-INF/db/migrate/150_add_plugins_child_first_classloader_column.rb (limited to 'sonar-server/src') 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/142_add_plugins_child_first_classloader_column.rb deleted file mode 100644 index 14842ab96a6..00000000000 --- a/sonar-server/src/main/webapp/WEB-INF/db/migrate/142_add_plugins_child_first_classloader_column.rb +++ /dev/null @@ -1,28 +0,0 @@ -# -# 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 AddPluginsChildFirstClassloaderColumn < ActiveRecord::Migration - - def self.up - add_column 'plugins', 'child_first_classloader', :boolean, :null => true - Plugin.reset_column_information - Plugin.update_all(Plugin.sanitize_sql_for_assignment({:child_first_classloader=>false})) - end - -end 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/150_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 new file mode 100644 index 00000000000..14842ab96a6 --- /dev/null +++ b/sonar-server/src/main/webapp/WEB-INF/db/migrate/150_add_plugins_child_first_classloader_column.rb @@ -0,0 +1,28 @@ +# +# 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 AddPluginsChildFirstClassloaderColumn < ActiveRecord::Migration + + def self.up + add_column 'plugins', 'child_first_classloader', :boolean, :null => true + Plugin.reset_column_information + Plugin.update_all(Plugin.sanitize_sql_for_assignment({:child_first_classloader=>false})) + end + +end -- cgit v1.2.3