[Catalyst] printing the generated SQL

Octavian Rasnita orasnita at gmail.com
Fri Sep 14 13:18:46 GMT 2007

From: "Paul Rudolf Seebacher" <paul.seebacher at gmx.net>

> Octavian Rasnita wrote:
>> Hi,
>> Is it possible to log a certain SQL which is generated in a Catalyst
>> application by a controller that uses a DBIx::Class model?
>> Thank you.
>> Octavian
>> _______________________________________________
>> List: Catalyst at lists.rawmode.org
>> Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst
>> Searchable archive:
>> http://www.mail-archive.com/catalyst@lists.rawmode.org/
>> Dev site: http://dev.catalyst.perl.org/
> This will print out geneerated SQL on debug screen:
> $ export DBIC_TRACE=1

And where should I enter this command line?

I don't need it for a program that uses DBIx::Class which is ran from the 
command line, but in a Catalyst app.

I have also tried to install some Catalyst modules (QueryLog) that should 
help me to do that, but I couldn't install it due to some make test errors 
(under Windows XP).


More information about the Catalyst mailing list