Re: [sqlalchemy] [BUG] [PATCH] Calling yield_per followed by execution_options results in AttributeError

2013-02-07 Thread Michael Bayer
that's an ImmutableDict so we can just call union() on it as we're supposed to bethis is http://www.sqlalchemy.org/trac/ticket/2661 and it's committed in reec3f59080ac, thanks ! On Feb 7, 2013, at 11:09 PM, Ryan Kelly wrote: > Calling yield_per on a query followed by execution_options res

[sqlalchemy] [BUG] [PATCH] Calling yield_per followed by execution_options results in AttributeError

2013-02-07 Thread Ryan Kelly
Calling yield_per on a query followed by execution_options results in the following error: Traceback (most recent call last): File "/tmp/execution_options.py", line 18, in query = query.execution_options(stream_results=True) File "", line 1, in File "/usr/lib/python2.7/dist-packages/sq

[sqlalchemy] SQLAlchemy 0.7.10 Released

2013-02-07 Thread Michael Bayer
SQLAlchemy 0.7.10 is now available. This is a bugfix release, sending out a series of fixes that have accumulated as version 0.8.0's release is imminent. Fixes in this version include issues related to the Oracle, SQL Server, MySQL, and Google App Engine dialects, as well as a few schema relate

Re: [sqlalchemy] self-ref relationship with refletion?

2013-02-07 Thread rurpy
On Thursday, February 7, 2013 2:10:33 PM UTC-7, Michael Bayer wrote: > > use a quoted expression that isn't evaluated until mapper configuration > time: > > parent = relationship("Test", remote_side="Test.id") > That did it, thanks. -- You received this message because you are subscribed to

Re: [sqlalchemy] self-ref relationship with refletion?

2013-02-07 Thread Michael Bayer
use a quoted expression that isn't evaluated until mapper configuration time: parent = relationship("Test", remote_side="Test.id") On Feb 7, 2013, at 3:51 PM, ru...@yahoo.com wrote: > How does one define a self-referential relationship when using > declarative objects and reflection? Based on

[sqlalchemy] self-ref relationship with refletion?

2013-02-07 Thread rurpy
How does one define a self-referential relationship when using declarative objects and reflection? Based on http://docs.sqlalchemy.org/en/rel_0_8/orm/relationships.html#adjacency-list-relationships I wrote the code below but when I run it I get an exception when the session.query() line is

[sqlalchemy] Re: Key error while creating link in graph

2013-02-07 Thread andrew cooke
I'm an idiot. Will delete post. I need to be more explicit about the intermediate table. On Thursday, 7 February 2013 07:56:18 UTC-3, andrew cooke wrote: > > > Hi, > > Could someone please explain what the following error means? I assume I > am expecting too much magic from SQLAlchemy, but I

[sqlalchemy] Re: Key error while creating link in graph

2013-02-07 Thread andrew cooke
Oh, staring at that some more - I guess the problem is that there is nothing that says that if alice links to bob then bob links from alice. I should just defined one arc. Sorry - I will fix my code. Andrew On Thursday, 7 February 2013 07:56:18 UTC-3, andrew cooke wrote: > > > Hi, > > Could

[sqlalchemy] Key error while creating link in graph

2013-02-07 Thread andrew cooke
Hi, Could someone please explain what the following error means? I assume I am expecting too much magic from SQLAlchemy, but I can't see why it doesn't "just work". I am trying to define a directed graph of related (music) artists. So I have an Artist class (nodes) and a Link class (directe