[Catalyst] getting the db connection used by catalyst

Andreas Marienborg omega at palle.net
Wed Oct 4 08:33:11 CEST 2006


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. initially, that will be it. It will present a number of
> convenience methods, which can be used to access either the db or
> cached data. There will likely be some methods to write to the db,
> again convenience stuff.
>
>
>
> On 10/4/06, Brandon Black <blblack at gmail.com> wrote:
>>
>>
>> On 10/3/06, Daniel McBrearty <danielmcbrearty at gmail.com> wrote:
>>> if you have a (dbix) database, and use it as a model, you generally
>>> end up doing this :
>>>
>>> $c->model-> ....
>>>
>>> and the database connection is handled internally.
>>>
>>> I now want to write another model which uses the db. It would be
>>> better to use the existing connection that cat has created, rather
>>> than create another one.
>>>
>>> If I write a new() method for this model, does it have access to the
>>> context? what is a good way to do this?
>>
>>
>> What kind of model is your new model, and how will it use/store/ 
>> whatever the
>> $dbh?  There are a lot of ways to do what you're talking about in  
>> general,
>> it all depends on what's right for your design.  Be aware that  
>> once you take
>> the raw $dbh from DBIC and start using it yourself, you lose all  
>> of its
>> fancy connection management.
>>
>> -- Brandon
>>
>>
>> _______________________________________________
>> List: Catalyst at 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/
>>
>>
>>
>
>
> -- 
> Daniel McBrearty
> email : danielmcbrearty at gmail.com
> www.engoi.com : the multi - language vocab trainer
> BTW : 0873928131
>
> _______________________________________________
> List: Catalyst at lists.rawmode.org
> Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst
> Searchable archive: http://www.mail-archive.com/ 
> catalyst at lists.rawmode.org/
> Dev site: http://dev.catalyst.perl.org/




More information about the Catalyst mailing list