Script Console Tricks

Script console in rails helps me very much to debug my applications. However, I usually encounter an annoying problem with ActiveRecord. I want to see the generated SQL that has been executed. I never have enough time to figure out this until last week. Just add the following code to your environment.rb, you could see the generated SQL statement.

if "irb" == $0
  ActiveRecord::Base.logger = Logger.new(STDOUT)  # ActiveRecord
  ActiveResource::Base.logger = Logger.new(STDOUT)  # ActiveResource
end

For more information:
http://weblog.jamisbuck.org/2007/1/31/more-on-watching-activerecord
http://railscasts.com/episodes/48-console-tricks