Forum: Ruby on Rails how to I see SQL trace when using (a) rails console & (b) running rspec tests???

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
D5df9fcd7ef4c3c937435d7d6adeab2a?d=identicon&s=25 Greg Hauptmann (Guest)
on 2009-04-21 02:54
(Received via mailing list)
Hi,

I'd like to know how to monitor the SQL calls (from ActiveRecord) for
both
the cases:
(a) using rails console [development mode], and
(b) running rspec tests [test mode]

How can I do this?  For item (a) I recollect previously I could just run
up
a "./script/server" and see this whilst using "./script/console" however
it
does not seem to be working currently for me.

Tks







--
Greg
http://blog.gregnet.org/
2505b282d57c29be797dc35b245adb4c?d=identicon&s=25 Philip Hallstrom (Guest)
on 2009-04-21 03:01
(Received via mailing list)
On Apr 20, 2009, at 5:53 PM, Greg Hauptmann wrote:

> a "./script/server" and see this whilst using "./script/console"
> however it
> does not seem to be working currently for me.

Not sure about (b), but for (a) put this in your ~/.irbrc

# Log to STDOUT if in Rails
if ENV.include?('RAILS_ENV') && !Object.const_defined?
('RAILS_DEFAULT_LOGGER')
   require 'logger'
   RAILS_DEFAULT_LOGGER = Logger.new(STDOUT)
end
Aafa8848c4b764f080b1b31a51eab73d?d=identicon&s=25 Phlip (Guest)
on 2009-04-21 04:48
(Received via mailing list)
>> (b) running rspec tests [test mode]

> Not sure about (b), but for (a) put this in your ~/.irbrc

For (b), gem install assert_efficient_sql, then put this around your
RSpec
money-line:

   inspect_sql :verbose => true do
      concoct_sql()
   end

It will spew out your SQL statements, and their EXPLAIN results, so you
can see
the bottlenecks.

It only works for MySQL tho...

Also, put in require 'assert_efficient_sql', and this:

Spec::Runner.configure do |c|
   c.include Test::Unit::Assertions
end

--
   Phlip
   http://flea.sourceforge.net/resume.html
This topic is locked and can not be replied to.