From 2d2a43f200b88627253f2906fbae87cef7c1e8ce Mon Sep 17 00:00:00 2001 From: Franck Cuny Date: Thu, 4 Aug 2016 11:12:37 -0700 Subject: Mass convert all posts from markdown to org. --- posts/2008-06-21-debug-your-dbix-class-queries.org | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100644 posts/2008-06-21-debug-your-dbix-class-queries.org (limited to 'posts/2008-06-21-debug-your-dbix-class-queries.org') 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. -- cgit v1.2.3