
    ,h                         S SK Jr   " S S\R                  5      r " S S5      r " S S\\R                  R
                  5      r " S S	\\R                  R                  5      rg
)   )typesc                       \ rS rSrSrSrg)JSON   a  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       V/var/www/auris/envauris/lib/python3.13/site-packages/sqlalchemy/dialects/mssql/json.pyr   r      s    7r   r   c                   &    \ rS rSrS rS rS rSrg)_FormatTypeMixinT   c                     [        5       eN)NotImplementedErrorselfvalues     r   _format_value_FormatTypeMixin._format_valueU   s    !##r   c                 :   ^ ^ T R                  U5      mU U4S jnU$ )Nc                 H   > TR                  U 5      n T(       a  T" U 5      n U $ r   r   r   r   
super_procs    r   process0_FormatTypeMixin.bind_processor.<locals>.process[   %    &&u-E"5)Lr   )string_bind_processorr   dialectr    r   s   `  @r   bind_processor_FormatTypeMixin.bind_processorX   s    //8
	 r   c                 :   ^ ^ T R                  U5      mU U4S jnU$ )Nc                 H   > TR                  U 5      n T(       a  T" U 5      n U $ r   r   r   s    r   r    3_FormatTypeMixin.literal_processor.<locals>.processf   r"   r   )string_literal_processorr$   s   `  @r   literal_processor"_FormatTypeMixin.literal_processorc   s    227;
	 r   r   N)r   r	   r
   r   r   r&   r,   r   r   r   r   r   r   T   s    $		r   r   c                       \ rS rSrS rSrg)JSONIndexTypeo   c                 H    [        U[        5      (       a  SU-  nU$ SU-  nU$ )Nz$[%s]z$."%s")
isinstanceintr   s     r   r   JSONIndexType._format_valuep   s0    eS!!eOE  u$Er   r   Nr   r	   r
   r   r   r   r   r   r   r/   r/   o   s    r   r/   c                       \ rS rSrS rSrg)JSONPathTypex   c           
          SSR                  U Vs/ s H"  n[        U[        5      (       a  SU-  OSU-  PM$     sn5      -  $ s  snf )Nz$%s z[%s]z."%s")joinr2   r3   )r   r   elems      r   r   JSONPathType._format_valuey   sV    GG !& % &0c%:%:FTM$N %
 	
s   )A
r   Nr5   r   r   r   r7   r7   x   s    
r   r7   N)r:   r   sqltypesr   r   r/   r7   r   r   r   <module>r?      sW    "88== 8B 6$hmm&A&A 	
#X]]%?%? 	
r   