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

Mario Minati mario.minati at googlemail.com
Sun Dec 2 12:55:57 GMT 2007


On Sunday 02 December 2007 01:19:05 Jess Robinson wrote:
> 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..

Wow,
didn't know about that.

Thank you.

Minor bugfix:
I think DBIx/Class/Schema/Journal/DB/AuduitLog.pm needs to be removed.

Greets,
Mario



More information about the DBIx-Class mailing list