comparison db/migrate/20120422150750_change_repositories_to_full_sti.rb @ 1517:dffacf8a6908 redmine-2.5

Update to Redmine SVN revision 13367 on 2.5-stable branch
author Chris Cannam
date Tue, 09 Sep 2014 09:29:00 +0100
parents 433d4f72a19b
children
comparison
equal deleted inserted replaced
1516:b450a9d58aed 1517:dffacf8a6908
1 class ChangeRepositoriesToFullSti < ActiveRecord::Migration 1 class ChangeRepositoriesToFullSti < ActiveRecord::Migration
2 def up 2 def up
3 Repository.connection.select_rows("SELECT id, type FROM #{Repository.table_name}").each do |repository_id, repository_type| 3 Repository.connection.
4 select_rows("SELECT id, type FROM #{Repository.table_name}").
5 each do |repository_id, repository_type|
4 unless repository_type =~ /^Repository::/ 6 unless repository_type =~ /^Repository::/
5 Repository.update_all ["type = ?", "Repository::#{repository_type}"], ["id = ?", repository_id] 7 Repository.where(["id = ?", repository_id]).
8 update_all(["type = ?", "Repository::#{repository_type}"])
6 end 9 end
7 end 10 end
8 end 11 end
9 12
10 def down 13 def down
11 Repository.connection.select_rows("SELECT id, type FROM #{Repository.table_name}").each do |repository_id, repository_type| 14 Repository.connection.
15 select_rows("SELECT id, type FROM #{Repository.table_name}").
16 each do |repository_id, repository_type|
12 if repository_type =~ /^Repository::(.+)$/ 17 if repository_type =~ /^Repository::(.+)$/
13 Repository.update_all ["type = ?", $1], ["id = ?", repository_id] 18 Repository.where(["id = ?", repository_id]).update_all(["type = ?", $1])
14 end 19 end
15 end 20 end
16 end 21 end
17 end 22 end