[sqlalchemy] Re: sqlalchemy.exc.InvalidRequestError: Object 'Foo at 0x23b0690' is already attached to session '29012560' (this is '30924944')

2009-06-02 Thread Gaetan de Menten
On Sun, May 31, 2009 at 16:50, Michael Bayer mike...@zzzcomputing.com wrote: On May 30, 2009, at 1:56 AM, ericthompso...@gmail.com wrote: Upon reaching the instantiation of Foo, my code blows up with the error message in the subject.  Now I realize this is often caused by threading issues

[sqlalchemy] Re: Relation spanning multiple tables

2009-06-02 Thread Mike Conley
This looks like an association proxy. Have you tried that? http://www.sqlalchemy.org/docs/05/reference/ext/associationproxy.html -- Mike Conley On Mon, Jun 1, 2009 at 11:46 PM, George Sakkis george.sak...@gmail.comwrote: I can't for the life of me figure out how to specify a relation

[sqlalchemy] Re: many-to-many relation, 'secondaryjoin' is needed as well

2009-06-02 Thread Gera88
Oh I did it Thanks! --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to

[sqlalchemy] Re: Relation spanning multiple tables

2009-06-02 Thread George Sakkis
On Jun 2, 7:00 am, Mike Conley mconl...@gmail.com wrote: This looks like an association proxy. Have you tried that? http://www.sqlalchemy.org/docs/05/reference/ext/associationproxy.html I don't see how this is related. From a quick read, it seems that's a simplified way to handle

[sqlalchemy] declarative defer error

2009-06-02 Thread quirogaco
Hello, error in declarative query with defer class ClassDefaults(dec.DeclarativeMeta): def __init__(cls, classname, bases, dict_): dict_['id'] = Fdb.Unicode(Adb.Length(55), Adb.Primary_Key(True), Adb.Unique(True), Adb.Nullable(False)) dict_['status'] =

[sqlalchemy] Re: declarative defer error

2009-06-02 Thread Michael Bayer
quirogaco wrote: File C:\Acappella_2Zero\thirdparty\sqlalchemy\orm\mapper.py, line 1612, in _ instance identitykey = identity_key(row) File C:\Acappella_2Zero\thirdparty\sqlalchemy\orm\mapper.py, line 1553, in i dentity_key return (identity_class, tuple(row[column] for column

[sqlalchemy] deletes using association_proxy

2009-06-02 Thread hollister
I have a many-to-many schema using an association object and the association proxy. I'm able to add data via the ORM, but trying to delete from the association (but not delete the left or right tables) throws a AssertionError: Dependency rule tried to blank-out primary key column