[sqlalchemy] Re: SQLError vs. FlushError

2006-11-11 Thread Michael Bayer
it depends on who is generating the error. in 0.3.0 we have some more automated code for reconciling two objects, one of which is deleted and the other saved, with the same primary key value. this is handy for association object mappings in particular. so when detecting an invalid

[sqlalchemy] Re: Constructing where-clauses dynamically

2006-11-11 Thread Daniel Miller
BTW, this post started out as a reply to James but grew into a collective summary of my thoughts on the entire thread so far. You've been warned :) James Taylor wrote: But wouldn't the join from orders to items be OUTER in this case since you can have orders with a total 50 but no items.