Contents

class AddPagesRankedModel < ActiveRecord::Migration
  def up
    add_column    :cms_pages,         :row_order,   :integer
    rename_column :cms_contentitems,  :position,  :row_order

    #--- because of some duplications in the position column, need to 
    #    create a more unique position value.  So add up the positions
    total = 0
    CmsPage.unscoped.order(:ancestry, :position).each do |page|
      total = total + page.position
      Account.current = Account.find(page.account_id)
      page.update_attributes :row_order => total
    end
    remove_column :cms_pages,        :position
  end
  
  def down
    remove_column :cms_pages,         :row_order
    add_columnn   :cms_pages,         :position, :integer
    rename_column :cms_contentitems,  :row_order, :position
  end
end

Version data entries

16 entries across 16 versions & 1 rubygems

Version	Path
dm_cms-4.2.3.10	db/migrate/20140328205246_add_pages_ranked_model.rb
dm_cms-4.2.3.9	db/migrate/20140328205246_add_pages_ranked_model.rb
dm_cms-4.2.3.8	db/migrate/20140328205246_add_pages_ranked_model.rb
dm_cms-4.2.3.7	db/migrate/20140328205246_add_pages_ranked_model.rb
dm_cms-4.2.3.6	db/migrate/20140328205246_add_pages_ranked_model.rb
dm_cms-4.2.3.5	db/migrate/20140328205246_add_pages_ranked_model.rb
dm_cms-4.2.3.4	db/migrate/20140328205246_add_pages_ranked_model.rb
dm_cms-4.2.3.3	db/migrate/20140328205246_add_pages_ranked_model.rb
dm_cms-4.2.3.2	db/migrate/20140328205246_add_pages_ranked_model.rb
dm_cms-4.2.3.1	db/migrate/20140328205246_add_pages_ranked_model.rb
dm_cms-4.2.3	db/migrate/20140328205246_add_pages_ranked_model.rb
dm_cms-4.2.2.3	db/migrate/20140328205246_add_pages_ranked_model.rb
dm_cms-4.2.2.2	db/migrate/20140328205246_add_pages_ranked_model.rb
dm_cms-4.2.2.1	db/migrate/20140328205246_add_pages_ranked_model.rb
dm_cms-4.2.2	db/migrate/20140328205246_add_pages_ranked_model.rb
dm_cms-4.2.1.5	db/migrate/20140328205246_add_pages_ranked_model.rb