From 0afbfaee75e8480e8e0ed0a3bbd3749a4756f727 Mon Sep 17 00:00:00 2001
From: franck cuny <franck@lumberjaph.net>
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

