Posts Tagged ‘sql’

debug your DBIx::Class queries

Saturday, June 21st, 2008

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.