summaryrefslogtreecommitdiff
path: root/posts/2008-06-21-debug-your-dbix-class-queries.org
blob: bc4ad858278174e5990d516c66c5b32b5a10abb5 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
If you use DBIx::Class and want to see what the SQL generated looks
like, you can set the environment variable *DBIC\_TRACE*.

#+BEGIN_SRC sh
    % DBIC_TRACE=1 my_programme.pl
#+END_SRC

And all the SQL will be printed on *STDERR*.

If you give a filename to the variable, like this

#+BEGIN_SRC sh
    % DBIC_TRACE="1=/tmp/sql.debug"
#+END_SRC

all the statements will be printed in this file.