[sqlalchemy] Re: FlushError (unsaved, pending instance and is an orphan)

2007-04-06 Thread svilen
what's your mappers? many2one/one2many relations etc? I expected that I can create a parent-child link either from parent to child (by appending to ranker.results) or from child to parent (as above), but apparently the latter doesn't seem to work. Is this the case or something else is wrong

[sqlalchemy] Re: association obj/proxy

2007-04-06 Thread svilen
seems this is the month of the many2many relations ;-) more on the theme: many2many i have a association of 3 tables, A,B,C. one of them (C) may not be present in all assoc_items. So that column has nullable=True. The problem is: adding associations to A-objects and saving them works; but

[sqlalchemy] Re: FlushError (unsaved, pending instance and is an orphan)

2007-04-06 Thread George Sakkis
On Apr 6, 2:52 am, svilen [EMAIL PROTECTED] wrote: what's your mappers? many2one/one2many relations etc? I expected that I can create a parent-child link either from parent to child (by appending to ranker.results) or from child to parent (as above), but apparently the latter doesn't

[sqlalchemy] Re: FlushError (unsaved, pending instance and is an orphan)

2007-04-06 Thread Gaetan de Menten
On 4/6/07, George Sakkis [EMAIL PROTECTED] wrote: I'm using SA (with Elixir on top) and I have a parent Entity Ranker that has many children Results; that is, for a Ranker instance rk, rk.results gives its children and for a Result rs, rs.ranker gives its parent. When I add new children by

[sqlalchemy] Re: association obj/proxy

2007-04-06 Thread Michael Bayer
On Apr 6, 2007, at 5:39 AM, svilen wrote: seems this is the month of the many2many relations ;-) more on the theme: many2many i have a association of 3 tables, A,B,C. one of them (C) may not be present in all assoc_items. So that column has nullable=True. The problem is: adding

[sqlalchemy] adding joins to existing select

2007-04-06 Thread vkuznet
Hi, is there are any way to add additional joins to a given select object? My problem is the following, I need to join the same table multiple times. How many times I don't know in advance and in addition I need to apply where clause while adding this join. Thanks, Valentin.

[sqlalchemy] Re: adding joins to existing select

2007-04-06 Thread Michael Bayer
the select object supports an append_from() method. however, if you want to chain the joins themselves together, you probably want to construct the Join object ahead of time and add it to the select via append_from() (or create the select by calling the select() method off the Join itself)

[sqlalchemy] Re: association obj/proxy

2007-04-06 Thread sdobrev
seems this is the month of the many2many relations ;-) more on the theme: many2many i have a association of 3 tables, A,B,C. one of them (C) may not be present in all assoc_items. So that column has nullable=True. when you say, association of 3 tables, A,B, C, do you mean, there

[sqlalchemy] Re: association obj/proxy

2007-04-06 Thread Michael Bayer
On Apr 6, 2007, at 8:19 PM, [EMAIL PROTECTED] wrote: btw whats the reasoning/rational behind the above default behaviour? i think it is often unexpected behavior, particularly for a query that returns rows between say table A and table B, where some of the rows contain nulls for the B