o
    èã¤g”  ã                   @   s\   d dl mZ G dd„ dejƒZG dd„ dƒZG dd„ deejjƒZG dd	„ d	eejjƒZd
S )é   )Útypesc                   @   s   e Zd ZdZdS )Ú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   ú`/var/www/html/ecg_monitoring/venv/lib/python3.10/site-packages/sqlalchemy/dialects/mssql/json.pyr      s    r   c                   @   s$   e Zd Zdd„ Zdd„ Zdd„ ZdS )Ú_FormatTypeMixinc                 C   s   t ƒ ‚©N)ÚNotImplementedError©ÚselfÚvaluer   r   r	   Ú_format_valueU   s   z_FormatTypeMixin._format_valuec                    ó   ˆ   |¡‰‡ ‡fdd„}|S )Nc                    ó   ˆ   | ¡} ˆrˆ| ƒ} | S r   ©r   ©r   ©r   Ú
super_procr   r	   Úprocess[   ó   
z0_FormatTypeMixin.bind_processor.<locals>.process)Ústring_bind_processor©r   Údialectr   r   r   r	   Úbind_processorX   ó   
z_FormatTypeMixin.bind_processorc                    r   )Nc                    r   r   r   r   r   r   r	   r   f   r   z3_FormatTypeMixin.literal_processor.<locals>.process)Ústring_literal_processorr   r   r   r	   Úliteral_processorc   r   z"_FormatTypeMixin.literal_processorN)r   r   r   r   r   r   r   r   r   r	   r
   T   s    r
   c                   @   ó   e Zd Zdd„ ZdS )ÚJSONIndexTypec                 C   s"   t |tƒrd| }|S d| }|S )Nz$[%s]z$."%s"©Ú
isinstanceÚintr   r   r   r	   r   p   s
   
ÿzJSONIndexType._format_valueN©r   r   r   r   r   r   r   r	   r!   o   ó    r!   c                   @   r    )ÚJSONPathTypec                 C   s   dd  dd„ |D ƒ¡ S )Nz$%sÚ c                 S   s&   g | ]}t |tƒrd | nd| ‘qS )z[%s]z."%s"r"   )Ú.0Úelemr   r   r	   Ú
<listcomp>|   s    ÿÿz.JSONPathType._format_value.<locals>.<listcomp>)Újoinr   r   r   r	   r   y   s   þÿÿzJSONPathType._format_valueNr%   r   r   r   r	   r'   x   r&   r'   N)r(   r   Úsqltypesr   r
   r!   r'   r   r   r   r	   Ú<module>   s
   
A	