class ReplacingPlanRolesWithBitflags < ActiveRecord::Migration
  def change
    # create the field to hold the user's role in plans
    add_column :roles, :access, :integer, null: false, default: 0
    # rename creator, editor, and aministrator column names so we can access data
    rename_column :roles, :creator, :create
    rename_column :roles, :editor, :edit
    rename_column :roles, :administrator, :admin

    # transfer the data from the other fields to the bitfield
    if table_exists?('roles')
      Role.find_each do |role|
        if role.admin
          role.administrator = true
        end
        if role.edit
          role.editor = true
        end
        if role.create
          role.creator = true
        end
        if role.user.nil?
          Role.delete_all(user_id: role.user_id)
        else
          role.save!
        end
      end
    end
    
    # remove the other columns
    remove_column :roles, :create
    remove_column :roles, :edit
    remove_column :roles, :admin
  end
end