##// END OF EJS Templates
jro_apps » redmine
RSS
Rails4: replace deprecated Relation#update_all at SetDefaultRepositories db migration...
Toshi MARUYAMA -
r12219:1d0c93792b71
parent child
Show More
Side by Side Unified
Context file:
r12219:1d0c93792b71 Loading diff...:
Show file before | Show file after | Hide comments
@@ -1,14 +1,14
1 class SetDefaultRepositories < ActiveRecord::Migration
1 class SetDefaultRepositories < ActiveRecord::Migration
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])
13 end
13 end
14 end
14 end
General Comments 0
You need to be logged in to leave comments. Login now