Re: [sqlalchemy] error in query many to many

2015-04-04 Thread Mike Bayer
On 4/4/15 12:14 PM, Mike Bayer wrote: > > > On 4/4/15 11:27 AM, biohege...@gmail.com wrote: >> Hi, >> >> I get a strange error when querying a many-to-many relationship >> (Protein - Omim / protein - omim). >> sqlalchemy 0.9.9 >> >> o=Omim.query.filter(Omim.acc=="157140").one() # this is OK >> o.

Re: [sqlalchemy] error in query many to many

2015-04-04 Thread Mike Bayer
On 4/4/15 11:27 AM, biohege...@gmail.com wrote: > Hi, > > I get a strange error when querying a many-to-many relationship > (Protein - Omim / protein - omim). > sqlalchemy 0.9.9 > > o=Omim.query.filter(Omim.acc=="157140").one() # this is OK > o.proteins # this gives an error > > 2015-04-04 17:16:

[sqlalchemy] error in query many to many

2015-04-04 Thread biohegedus
Hi, I get a strange error when querying a many-to-many relationship (Protein - Omim / protein - omim). sqlalchemy 0.9.9 o=Omim.query.filter(Omim.acc=="157140").one() # this is OK o.proteins # this gives an error 2015-04-04 17:16:09,984 INFO sqlalchemy.engine.base.Engine SELECT protein.id AS pr