[Dbix-class] Multiple Tables - One Class

James R. Leu jleu at mindspring.com
Tue May 12 13:17:16 GMT 2009


Hello Lee,

On Tue, May 12, 2009 at 10:39:16AM +0800, Lee Standen wrote:
> Hi All,
> 
> Has anyone seen a  modification to DBIC which will handle multiple tables
> per class?

You may need to provide a little more info about what your trying to
accomplish.  Simply trying to span multiple tables that have the same
schema can sometimes be handled with some DB foo (views etc).  Having
different tables queried based on the request is a completely different
issue.

> A requirement has just come up out of the blue for the project I'm working
> on which requires the data to be segmented into daily tables.  Since this
> started as a personal project, and not officially company sponsored, I was
> able to do what I wanted, so ended up with DBIC + Catalyst, but this new
> requirement looks to through a bit of a spanner in the works.

My gut response to data being segmented by days is that you could
potential use a table that is partitioned by day of the year
(again a DB approach to your problem).

Either way, there are a lot a smart people on this list that have
solved many problems using catalyst/dbic.  So if you provide a little
more info, I'm sure someone will have already implemented something
similar.

-- 
James R. Leu
jleu at mindspring.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: not available
Url : http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20090512/71ed80a4/attachment.pgp


More information about the DBIx-Class mailing list