[Dbix-class] Advise

[Duncan Ferguson]

Wotcha,

I have set up a perl module using Class::DBI to access a mysql database of my own design at my work.  Then 2 things happened.  The first was I discovered DBIx::Class, and the second is that the data source I was using (an excel spreadsheet which I import into my DB) is being imported into a data warehouse by someone else in the business and I have no say in how it has been designed (however, I have been told I can plug into the new database to save data duplication - the new database will be the gold source and the spreadsheet dropped).

Since I have to rework everything I am starting from scratch with DBIx::Class.

My problem is that it seems little or no thought is being put into the design and the spreadsheet is being dumped into one table (rather than split it all out into seperate tables like I had - requires too much thought and work for them obviously...).

What is the best way to set up my schema to split out the classes virtually?  I guess I can write a number of modules with different names (as I had them before in my own design) all referencing different columns within the same table, but what does this mean for the unique id's for ResultSource's (that no longer exist in the new data) that DBIC seems to require?  Is this possible to cope with this DBIC?

Thanks

  Duncs

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.rawmode.org/pipermail/dbix-class/attachments/20060724/02866d8a/attachment.htm