Contents

class AdminData::DiagnosticController < AdminData::BaseController

  unloadable

  before_filter :ensure_is_allowed_to_view

  def index
    @page_title = 'diagnostic'
    respond_to {|format| format.html}
  end

  def missing_index
    @page_title = 'missing index'
    @indexes = {}
    conn = ActiveRecord::Base.connection
    conn.tables.each do |table|
      indexed_columns = conn.indexes(table).map { |i| i.columns }.flatten
      conn.columns(table).each do |column|
        if column.name.match(/_id/) && !indexed_columns.include?(column.name)
          @indexes[table] ||= []
          @indexes[table] << column.name
        end
      end
    end
    respond_to {|format| format.html}
  end

end

Version data entries

3 entries across 3 versions & 1 rubygems

Version	Path
admin_data-1.0.2	app/controllers/admin_data/diagnostic_controller.rb
admin_data-1.0.1	app/controllers/admin_data/diagnostic_controller.rb
admin_data-1.0.0	app/controllers/admin_data/diagnostic_controller.rb