Re: [Catalyst] printing the generated SQL
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: Catalyst@lists.rawmode.org Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/ Dev site: http://dev.catalyst.perl.org/ This will print out geneerated SQL on debug screen: $ export DBIC_TRACE=1 ___ List: Catalyst@lists.rawmode.org Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/ Dev site: http://dev.catalyst.perl.org/
Re: [Catalyst] printing the generated SQL
From: Paul Rudolf Seebacher [EMAIL PROTECTED] 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: Catalyst@lists.rawmode.org Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/ Dev site: http://dev.catalyst.perl.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: Catalyst@lists.rawmode.org Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/ Dev site: http://dev.catalyst.perl.org/
Re: [Catalyst] printing the generated SQL
| From: Paul Rudolf Seebacher [EMAIL PROTECTED] | 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: Catalyst@lists.rawmode.org Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/ Dev site: http://dev.catalyst.perl.org/
[Catalyst] 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: Catalyst@lists.rawmode.org Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/ Dev site: http://dev.catalyst.perl.org/
Re: [Catalyst] printing the generated SQL
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: Catalyst@lists.rawmode.org Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/ Dev site: http://dev.catalyst.perl.org/
Re: [Catalyst] printing the generated SQL
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 DirectorWant a managed development or deployment platform? Shadowcat Systems Ltd. Contact mst (at) shadowcatsystems.co.uk for a quote http://chainsawblues.vox.com/http://www.shadowcat.co.uk/ ___ List: Catalyst@lists.rawmode.org Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/ Dev site: http://dev.catalyst.perl.org/