[Catalyst] printing the generated SQL

[Emanuele Zeppieri]

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?

$c->model('MyModel')->storage->debug(1);

Also have a look at:
http://search.cpan.org/dist/DBIx-Class-QueryLog/
http://search.cpan.org/dist/Catalyst-Model-DBIC-Schema-QueryLog/

Cheers,
Emanuele.