Contents

class AddPositionToPages < ActiveRecord::Migration
  def self.up
    add_column :pages, :position, :integer
    Page.reset_column_information
    say_with_time("Putting all pages in a default order...") do
      ActiveRecord::Base.record_timestamps = false
      Page.where(parent_id: nil).each do |p|
        put_children_into_list(p)
      end
      ActiveRecord::Base.record_timestamps = true
    end
  end
  
  def self.down
    remove_column :pages, :position
  end
  
  def self.put_children_into_list(page)
    page.children.order("title asc").each_with_index do |pg, idx|
      pg.update_attribute('position', idx + 1)
      put_children_into_list(pg)
    end
  end
end

Version data entries

6 entries across 6 versions & 1 rubygems

Version	Path
trusty-reorder-extension-2.0.6	db/migrate/01_add_position_to_pages.rb
trusty-reorder-extension-2.0.5	db/migrate/01_add_position_to_pages.rb
trusty-reorder-extension-2.0.4	db/migrate/01_add_position_to_pages.rb
trusty-reorder-extension-2.0.3	db/migrate/01_add_position_to_pages.rb
trusty-reorder-extension-2.0.2	db/migrate/01_add_position_to_pages.rb
trusty-reorder-extension-2.0.1.pre.beta	db/migrate/01_add_position_to_pages.rb