Re: [sqlalchemy] Re: Order of INSERTs for children of an object

2010-05-20 Thread Tomasz Nazar
Thanks for quick response. Yes we had a discussion on this list (http://www.mail-archive.com/sqlalchemy@googlegroups.com/msg12897.html), but I didn't went deeper into why it happens and just used dependencies what worked great for me. I will try to use the code you gave. What I can do later is I

Re: [sqlalchemy] Re: Order of INSERTs for children of an object

2010-05-19 Thread Tomasz Nazar
On Sat, Jan 17, 2009 at 3:40 AM, Michael Bayer mike...@zzzcomputing.com wrote: On Jan 16, 2009, at 6:13 PM, Tomasz Nazar wrote: Do I have control over this behaviour? Or am I doing sth wrong? Thanks for any help..Tomasz you can !   its an exposed internal API but its pretty stable for

[sqlalchemy] Re: Order of INSERTs for children of an object

2009-01-19 Thread Tomasz Nazar
Thanks Michael, it works for simple case and solved my issue for now. In SqlA 0.4 import is wrong. proper one is: from sqlalchemy.orm.session import SessionExtension So, for A-B dependency it works. 'Inserts' seem not be random any more. I wanted to play a bit more with that feature and can I

[sqlalchemy] Re: Order of INSERTs for children of an object

2009-01-19 Thread Michael Bayer
On Jan 19, 2009, at 9:10 AM, Tomasz Nazar wrote: Thanks Michael, it works for simple case and solved my issue for now. In SqlA 0.4 import is wrong. proper one is: from sqlalchemy.orm.session import SessionExtension So, for A-B dependency it works. 'Inserts' seem not be random any

[sqlalchemy] Re: Order of INSERTs for children of an object

2009-01-19 Thread Tomasz Nazar
On Mon, Jan 19, 2009 at 4:33 PM, Michael Bayer mike...@zzzcomputing.com wrote: So, for A-B dependency it works. 'Inserts' seem not be random any more. I wanted to play a bit more with that feature and can I configure many dependencies in that way? I was thinking if can tell SQLA to have kind

[sqlalchemy] Re: Order of INSERTs for children of an object

2009-01-19 Thread Michael Bayer
On Jan 19, 2009, at 11:17 AM, Tomasz Nazar wrote: Hmm, the circular dependency: I do have some mappers configured that some cycle exists in fact. Is this what you're talking about? Conference- (has many) ConferenceInterpreter -(related to one) User - (created many) Conference - . I

[sqlalchemy] Re: Order of INSERTs for children of an object

2009-01-19 Thread Tomasz Nazar
On Mon, Jan 19, 2009 at 5:37 PM, Michael Bayer mike...@zzzcomputing.com wrote: if you actually have foreign keys expressing multiple paths to the same things then there would be a cycle. It's hard to tell from your mappings, your tables don't seem to have cycles from a foreign key

[sqlalchemy] Re: Order of INSERTs for children of an object

2009-01-16 Thread Michael Bayer
On Jan 16, 2009, at 6:13 PM, Tomasz Nazar wrote: Do I have control over this behaviour? Or am I doing sth wrong? Thanks for any help..Tomasz you can ! its an exposed internal API but its pretty stable for now. Build a SessionExtension like this: from sqlalchemy.orm.interfaces import