On linux I start the server with: > DBIC_TRACE=1 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 < [email protected]> 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 = 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 => > $c->user->auth_realm, key => $c->user->url }); > > Would show the query below in STDOUT > > SELECT * FROM UserAccount where realm = '<user realm>' AND key ='<user > url>'; > > I'm running in a windows environment with strawberry perl and using > Eclipse. > > _______________________________________________ > List: [email protected] > Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst > Searchable archive: > http://www.mail-archive.com/[email protected]/ > Dev site: http://dev.catalyst.perl.org/ > >
_______________________________________________ List: [email protected] Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/[email protected]/ Dev site: http://dev.catalyst.perl.org/
