Contents

# change post structure to optimize query speed
class RenameColumnPosts < ActiveRecord::Migration
  def change
    remove_column :posts, :comment_count
    add_column :posts, :post_order, :integer, default: 0
    add_column :posts, :taxonomy_id, :integer, default: nil, index: true
    Post.all.each do |post|
      begin
        post_id = post.get_post_type_depre.id
        post.update_column("taxonomy_id", post_id)
        post_order = post.term_relationships.where("term_taxonomy_id = ?", post_id).first.term_order
        post.update_column("post_order", post_order)
      rescue
        # puts "**************** The following Post is invalid: #{post.inspect}"
      end
    end
  end
end

Version data entries

11 entries across 11 versions & 1 rubygems

Version	Path
camaleon_cms-1.1.0	db/migrate/20150926095310_rename_column_posts.rb
camaleon_cms-1.0.9	db/migrate/20150926095310_rename_column_posts.rb
camaleon_cms-1.0.8	db/migrate/20150926095310_rename_column_posts.rb
camaleon_cms-1.0.7	db/migrate/20150926095310_rename_column_posts.rb
camaleon_cms-1.0.6	db/migrate/20150926095310_rename_column_posts.rb
camaleon_cms-1.0.5	db/migrate/20150926095310_rename_column_posts.rb
camaleon_cms-1.0.4	db/migrate/20150926095310_rename_column_posts.rb
camaleon_cms-1.0.3	db/migrate/20150926095310_rename_column_posts.rb
camaleon_cms-1.0.2	db/migrate/20150926095310_rename_column_posts.rb
camaleon_cms-1.0.1	db/migrate/20150926095310_rename_column_posts.rb
camaleon_cms-1.0	db/migrate/20150926095310_rename_column_posts.rb