http://snippets.dzone.com/posts Wed, 08 Oct 2008 07:11:47 GMT DZone Snippets: activerecord code http://snippets.dzone.com/posts/show/3402 from <http://weblog.jamisbuck.org/2007/1/31/more-on-watching-activerecord> <br /> <br />In config/environment.rb: <br /> <br /><code> <br />def log_to(stream) <br /> ActiveRecord::Base.logger = Logger.new(stream) <br /> ActiveRecord::Base.clear_active_connections! <br />end <br /></code> <br /> <br />then in the console : <br /><code> <br />>> log_to STDOUT <br />=> ... <br />>> Post.find(:first) <br /> Post Load (0.000138) SELECT * FROM posts LIMIT 1 <br />=> #<Post:0x1234 ...> <br />>> <br /></code> <br /> <br />The best part is, by clearing the active connections after setting the logger, you can change the logger at any time, even after you’ve made any number of find calls. <br /> <br />And, you can pass your own stream objects into it: <br /><code> <br />>> buffer = StringIO.new <br />=> ... <br />>> log_to buffer <br />=> ... <br />>> Post.find(:first) <br />=> #<Post:0x1234 ...> <br />>> p buffer.string <br />=> " \e[4;35;1mPost Load (0.000138)\e[0m \e[0mSELECT * FROM posts LIMIT 1\e[0m\n" <br />>> <br /></code> Thu, 01 Feb 2007 13:45:53 GMT http://snippets.dzone.com/posts/show/3402 Mickael (Mickael)