[Dbix-class] Adding comments to generated queries

[Len Jaffe]

On Wed, May 30, 2012 at 11:23 AM, fREW Schmidt <frioux at gmail.com> wrote:

> On Wed, May 30, 2012 at 8:23 AM, David Cantrell <david at cantrell.org.uk>wr=
ote:
>
>> On Wed, May 30, 2012 at 06:03:52AM -0500, Bill Moseley wrote:
>>
>> > Of course, with DBIC it's a bit more difficult to define "where" a que=
ry
>> > comes from since it can get built in parts and doesn't get executed
>> until
>> > it's used.  Plus, we already have code that reports on "slow" queries
>> (or
>> > excessive queries) in a given web request.
>> >
>> > Still, Is there any existing module that would do something like this
>> this?
>> > I'm not sure what it would put in outside of a stack trace.
>>
>> You mean like this?
>>
>> http://search.cpan.org/~dcantrell/DBIx-Class-QueryLog-WithStackTrace-1.0/
>>
>
> Similarly:
> https://metacpan.org/module/FREW/DBIx-Class-UnicornLogger-0.001000/lib/DB=
Ix/Class/UnicornLogger.pm
>

I would imagine, that the query isn't slow until the precise moment it's
executed, at which point I'd want to log and comment.

Len.

-- =

lenjaffe at jaffesystems.com   614-404-4214             www.volunteerable.net
Proprietor: http://www.theycomewithcheese.com/ - An Homage to Fromage
Greenbar <http://www.greenbartraining.org/>: Grubmaster: 2012-2009, Grub
Asst: 2008, Trained: 2007.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20120530/821=
7df26/attachment.htm