view .svn/pristine/fd/fd9cfecdc53ee6ce77b107732eb9cf31666cd8fa.svn-base @ 1539:22d57b0e0a77 live

OK, this script works now, but it should be using the API

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

  def self.down
    Repository.update_all(["is_default = ?", false])
  end
end