Re: [Catalyst] getting the db connection used by catalyst

2006-10-04 Thread Andreas Marienborg
I assume you have considered adding this to your dbic-schema? If it is all to deal with the same DB, and the same structures, you might benefit from that. andreas On 4. okt. 2006, at 04.27, Daniel McBrearty wrote: basically it does some fancy processing on the db and caches the results.

Re: [Catalyst] getting the db connection used by catalyst

2006-10-04 Thread Daniel McBrearty
I have. Could do it either way, but on the whole I prefer to seperate the two. Even if I did that, I think I'd have the same question - how to get a connection without creating a new one. On 10/4/06, Andreas Marienborg [EMAIL PROTECTED] wrote: I assume you have considered adding this to your

Re: [Catalyst] getting the db connection used by catalyst

2006-10-04 Thread Daniel McBrearty
maybe I'm worrying too much about reusing the catalyst connection - I could just get a connection in new() and keep a ref to it there, and use that whenever needed. I don't know much about what goes on internally, or how much overhead each connection has with it ... On 10/4/06, Daniel McBrearty

Re: [Catalyst] getting the db connection used by catalyst

2006-10-04 Thread Matt S Trout
Daniel McBrearty wrote: I have. Could do it either way, but on the whole I prefer to seperate the two. Even if I did that, I think I'd have the same question - how to get a connection without creating a new one. $storage-dbh DO NOT CACHE THAT Grab it each time, then you benefit from all of

Re: [Catalyst] getting the db connection used by catalyst

2006-10-04 Thread Daniel McBrearty
ok. thanks. what is the magic? is its behaviour in one of the perldocs? On 10/4/06, Matt S Trout [EMAIL PROTECTED] wrote: Daniel McBrearty wrote: I have. Could do it either way, but on the whole I prefer to seperate the two. Even if I did that, I think I'd have the same question - how

Re: [Catalyst] getting the db connection used by catalyst

2006-10-04 Thread Matt S Trout
Daniel McBrearty wrote: ok. thanks. what is the magic? is its behaviour in one of the perldocs? It auto-reconnects as required etc., handles reconnection post-fork and thread spawn, that sort of thing. -- Matt S Trout Offering custom development, consultancy and support

[Catalyst] Advice for Catalyst::Plugin::Authentication::Store::DBIC needed

2006-10-04 Thread Bernhard Graf
In a Cat application I use C:P::Authentication::Store::DBIC and it works well. But now I need to modify authentication a little bit: A status field of the user object should also be checked, e.g. grant access only if status is set to active. Documentation of the module mentions a configuration

Re: [Catalyst] Advice for Catalyst::Plugin::Authentication::Store::DBIC needed

2006-10-04 Thread leonard . a . jaffe
-- Leonard A. Jaffe (614)213-4283 JP Morgan Chase, Columbus, OH DSS Monitoring Instrumentation Services [EMAIL PROTECTED] Bernhard Graf wrote: In a Cat application I use C:P::Authentication::Store::DBIC and it