[Catalyst] C::M::DBIC::Schema::QyeryLog: can't collect any stats...

[Marcello Romani]

Cory Watson ha scritto:
> On 9/19/07, Marcello Romani <mromani at ottotecnica.com> wrote:
>> Do you use it in cat apps on in plain dbic ?
>>
>> Could you provide an example of usage ?
> 
> http://www.onemogin.com/blog/554-profile-your-catalystdbixclass-app-with-querylog.html
> 
> The syntax has changed a bit due to the Analyzer, but you should be
> able to make the leap.
> 

Thank you, but I had read that article before.
While interesting and useful, it doesn't provide any code example on how 
to actually use dbic::querylog in a cat app (I read the 
$schema->debugobj($ql_instance) and $schema->debug(1) instruction, but 
where do I exactly put them in a cat app, since the cat model's 
connection is delayed until needed ?).

I went on with my tests, and I think your suggestion was right.
If I put this line in the TT template:

[% querylog %]

I get something like DBIx::Class::QueryLog=HASH(0x93b48a8)
where the hash address changes every time I refersh the page.
I think the address should be the same, otherwise I always get a fresh 
object which of course doesn't have any statistics in it... Right ?

-- 
Marcello Romani
Responsabile IT
Ottotecnica s.r.l.
http://www.ottotecnica.com