Contents

class AddPositionToItems < ActiveRecord::Migration
  def change
    add_column :items, :position, :integer

    Item.order('id desc').each.with_index do |item, position|
      item.update_attribute :position, position
    end

    change_column :items, :position, :integer, :null => false

    add_index :items, [:position]
  end
end

Version data entries

23 entries across 8 versions & 1 rubygems

Version	Path
activerecord-sortable-0.0.3	spec/dummy/db/migrate/20140525112123_add_position_to_items.rb
activerecord-sortable-0.0.2	spec/dummy/db/migrate/20140525112123_add_position_to_items.rb
activerecord-sortable-0.0.1	spec/dummy/db/migrate/20140525112123_add_position_to_items.rb