[Dbix-class] autosetup of dbic classes from master dbic class possible?

[Mario Minati]

Hello,

I'm developing an intranet application with Catalyst an postgresql. As deleted 
(and old) records needed to be accesible I created the following db 
structure:

table: company - contains company data
  - PK: id
  - on delete/update copy old data to company_historic

table: company__historic - contains old (or deleted) company data
  - PK: historic_id as row id is no longer unique

view: company__view_all
  - Union All select over company and company__historic

view: company__view
  - filtered view of company__view_all only containg the newest 
   (MAX on row modified) records for each id

I have the same structure for another 10 (later more) object types.


What I want to achieve:

I would like to write a DBIx::Class component that automagically creates the
instances for ..__historic, ..__view_all, ..__view.


What would be the best way to realize this?


Thank you for every helpfull wink :-)

Greets,
Mario Minati