]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
- Added support for the :class:`postgresql.JSONB` datatype when
authorMike Bayer <mike_mp@zzzcomputing.com>
Sun, 1 Feb 2015 00:04:54 +0000 (19:04 -0500)
committerMike Bayer <mike_mp@zzzcomputing.com>
Sun, 1 Feb 2015 00:06:04 +0000 (19:06 -0500)
commit0bd74617f877a4b97c2a59a1d1561809ce8d277c
tree19ad233369c73650f96f5e00cd80f9b63db82582
parent9d8b0633cc6f4de62b2ce64efd9aaa02464564cd
- Added support for the :class:`postgresql.JSONB` datatype when
using psycopg2 2.5.4 or greater, which features native conversion
of JSONB data so that SQLAlchemy's converters must be disabled;
additionally, the newly added psycopg2 extension
``extras.register_default_jsonb`` is used to establish a JSON
deserializer passed to the dialect via the ``json_deserializer``
argument.  Also repaired the Postgresql integration tests which
weren't actually round-tripping the JSONB type as opposed to the
JSON type.  Pull request courtesy Mateusz Susik.

- Repaired the use of the "array_oid" flag when registering the
HSTORE type with older psycopg2 versions < 2.4.3, which does not
support this flag, as well as use of the native json serializer
hook "register_default_json" with user-defined ``json_deserializer``
on psycopg2 versions < 2.5, which does not include native json.

(cherry picked from commit bf70f556b382dc376783efbcb598e0fab71ee235)
README.unittests.rst
doc/build/changelog/changelog_09.rst
lib/sqlalchemy/dialects/postgresql/psycopg2.py
test/dialect/postgresql/test_types.py
test/requirements.py