From 0afbfaee75e8480e8e0ed0a3bbd3749a4756f727 Mon Sep 17 00:00:00 2001 From: franck cuny Date: Fri, 10 Sep 2010 23:25:10 +0200 Subject: initial import --- ...2008-06-21-debug-your-dbix-class-queries.textile | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) create mode 100644 _posts/2008-06-21-debug-your-dbix-class-queries.textile (limited to '_posts/2008-06-21-debug-your-dbix-class-queries.textile') diff --git a/_posts/2008-06-21-debug-your-dbix-class-queries.textile b/_posts/2008-06-21-debug-your-dbix-class-queries.textile new file mode 100644 index 0000000..3d0d787 --- /dev/null +++ b/_posts/2008-06-21-debug-your-dbix-class-queries.textile @@ -0,0 +1,21 @@ +--- +layout: post +category: perl +title: debug your DBIx::Class queries +--- + +If you use DBIx::Class and you want to see what the SQL generated looks like, you can set the environment variable DBIC_TRACE. + +{% highlight vim %} +% DBIC_TRACE=1 my_programme.pl +{% endhighlight %} + +And all the SQL will be printed on STDERR. + +If you give a filename to the variable, like this + +{% highlight vim %} +% DBIC_TRACE="1=/tmp/sql.debug" +{% endhighlight %} + +all the statements will be printed in this file. -- cgit v1.2.3