summaryrefslogtreecommitdiff
path: root/posts/2008-06-21-debug-your-dbix-class-queries.md
diff options
context:
space:
mode:
authorFranck Cuny <franckcuny@gmail.com>2016-07-31 10:16:40 -0700
committerFranck Cuny <franckcuny@gmail.com>2016-07-31 13:42:48 -0700
commit63f413891d5adc596e4d51dfba4d0d23fdea3ca4 (patch)
treec2726b60515057a20f434bd89c596360ef17852b /posts/2008-06-21-debug-your-dbix-class-queries.md
parentAdd Google Analytic tracker. (diff)
downloadlumberjaph-63f413891d5adc596e4d51dfba4d0d23fdea3ca4.tar.gz
Stop generating a static site.
Diffstat (limited to 'posts/2008-06-21-debug-your-dbix-class-queries.md')
-rw-r--r--posts/2008-06-21-debug-your-dbix-class-queries.md15
1 files changed, 15 insertions, 0 deletions
diff --git a/posts/2008-06-21-debug-your-dbix-class-queries.md b/posts/2008-06-21-debug-your-dbix-class-queries.md
new file mode 100644
index 0000000..dee84f5
--- /dev/null
+++ b/posts/2008-06-21-debug-your-dbix-class-queries.md
@@ -0,0 +1,15 @@
+If you use DBIx::Class and want to see what the SQL generated looks like, you can set the environment variable **DBIC_TRACE**.
+
+```sh
+% 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
+
+```sh
+% DBIC_TRACE="1=/tmp/sql.debug"
+```
+
+all the statements will be printed in this file.