관리-도구
편집 파일: json.cpython-38.pyc
U -?�f� � @ s\ d dl mZ G dd� dej�ZG dd� d�ZG dd� deejj�ZG dd � d eejj�Zd S ) � )�typesc @ s e Zd ZdZdS )�JSONa� MSSQL JSON type. MSSQL supports JSON-formatted data as of SQL Server 2016. The :class:`_mssql.JSON` datatype at the DDL level will represent the datatype as ``NVARCHAR(max)``, but provides for JSON-level comparison functions as well as Python coercion behavior. :class:`_mssql.JSON` is used automatically whenever the base :class:`_types.JSON` datatype is used against a SQL Server backend. .. seealso:: :class:`_types.JSON` - main documentation for the generic cross-platform JSON datatype. The :class:`_mssql.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_VALUE`` or ``JSON_QUERY`` functions at the database level. The SQL Server :class:`_mssql.JSON` type necessarily makes use of the ``JSON_QUERY`` and ``JSON_VALUE`` functions when querying for elements of a JSON object. These two functions have a major restriction in that they are **mutually exclusive** based on the type of object to be returned. The ``JSON_QUERY`` function **only** returns a JSON dictionary or list, but not an individual string, numeric, or boolean element; the ``JSON_VALUE`` function **only** returns an individual string, numeric, or boolean element. **both functions either return NULL or raise an error if they are not used against the correct expected value**. To handle this awkward requirement, indexed access rules are as follows: 1. When extracting a sub element from a JSON that is itself a JSON dictionary or list, the :meth:`_types.JSON.Comparator.as_json` accessor should be used:: stmt = select( data_table.c.data["some key"].as_json() ).where( data_table.c.data["some key"].as_json() == {"sub": "structure"} ) 2. When extracting a sub element from a JSON that is a plain boolean, string, integer, or float, use the appropriate method among :meth:`_types.JSON.Comparator.as_boolean`, :meth:`_types.JSON.Comparator.as_string`, :meth:`_types.JSON.Comparator.as_integer`, :meth:`_types.JSON.Comparator.as_float`:: stmt = select( data_table.c.data["some key"].as_string() ).where( data_table.c.data["some key"].as_string() == "some string" ) .. versionadded:: 1.4 N)�__name__� __module__� __qualname__�__doc__� r r �N/opt/hc_python/lib64/python3.8/site-packages/sqlalchemy/dialects/mssql/json.pyr s r c @ s$ e Zd Zdd� Zdd� Zdd� ZdS )�_FormatTypeMixinc C s t � �d S �N)�NotImplementedError��self�valuer r r � _format_valueY s z _FormatTypeMixin._format_valuec s � � |��� �fdd�}|S )Nc s � � | �} �r�| �} | S r �r �r �r Z super_procr r �process_ s z0_FormatTypeMixin.bind_processor.<locals>.process)Zstring_bind_processor�r �dialectr r r r �bind_processor\ s z _FormatTypeMixin.bind_processorc s � � |��� �fdd�}|S )Nc s � � | �} �r�| �} | S r r r r r r r j s z3_FormatTypeMixin.literal_processor.<locals>.process)Zstring_literal_processorr r r r �literal_processorg s z"_FormatTypeMixin.literal_processorN)r r r r r r r r r r r X s r c @ s e Zd Zdd� ZdS )� JSONIndexTypec C s t |t�rd| }nd| }|S )Nz$[%s]z$."%s"�� isinstance�intr r r r r t s zJSONIndexType._format_valueN�r r r r r r r r r s s r c @ s e Zd Zdd� ZdS )� JSONPathTypec C s dd� dd� |D �� S )Nz$%s� c S s& g | ] }t |t�rd | nd| �qS )z[%s]z."%s"r )�.0�elemr r r � <listcomp>� s �z.JSONPathType._format_value.<locals>.<listcomp>)�joinr r r r r } s ���zJSONPathType._format_valueNr r r r r r | s r N)r r Zsqltypesr r r r r r r r �<module> s E