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 protein_id, protein.acc AS protein_acc, protein.entry_name AS protein_entry_name, protein.gene_name AS protein_gene_name, protein.is_human AS protein_is_human, protein.is_membrane AS protein_is_membrane, protein.is_reviewed AS protein_is_reviewed, protein.sprot_str AS protein_sprot_str FROM protein, omim_assoc WHERE %s = omim_assoc.omim_id AND protein.id = omim_assoc.protein_id 2015-04-04 17:16:09,985 INFO sqlalchemy.engine.base.Engine (16083L,) Traceback (most recent call last): [skipped] File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.9.9-py2.7-linux-x86_64.egg/sqlalchemy/orm/strategies.py", line 169, in fetch_col dict_[key] = row[col] ValueError: int_to_boolean only accepts None, 0 or 1 ---- However, when querying this in mysql client: SELECT protein.id AS protein_id FROM protein, omim_assoc WHERE 16083 = omim_assoc.omim_id AND protein.id = omim_assoc.protein_id; No problem, the protein is found. Moreover, if I query Omim with a different ac, it works. ---- I have no idea how to debug... Thanks for your help in advance, Tamas -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.