Chris@909: class PopulateChangesetsUserId < ActiveRecord::Migration Chris@909: def self.up Chris@909: committers = Changeset.connection.select_values("SELECT DISTINCT committer FROM #{Changeset.table_name}") Chris@909: committers.each do |committer| Chris@909: next if committer.blank? Chris@909: if committer.strip =~ /^([^<]+)(<(.*)>)?$/ Chris@909: username, email = $1.strip, $3 Chris@909: u = User.find_by_login(username) Chris@909: u ||= User.find_by_mail(email) unless email.blank? Chris@909: Changeset.update_all("user_id = #{u.id}", ["committer = ?", committer]) unless u.nil? Chris@909: end Chris@909: end Chris@909: end Chris@909: Chris@909: def self.down Chris@909: Changeset.update_all('user_id = NULL') Chris@909: end Chris@909: end