Tuesday, March 23, 2010

DBIx:Class debugging

If you use DBIx::Class and you want to see what the SQL generated looks
like, you can set the environment variable DBIC_TRACE.

% DBIC_TRACE=1 my_programme.pl
And all the SQL will be printed on STDERR.

If you give a filename to the variable, like this

DBIC_TRACE="1=/tmp/sql.debug"
all the statements will be printed in this file.

I got this info from i'm a lumberjaph which is a great blog about web programming in general and also have quite a few posts about perl and catalyst.

No comments: