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 <[EMAIL PROTECTED]> 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. > > On 10/4/06, Andreas Marienborg <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> wrote: > > >> > > >> > > >> On 10/3/06, Daniel McBrearty <[EMAIL PROTECTED]> 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@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@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/ > > > > > > _______________________________________________ > > 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/ > > > > > -- > Daniel McBrearty > email : danielmcbrearty at gmail.com > www.engoi.com : the multi - language vocab trainer > BTW : 0873928131 > -- Daniel McBrearty email : danielmcbrearty at gmail.com www.engoi.com : the multi - language vocab trainer BTW : 0873928131 _______________________________________________ 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/