Ë
    r™ãjÚ  ã                  ó,  — d dl mZ d dlmZ d dlmZ ddlmZ ddlm	Z	 erddl
mZ ddlmZ dd	lmZ  G d
„ dej                  e	   «      Z G d„ d«      Z G d„ deej                  j"                  «      Z G d„ deej                  j$                  «      Zy)é    )Úannotations)ÚAny)ÚTYPE_CHECKINGé   )Útypes)Ú_T_JSON)ÚDialect)Ú_BindProcessorType)Ú_LiteralProcessorTypec                  ó   — e Zd ZdZy)Ú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__© ó    úi/var/www/html/python-recuperauto-other/env/lib/python3.12/site-packages/sqlalchemy/dialects/mssql/json.pyr   r      s   „ ò7r   r   c                  ó,   — e Zd Zdd„Zdd„Z	 	 	 	 dd„Zy)Ú_FormatTypeMixinc                ó   — t        «       ‚©N)ÚNotImplementedError)ÚselfÚvalues     r   Ú_format_valuez_FormatTypeMixin._format_value^   s   € Ü!Ó#Ð#r   c                ó:   ‡ ‡— ‰ j                  |«      Šdˆ ˆfd„}|S )Nc                ó>   •— ‰j                  | «      } ‰r ‰| «      } | S r   ©r   ©r   r   Ú
super_procs    €€r   Úprocessz0_FormatTypeMixin.bind_processor.<locals>.processd   ó%   ø€ Ø×&Ñ& uÓ-ˆEÙÙ" 5Ó)�ØˆLr   )r   r   Úreturnr   )Ústring_bind_processor©r   Údialectr"   r!   s   `  @r   Úbind_processorz_FormatTypeMixin.bind_processora   s   ù€ Ø×/Ñ/°Ó8ˆ
ö	ð ˆr   c                ó:   ‡ ‡— ‰ j                  |«      Šdˆ ˆfd„}|S )Nc                ó>   •— ‰j                  | «      } ‰r ‰| «      } | S r   r   r    s    €€r   r"   z3_FormatTypeMixin.literal_processor.<locals>.processq   r#   r   ©r   r   r$   Ústr)Ústring_literal_processorr&   s   `  @r   Úliteral_processorz"_FormatTypeMixin.literal_processorl   s!   ù€ ð ×2Ñ2°7Ó;ˆ
ö	ð ˆr   Nr+   )r'   r	   r$   z_BindProcessorType[Any])r'   r	   r$   z_LiteralProcessorType[Any])r   r   r   r   r(   r.   r   r   r   r   r   ]   s!   „ ó$ó	ðØðà	#ôr   r   c                  ó   — e Zd Zdd„Zy)ÚJSONIndexTypec                ó>   — t        |t        «      rd|z  }|S d|z  }|S )Nz$[%s]z$."%s")Ú
isinstanceÚint)r   r   Úformatted_values      r   r   zJSONIndexType._format_value{   s/   € Ü�eœSÔ!Ø%¨™oˆOð Ðð '¨Ñ.ˆOØÐr   Nr+   ©r   r   r   r   r   r   r   r0   r0   z   s   „ ôr   r0   c                  ó   — e Zd Zdd„Zy)ÚJSONPathTypec           
     ó€   — ddj                  |D �cg c]  }t        |t        «      rd|z  nd|z  ‘Œ c}«      z  S c c}w )Nz$%sÚ z[%s]z."%s")Újoinr2   r3   )r   r   Úelems      r   r   zJSONPathType._format_value„   sN   € ØØ�G‰Gð !&öàô &0°´cÔ%:�F˜T’MÀÈ$ÁÑNòóñ
ð 	
ùòs   ‘!;
Nr+   r5   r   r   r   r7   r7   ƒ   s   „ ô
r   r7   N)Ú
__future__r   Útypingr   r   r9   r   ÚsqltypesÚsql.sqltypesr   Úengine.interfacesr	   Úsql.type_apir
   r   r   r   r0   r7   r   r   r   ú<module>rB      st   ðõ #å Ý  å !Ý #áÝ,Ý2Ý5ô8ˆ8�=‰=˜Ñ!ô 8÷Bñ ô:Ð$ h§m¡m×&AÑ&Aô ô	
Ð# X§]¡]×%?Ñ%?õ 	
r   