Contents

class RemoveDuplicatedIndexOnAllTables < ActiveRecord::Migration
    def self.up
        ActiveRecord::Base.connection.tables.each do |t|
            if ActiveRecord::Base.connection.indexes(t).collect {|c| c.columns}.include?("id")
                remove_index t.to_s, :id
            end
        end
    end

    def self.down
        ActiveRecord::Base.connection.tables.each do |t|
            unless ActiveRecord::Base.connection.indexes(t).collect {|c| c.columns}.include?("id")
                add_index t.to_s, :id, :integer => true
            end
        end
    end
end

Version data entries

6 entries across 6 versions & 1 rubygems

Version	Path
puppet-0.25.5	lib/puppet/rails/database/002_remove_duplicated_index_on_all_tables.rb
puppet-0.25.4	lib/puppet/rails/database/002_remove_duplicated_index_on_all_tables.rb
puppet-0.25.3	lib/puppet/rails/database/002_remove_duplicated_index_on_all_tables.rb
puppet-0.25.2	lib/puppet/rails/database/002_remove_duplicated_index_on_all_tables.rb
puppet-0.25.1	lib/puppet/rails/database/002_remove_duplicated_index_on_all_tables.rb
puppet-0.25.0	lib/puppet/rails/database/002_remove_duplicated_index_on_all_tables.rb