annotate db/migrate/.svn/text-base/072_add_enumerations_position.rb.svn-base @ 36:de76cd3e8c8e cc-branches

* Probably abortive experiments in extracting the branch from Hg
author Chris Cannam <chris.cannam@soundsoftware.ac.uk>
date Wed, 20 Oct 2010 10:07:29 +0100
parents 513646585e45
children
rev   line source
Chris@0 1 class AddEnumerationsPosition < ActiveRecord::Migration
Chris@0 2 def self.up
Chris@0 3 add_column(:enumerations, :position, :integer, :default => 1) unless Enumeration.column_names.include?('position')
Chris@0 4 Enumeration.find(:all).group_by(&:opt).each do |opt, enums|
Chris@0 5 enums.each_with_index do |enum, i|
Chris@0 6 # do not call model callbacks
Chris@0 7 Enumeration.update_all "position = #{i+1}", {:id => enum.id}
Chris@0 8 end
Chris@0 9 end
Chris@0 10 end
Chris@0 11
Chris@0 12 def self.down
Chris@0 13 remove_column :enumerations, :position
Chris@0 14 end
Chris@0 15 end