blob: 3d0d7876dd622c01bc37e5412b00b9731b6e2ce5 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
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.
|
