class MigrateDataFromOldStructureToNewStructure < ActiveRecord::Migration
  add_column :posts, :published_at, :datetime
  def self.up
    Category.find(:all).each do |category|
      Blog.new do |blog|
        blog.id = category.id
        blog.name = category.name
        blog.user_id = '87'
        blog.created_at = category.created_at
        blog.updated_at = category.updated_at
        blog.posts_count = category.articles_count
        blog.private = '0'
        blog.save!
      end
    end
    Article.find(:all).each do |article|
      Post.new do |post|
        post.id = article.id
        post.blog_id  = article.category_id
        post.name = article.name
        post.body = article.body
        post.dt_at = article.created_at
        post.author = 'Редакция Rupoker.com'
        post.created_at = article.created_at
        post.updated_at = article.updated_at
        post.user_id  = '8'
        post.cached_slug = article.slug
        post.tag_list = article.tag_list+","+article.location.name
        post.published_at = article.dt
        post.save!
      end
    end
  end

  def self.down
    remove_column :posts, :published_at
  end
end