Chris@1115: class ChangeRepositoriesToFullSti < ActiveRecord::Migration
Chris@1115:   def up
Chris@1517:     Repository.connection.
Chris@1517:          select_rows("SELECT id, type FROM #{Repository.table_name}").
Chris@1517:          each do |repository_id, repository_type|
Chris@1115:       unless repository_type =~ /^Repository::/
Chris@1517:         Repository.where(["id = ?", repository_id]).
Chris@1517:           update_all(["type = ?", "Repository::#{repository_type}"])
Chris@1115:       end
Chris@1115:     end
Chris@1115:   end
Chris@1115: 
Chris@1115:   def down
Chris@1517:     Repository.connection.
Chris@1517:           select_rows("SELECT id, type FROM #{Repository.table_name}").
Chris@1517:           each do |repository_id, repository_type|
Chris@1115:       if repository_type =~ /^Repository::(.+)$/
Chris@1517:         Repository.where(["id = ?", repository_id]).update_all(["type = ?", $1])
Chris@1115:       end
Chris@1115:     end
Chris@1115:   end
Chris@1115: end