Re: [sqlalchemy] update using query - joint table inheritance

2013-08-10 Thread Michael Bayer
On Aug 9, 2013, at 10:45 PM, Mark Eastwood markeastwoo...@gmail.com wrote: It is easier to describe in code than in words. absolutely, this is much preferred. Can anyone please tell me if there is something that I am doing wrong? is this a bug with sqlalchemy? it's kind of a bug, yes,

Re: [sqlalchemy] update using query - joint table inheritance

2013-08-10 Thread Mark Eastwood
Hi Michael, Thankyou very much for your reply, which is exactly what I needed. I also saw the new ticket that was raised for documentation of this, thankyou zzzeek. Mark -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this

[sqlalchemy] update using query - joint table inheritance

2013-08-09 Thread Mark Eastwood
Hi all, I am getting some unexpected behaviour when trying to update selected rows from a query when using joint table inheritance. Using MySQL, a query that is filtered based on items in the parent table, does not honour this filter when updating items in the child table (all children are