Contents

class AddBlogIdToResources < ActiveRecord::Migration[4.2]
  class Blog < ActiveRecord::Base; end
  class Content < ActiveRecord::Base; end
  class Resource < ActiveRecord::Base; end

  def up
    add_column :resources, :blog_id, :integer

    if Resource.any?
      default_blog_id = Blog.order(:id).first.id
      Resource.find_each do |resource|
        content_id = resource.article_id
        blog_id = if content_id
                    Content.find(content_id).blog_id
                  else
                    default_blog_id
                  end
        resource.update_column(:blog_id, blog_id)
      end
    end

    change_column :resources, :blog_id, :integer, null: false
  end

  def down
    remove_column :resources, :blog_id
  end
end

Version data entries

3 entries across 3 versions & 1 rubygems

Version	Path
publify_core-9.1.0	db/migrate/20160701062604_add_blog_id_to_resources.rb
publify_core-9.0.1	db/migrate/20160701062604_add_blog_id_to_resources.rb
publify_core-9.0.0	db/migrate/20160701062604_add_blog_id_to_resources.rb