How to disable logging sql to particular query in rails

Question

This is what I have found out from another SO Answer Disable Rails SQL logging in console

ActiveRecord::Base.logger.silence do
  User.where(auth_token: request.headers['X-AUTH']).first
end

But the method seems to be deprecated. Is there any latest way to silence the logs for queries in a block?

Huh - that docs for Rails 5.2 ([here](http://api.rubyonrails.org/classes/ActiveSupport/Logger.html) and [here](http://api.rubyonrails.org/classes/LoggerSilence.html)) show `silence` being included with no mention of it being deprecated. What version of Rails are you using? — SRack, May 09 '18 at 17:04
Actually I am also not getting warning, but https://apidock.com/rails/Logger/silence showed deprecation. So I thought it's deprecated in 5.1 also. How do we know it's not deprecated? — gates, May 09 '18 at 17:07

score 0 · Answer 1 · answered May 09 '18 at 17:15

0

The warning you're seeing here states:

Method deprecated or moved

This looks like a case of "or moved" :)

Within the warning block it mentions the locations of similar methods, including LoggerSilence#silence.

That module contains a silence method and is now included in the ActiveSupport::Logger class, which will handle it as you need.

Hope that helps here!

answered May 09 '18 at 17:15

SRack

11,495
5
47
60

What did you decide upon @gates? Did this answer the question? – SRack May 10 '18 at 15:42

score 0 · Answer 2 · answered May 17 '20 at 23:43

In Rails 6 I use the following to prevent a query log of a token:

def authenticate_user                                                                                                                                                                                                                                                                                                                                                                      
  Rails.logger.info "Authenticating user..."                                                                                                                                                                                                                                                                                                                                          
  Rails.logger.silence do                                                                                                                                                                                                                                                                                                                                                             
    @current_user ||= User.find_by(token: token)                                                                                                                                                                                                                                                                                                                    
  end
end

I couple this with adding the token to:

config/initializers/filter_parameter_logging.rb

How to disable logging sql to particular query in rails

2 Answers2