Re: [sqlalchemy] pg8000 driver and JSON test

2018-06-07 Thread Mike Bayer
On Thu, Jun 7, 2018 at 5:46 AM, Tony Locke wrote: > Thanks for your swift reply Mike. I should have said that I'm changing > the way that pg8000 works so that there's a pg8000.PGJson wrapper for > JSON values. The reason for doing so is to allow pg8000 to send the > correct type code to Postgres.

Re: [sqlalchemy] pg8000 driver and JSON test

2018-06-07 Thread Tony Locke
Thanks for your swift reply Mike. I should have said that I'm changing the way that pg8000 works so that there's a pg8000.PGJson wrapper for JSON values. The reason for doing so is to allow pg8000 to send the correct type code to Postgres. Previously with pg8000, JSON was represented as a string,

[sqlalchemy] pg8000 driver and JSON test

2018-06-06 Thread Tony Locke
Hi, I'm trying to get the latest pg8000 driver to pass the SQLAlchemy dialect tests. I'm stuck on the following test in test_types.py: def test_crit_against_string_coerce_type(self): name = self.tables.data_table.c.name col = self.tables.data_table.c['data']