From caf49264c89a5bb1c3cff0dbe51be24839574555 2014-01-17 01:41:06 From: Toshi MARUYAMA Date: 2014-01-17 01:41:06 Subject: [PATCH] Rails4: replace deprecated Relation#update_all at ChangeRepositoriesToFullSti db migration git-svn-id: http://svn.redmine.org/redmine/trunk@12664 e93f8b46-1217-0410-a6f0-8f06a7374b81 --- diff --git a/db/migrate/20120422150750_change_repositories_to_full_sti.rb b/db/migrate/20120422150750_change_repositories_to_full_sti.rb index 067d602..d0de7ba 100644 --- a/db/migrate/20120422150750_change_repositories_to_full_sti.rb +++ b/db/migrate/20120422150750_change_repositories_to_full_sti.rb @@ -1,16 +1,21 @@ class ChangeRepositoriesToFullSti < ActiveRecord::Migration def up - Repository.connection.select_rows("SELECT id, type FROM #{Repository.table_name}").each do |repository_id, repository_type| + Repository.connection. + select_rows("SELECT id, type FROM #{Repository.table_name}"). + each do |repository_id, repository_type| unless repository_type =~ /^Repository::/ - Repository.update_all ["type = ?", "Repository::#{repository_type}"], ["id = ?", repository_id] + Repository.where(["id = ?", repository_id]). + update_all(["type = ?", "Repository::#{repository_type}"]) end end end def down - Repository.connection.select_rows("SELECT id, type FROM #{Repository.table_name}").each do |repository_id, repository_type| + Repository.connection. + select_rows("SELECT id, type FROM #{Repository.table_name}"). + each do |repository_id, repository_type| if repository_type =~ /^Repository::(.+)$/ - Repository.update_all ["type = ?", $1], ["id = ?", repository_id] + Repository.where(["id = ?", repository_id]).update_all(["type = ?", $1]) end end end