Log every SQL query to database in Rails 3

Question

This question is a follow up to this question, where should I place this code?

connection = ActiveRecord::Base.connection
class << connection
  alias :original_exec :execute
  def execute(sql, *name)
    # try to log sql command but ignore any errors that occur in this block
    # we log before executing, in case the execution raises an error
    begin
        file = File.open(RAILS_ROOT + "/log/sql.txt",'a'){|f| f.puts Time.now.to_s+": "+sql}
    rescue Exception => e
      ;
    end
    # execute original statement
    original_exec(sql, *name)
  end
end

I have tried placing it inside of the model, but what happens is when I execute some sql query more then once it returns "stack level is to deep" error.

Sigurd · Accepted Answer · 2010-12-02 10:12:15Z

2

Put it in config/initializers. Most likely it's because of reloading classes each time in dev env. This code need to be executed only once though.

answered Dec 2, 2010 at 10:12

Sigurd

7,9733 gold badges27 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Log every SQL query to database in Rails 3

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related