aboutsummaryrefslogblamecommitdiffstats
path: root/activerecord/lib/active_record/log_subscriber.rb
blob: f31931316cf95e458551006c8c3f2c6c4ab0e3a9 (plain) (tree)
1
2
3
4
5
6
7
8
9

                                                    
                                                
 
                            
                                                       


                    
                                                     






                                   


                                                                         
          
                         
         
 
                        

       
                  

                                 

                                          
                             
 
                                                             
 
                                                                
                           
                 

                                           


                                                                                           
         
 
                                                        
                                             
 
                                       

       

           





                                                                                  
         
 

                        













                                                   
              
                 
           
         
 


                                 


     
                                                    
module ActiveRecord
  class LogSubscriber < ActiveSupport::LogSubscriber
    IGNORE_PAYLOAD_NAMES = ["SCHEMA", "EXPLAIN"]

    def self.runtime=(value)
      ActiveRecord::RuntimeRegistry.sql_runtime = value
    end

    def self.runtime
      ActiveRecord::RuntimeRegistry.sql_runtime ||= 0
    end

    def self.reset_runtime
      rt, self.runtime = runtime, 0
      rt
    end

    def render_bind(attr, type_casted_value)
      value = if attr.type.binary? && attr.value
        "<#{attr.value_for_database.to_s.bytesize} bytes of binary data>"
      else
        type_casted_value
      end

      [attr.name, value]
    end

    def sql(event)
      return unless logger.debug?

      self.class.runtime += event.duration

      payload = event.payload

      return if IGNORE_PAYLOAD_NAMES.include?(payload[:name])

      name  = "#{payload[:name]} (#{event.duration.round(1)}ms)"
      sql   = payload[:sql]
      binds = nil

      unless (payload[:binds] || []).empty?
        binds = "  " + payload[:binds].zip(payload[:type_casted_binds]).map { |attr, value|
          render_bind(attr, value)
        }.inspect
      end

      name = colorize_payload_name(name, payload[:name])
      sql  = color(sql, sql_color(sql), true)

      debug "  #{name}  #{sql}#{binds}"
    end

    private

      def colorize_payload_name(name, payload_name)
        if payload_name.blank? || payload_name == "SQL" # SQL vs Model Load/Exists
          color(name, MAGENTA, true)
        else
          color(name, CYAN, true)
        end
      end

      def sql_color(sql)
        case sql
        when /\A\s*rollback/mi
          RED
        when /select .*for update/mi, /\A\s*lock/mi
          WHITE
        when /\A\s*select/i
          BLUE
        when /\A\s*insert/i
          GREEN
        when /\A\s*update/i
          YELLOW
        when /\A\s*delete/i
          RED
        when /transaction\s*\Z/i
          CYAN
          else
          MAGENTA
        end
      end

      def logger
        ActiveRecord::Base.logger
      end
  end
end

ActiveRecord::LogSubscriber.attach_to :active_record