diff options
Diffstat (limited to 'posts/2008-06-21-debug-your-dbix-class-queries.org')
| -rw-r--r-- | posts/2008-06-21-debug-your-dbix-class-queries.org | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/posts/2008-06-21-debug-your-dbix-class-queries.org b/posts/2008-06-21-debug-your-dbix-class-queries.org new file mode 100644 index 0000000..bc4ad85 --- /dev/null +++ b/posts/2008-06-21-debug-your-dbix-class-queries.org @@ -0,0 +1,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. |