Re: [sqlalchemy] SQLAlchemy 1.1b2 TypeError: the JSON object must be str, not 'bytes' with mysql 5.7.12 and JSON field type

2016-07-24 Thread Eric Wittle
No special requirement for pymysql on my end, installed mysqlclient and now the test passes. Thanks for your help! On Sunday, July 24, 2016 at 5:09:34 PM UTC-4, Mike Bayer wrote: > > this mostly appears to be a pymysql issue (string values should be > decoded, mysqlclient acts correctly) so I'v

Re: [sqlalchemy] SQLAlchemy 1.1b2 TypeError: the JSON object must be str, not 'bytes' with mysql 5.7.12 and JSON field type

2016-07-24 Thread Mike Bayer
this mostly appears to be a pymysql issue (string values should be decoded, mysqlclient acts correctly) so I've reported it at https://github.com/PyMySQL/PyMySQL/issues/488 I'd install mysqlclient for now. Hopefully pymysql can respond if they'll fix this in time for SQLA 1.1 final. Trackin

[sqlalchemy] SQLAlchemy 1.1b2 TypeError: the JSON object must be str, not 'bytes' with mysql 5.7.12 and JSON field type

2016-07-23 Thread Eric Wittle
I'm trying to include a JSON field in a table with mysql 5.7.12 and sqlalchemy 1.1b2. I've successfully inserted JSON into the database, but when I load the record containing the JSON, I get the TypeError shown in the subject. The database was created with charset utf8, and the connect string