view db/migrate/20120422150750_change_repositories_to_full_sti.rb @ 1384:b51b5ae3734c luisf

Merge
author luisf <luis.figueira@eecs.qmul.ac.uk>
date Fri, 20 Sep 2013 19:04:25 +0100
parents 433d4f72a19b
children dffacf8a6908
line wrap: on
line source
class ChangeRepositoriesToFullSti < ActiveRecord::Migration
  def up
    Repository.connection.select_rows("SELECT id, type FROM #{Repository.table_name}").each do |repository_id, repository_type|
      unless repository_type =~ /^Repository::/
        Repository.update_all ["type = ?", "Repository::#{repository_type}"], ["id = ?", repository_id]
      end
    end
  end

  def down
    Repository.connection.select_rows("SELECT id, type FROM #{Repository.table_name}").each do |repository_id, repository_type|
      if repository_type =~ /^Repository::(.+)$/
        Repository.update_all ["type = ?", $1], ["id = ?", repository_id]
      end
    end
  end
end