[sqlalchemy] Re: reflecting (autoload=True) MySQL tinyint(1) fields

2010-05-04 Thread Brad Wells
The docs for the MySQL dialect need to be updated to reflect this change. See http://www.sqlalchemy.org/docs/reference/dialects/mysql.html#sqlalchemy.dialects.mysql.TINYINT For what it's worth I'd really like to see this remain as an optional behavior. The BOOL/BOOLEN column types in MySQL are

Re: [sqlalchemy] Re: reflecting (autoload=True) MySQL tinyint(1) fields

2010-05-04 Thread Michael Bayer
On May 4, 2010, at 1:22 PM, Brad Wells wrote: The docs for the MySQL dialect need to be updated to reflect this change. See http://www.sqlalchemy.org/docs/reference/dialects/mysql.html#sqlalchemy.dialects.mysql.TINYINT For what it's worth I'd really like to see this remain as an optional

[sqlalchemy] Re: reflecting (autoload=True) MySQL tinyint(1) fields

2010-05-04 Thread Brad Wells
0/1 generally works in Python but won't convert to formats with native boolean values correctly, in my case JSON. Just a note, your suggestion works for me but will fail for any unsigned columns. I have a working solution so I'm fine with moving on from the issue, Overall however, with MySQL's