diff options
| author | Franck Cuny <franck.cuny@gmail.com> | 2016-08-10 14:33:04 -0700 |
|---|---|---|
| committer | Franck Cuny <franck.cuny@gmail.com> | 2016-08-10 20:17:56 -0700 |
| commit | 8d7d02f42c3947f756c18cb4d37d9d97fbd0d27d (patch) | |
| tree | a6cecddaaea7e87d901a6c28bebe3a531438f24b /posts/2008-06-21-debug-your-dbix-class-queries.md | |
| parent | Merge branch 'convert-to-org' (diff) | |
| download | lumberjaph-8d7d02f42c3947f756c18cb4d37d9d97fbd0d27d.tar.gz | |
convert back to md
Diffstat (limited to 'posts/2008-06-21-debug-your-dbix-class-queries.md')
| -rw-r--r-- | posts/2008-06-21-debug-your-dbix-class-queries.md | 15 |
1 files changed, 15 insertions, 0 deletions
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..4ab4ec6 --- /dev/null +++ b/posts/2008-06-21-debug-your-dbix-class-queries.md @@ -0,0 +1,15 @@ +If you use DBIx::Class and want to see what the SQL generated looks like, you can set the environment variable **DBIC\_TRACE**. + +``` bash +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 + +``` bash +DBIC_TRACE="1=/tmp/sql.debug" +``` + +all the statements will be printed in this file. |