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:12:37 -0700
committerFranck Cuny <franckcuny@gmail.com>2016-08-04 11:12:37 -0700
commit2d2a43f200b88627253f2906fbae87cef7c1e8ce (patch)
treec65377350d12bd1e62e0bdd58458c1044541c27b /posts/2008-06-21-debug-your-dbix-class-queries.org
parentUse Bullet list for the index. (diff)
downloadlumberjaph-2d2a43f200b88627253f2906fbae87cef7c1e8ce.tar.gz
Mass convert all posts from markdown 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.