Sha256: b34815bf4e7442b2844c9094fb734154eedd4669a7c8bcbca9ffb1b3f46b9385

Contents?: true

Size: 1.85 KB

Versions: 22

Compression:

Stored size: 1.85 KB

Contents

require 'active_record/connection_adapters/sqlserver/showplan/printer_table'
require 'active_record/connection_adapters/sqlserver/showplan/printer_xml'

module ActiveRecord
  module ConnectionAdapters
    module Sqlserver
      module Showplan
        
        OPTION_ALL  = 'SHOWPLAN_ALL'
        OPTION_TEXT = 'SHOWPLAN_TEXT'
        OPTION_XML  = 'SHOWPLAN_XML'
        OPTIONS = [OPTION_ALL, OPTION_TEXT, OPTION_XML]
        
        def explain(arel, binds = [])
          sql = to_sql(arel)
          result = with_showplan_on { do_exec_query(sql, 'EXPLAIN', binds) }
          printer = showplan_printer.new(result)
          printer.pp
        end
        
        
        protected
        
        def with_showplan_on
          set_showplan_option(true)
          yield
        ensure
          set_showplan_option(false)
        end
        
        def set_showplan_option(enable = true)
          sql = "SET #{option} #{enable ? 'ON' : 'OFF'}"
          raw_connection_do(sql)
        rescue Exception => e
          raise ActiveRecordError, "#{option} could not be turned #{enable ? 'ON' : 'OFF'}, perhaps you do not have SHOWPLAN permissions?"
        end
        
        def option
          (SQLServerAdapter.showplan_option || OPTION_ALL).tap do |opt|
            raise(ArgumentError, "Unknown SHOWPLAN option #{opt.inspect} found.") if OPTIONS.exclude?(opt)
          end
        end
        
        def showplan_all?
          option == OPTION_ALL
        end
        
        def showplan_text?
          option == OPTION_TEXT
        end
        
        def showplan_xml?
          option == OPTION_XML
        end
        
        def showplan_printer
          case option
          when OPTION_XML then PrinterXml
          when OPTION_ALL, OPTION_TEXT then PrinterTable
          else PrinterTable
          end
        end
        
      end
    end
  end
end

Version data entries

22 entries across 22 versions & 2 rubygems

Version Path
activerecord-sqlserver-adapter-3.2.18 lib/active_record/connection_adapters/sqlserver/showplan.rb
activerecord-sqlserver-adapter-3.2.17 lib/active_record/connection_adapters/sqlserver/showplan.rb
activerecord-sqlserver-adapter-3.2.16 lib/active_record/connection_adapters/sqlserver/showplan.rb
activerecord-sqlserver-adapter-3.2.15 lib/active_record/connection_adapters/sqlserver/showplan.rb
activerecord-sqlserver-adapter-3.2.14 lib/active_record/connection_adapters/sqlserver/showplan.rb
activerecord-sqlserver-adapter-3.2.13 lib/active_record/connection_adapters/sqlserver/showplan.rb
sic-activerecord-sqlserver-adapter-4.0.0 lib/active_record/connection_adapters/sqlserver/showplan.rb
activerecord-sqlserver-adapter-3.2.12 lib/active_record/connection_adapters/sqlserver/showplan.rb
activerecord-sqlserver-adapter-3.2.11 lib/active_record/connection_adapters/sqlserver/showplan.rb
activerecord-sqlserver-adapter-3.2.10 lib/active_record/connection_adapters/sqlserver/showplan.rb
activerecord-sqlserver-adapter-3.2.9 lib/active_record/connection_adapters/sqlserver/showplan.rb
activerecord-sqlserver-adapter-3.2.8 lib/active_record/connection_adapters/sqlserver/showplan.rb
activerecord-sqlserver-adapter-3.2.7 lib/active_record/connection_adapters/sqlserver/showplan.rb
activerecord-sqlserver-adapter-3.2.6 lib/active_record/connection_adapters/sqlserver/showplan.rb
activerecord-sqlserver-adapter-3.2.5 lib/active_record/connection_adapters/sqlserver/showplan.rb
activerecord-sqlserver-adapter-3.2.4 lib/active_record/connection_adapters/sqlserver/showplan.rb
activerecord-sqlserver-adapter-3.2.3 lib/active_record/connection_adapters/sqlserver/showplan.rb
activerecord-sqlserver-adapter-3.2.2 lib/active_record/connection_adapters/sqlserver/showplan.rb
activerecord-sqlserver-adapter-3.2.1 lib/active_record/connection_adapters/sqlserver/showplan.rb
activerecord-sqlserver-adapter-3.2.0 lib/active_record/connection_adapters/sqlserver/showplan.rb