SQL logging with trace

sqllogging.rb

  class MyLogger < Logger
    def add(severity, message = nil, progname = nil)
      severity ||= UNKNOWN
      if @logdev.nil? or severity < @level
        return true
      end
      if progname.nil?
        progname = @progname
      end
      if message.nil?
        if block_given?
          message = yield
        else
          message = progname
          progname = @progname
        end
      end
      message = <<~MSG
      \n\033[95mSQL\033[0m:\n#{message}
      \033[92mTRACE\033[0m:\n\033[90m#{caller.reject { |c| c =~ /\/.gem\// }.join("\n")}\033[0m\n
      MSG
      @logdev.write(
        format_message(format_severity(severity), Time.now, progname, message))
      true
    end
  end
  ActiveRecord::Base.logger = MyLogger.new(STDOUT)