delta/python-packages/sqlalchemy.git/lib/sqlalchemy/dialects/postgresql/json.py, branch ticket_3148

-Fixed bug where Postgresql JSON type was not able to persist or

2014-08-07T14:43:55+00:00

otherwise render a SQL NULL column value, rather than a JSON-encoded
``'null'``.  To support this case, changes are as follows:

* The value :func:`.null` can now be specified, which will always
  result in a NULL value resulting in the statement.

* A new parameter :paramref:`.JSON.none_as_null` is added, which
  when True indicates that the Python ``None`` value should be
  peristed as SQL NULL, rather than JSON-encoded ``'null'``.

Retrival of NULL as None is also repaired for DBAPIs other than
psycopg2, namely pg8000.

fixes #3159

- apply pep8 formatting to sqlalchemy/sql, sqlalchemy/util, sqlalchemy/dialects,

2014-07-20T16:44:40+00:00

sqlalchemy/orm, sqlalchemy/event, sqlalchemy/testing

- break up the copyright comment as part of a pass

2014-07-09T22:26:55+00:00

to get all flake8 passing

jsonb support for <@, ?| and ?& added.

2014-07-01T09:24:30+00:00

need to see if equality already works.

minor cleanup of the jsonb - had extraneous operators that where copied

2014-06-28T19:11:03+00:00

from hstore that don't apply.

Add tests for ? and @> operators.

add has_key & contains operators for jsonb (ported over from hstore)

2014-06-28T18:47:20+00:00

initial support for JSONB - this only allows you to define the JSONB

2014-06-24T07:23:21+00:00

datatype - this does not add any of the additional support for
querying/indexing yet.

- happy new year

2014-01-05T21:57:05+00:00

- rework the JSON expression system so that "astext" is called after

2013-12-27T23:25:57+00:00

the indexing.  this is for more natural operation.
- also add cast() to the JSON expression to complement astext. This integrates
the CAST call which will be needed frequently.  Part of [ticket:2687].
- it's a little unclear how more advanced unicode attribute-access is going to go,
some quick attempts at testing yielded strange error messages from psycopg2.
- do other cross linking as mentioned in [ticket:2687].

- make the json serializer and deserializer per-dialect, so that we are

2013-12-17T22:46:09+00:00

compatible with psycopg2's per-connection/cursor approach.  add round trip tests for
both native and non-native.