gistfile1.rbx

class AddProjectIdToVotes < ActiveRecord::Migration
  def self.up
    # add_column :votes, :project_id, :integer
    
    DbCluster.each do |c|
      puts "Executing in #{c.connection_name}"
      
      Line::Version.find(:all).each do |line_version|
        Vote.find(:all, :conditions => { :voteable_type => 'Line::Version', :voteable_id => line_version.id }).each do |vote|
          if line_version.project_id
            Vote.update_all("voteable_id = '#{line_version.guid}', project_id = #{line_version.project_id}",
              "id = #{vote.id}"
            )
          end
        end
      end
    end
  end

  def self.down
    remove_column :votes, :project_id
  end
end