Contents

class AddCommentCountToActivityObject < ActiveRecord::Migration
  def up
    add_column :activity_objects, :comment_count, :integer, :default => 0

    ActivityObject.record_timestamps = false
    ActivityObject.reset_column_information

    ActivityObject.all.each do |ao|
      parent_activity = ao.activities.first

      # Actors have not parent activities
      next if parent_activity.blank?

      ao.update_attribute(:comment_count, Activity.includes(:activity_objects).where('activity_objects.object_type' => "Comment").where(:ancestry => [parent_activity.id]).size)
    end

    ActivityObject.record_timestamps = true
    ActivityObject.reset_column_information
  end

  def down
    remove_column :activity_objects, :comment_count
  end
end

Version data entries

41 entries across 41 versions & 2 rubygems

Version	Path
social_stream-1.1.12	base/db/migrate/20120621135650_add_comment_count_to_activity_object.rb
social_stream-base-1.1.11	db/migrate/20120621135650_add_comment_count_to_activity_object.rb
social_stream-1.1.11	base/db/migrate/20120621135650_add_comment_count_to_activity_object.rb
social_stream-base-1.1.10	db/migrate/20120621135650_add_comment_count_to_activity_object.rb
social_stream-1.1.10	base/db/migrate/20120621135650_add_comment_count_to_activity_object.rb
social_stream-base-1.1.9	db/migrate/20120621135650_add_comment_count_to_activity_object.rb
social_stream-1.1.9	base/db/migrate/20120621135650_add_comment_count_to_activity_object.rb
social_stream-base-1.1.8	db/migrate/20120621135650_add_comment_count_to_activity_object.rb
social_stream-1.1.8	base/db/migrate/20120621135650_add_comment_count_to_activity_object.rb
social_stream-base-1.1.7	db/migrate/20120621135650_add_comment_count_to_activity_object.rb
social_stream-1.1.7	base/db/migrate/20120621135650_add_comment_count_to_activity_object.rb
social_stream-base-1.1.6	db/migrate/20120621135650_add_comment_count_to_activity_object.rb
social_stream-1.1.6	base/db/migrate/20120621135650_add_comment_count_to_activity_object.rb
social_stream-base-1.1.5	db/migrate/20120621135650_add_comment_count_to_activity_object.rb
social_stream-1.1.5	base/db/migrate/20120621135650_add_comment_count_to_activity_object.rb
social_stream-base-1.1.4	db/migrate/20120621135650_add_comment_count_to_activity_object.rb
social_stream-1.1.4	base/db/migrate/20120621135650_add_comment_count_to_activity_object.rb
social_stream-1.1.3	base/db/migrate/20120621135650_add_comment_count_to_activity_object.rb
social_stream-base-1.1.3	db/migrate/20120621135650_add_comment_count_to_activity_object.rb
social_stream-1.1.2	base/db/migrate/20120621135650_add_comment_count_to_activity_object.rb