[sqlalchemy] Re: error in query many to many

2015-04-04 Thread biohegedus
Thanks for your input! It helped my to find a bug in my code. I inserted 0 for false, 1 and 2 for true. However, inserting a "bad" value for boolean using SQLAlchemy should also result in an exception and not only selecting a boolean with a "bad" value. Thanks again, Tamas On Saturday, April 4,

[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