annotate 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
rev   line source
Chris@1115 1 class ChangeRepositoriesToFullSti < ActiveRecord::Migration
Chris@1115 2 def up
Chris@1115 3 Repository.connection.select_rows("SELECT id, type FROM #{Repository.table_name}").each do |repository_id, repository_type|
Chris@1115 4 unless repository_type =~ /^Repository::/
Chris@1115 5 Repository.update_all ["type = ?", "Repository::#{repository_type}"], ["id = ?", repository_id]
Chris@1115 6 end
Chris@1115 7 end
Chris@1115 8 end
Chris@1115 9
Chris@1115 10 def down
Chris@1115 11 Repository.connection.select_rows("SELECT id, type FROM #{Repository.table_name}").each do |repository_id, repository_type|
Chris@1115 12 if repository_type =~ /^Repository::(.+)$/
Chris@1115 13 Repository.update_all ["type = ?", $1], ["id = ?", repository_id]
Chris@1115 14 end
Chris@1115 15 end
Chris@1115 16 end
Chris@1115 17 end