FM / mysql

/opt/imh-python/lib/python3.9/site-packages/sqlalchemy/dialects/mysql/

/opt/imh-python/lib/python3.9/site-packages/sqlalchemy/dialects/mysql

Name	Size	Mode	Actions
__pycache__/	-	0755	rm
base.py	107282	0644	edit dl rm
cymysql.py	2244	0644	edit dl rm
dml.py	4764	0644	edit dl rm
enumerated.py	11307	0644	edit dl rm
gaerdbms.py	3375	0644	edit dl rm
json.py	2045	0644	edit dl rm
mysqlconnector.py	7889	0644	edit dl rm
mysqldb.py	8504	0644	edit dl rm
oursql.py	8086	0644	edit dl rm
provision.py	1269	0644	edit dl rm
pymysql.py	2720	0644	edit dl rm
pyodbc.py	3470	0644	edit dl rm
reflection.py	18275	0644	edit dl rm
types.py	24589	0644	edit dl rm
zxjdbc.py	3970	0644	edit dl rm
__init__.py	2056	0644	edit dl rm

Edit: /opt/imh-python/lib/python3.9/site-packages/sqlalchemy/dialects/mysql/json.py (2045B)

# 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
                ]
            )
        )

# mysql/json.py # Copyright (C) 2005-2021 the SQLAlchemy authors and contributors # # # 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 ] ) )