Chris@1517: class SetDefaultRepositories < ActiveRecord::Migration
Chris@1517:   def self.up
Chris@1517:     Repository.update_all(["is_default = ?", false])
Chris@1517:     # Sets the last repository as default in case multiple repositories exist for the same project
Chris@1517:     Repository.connection.select_values("SELECT r.id FROM #{Repository.table_name} r" +
Chris@1517:       " WHERE r.id = (SELECT max(r1.id) FROM #{Repository.table_name} r1 WHERE r1.project_id = r.project_id)").each do |i|
Chris@1517:         Repository.where(["id = ?", i]).update_all(["is_default = ?", true])
Chris@1517:     end
Chris@1517:   end
Chris@1517: 
Chris@1517:   def self.down
Chris@1517:     Repository.update_all(["is_default = ?", false])
Chris@1517:   end
Chris@1517: end