Mercurial > hg > soundsoftware-site
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]) |