File Manager

✏️ ts/mysql/json.py

# mysql/json.py
# Copyright (C) 2005-2021 the SQLAlchemy authors and contributors
# <see AUTHORS file>
#
# This module is part of SQLAlchemy and is released under
# the MIT License: http://www.opensource.org/licenses/mit-license.php

from __future__ import absolute_import

from ... import types as sqltypes

class JSON(sqltypes.JSON):
    """MySQL JSON type.

MySQL supports JSON as of version 5.7.
    MariaDB supports JSON (as an alias for LONGTEXT) as of version 10.2.

The :class:`.mysql.JSON` type supports persistence of JSON values
    as well as the core index operations provided by :class:`_types.JSON`
    datatype, by adapting the operations to render the ``JSON_EXTRACT``
    function at the database level.

.. versionadded:: 1.1

"""

pass

class _FormatTypeMixin(object):
    def _format_value(self, value):
        raise NotImplementedError()

def bind_processor(self, dialect):
        super_proc = self.string_bind_processor(dialect)

def process(value):
            value = self._format_value(value)
            if super_proc:
                value = super_proc(value)
            return value

return process

def literal_processor(self, dialect):
        super_proc = self.string_literal_processor(dialect)

def process(value):
            value = self._format_value(value)
            if super_proc:
                value = super_proc(value)
            return value

return process

class JSONIndexType(_FormatTypeMixin, sqltypes.JSON.JSONIndexType):
    def _format_value(self, value):
        if isinstance(value, int):
            value = "$[%s]" % value
        else:
            value = '$."%s"' % value
        return value

class JSONPathType(_FormatTypeMixin, sqltypes.JSON.JSONPathType):
    def _format_value(self, value):
        return "$%s" % (
            "".join(
                [
                    "[%s]" % elem if isinstance(elem, int) else '."%s"' % elem
                    for elem in value
                ]
            )
        )

Batal

⬅ dialects 17 item

Nama	Tipe	Ukuran	Diubah	Aksi
📁__pycache__	dir	—	2026-03-11 18:53	📂 Buka
🐍__init__.py	py	2 KB	2026-01-20 12:58	✏️ 👁️
🐍base.py	py	104.8 KB	2026-01-20 12:58	✏️ 👁️
🐍cymysql.py	py	2.2 KB	2026-01-20 12:58	✏️ 👁️
🐍dml.py	py	4.7 KB	2026-01-20 12:58	✏️ 👁️
🐍enumerated.py	py	11 KB	2026-01-20 12:58	✏️ 👁️
🐍gaerdbms.py	py	3.3 KB	2026-01-20 12:58	✏️ 👁️
🐍json.py	py	2 KB	2026-01-20 12:58	✏️ 👁️
🐍mysqlconnector.py	py	7.7 KB	2026-01-20 12:58	✏️ 👁️
🐍mysqldb.py	py	8.3 KB	2026-01-20 12:58	✏️ 👁️
🐍oursql.py	py	7.9 KB	2026-01-20 12:58	✏️ 👁️
🐍provision.py	py	1.2 KB	2026-01-20 12:58	✏️ 👁️
🐍pymysql.py	py	2.7 KB	2026-01-20 12:58	✏️ 👁️
🐍pyodbc.py	py	3.4 KB	2026-01-20 12:58	✏️ 👁️
🐍reflection.py	py	17.8 KB	2026-01-20 12:58	✏️ 👁️
🐍types.py	py	24 KB	2026-01-20 12:58	✏️ 👁️
🐍zxjdbc.py	py	3.9 KB	2026-01-20 12:58	✏️ 👁️

✏️ Rename