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

[Jess Robinson]

On Thu, 29 Nov 2007, Mario Minati wrote:

> 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?
>
>

You vould look at DBIx::Class::Journal in svn ( 
http://dev.catalystframework.org/repos/bast/trunk/DBIx-Class-Journal ) to 
see how that does it..

(Darn, must release that code..)

Jess