Contents

class AddNestingToArticles < ActiveRecord::Migration
  def self.up
    remove_column :contents, :position
    add_column :contents, :parent_id, :integer
    add_column :contents, :lft, :integer, :default => 0, :null => false
    add_column :contents, :rgt, :integer, :default => 0, :null => false

    # initialize lft, rgt, and parent_ids in all articles for each section
    Article.all.group_by(&:section).each do |section, articles| 
      articles.each_with_index do |a, i|
        a.parent_id = nil
        a.lft = i*2+1
        a.rgt = i*2+2
        a.save
      end
    end

  end

  def self.down
    add_column  :contents, :position, :integer
    remove_column :contents, :parent_id
    remove_column :contents, :lft
    remove_column :contents, :rgt
  end
end

Version data entries

15 entries across 15 versions & 2 rubygems

Version	Path
adva-0.3.2	db/migrate/20091026000906_add_nesting_to_articles.rb
adva-0.3.1	db/migrate/20091026000906_add_nesting_to_articles.rb
adva-0.3.0	db/migrate/20091026000906_add_nesting_to_articles.rb
adva-0.2.4	db/migrate/20091026000906_add_nesting_to_articles.rb
adva-0.2.3	db/migrate/20091026000906_add_nesting_to_articles.rb
adva-0.2.2	db/migrate/20091026000906_add_nesting_to_articles.rb
adva-0.2.1	db/migrate/20091026000906_add_nesting_to_articles.rb
adva-0.2.0	db/migrate/20091026000906_add_nesting_to_articles.rb
adva-0.1.4	db/migrate/20091026000906_add_nesting_to_articles.rb
adva-0.1.3	db/migrate/20091026000906_add_nesting_to_articles.rb
adva-0.1.2	db/migrate/20091026000906_add_nesting_to_articles.rb
adva-0.1.1	db/migrate/20091026000906_add_nesting_to_articles.rb
adva-0.1.0	db/migrate/20091026000906_add_nesting_to_articles.rb
adva_cms-0.0.1	db/migrate/20091026000906_add_nesting_to_articles.rb
adva-0.0.1	adva_cms/db/migrate/20091026000906_add_nesting_to_articles.rb