§
    eŠtj”  ã                   ó¶   — d dl mZ  G d„ dej        ¦  «        Z G d„ d¦  «        Z G d„ deej        j        ¦  «        Z G d„ d	eej        j        ¦  «        Zd
S )é   )Útypesc                   ó   — 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__© ó    ú\/var/www/html/CA-Chatbot/venv/lib/python3.11/site-packages/sqlalchemy/dialects/mssql/json.pyr   r      s   € € € € € ð7ð 7ð 7ð 7r   r   c                   ó    — e Zd Zd„ Zd„ Zd„ ZdS )Ú_FormatTypeMixinc                 ó   — t          ¦   «         ‚©N)ÚNotImplementedError©ÚselfÚvalues     r   Ú_format_valuez_FormatTypeMixin._format_valueU   s   € Ý!Ñ#Ô#Ð#r   c                 ó@   ‡ ‡— ‰                       |¦  «        Šˆ ˆfd„}|S )Nc                 óL   •— ‰                      | ¦  «        } ‰r ‰| ¦  «        } | S r   ©r   ©r   r   Ú
super_procs    €€r   Úprocessz0_FormatTypeMixin.bind_processor.<locals>.process[   ó2   ø€ Ø×&Ò& uÑ-Ô-ˆEØð *Ø"˜
 5Ñ)Ô)�ØˆLr   )Ústring_bind_processor©r   Údialectr   r   s   `  @r   Úbind_processorz_FormatTypeMixin.bind_processorX   s<   øø€ Ø×/Ò/°Ñ8Ô8ˆ
ð	ð 	ð 	ð 	ð 	ð 	ð ˆr   c                 ó@   ‡ ‡— ‰                       |¦  «        Šˆ ˆfd„}|S )Nc                 óL   •— ‰                      | ¦  «        } ‰r ‰| ¦  «        } | S r   r   r   s    €€r   r   z3_FormatTypeMixin.literal_processor.<locals>.processf   r   r   )Ústring_literal_processorr   s   `  @r   Úliteral_processorz"_FormatTypeMixin.literal_processorc   s<   øø€ Ø×2Ò2°7Ñ;Ô;ˆ
ð	ð 	ð 	ð 	ð 	ð 	ð ˆr   N)r   r   r   r   r    r$   r
   r   r   r   r   T   sA   € € € € € ð$ð $ð $ð	ð 	ð 	ð	ð 	ð 	ð 	ð 	r   r   c                   ó   — e Zd Zd„ ZdS )ÚJSONIndexTypec                 óF   — t          |t          ¦  «        rd|z  }nd|z  }|S )Nz$[%s]z$."%s"©Ú
isinstanceÚintr   s     r   r   zJSONIndexType._format_valuep   s.   € Ý�e�SÑ!Ô!ð 	%Ø˜e‘OˆEˆEà˜uÑ$ˆEØˆr   N©r   r   r   r   r
   r   r   r&   r&   o   s#   € € € € € ðð ð ð ð r   r&   c                   ó   — e Zd Zd„ ZdS )ÚJSONPathTypec                 óF   — dd                      d„ |D ¦   «         ¦  «        z  S )Nz$%sÚ c                 óL   — g | ]!}t          |t          ¦  «        rd |z  nd|z  ‘Œ"S )z[%s]z."%s"r(   )Ú.0Úelems     r   ú
<listcomp>z.JSONPathType._format_value.<locals>.<listcomp>|   sC   € ð ð ð àõ &0°µcÑ%:Ô%:ÐN�F˜T‘M�MÀÈ$Áðð ð r   )Újoinr   s     r   r   zJSONPathType._format_valuey   s<   € ØØ�GŠGðð à %ðñ ô ñô ñ
ð 	
r   Nr+   r
   r   r   r-   r-   x   s#   € € € € € ð
ð 
ð 
ð 
ð 
r   r-   N)r/   r   Úsqltypesr   r   r&   r-   r
   r   r   ú<module>r6      sÜ   ðð "Ð !Ð !Ð !Ð !Ð !ð8ð 8ð 8ð 8ð 8ˆ8Œ=ñ 8ô 8ð 8ðBð ð ð ð ñ ô ð ð6ð ð ð ð Ð$ h¤mÔ&Añ ô ð ð	
ð 	
ð 	
ð 	
ð 	
Ð# X¤]Ô%?ñ 	
ô 	
ð 	
ð 	
ð 	
r   