summaryrefslogtreecommitdiff
path: root/content/post/2008-06-21-debug-your-dbix-class-queries.md
diff options
context:
space:
mode:
authorFranck Cuny <franckcuny@gmail.com>2016-07-02 20:06:31 -0700
committerFranck Cuny <franckcuny@gmail.com>2016-07-02 20:06:31 -0700
commit4b8e43f75b394a4e6169884fbfb4c606865c6a22 (patch)
tree48cae6b8e8f9b68cae29676d8a15cb3ddbfcccda /content/post/2008-06-21-debug-your-dbix-class-queries.md
parentStop using Jekyll. (diff)
downloadlumberjaph-4b8e43f75b394a4e6169884fbfb4c606865c6a22.tar.gz
Import migration from Jekyll to Hugo.
All the posts were converted, and the layout is created. This looks like it works just fine.
Diffstat (limited to '')
-rw-r--r--content/post/2008-06-21-debug-your-dbix-class-queries.md21
1 files changed, 21 insertions, 0 deletions
diff --git a/content/post/2008-06-21-debug-your-dbix-class-queries.md b/content/post/2008-06-21-debug-your-dbix-class-queries.md
new file mode 100644
index 0000000..7270d82
--- /dev/null
+++ b/content/post/2008-06-21-debug-your-dbix-class-queries.md
@@ -0,0 +1,21 @@
+---
+date: 2008-06-21T00:00:00Z
+summary: In which I explain how to see SQL queries generated for DBIx::Class.
+title: debug your DBIx::Class queries
+---
+
+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.