Re: [Dbix-class] inflate_results and source_name

2010-05-06 Thread Matt S Trout
On Sun, May 02, 2010 at 08:21:11PM -0700, Bill Moseley wrote: On Thu, Apr 29, 2010 at 2:08 PM, Matt S Trout m...@shadowcat.co.uk wrote: source_name is a proxy through to the result_source_instance in class data. If you don't call __PACKAGE__-table(__PACKAGE__-table); in a subclass

Re: [Dbix-class] Schema::Loader and views on Pg

2010-05-06 Thread Matt S Trout
On Sun, May 02, 2010 at 09:56:15PM -0700, Dorian Taylor (Lists) wrote: On 2-May-10, at 12:59 PM, Matt S Trout wrote: Thanks! What about letting S::L pull the column names and then just setting the primary keys and adding rels as a fixup? I think what I'm going to do is make the

Re: [Dbix-class] Improved resultset iterators

2010-05-06 Thread Matt S Trout
On Tue, May 04, 2010 at 01:08:52PM +1000, Toby Corkindale wrote: On 22/04/10 19:00, Peter Rabbitson wrote: Toby Corkindale wrote: Hey all, Wouldn't it be nice if the ResultSet iterators were a bit more advanced? I would love it if the iterator built into DBIx::Class supported some more

Re: [Dbix-class] Using update on a resultset with join

2010-05-06 Thread Matt S Trout
On Wed, May 05, 2010 at 12:24:18PM +0200, Peter Rabbitson wrote: Whereas I was expecting SQL like: UPDATE foo me JOIN ( bars bar ON bars.id = me.bar_id ) SET me.exported = 1 WHERE ( me.exported = 0 AND bar.state = 'WA' ) Newer versions address this issue, albeit not with the SQL you