MySqlDb any way to see the query string

[MRAB]

Dennis Lee Bieber wrote:
> On Sat, 10 Jul 2010 20:22:21 +0200, News123 <news1234 at free.fr> declaimed
> the following in gmane.comp.python.general:
> 
>> Hi,
>>
>> I'm using MYSQLdb
> 	<snip>
>> What I wondered is whether there is any way to print the 'filled in'
>> query string for debuggin.
>>
> 	Just edit the MySQLdb cursors module -- it's plain Python unless
> something has changed in the last year... Find the .execute() method,
> and stuff in a debug print statement where it does the escaping and
> "fill in" (reason MySQLdb uses %s placeholder is that it uses Python to
> do the fill in; things may change if the module is ever updated to use
> ver 5 prepared queries).
> 
> 	Come to think of it, one could probably duplicate the .execute()
> method, creating a "d_execute" with the print statement, while not
> affecting operational code... That way one wouldn't have to edit the
> module just for testing.
> 
Why duplicate the method? Why not add a keyword argument to turn on
printing or a provide a file-type instance to which it should log the
query?