'How to show SQL query log generated by a RSpec test?

I am writing a spec for my rails 3 application. I want to test that db transactions are really working. It would be really helpful to be able to see the sql queries being generated my app while being driven by the spec.

Is there a way to see the queries just like in the rails console?

I'm using Rails 3.0.9, RSpec 2.6, and sqlite (will move to mysql later on)

sqlruby-on-railstestingloggingrspec


Solution 1:[1]

Put this in your specs:

ActiveRecord::Base.logger = Logger.new(STDOUT) if defined?(ActiveRecord::Base)

and you can tail -f log/test.log and see what's happening. Either one but not both.

Edit for Rails 5.2, add this line:

ActiveRecord::Base.verbose_query_logs = true

Thanks to Mike Monteiro for the update!

Solution 2:[2]

According to the Rails 5 docs (Active Record Explain). You can now use the explain method. This will only log the queries you specify, but you will not be overwhelmed if you have a large amount of SQL code before your tests.

ap Model.explain

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Zoe stands with Ukraine
Solution 2

Related Questions