Joerg Braun wrote:
I can update a bunch of rows with resultset->search(...)->update(...).
Is it possible to model with DBIC an SQL like
INSERT INTO <table> ( <cols>) SELECT <cols> FROM <table> WHERE <cond>;
Not yet, but this is a feature we'd like to have. You can kick-start the
process by contributing an extra test to the test suite. Something like:
$rs->populate ([ \...@column_names, $source_rs->as_query ]);
The repo can be found at
http://github.com/dbix-class/DBIx-Class
git://git.shadowcat.co.uk/dbsrgits/DBIx-Class.git
Cheers
_______________________________________________
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]
