+
    }¯³j”  ã                   óÐ   € ^RI Ht  ! R R]P                  4      t ! R R4      t ! R R]]P                  P
                  4      t ! R R	]]P                  P                  4      tR
# )é   )Útypesc                   ó   € ] tR t^tRtRtR# )Ú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__Ú__firstlineno__Ú__doc__Ú__static_attributes__r   ó    Ú_/home/luca/screen-checking/.venv/lib/python3.14/site-packages/sqlalchemy/dialects/mssql/json.pyr   r      s   † õ7r   r   c                   ó2   a € ] tR t^Tt o R tR tR tRtV tR# )Ú_FormatTypeMixinc                ó   € \        4       h©N)ÚNotImplementedError©ÚselfÚvalues   &&r   Ú_format_valueÚ_FormatTypeMixin._format_valueU   s   € Ü!Ó#Ð#r   c                ó:   a a€ S P                  V4      oV V3R  lpV# )c                 óJ   <€ SP                  V 4      p S'       d	   S! V 4      p V # r   ©r   ©r   r   Ú
super_procs   &€€r   ÚprocessÚ0_FormatTypeMixin.bind_processor.<locals>.process[   ó%   ø€ Ø×&Ñ& uÓ-ˆEßÙ" 5Ó)�ØˆLr   )Ústring_bind_processor©r   Údialectr   r   s   f& @r   Úbind_processorÚ_FormatTypeMixin.bind_processorX   s   ù€ Ø×/Ñ/°Ó8ˆ
ö	ð ˆr   c                ó:   a a€ S P                  V4      oV V3R  lpV# )c                 óJ   <€ SP                  V 4      p S'       d	   S! V 4      p V # r   r   r   s   &€€r   r   Ú3_FormatTypeMixin.literal_processor.<locals>.processf   r    r   )Ústring_literal_processorr"   s   f& @r   Úliteral_processorÚ"_FormatTypeMixin.literal_processorc   s   ù€ Ø×2Ñ2°7Ó;ˆ
ö	ð ˆr   r   N)	r   r   r	   r
   r   r$   r*   r   Ú__classdictcell__©Ú__classdict__s   @r   r   r   T   s   ø‡ € ò$ò	÷	ð 	r   r   c                   ó&   a € ] tR t^ot o R tRtV tR# )ÚJSONIndexTypec                óZ   € \        V\        4      '       d   R V,          pV# RV,          pV# )z$[%s]z$."%s")Ú
isinstanceÚintr   s   &&r   r   ÚJSONIndexType._format_valuep   s0   € Ü�eœS×!Ò!Ø˜e•OˆEð ˆð ˜uÕ$ˆEØˆr   r   N©r   r   r	   r
   r   r   r,   r-   s   @r   r0   r0   o   s   ø‡ € ÷ð r   r0   c                   ó&   a € ] tR t^xt o R tRtV tR# )ÚJSONPathTypec           
     ó¨   € R RP                  V Uu. uF+  p\        V\        4      '       d
   RV,          MRV,          NK-  	  up4      ,          # u upi )z$%sÚ z[%s]z."%s")Újoinr2   r3   )r   r   Úelems   && r   r   ÚJSONPathType._format_valuey   sV   € ØØ�G‰Gñ !&óá %˜ô &0°´c×%:Ò%:�F˜T–MÀÈ$ÅÒNÙ %ñóõ
ð 	
ùòs   ‘1A
r   Nr5   r-   s   @r   r7   r7   x   s   ø‡ € ÷
ð 
r   r7   N)r9   r   Úsqltypesr   r   r0   r7   r   r   r   Ú<module>r>      sW   ðõ "ô8ˆ8�=‰=ô 8÷Bñ ô6Ð$ h§m¡m×&AÑ&Aô ô	
Ð# X§]¡]×%?Ñ%?ö 	
r   