On Thursday 29 November 2007 10:07:24 you 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? > > > Thank you for every helpfull wink :-) > > Greets, > Mario Minati
RTFM!? http://search.cpan.org/~ash/DBIx-Class/lib/DBIx/Class/Manual/Cookbook.pod#Arbitrary_SQL_through_a_custom_ResultSource ;-) Mario _______________________________________________ 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]
