Disable Rails SQL logging in console

Question

Is there a way to disable SQL query logging when I m executing commands in the console  Ideally  it would be great if I can just disable it and re-enable it with a command in the console   I m trying to debug something and using  puts  to print out some relevant data  However  the sql query output is making it hard to read     Edit  I found another solution  since setting the logger to nil sometimes raised an error  if something other than my code tried to call logger warn  Instead of setting the logger to nil you can set the level of the logger to 1   ActiveRecord  Base logger level   1   or Logger  INFO

User · Answer

This might not be a suitable solution for the console  but Rails has a method for this problem  Logger silence  ActiveRecord  Base logger silence do     the stuff you want to be silenced end

User · Answer

In Rails 3 2 I m doing something like this in config environment development rb   module MyApp   class Application  lt  Rails  Application     console do       ActiveRecord  Base logger   Logger new  Rails root join  log    development log         end   end end

User · Answer

In case someone wants to actually knock out SQL statement logging  without changing logging level  and while keeping the logging from their AR models    The line that writes to the log  in Rails 3 2 16  anyway  is the call to debug in lib active record log subscriber rb 50   That debug method is defined by ActiveSupport  LogSubscriber   So we can knock out the logging by overwriting it like so   module ActiveSupport   class LogSubscriber     def debug  args   amp block      end   end end

User · Answer

For Rails 4 you can put the following in an environment file      config environments development rb  config active record logger   nil

User · Answer

Here s a variation I consider somewhat cleaner  that still allows potential other logging from AR  In config environments development rb    config after initialize do   ActiveRecord  Base logger   Rails logger clone   ActiveRecord  Base logger level   Logger  INFO end

User · Answer

Just as an FYI  in Rails 2 you can do   ActiveRecord  Base silence    lt code you don t want to log goes here gt      Obviously the curly braces could be replaced with a do end block if you wanted

User · Answer

I used this  config log level    info edit-in config environments performance rb  Working great for me  rejecting SQL output  and show only rendering and important info

User · Answer

To turn it off   old logger   ActiveRecord  Base logger ActiveRecord  Base logger   nil   To turn it back on   ActiveRecord  Base logger   old logger

[sql] Disable Rails SQL logging in console

Examples related to sql

Examples related to ruby-on-rails

Examples related to console