[Catalyst] getting database handles and run arbitrary SQL

2008-09-24 Thread theshz
Hi, I'm new to Catalyst, just went through the Tutorial, everything worked fine. But for my reporting application (part of a bigger application where CRUD will be more often), I need to run some complicated querries. I did find the Arbitray SQL article in DBIx's FAQ, but I don't even know how

Re: [Catalyst] getting database handles and run arbitrary SQL

2008-09-24 Thread Johannes Plunien
Hi, On 24.09.2008, at 09:15, theshz wrote: Is it possible to get the database handle and run SQL directly as in DBI? yes, try: my $dbh = $c-model('DBIC::User')-result_source-storage-dbh; (assuming your model based on Catalyst::Model::DBIC::Schema is named DBIC and you got a schema

Re: [Catalyst] A suitable method to redraw a page

2008-09-24 Thread Dermot
2008/9/24 J. Shirley [EMAIL PROTECTED]: On Tue, Sep 23, 2008 at 4:30 PM, Dermot [EMAIL PROTECTED] wrote: Plugin::XMLRPC is -not- a controller, as such, you probably do want to use it. Do you mean do or 'do not' want to use it. If you use Catalyst::Controller::REST handles serialization

Re: [Catalyst] A suitable method to redraw a page

2008-09-24 Thread Tomas Doran
On 24 Sep 2008, at 09:20, Dermot wrote: If my the root of my app is /myapp. I have installed a the REST Controller as lib/MyApp/Controller/REST.pm The Controller has this for now. sub files : Local : ActionClass('REST') { my ($self, $c) = @_; $c-log-debug(Hello from REST Controller); }

Re: [Catalyst] Search example in any docs?

2008-09-24 Thread Tomas Doran
On 24 Sep 2008, at 00:34, Dr. Jennifer Nussbaum wrote: Thanks. I do appreciate this, and its a neat solution, but the problem wasnt that i dont know how to put common elements in a base class, the problem is that nowhere in the Cat docs, formal or informal, are there any examples of doing

Re: [Catalyst] A suitable method to redraw a page

2008-09-24 Thread Tomas Doran
On 24 Sep 2008, at 00:30, Dermot wrote: 2008/9/23 Mesdaq, Ali [EMAIL PROTECTED]: I think ajax would be your friend here. I think I'll try something like that. As the files and Cat App are on one server and the referrer is a different server, I will have the referrer call a local script and

Re: [Catalyst] A suitable method to redraw a page

2008-09-24 Thread Dermot
2008/9/24 Dermot [EMAIL PROTECTED]: 2008/9/24 J. Shirley [EMAIL PROTECTED]: On Tue, Sep 23, 2008 at 4:30 PM, Dermot [EMAIL PROTECTED] wrote: Plugin::XMLRPC is -not- a controller, as such, you probably do want to use it. Do you mean do or 'do not' want to use it. My remote LWP client

Re: [Catalyst] Search example in any docs?

2008-09-24 Thread Zbigniew Lukasiak
On Tue, Sep 23, 2008 at 10:21 PM, Dr. Jennifer Nussbaum [EMAIL PROTECTED] wrote: --- On Tue, 9/23/08, Zbigniew Lukasiak [EMAIL PROTECTED] wrote: Hi there, I am sure you are referring to http://www.catalystframework.org/calendar/2007/16 :) I don't really know what you need, but I start

Re: [Catalyst] Failing tests in Catalyst::Controller::SOAP

2008-09-24 Thread Adam Bartosik
I'll try to take a look at the test errors soon, but I'm pretty swamped at $work for the near future. That said, I'm using the latest C:C::SOAP in production without any problems. :-) Hi Drew, Which versions of XML::Compile, XML::Compile::SOAP do you use there? Adam -- Adam Bartosik

[Catalyst] persistent perl engine

2008-09-24 Thread Carl Franks
I'm just posting this here in case it's useful to anyone else. `perperl` provided by the PersistentPerl distribution seems to work fine with myapp_cgi.pl - with one exception... sysread() seems to always return 0 when running under perperl. I've created a basic engine that simply overrides

Re: [Catalyst] Search example in any docs?

2008-09-24 Thread Jesse Sheidlower
On Tue, Sep 23, 2008 at 05:45:17PM -0700, J. Shirley wrote: On Tue, Sep 23, 2008 at 4:34 PM, Dr. Jennifer Nussbaum [EMAIL PROTECTED] wrote: Thanks. I do appreciate this, and its a neat solution, but the problem wasnt that i dont know how to put common elements in a base class, the

Re: [Catalyst] Search example in any docs?

2008-09-24 Thread J. Shirley
On Wed, Sep 24, 2008 at 7:00 AM, Jesse Sheidlower [EMAIL PROTECTED] wrote: On Tue, Sep 23, 2008 at 05:45:17PM -0700, J. Shirley wrote: On Tue, Sep 23, 2008 at 4:34 PM, Dr. Jennifer Nussbaum [EMAIL PROTECTED] wrote: Thanks. I do appreciate this, and its a neat solution, but the problem

Re: [Catalyst] Multiple DB, single instance of Cat

2008-09-24 Thread Matt S Trout
On Thu, Sep 11, 2008 at 11:58:31PM +0100, Nigel Stuckey wrote: Matt I stand corrected on DBIx! Yes, indeed I mean DBIx::Class. The code is in and works, but has a couple of issues. Firstly, it creates new classes and carries out a DB connect every time there is a request. Is there a

Re: [Catalyst] Race condition in Catalyst::Plugin::Session and Catalyst::Engine::Apache (possibly other engines too)

2008-09-24 Thread Matt S Trout
On Wed, Sep 10, 2008 at 06:59:21PM -0400, Sergio Salvi wrote: There is a race condition in C::P::Session when using C::Engine::Apache (and probably other engines too): I have a simple controller action (let's call it /save) that gets data submitted from an HTML form via POST, process that

Re: [Catalyst] C::P::Compress::Gzip

2008-09-24 Thread Peter Corlett
On Sat, Sep 20, 2008 at 11:46:25AM +0300, Octavian Rasnita wrote: I try to use C::P::Compress::Gzip, but if I add it to the list of plugins, the program gives an error in the browser telling The requested URL / was not found on this server. It's probably easier to just configure Apache to do

Re: [Catalyst] One (central) app, one schema, X databases

2008-09-24 Thread Matt S Trout
On Wed, Sep 10, 2008 at 10:42:35AM +0100, Chisel Wright wrote: I'm just in the initial planning phase of a project. The basic idea is to have X locations running App::Location, each with a local database that has a App::Location::Schema. Everything's the same, just different data in the

Re: [Catalyst] #catalyst

2008-09-24 Thread Matt S Trout
On Sat, Sep 13, 2008 at 10:09:26PM -0500, Jonathan Rockway wrote: * On Sat, Sep 13 2008, Zbigniew Lukasiak wrote: Hi there, I did not see how it looked like at the channel a few days ago - but I hope that my irc client malfunction did not offend someone too severly (unlike that famous

Re: [Catalyst] Mojo, a new kind of web framework

2008-09-24 Thread Sebastian Riedel
Pause seems not to work atm. so it's just on kraih.com for now. http://kraih.com/Mojo-0.2.tar.gz From the pod: *IMPORTANT!* This is beta software, don't use it for anything serious, it might eat your puppy or cause the apocalypse. (You've been warned...) -- sebastian 24.09.2008 20:45 John

[Catalyst] DBIC Authentication Errors

2008-09-24 Thread Greg Coates
I'm getting errors when I try to login to my web app, which is set up to use the DBIC authentication plugin. Here's the relevant portion of my config file: authentication: default_realm: dbic realms: dbic: credential: class: Password password_field: usr_password

Re: [Catalyst] Search example in any docs?

2008-09-24 Thread J. Shirley
On Wed, Sep 24, 2008 at 10:46 AM, Kenny Gatdula [EMAIL PROTECTED] wrote: On Sep 23, 2008, at 8:45 PM, J. Shirley wrote: Wiki! Wiki! Document what you've done and post on here. Wiki nodes are a living document and can evolve with time and evolve into better solutions. Because I love

Re: [Catalyst] DBIC Authentication Errors

2008-09-24 Thread J. Shirley
On Wed, Sep 24, 2008 at 2:52 PM, Greg Coates [EMAIL PROTECTED] wrote: I'm getting errors when I try to login to my web app, which is set up to use the DBIC authentication plugin. Here's the relevant portion of my config file: authentication: default_realm: dbic realms: dbic:

Re: [Catalyst] DBIC Authentication Errors

2008-09-24 Thread Greg Coates
Yep, that fixed it. I knew it had to be something simple! Thanks, Greg J. Shirley wrote: On Wed, Sep 24, 2008 at 2:52 PM, Greg Coates [EMAIL PROTECTED] wrote: I'm getting errors when I try to login to my web app, which is set up to use the DBIC authentication plugin. Here's the relevant

Re: [Catalyst] A suitable method to redraw a page

2008-09-24 Thread Dermot
2008/9/24 J. Shirley [EMAIL PROTECTED]: If you use Catalyst::Controller::REST Wow. It's quite a nifty module. I really like it. Thanx, Dp. ___ List: Catalyst@lists.scsys.co.uk Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst