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 _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[EMAIL PROTECTED]
