summaryrefslogtreecommitdiff
path: root/posts/2008-06-21-debug-your-dbix-class-queries.org
diff options
context:
space:
mode:
authorFranck Cuny <franckcuny@gmail.com>2016-08-04 11:45:44 -0700
committerFranck Cuny <franckcuny@gmail.com>2016-08-04 11:45:44 -0700
commit585b48b6a605cb71ef99dd767880e1b7ee5bf24e (patch)
treec65377350d12bd1e62e0bdd58458c1044541c27b /posts/2008-06-21-debug-your-dbix-class-queries.org
parentUse Bullet list for the index. (diff)
parentMass convert all posts from markdown to org. (diff)
downloadlumberjaph-585b48b6a605cb71ef99dd767880e1b7ee5bf24e.tar.gz
Merge branch 'convert-to-org'
Diffstat (limited to '')
-rw-r--r--posts/2008-06-21-debug-your-dbix-class-queries.org16
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.