From ef00815be5af9a4e431e57d99ff0321d65773cdd Mon Sep 17 00:00:00 2001 From: Franck Cuny Date: Thu, 19 Sep 2013 10:34:32 -0700 Subject: Another post convert to md --- _posts/2008-06-21-debug-your-dbix-class-queries.md | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) create mode 100644 _posts/2008-06-21-debug-your-dbix-class-queries.md (limited to '_posts/2008-06-21-debug-your-dbix-class-queries.md') diff --git a/_posts/2008-06-21-debug-your-dbix-class-queries.md b/_posts/2008-06-21-debug-your-dbix-class-queries.md new file mode 100644 index 0000000..dc58280 --- /dev/null +++ b/_posts/2008-06-21-debug-your-dbix-class-queries.md @@ -0,0 +1,21 @@ +--- +layout: post +title: debug your DBIx::Class queries +summary: In which I explain how to see SQL queries generated for DBIx::Class. +--- + +If you use DBIx::Class and want to see what the SQL generated looks like, you can set the environment variable **DBIC_TRACE**. + +```sh +% DBIC_TRACE=1 my_programme.pl +``` + +And all the SQL will be printed on **STDERR**. + +If you give a filename to the variable, like this + +```sh +% DBIC_TRACE="1=/tmp/sql.debug" +``` + +all the statements will be printed in this file. -- cgit v1.2.3