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

[Blaine Everingham]

Thanks Marilyn,
You got me thinking that maybe it was a runtime issue with the Perl Interpr=
eter running through Eclipse.
Anyhow, when I run the myapp_server.pl from the windows command prompt I se=
e the queries.
Blaine

Date: Wed, 1 Dec 2010 15:16:23 -0800
Subject: Re: [Catalyst] Catalyst::Model::DBIC::Schema - Print Debug stateme=
nt
From: marilyn at marilynburgess.com
To: catalyst at lists.scsys.co.uk

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 hotmai=
l.com> wrote:






I'm trying to see the queries the actual query code that is submitted to th=
e 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 Env=
ironment  DBIC_TRACE =3D 1

Each time I run the myapp_server.pl -d -r it does not show the query execut=
ed.



Ideally Executing :

$c->model("MyDatabase::UserAccount")->find({  realm =3D> $c->user->auth_rea=
lm,   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/





_______________________________________________
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/bdbb4=
925/attachment.htm