[Catalyst] How many models?

[Matt S Trout]

On Thu, Apr 26, 2007 at 10:02:24PM +0100, Jamie Neil wrote:
> John Napiorkowski wrote:
> >I think the consensus is that it's best to create business logic type
> >models outside of Catalyst and then build a simple wrapper model for
> >it.  That way you can use it for stuff like cron jobs and anything
> >that doesn't live inside of Catalyst.
> 
> That's exactly what we're trying to do.
> 
> >Now I isolated the business logic for creating an account into the
> >MyApp::Logic::Accounts package because for my system creating a new
> >user is much more than just inserting a row into the Users database.
> >The logic would using the MyApp::Schema::Users Class and some other
> >classes and wrap all that into a neat interface.
> 
> Again, this is the direction we are going, however what I was concerned 
> about was that this way we would end up with a lot more database handles 
> that was necessary (we may have three or four models). Whilst this is 
> not a problem for a single application, we are planning on running many 
> instances sharing the same database server.
> 
> Of course I may just be misunderstanding how DBIx::Class works :)

Just make sure your applications share the DBIx::Class::Storage::DBI
object between any $schema instances they're using - then they'll all use
a single persistent $dbh.

Alternatively, just make your logic models get their DBIC objects via
ACCEPT_CONTEXT (see Catalyst::Component) at which point everything's running
through the one DBIC::Schema model eventually.

-- 
      Matt S Trout       Need help with your Catalyst or DBIx::Class project?
   Technical Director    Want a managed development or deployment platform?
Shadowcat Systems Ltd.   Contact mst (at) shadowcatsystems.co.uk for a quote
                                          http://www.shadowcatsystems.co.uk/