[Catalyst] getting the db connection used by catalyst

Daniel McBrearty danielmcbrearty at gmail.com
Wed Oct 4 10:33:32 CEST 2006


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 <omega at palle.net> wrote:
> 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/
>
>
> _______________________________________________
> 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



More information about the Catalyst mailing list