[Catalyst] printing the generated SQL

[Octavian Rasnita]

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).

Octavian