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, 2015 at 5:27:28 PM UTC+2, [email protected] 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: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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
