printing the generated SQL

Hi,

Is it possible to log a certain SQL which is generated in a
Catalyst 
application by a controller that uses a DBIx::Class model?

Thank you.

Octavian


_______________________________________________
List: Catalystlists.rawmode.org
Listinfo: ht
tp://lists.rawmode.org/mailman/listinfo/catalyst
Searchable archive: http://www.mail-
archive.com/catalystlists.rawmode.org/
Dev site: http://dev.catalyst.per
l.org/

Octavian Rasnita wrote:

> Hi,
> 
> Is it possible to log a certain SQL which is generated
in a Catalyst 
> application by a controller that uses a DBIx::Class
model?

$c->model('MyModel')->storage->debug(1);

Also have a look at:
http
://search.cpan.org/dist/DBIx-Class-QueryLog/
http://search.cpan.org/dist/Catalyst-Model-DBIC-
Schema-QueryLog/

Cheers,
Emanuele.

_______________________________________________
List: Catalystlists.rawmode.org
Listinfo: ht
tp://lists.rawmode.org/mailman/listinfo/catalyst
Searchable archive: http://www.mail-
archive.com/catalystlists.rawmode.org/
Dev site: http://dev.catalyst.per
l.org/

On Thu, Sep 13, 2007 at 03:35:46PM +0300, Octavian Rasnita
wrote:
> Hi,
> 
> Is it possible to log a certain SQL which is generated
in a Catalyst 
> application by a controller that uses a DBIx::Class
model?

Yes.

-- 
      Matt S Trout       Need help with your Catalyst or
DBIx::Class project?
   Technical Director    Want a managed development or
deployment platform?
 Shadowcat Systems Ltd.  Contact mst (at)
shadowcatsystems.co.uk for a quote
http://chainsawblues.vo
x.com/                    http://www.shadowcat.co.u
k/ 

_______________________________________________
List: Catalystlists.rawmode.org
Listinfo: ht
tp://lists.rawmode.org/mailman/listinfo/catalyst
Searchable archive: http://www.mail-
archive.com/catalystlists.rawmode.org/
Dev site: http://dev.catalyst.per
l.org/

Octavian Rasnita wrote:
> Hi,
>
> Is it possible to log a certain SQL which is generated
in a Catalyst
> application by a controller that uses a DBIx::Class
model?
>
> Thank you.
>
> Octavian
>
>
> _______________________________________________
> List: Catalystlists.rawmode.org
> Listinfo: ht
tp://lists.rawmode.org/mailman/listinfo/catalyst
> Searchable archive:
> http://www.mail-
archive.com/catalystlists.rawmode.org/
> Dev site: http://dev.catalyst.per
l.org/
>
This will print out geneerated SQL on debug screen:
$ export DBIC_TRACE=1

_______________________________________________
List: Catalystlists.rawmode.org
Listinfo: ht
tp://lists.rawmode.org/mailman/listinfo/catalyst
Searchable archive: http://www.mail-
archive.com/catalystlists.rawmode.org/
Dev site: http://dev.catalyst.per
l.org/

From: "Paul Rudolf Seebacher"
<paul.seebachergmx.net>


> Octavian Rasnita wrote:
>> Hi,
>>
>> Is it possible to log a certain SQL which is
generated in a Catalyst
>> application by a controller that uses a DBIx::Class
model?
>>
>> Thank you.
>>
>> Octavian
>>
>>
>> _______________________________________________
>> List: Catalystlists.rawmode.org
>> Listinfo: ht
tp://lists.rawmode.org/mailman/listinfo/catalyst
>> Searchable archive:
>> http://www.mail-
archive.com/catalystlists.rawmode.org/
>> Dev site: http://dev.catalyst.per
l.org/
>>
> This will print out geneerated SQL on debug screen:
> $ export DBIC_TRACE=1
>

And where should I enter this command line?

I don't need it for a program that uses DBIx::Class which is
ran from the 
command line, but in a Catalyst app.

I have also tried to install some Catalyst modules
(QueryLog) that should 
help me to do that, but I couldn't install it due to some
make test errors 
(under Windows XP).

Octavian


_______________________________________________
List: Catalystlists.rawmode.org
Listinfo: ht
tp://lists.rawmode.org/mailman/listinfo/catalyst
Searchable archive: http://www.mail-
archive.com/catalystlists.rawmode.org/
Dev site: http://dev.catalyst.per
l.org/

| From: "Paul Rudolf Seebacher"
<paul.seebachergmx.net>
|
>> Octavian Rasnita wrote:
>>> Hi,
>>> 
>>> Is it possible to log a certain SQL which is
generated in a Catalyst
>>> application by a controller that uses a
DBIx::Class model?
>>> 
>>> Thank you.
>>> 
>>> Octavian
>>> 

>> This will print out geneerated SQL on debug
screen:
>> $ export DBIC_TRACE=1
  
| And where should I enter this command line?
| 
| I don't need it for a program that uses DBIx::Class which
is ran from the 
| command line, but in a Catalyst app.

[rest snipped]

In your shell:

# bash
$ export DBIC_TRACE=1 

or

# csh
$ setenv DBIC_TRACE 1


and then start the catalyst builtin test server like this
$ ./script/myapp_server.pl

or do all at once, like this
$ DBIC_TRACE=1 ./script/myapp_server.pl

Then point your browser to http://localhost:3000, use
your
app and see the SQL queries being written to your terminal.

Same thing for non-catalyst scripts that use DBIC:
$ DBIC_TRACE=1 ./myscript.pl

HTH,

Fernan


_______________________________________________
List: Catalystlists.rawmode.org
Listinfo: ht
tp://lists.rawmode.org/mailman/listinfo/catalyst
Searchable archive: http://www.mail-
archive.com/catalystlists.rawmode.org/
Dev site: http://dev.catalyst.per
l.org/