�
_��g�. � � � d Z ddlmZ ddlmZ ddlmZ ddlZddlZddlm Z ddlm
Z
ddlm Z ddlm Z dd lm
Z
dd
lmZ dd lmZ dd lmZ dd
lmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddl m Z ese sddl m Z nddl m Z erddl!m"Z" ddl!m#Z# dd l!m$Z$ ed e � � Z% ed ee d f � � Z& G d!� d"e ee e e& � Z'e Z(e'Z) G d#� d$e� Z* G d%� d&e*ejV d' ejX e � Z- G d(� d)e*ej\ d'e f � Z/ G d*� d+e ej d'e f � Z0y),z.Define row constructs including :class:`.Row`.� )� annotations)�ABCN)�Any)�Callable)�Dict)�Generic)�Iterator)�List)�Mapping)�NoReturn)�Optional)�overload)�Sequence)�Tuple)�
TYPE_CHECKING)�TypeVar)�Union� )�util)�
deprecated)�HAS_CYEXTENSION� )�BaseRow)�_KeyType)�_ProcessorsType)� RMKeyView�_T)�bound�_TP.c � � e Zd ZdZdZd d�Zd!d�Zd"d�Z edd� d"d�� Z e
d"d �� Z e
edd
� d"d �� � Z e
d#d �� Z
d$d
�Zesd%d�Z ed� Z ed� Zd&d�Zd'd�Zej, Zered(d�� Zed)d�� Zd*d�Zd+d�Zd+d�Zd+d�Zd+d�Z d+d�Z d+d�Z d,d �Z e
d-d �� Z d.d �Z!y )/�Rowa Represent a single result row.
The :class:`.Row` object represents a row of a database result. It is
typically associated in the 1.x series of SQLAlchemy with the
:class:`_engine.CursorResult` object, however is also used by the ORM for
tuple-like results as of SQLAlchemy 1.4.
The :class:`.Row` object seeks to act as much like a Python named
tuple as possible. For mapping (i.e. dictionary) behavior on a row,
such as testing for containment of keys, refer to the :attr:`.Row._mapping`
attribute.
.. seealso::
:ref:`tutorial_selecting_data` - includes examples of selecting
rows from SELECT statements.
.. versionchanged:: 1.4
Renamed ``RowProxy`` to :class:`.Row`. :class:`.Row` is no longer a
"proxy" object in that it contains the final form of data within it,
and now acts mostly like a named tuple. Mapping-like functionality is
moved to the :attr:`.Row._mapping` attribute. See
:ref:`change_4710_core` for background on this change.
� c � � t d� �)Nzcan't set attribute��AttributeError)�self�name�values �F/opt/hc_python/lib64/python3.12/site-packages/sqlalchemy/engine/row.py� __setattr__zRow.__setattr__P s � � � 2�3�3� c � � t d� �)Nzcan't delete attributer$ )r& r' s r) � __delattr__zRow.__delattr__S s � � � 5�6�6r+ c � � | S )a5 Return a 'tuple' form of this :class:`.Row`.
At runtime, this method returns "self"; the :class:`.Row` object is
already a named tuple. However, at the typing level, if this
:class:`.Row` is typed, the "tuple" return type will be a :pep:`484`
``Tuple`` datatype that contains typing information about individual
elements, supporting typed unpacking and attribute access.
.. versionadded:: 2.0.19 - The :meth:`.Row._tuple` method supersedes
the previous :meth:`.Row.tuple` method, which is now underscored
to avoid name conflicts with column names in the same way as other
named-tuple methods on :class:`.Row`.
.. seealso::
:attr:`.Row._t` - shorthand attribute notation
:meth:`.Result.tuples`
r" �r& s r) �_tuplez
Row._tupleV s � �, � r+ z2.0.19z�The :meth:`.Row.tuple` method is deprecated in favor of :meth:`.Row._tuple`; all :class:`.Row` methods and library-level attributes are intended to be underscored to avoid name conflicts. Please use :meth:`Row._tuple`.c �" � | j � S )zUReturn a 'tuple' form of this :class:`.Row`.
.. versionadded:: 2.0
)r0 r/ s r) �tuplez Row.tuplen s � � �{�{�}� r+ c � � | S )aw A synonym for :meth:`.Row._tuple`.
.. versionadded:: 2.0.19 - The :attr:`.Row._t` attribute supersedes
the previous :attr:`.Row.t` attribute, which is now underscored
to avoid name conflicts with column names in the same way as other
named-tuple methods on :class:`.Row`.
.. seealso::
:attr:`.Result.t`
r" r/ s r) �_tzRow._t} s � � � r+ z�The :attr:`.Row.t` attribute is deprecated in favor of :attr:`.Row._t`; all :class:`.Row` methods and library-level attributes are intended to be underscored to avoid name conflicts. Please use :attr:`Row._t`.c � � | j S )zKA synonym for :meth:`.Row._tuple`.
.. versionadded:: 2.0
)r4 r/ s r) �tzRow.t� s
� � �w�w�r+ c �Z � t | j d| j | j � S )a] Return a :class:`.RowMapping` for this :class:`.Row`.
This object provides a consistent Python mapping (i.e. dictionary)
interface for the data contained within the row. The :class:`.Row`
by itself behaves like a named tuple.
.. seealso::
:attr:`.Row._fields`
.. versionadded:: 1.4
N)�
RowMapping�_parent�
_key_to_index�_datar/ s r) �_mappingz Row._mapping� s# � � �$�,�,��d�.@�.@�$�*�*�M�Mr+ c �Z � t | j || j | j � S �N)r! r9 r: r; )r& � processors r) �_filter_on_valueszRow._filter_on_values� s# � � �4�<�<��D�,>�,>��
�
�K�Kr+ c �& � � t d� fd� � }|S )z3Handle ambiguous names such as "count" and "index" c �p �� � � j j �� r� j �� S d�� fd� }|S )Nc �L �� t t j �� �g| ��i |��S r> )�getattr�collections_abcr )�arg�kwr' r& s ��r) �methz4Row._special_name_accessor.<locals>.go.<locals>.meth� s2 �� � F�w��'?�'?�� F� � �#&� �*,� � r+ )rF r rG r �returnr )r9 �_has_key� __getattr__)r& rH r' s ` �r) �goz&Row._special_name_accessor.<locals>.go� s2 �� ��<�<�(�(��.� �+�+�D�1�1��
�Kr+ )r& r! rI r )�property)r' rL s ` r) �_special_name_accessorzRow._special_name_accessor� s �� � �
� �
� �Ir+ �count�indexc � � || j v S r> )r; �r& �keys r) � __contains__zRow.__contains__� s � ��d�j�j� � r+ c � � t |t � r% || j � |j � � S || j � |� S r> )�
isinstancer! �_to_tuple_instance)r& �other�ops r) �_opzRow._op� sK � � �%��%�
�t�&�&�(�%�*B�*B�*D� E�
� �D�+�+�-�u�5�
r+ c � � y r> r" �r& rP s r) � __getitem__zRow.__getitem__� s � �25r+ c � � y r> r" r\ s r) r] zRow.__getitem__� s � �>Ar+ c � � y r> r" r\ s r) r] zRow.__getitem__� s � �r+ c �B � | j |t j � S r> )rZ �operator�lt�r& rX s r) �__lt__z
Row.__lt__� � � ��x�x��x�{�{�+�+r+ c �B � | j |t j � S r> )rZ ra �lerc s r) �__le__z
Row.__le__� re r+ c �B � | j |t j � S r> )rZ ra �gerc s r) �__ge__z
Row.__ge__� re r+ c �B � | j |t j � S r> )rZ ra �gtrc s r) �__gt__z
Row.__gt__� re r+ c �B � | j |t j � S r> )rZ ra �eqrc s r) �__eq__z
Row.__eq__� re r+ c �B � | j |t j � S r> )rZ ra �nerc s r) �__ne__z
Row.__ne__� re r+ c �> � t t j | � � S r> )�repr�sql_util� _repr_rowr/ s r) �__repr__z Row.__repr__� s � ��H�&�&�t�,�-�-r+ c �l � t | j j D �cg c] }|��|�� c}� S c c}w )a� Return a tuple of string keys as represented by this
:class:`.Row`.
The keys can represent the labels of the columns returned by a core
statement or the names of the orm classes returned by an orm
execution.
This attribute is analogous to the Python named tuple ``._fields``
attribute.
.. versionadded:: 1.4
.. seealso::
:attr:`.Row._mapping`
)r2 r9 �keys)r& �ks r) �_fieldsz Row._fields� s1 � �& �� � �!2�!2�D�!2�A�a�m�a�!2�D�E�E��Ds �1�1c �, � t | j � S )am Return a new dict which maps field names to their corresponding
values.
This method is analogous to the Python named tuple ``._asdict()``
method, and works by applying the ``dict()`` constructor to the
:attr:`.Row._mapping` attribute.
.. versionadded:: 1.4
.. seealso::
:attr:`.Row._mapping`
)�dictr< r/ s r) �_asdictz Row._asdict s � � �D�M�M�"�"r+ N)r' �strr( r rI r )r' r� rI r )rI r )rI r8 )r? zOptional[_ProcessorsType]rI zRow[Any])r' r� rI r )rS r rI �bool)rX r rY zCallable[[Any, Any], bool]rI r� )rP �intrI r )rP �slicerI �
Sequence[Any])rP zUnion[int, slice]rI r �rX r rI r� �rI r� )rI zTuple[str, ...])rI zDict[str, Any])"�__name__�
__module__� __qualname__�__doc__� __slots__r* r- r0 r r2 rM r4 r6 r< r@ r rN rO rP rT rZ r �__hash__r r] rd rh rk rn rq rt ry r} r� r" r+ r) r! r! 2 sA � ��6 �I�4�7��0 �� C�� �� � � � � � ��� ?���� �� �N� �N� L�2�L� �L�
� �$ '�w�/��&�w�/��!�
� � � �H�� �5�
�5� �A�
�A�C�,�,�,�,�,�,�.� �F� �F�(#r+ r! c �f � e Zd ZU dZded< ded< dd�Zdd�Zdd�Zdd �Zdd
�Z dd �Z
dd �Z y
)�
ROMappingViewr" r� �_items�Mapping['_KeyType', Any]r< c � � || _ || _ y r> )r< r� )r& �mapping�itemss r) �__init__zROMappingView.__init__% s � � ��
��� r+ c �, � t | j � S r> )�lenr� r/ s r) �__len__zROMappingView.__len__+ s � ��4�;�;� � r+ c �$ � dj | � S )Nz&{0.__class__.__name__}({0._mapping!r}))�formatr/ s r) ry zROMappingView.__repr__. s � �7�>�>�t�D�Dr+ c �, � t | j � S r> )�iterr� r/ s r) �__iter__zROMappingView.__iter__1 s � ��D�K�K� � r+ c � � || j v S r> �r� )r& �items r) rT zROMappingView.__contains__4 s � ��t�{�{�"�"r+ c �0 � t |� t | � k( S r> ��listrc s r) rq zROMappingView.__eq__7 � � ��E�{�d�4�j�(�(r+ c �0 � t |� t | � k7 S r> r� rc s r) rt zROMappingView.__ne__: r� r+ N)r� r� r� r� �rI r� r� )rI z
Iterator[Any])r� r rI r� r� ) r� r� r� r� �__annotations__r� r� ry r� rT rq rt r" r+ r) r� r� sG � ��I� ��&�&� �/� �8E� � �E�!�#�)�)r+ r� c � � e Zd ZdZy)�ROMappingKeysValuesViewr� N�r� r� r� r� r" r+ r) r� r� > s � � �Ir+ r� r c � � e Zd ZdZy)�ROMappingItemsViewr� Nr� r" r+ r) r� r� D s � ��Ir+ r� c �z � e Zd ZdZdZerd
d�Zn ej Zdd�Z dd�Z
dd�Z dd�Z dd�Z
dd �Zdd
�Zdd �Zy )r8 a� A ``Mapping`` that maps column names and objects to :class:`.Row`
values.
The :class:`.RowMapping` is available from a :class:`.Row` via the
:attr:`.Row._mapping` attribute, as well as from the iterable interface
provided by the :class:`.MappingResult` object returned by the
:meth:`_engine.Result.mappings` method.
:class:`.RowMapping` supplies Python mapping (i.e. dictionary) access to
the contents of the row. This includes support for testing of
containment of specific keys (string column names or objects), as well
as iteration of keys, values, and items::
for row in result:
if "a" in row._mapping:
print("Column 'a': %s" % row._mapping["a"])
print("Column b: %s" % row._mapping[table.c.b])
.. versionadded:: 1.4 The :class:`.RowMapping` object replaces the
mapping-like access previously provided by a database result row,
which now seeks to behave mostly like a named tuple.
r" c � � y r> r" rR s r) r] zRowMapping.__getitem__f s � �Sr+ c �, � t | j � S r> )r� r; r/ s r) � _values_implzRowMapping._values_implk s � ��D�J�J� � r+ c �< � d� | j j D � S )Nc 3 �& K � | ] }|��|�� � y �wr> r" )�.0r| s r) � <genexpr>z&RowMapping.__iter__.<locals>.<genexpr>o s � �� �>�,�a��
��,�s ���r9 r{ r/ s r) r� zRowMapping.__iter__n s � �>�4�<�<�,�,�>�>r+ c �, � t | j � S r> )r� r; r/ s r) r� zRowMapping.__len__q s � ��4�:�:�� r+ c �8 � | j j |� S r> )r9 rJ rR s r) rT zRowMapping.__contains__t s � ��|�|�$�$�S�)�)r+ c �* � t t | � � S r> )rv r r/ s r) ry zRowMapping.__repr__w s � ��D��J� � r+ c �f � t | | j � D �cg c] }|| | f�� c}� S c c}w )zeReturn a view of key/value tuples for the elements in the
underlying :class:`.Row`.
)r� r{ rR s r) r� zRowMapping.itemsz s7 � �
"� �t�y�y�{�;�{��C��c��#�{�;�
�
��;s �.
c �. � | j j S )znReturn a view of 'keys' for string column names represented
by the underlying :class:`.Row`.
r� r/ s r) r{ zRowMapping.keys� s � � �|�|� � � r+ c �6 � t | | j � � S )zeReturn a view of values for the values represented in the
underlying :class:`.Row`.
)r� r� r/ s r) �valueszRowMapping.values� s � �
'�t�T�->�->�-@�A�Ar+ N)rS r rI r )rI z List[Any])rI z
Iterator[str]r� )rS �objectrI r� r� )rI r� )rI r )rI r� )r� r� r� r� r� r r] r �_get_by_key_impl_mappingr� r� r� rT ry r� r{ r� r" r+ r) r8 r8 H sJ � ��2 �I��8� �6�6� � �?� �*� �
�!�Br+ r8 )1r� �
__future__r �abcr �collections.abcrE ra �typingr r r r r r
r r r
r r r r r r �sqlr rw r � util._has_cyr �_py_rowr �"sqlalchemy.cyextension.resultproxy�resultr r r r r r! � BaseRowProxy�RowProxyr� �KeysView�
ValuesViewr� � ItemsViewr� r8 r" r+ r) �<module>r� s �� 5� "� � )� �
� � � � � � � � � � � � � � � � "� � *���+�E�� �'�!� �T�� ��
�e�5��c��?�+��f#�'�8�C�=�'�#�,� f#�R � � �� )�C� )�> ��6�?�?�:�.��0A�0A�#�0F� � � ��(8�(8��S� �(I� �HB��&�.�.��S� �9� HBr+