comparison db/migrate/20120115143126_set_default_repositories.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
2 def self.up 2 def self.up
3 Repository.update_all(["is_default = ?", false]) 3 Repository.update_all(["is_default = ?", false])
4 # Sets the last repository as default in case multiple repositories exist for the same project 4 # Sets the last repository as default in case multiple repositories exist for the same project
5 Repository.connection.select_values("SELECT r.id FROM #{Repository.table_name} r" + 5 Repository.connection.select_values("SELECT r.id FROM #{Repository.table_name} r" +
6 " WHERE r.id = (SELECT max(r1.id) FROM #{Repository.table_name} r1 WHERE r1.project_id = r.project_id)").each do |i| 6 " WHERE r.id = (SELECT max(r1.id) FROM #{Repository.table_name} r1 WHERE r1.project_id = r.project_id)").each do |i|
7 Repository.update_all(["is_default = ?", true], ["id = ?", i]) 7 Repository.where(["id = ?", i]).update_all(["is_default = ?", true])
8 end 8 end
9 end 9 end
10 10
11 def self.down 11 def self.down
12 Repository.update_all(["is_default = ?", false]) 12 Repository.update_all(["is_default = ?", false])