[Catalyst] Catalyst::Model::DBIC::Schema - Print Debug statement

[Marilyn Burgess]

On linux I start the server with:

> DBIC_TRACE=3D1 myapp_server.pl -r

which does the trick. Not sure if the same will work under windows.

Marilyn


On Wed, Dec 1, 2010 at 3:03 PM, Blaine Everingham <
grandmasterblaine at hotmail.com> wrote:

>  I'm trying to see the queries the actual query code that is submitted to
> the database when I perform a find on a model.
>
> I've tried:
>
> 1) Adding $ENV{DBIC_TRACE}++ to the MyApp.pm
> 2) Setting the Windows7 Environment variable DBIC_TRACE to 1
> 3) Setting my run configuration in Eclispe with the arguments -d -r AND
> Environment  DBIC_TRACE =3D 1
>
> Each time I run the myapp_server.pl -d -r it does not show the query
> executed.
>
>
> Ideally Executing :
>
> $c->model("MyDatabase::UserAccount")->find({  realm =3D>
> $c->user->auth_realm,   key =3D> $c->user->url });
>
> Would show the query below in STDOUT
>
> SELECT * FROM UserAccount where realm =3D '<user realm>' AND key =3D'<user
> url>';
>
> I'm running in a windows environment with strawberry perl and using
> Eclipse.
>
> _______________________________________________
> List: Catalyst at lists.scsys.co.uk
> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
> Searchable archive:
> http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
> Dev site: http://dev.catalyst.perl.org/
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/catalyst/attachments/20101201/a9b59=
a36/attachment.htm