[Dbix-class] How to get bind values into DBIC::QueryLog

Richard Jones ra.jones at dpw.clara.co.uk
Mon Sep 10 18:39:58 GMT 2007


Cory Watson wrote:
> On 9/7/07, Richard Jones <ra.jones at dpw.clara.co.uk> wrote:
>> I find DBIx:Class::QueryLog very useful in dumping SQL data to the
>> browser in a nicely formatted table, but find it lacks one very useful
>> feature of DBIC::Profiler - displaying the bind values. That makes it
>> easy to run the query manually in a client.
> 
> It doesn't lack this feature at all. The QueryLog object is just a
> list of Query and Transaction objects.  Each Query object has a
> params() accessor that will give you the bind values for the statement
> that the Query object represents.

Wow, yes that was easy. I just added q.params.join(',') to my template
and up they pop. Thanks.
-- 
Richard Jones



More information about the DBIx-Class mailing list