diff options
| author | Ilja Everilä <ilja.everila@siili.com> | 2018-03-15 10:18:13 -0400 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2018-07-10 18:55:31 -0400 |
| commit | 62d59088dfe86d7ecabd85ad626ee108b668acc5 (patch) | |
| tree | fcff5112cbf21ab4b2b8ef8d6993ff57ea64d9e4 /lib/sqlalchemy/sql | |
| parent | 3cc832992d6820a3cbc88d1b8aca958af8175a49 (diff) | |
| download | sqlalchemy-62d59088dfe86d7ecabd85ad626ee108b668acc5.tar.gz | |
Sqlite json
Added support for SQLite's json functionality via the new
SQLite implementation for :class:`.sqltypes.JSON`, :class:`.sqlite.JSON`.
The name used for the type is ``JSON``, following an example found at
SQLite's own documentation. Pull request courtesy Ilja Everilä.
Fixes: #3850
Change-Id: I3d2714fb8655343a99d13dc751b16b93d05d7dda
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/434
Diffstat (limited to 'lib/sqlalchemy/sql')
| -rw-r--r-- | lib/sqlalchemy/sql/sqltypes.py | 9 |
1 files changed, 7 insertions, 2 deletions
diff --git a/lib/sqlalchemy/sql/sqltypes.py b/lib/sqlalchemy/sql/sqltypes.py index a2ae9de50..08af78606 100644 --- a/lib/sqlalchemy/sql/sqltypes.py +++ b/lib/sqlalchemy/sql/sqltypes.py @@ -1834,8 +1834,13 @@ class JSON(Indexable, TypeEngine): .. note:: :class:`.types.JSON` is provided as a facade for vendor-specific JSON types. Since it supports JSON SQL operations, it only - works on backends that have an actual JSON type, currently - PostgreSQL as well as certain versions of MySQL. + works on backends that have an actual JSON type, currently: + + * PostgreSQL + + * MySQL as of version 5.7 (MariaDB as of the 10.2 series does not) + + * SQLite as of version 3.9 :class:`.types.JSON` is part of the Core in support of the growing popularity of native JSON datatypes. |