From e93d3eb4d95d89051eb9ea6f6ab6b8f2f6751487 Mon Sep 17 00:00:00 2001 From: Fabrice Bellingard Date: Mon, 26 Mar 2012 17:47:26 +0200 Subject: SONAR-3352 Fix issue linked to nullable boolean columns --- .../281_clean_reviews_with_null_booleans.rb | 35 ++++++++++++++++++++++ 1 file changed, 35 insertions(+) create mode 100644 sonar-server/src/main/webapp/WEB-INF/db/migrate/281_clean_reviews_with_null_booleans.rb (limited to 'sonar-server/src/main/webapp/WEB-INF') diff --git a/sonar-server/src/main/webapp/WEB-INF/db/migrate/281_clean_reviews_with_null_booleans.rb b/sonar-server/src/main/webapp/WEB-INF/db/migrate/281_clean_reviews_with_null_booleans.rb new file mode 100644 index 00000000000..1f7dac497e0 --- /dev/null +++ b/sonar-server/src/main/webapp/WEB-INF/db/migrate/281_clean_reviews_with_null_booleans.rb @@ -0,0 +1,35 @@ +# +# Sonar, entreprise quality control tool. +# Copyright (C) 2008-2012 SonarSource +# 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 +# + +# +# Sonar 2.15 +# +class CleanReviewsWithNullBooleans < ActiveRecord::Migration + + class Review < ActiveRecord::Base + end + + def self.up + Review.reset_column_information + Review.update_all(Review.sanitize_sql_for_assignment({:manual_violation => false}), "manual_violation IS null") + Review.update_all(Review.sanitize_sql_for_assignment({:manual_severity => false}), "manual_severity IS null") + end + +end -- cgit v1.2.3