
    h                         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y
)   )typesc                       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__     GD:\EasyAligner\venv\Lib\site-packages\sqlalchemy/dialects/mssql/json.pyr   r      s    7r   r   c                       e Zd Zd Zd Zd Zy)_FormatTypeMixinc                     t               N)NotImplementedErrorselfvalues     r   _format_valuez_FormatTypeMixin._format_valueU   s    !##r   c                 8      j                  |       fd}|S )Nc                 >    j                  |       } r |       } | S r   r   r   r   
super_procs    r   processz0_FormatTypeMixin.bind_processor.<locals>.process[   %    &&u-E"5)Lr   )string_bind_processorr   dialectr   r   s   `  @r   bind_processorz_FormatTypeMixin.bind_processorX   s    //8
	 r   c                 8      j                  |       fd}|S )Nc                 >    j                  |       } 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27;
	 r   N)r   r   r   r   r    r$   r
   r   r   r   r   T   s    $		r   r   c                       e Zd Zd Zy)JSONIndexTypec                 >    t        |t              rd|z  }|S d|z  }|S )Nz$[%s]z$."%s")
isinstanceintr   s     r   r   zJSONIndexType._format_valuep   s-    eS!eOE  u$Er   Nr   r   r   r   r
   r   r   r&   r&   o   s    r   r&   c                       e Zd Z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")joinr(   r)   )r   r   elems      r   r   zJSONPathType._format_valuey   sS    GG !& % &0c%:FTM$N %
 	
s   !;
Nr*   r
   r   r   r,   r,   x   s    
r   r,   N)r.   r   sqltypesr   r   r&   r,   r
   r   r   <module>r2      sW    "88== 8B 6$hmm&A&A 	
#X]]%?%? 	
r   