codekingpro/portable-devtools
115k
1�
2 ��j�0 � � � S r SSKJr SSKJr SSKJr SSKrSSKrSSKJ r SSKJ3r4 SSKJ r SSKJ r SS KJ
r
SS5KJr SS KJr SS KJr SS
KJr SSKJr SSKJr SSKJr SSKJr SSKJr SSKJr SSKJr SSKJr SSK J r \( d \ ( d SSK J r OSSK J r \( a SSK!J"r" SSK!J#r# SS K!J$r$ \" S \ S 9r%\" S \\ S 4 S 9r& " S! S"\ \\ \ \& 5 r'\ r(\'r) " S# S$\5 r* " S% S&\*\RV S' \RX \ 5 r- " S( S)\*\R\ S'\ 4 5 r/ " S* S+\ \R S'\ 4 5 r0g),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)�6deprecated)�HAS_CYEXTENSION� )�BaseRow)�_KeyType)�_ProcessorsType)� RMKeyView�_T)�bound�_TP.c �� � \ rS rSrSrSrS!S jrS"S jrS#S jr\ " SS5 S#S j5 r7\ S#S8 j5 r \ \ " SS 5 S#S j5 5 r
\ S$S
j5 r S%S jr\( d S&S jr\" S5 r\" S5 rS'S jrS(S jr\R. r\( a \S)S j5 r\S*S j5 rS+S jrS,S jrS,S jrS,S jr S,S jr S,S jr S,S jr S-S jr \ S.S j5 r!S/S jr"Sr#g )0�Row�2 a� Represent a single result row.9 10The :class:`.Row` object represents a row of a database result. It is11typically associated in the 1.x series of SQLAlchemy with the12:class:`_engine.CursorResult` object, however is also used by the ORM for13tuple-like results as of SQLAlchemy 1.4.14 15The :class:`.Row` object seeks to act as much like a Python named16tuple as possible. For mapping (i.e. dictionary) behavior on a row,17such as testing for containment of keys, refer to the :attr:`.Row._mapping`18attribute.19 20.. seealso::21 22 :ref:`tutorial_selecting_data` - includes examples of selecting23 rows from SELECT statements.24 25.. versionchanged:: 1.426 27 Renamed ``RowProxy`` to :class:`.Row`. :class:`.Row` is no longer a28 "proxy" object in that it contains the final form of data within it,29 and now acts mostly like a named tuple. Mapping-like functionality is30 moved to the :attr:`.Row._mapping` attribute. See31 :ref:`change_4710_core` for background on this change.32 33� c � � [ S5 e)Nzcan't set attribute��AttributeError)�self�name�values �[D:\code\apps\devtools\python\user_packages\Python313\site-packages\sqlalchemy/engine/row.py� __setattr__�Row.__setattr__P s � � � 2�3�3� c � � [ S5 e)Nzcan't delete attributer% )r' r( s r* � __delattr__�Row.__delattr__S s � � � 5�6�6r- c � � U $ )a� Return a 'tuple' form of this :class:`.Row`.34 35At runtime, this method returns "self"; the :class:`.Row` object is36already a named tuple. However, at the typing level, if this37:class:`.Row` is typed, the "tuple" return type will be a :pep:`484`38``Tuple`` datatype that contains typing information about individual39elements, supporting typed unpacking and attribute access.40 41.. versionadded:: 2.0.19 - The :meth:`.Row._tuple` method supersedes42 the previous :meth:`.Row.tuple` method, which is now underscored43 to avoid name conflicts with column names in the same way as other44 named-tuple methods on :class:`.Row`.45 46.. seealso::47 48 :attr:`.Row._t` - shorthand attribute notation49 50 :meth:`.Result.tuples`51 52 53r# �r' s r* �_tuple�54Row._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 �" � U R 5 $ )zEReturn a 'tuple' form of this :class:`.Row`.55 56.. versionadded:: 2.057 58)r3 r2 s r* �tuple� Row.tuplen s � � �{�{�}� r- c � � U $ )a? A synonym for :meth:`.Row._tuple`.59 60.. versionadded:: 2.0.19 - The :attr:`.Row._t` attribute supersedes61 the previous :attr:`.Row.t` attribute, which is now underscored62 to avoid name conflicts with column names in the same way as other63 named-tuple methods on :class:`.Row`.64 65.. seealso::66 67 :attr:`.Result.t`68r# r2 s r* �_t�Row._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 � � U R $ )z;A synonym for :meth:`.Row._tuple`.69 70.. versionadded:: 2.071 72)r9 r2 s r* �t�Row.t� s
� � �w�w�r- c �Z � [ U R SU R U R 5 $ )a% Return a :class:`.RowMapping` for this :class:`.Row`.73 74This object provides a consistent Python mapping (i.e. dictionary)75interface for the data contained within the row. The :class:`.Row`76by itself behaves like a named tuple.77 78.. seealso::79 80 :attr:`.Row._fields`81 82.. versionadded:: 1.483 84N)�85RowMapping�_parent�
_key_to_index�_datar2 s r* �_mapping� Row._mapping� s# � � �$�,�,��d�.@�.@�$�*�*�M�Mr- c �X � [ U R XR U R 5 $ �N)r! r@ rA rB )r' � processors r* �_filter_on_values�Row._filter_on_values� s! � � �4�<�<��,>�,>��86�87�K�Kr- c �* ^ � [ SU 4S jj5 nU$ )z3Handle ambiguous names such as "count" and "index" c �~ >^ � T R R T5 ( a T R T5 $ SUU 4S jjnU$ )Nc �L >� [ [ R T5 " T/U Q70 UD6$ rF )�getattr�collections_abcr )�arg�kwr( r' s ��r* �meth�4Row._special_name_accessor.<locals>.go.<locals>.meth� s0 �� � &��'?�'?�� F� � �#&� �*,� � r- )rO r rP r �returnr )r@ �_has_key� __getattr__)r' rQ r( s ` �r* �go�&Row._special_name_accessor.<locals>.go� s: �� ��<�<�(�(��.�.� �+�+�D�1�1�� �88 �Kr- )r' r! rS r )�property)r( rV s ` r* �_special_name_accessor�Row._special_name_accessor� s �� � �89
� �90
� �Ir- �count�indexc � � XR ; $ rF )rB �r' �keys r* � __contains__�Row.__contains__� s � ��j�j� � r- c � � [ U[ 5 ( a% U" U R 5 UR 5 5 $ U" U R 5 U5 $ rF )�91isinstancer! �_to_tuple_instance)r' �other�ops r* �_op�Row._op� sN � � �%��%�%�
�t�&�&�(�%�*B�*B�*D� E� 92� �D�+�+�-�u�5� 93r- c � � g rF r# �r' r\ s r* � __getitem__�Row.__getitem__� s � �25r- c � � g rF r# rj s r* rk rl � s � �>Ar- c � � g rF r# rj s r* rk rl � s � �r- c �B � U R U[ R 5 $ rF )rg �operator�lt�r' re s r* �__lt__�94Row.__lt__� � � ��x�x��x�{�{�+�+r- c �B � U R U[ R 5 $ rF )rg rp �lerr s r* �__le__�95Row.__le__� ru r- c �B � U R U[ R 5 $ rF )rg rp �gerr s r* �__ge__�96Row.__ge__� ru r- c �B � U R U[ R 5 $ rF )rg rp �gtrr s r* �__gt__�97Row.__gt__� ru r- c �B � U R U[ R 5 $ rF )rg rp �eqrr s r* �__eq__�98Row.__eq__� ru r- c �B � U R U[ R 5 $ rF )rg rp �nerr s r* �__ne__�99Row.__ne__� ru r- c �@ � [ [ R " U 5 5 $ rF )�repr�sql_util� _repr_rowr2 s r* �__repr__� Row.__repr__� s � ��H�&�&�t�,�-�-r- c �t � [ U R R Vs/ s H oc M UPM sn5 $ s snf )aa Return a tuple of string keys as represented by this100:class:`.Row`.101 102The keys can represent the labels of the columns returned by a core103statement or the names of the orm classes returned by an orm104execution.105 106This attribute is analogous to the Python named tuple ``._fields``107attribute.108 109.. versionadded:: 1.4110 111.. seealso::112 113 :attr:`.Row._mapping`114 115)r6 r@ �keys)r' �ks r* �_fields� Row._fields� s- � �& �� � �!2�!2�D�!2�A�a�!2�D�E�E��Ds �5�5c �, � [ U R 5 $ )a- Return a new dict which maps field names to their corresponding116values.117 118This method is analogous to the Python named tuple ``._asdict()``119method, and works by applying the ``dict()`` constructor to the120:attr:`.Row._mapping` attribute.121 122.. versionadded:: 1.4123 124.. seealso::125 126 :attr:`.Row._mapping`127 128)�dictrC r2 s r* �_asdict� Row._asdict s � � �D�M�M�"�"r- N)r( �strr) r rS r )r( r� rS r )rS r )rS r? )rG zOptional[_ProcessorsType]rS zRow[Any])r( r� rS r )r_ r rS �bool)re r rf zCallable[[Any, Any], bool]rS r� )r\ �intrS r )r\ �slicerS �
Sequence[Any])r\ zUnion[int, slice]rS r �re r rS r� �rS r� )rS zTuple[str, ...])rS zDict[str, Any])$�__name__�129__module__� __qualname__�__firstlineno__�__doc__� __slots__r+ r/ r3 r r6 rX r9 r< rC rH r rY r[ r\ r` rg r �__hash__r rk rs rx r| r� r� r� r� r� r� �__static_attributes__r# r- r* r! r! 2 sA � ��6 �I�4�7��0 �� C�� �� � � � � � ��� ?���� �� �N� �N� L�2�L� �L�130 � �$ '�w�/��&�w�/��!�131� � � �H�� �5� 132�5� �A� 133�A�C�,�,�,�,�,�,�.� �F� �F�(#r- r! c �| � \ rS rSr% SrS\S' S\S' SS jrSS jrSS jrSS134 jr SS jr135SS jr SS
jr Sr
g)�
ROMappingViewi r# r� �_items�Mapping['_KeyType', Any]rC c � � Xl X l g rF )rC r� )r' �mapping�itemss r* �__init__�ROMappingView.__init__% s � � �
�� r- c �, � [ U R 5 $ rF )�lenr� r2 s r* �__len__�ROMappingView.__len__+ s � ��4�;�;� � r- c �$ � SR U 5 $ )Nz&{0.__class__.__name__}({0._mapping!r}))�formatr2 s r* r� �ROMappingView.__repr__. s � �7�>�>�t�D�Dr- c �, � [ U R 5 $ rF )�iterr� r2 s r* �__iter__�ROMappingView.__iter__1 s � ��D�K�K� � r- c � � XR ; $ rF �r� )r' �items r* r` �ROMappingView.__contains__4 s � ��{�{�"�"r- c �0 � [ U5 [ U 5 :H $ rF ��listrr s r* r� �ROMappingView.__eq__7 � � ��E�{�d�4�j�(�(r- c �0 � [ U5 [ U 5 :g $ rF r� rr s r* r� �ROMappingView.__ne__: r� r- )r� rC N)r� r� r� r� �rS r� r� )rS z
Iterator[Any])r� r rS r� r� )r� r� r� r� r� �__annotations__r� r� r� r� r` r� r� r� r# r- r* r� r� sG � ��I� ��&�&� �/� �8E� � �E�!�#�)�)r- r� c � � \ rS rSrSrSrg)�ROMappingKeysValuesViewi> r� r# N�r� r� r� r� r� r� r# r- r* r� r� > s � � �Ir- r� r c � � \ rS rSrSrSrg)�ROMappingItemsViewiD r� r# Nr� r# r- r* r� r� D s � ��Ir- r� c � � \ rS rSrSrSr\( a SS jrO \R rSS jr136SS jr SS jr SS jr
SS jrSS137 jrSS jrSS jrSrg
)r? iH a� A ``Mapping`` that maps column names and objects to :class:`.Row`138values.139 140The :class:`.RowMapping` is available from a :class:`.Row` via the141:attr:`.Row._mapping` attribute, as well as from the iterable interface142provided by the :class:`.MappingResult` object returned by the143:meth:`_engine.Result.mappings` method.144 145:class:`.RowMapping` supplies Python mapping (i.e. dictionary) access to146the contents of the row. This includes support for testing of147containment of specific keys (string column names or objects), as well148as iteration of keys, values, and items::149 150 for row in result:151 if "a" in row._mapping:152 print("Column 'a': %s" % row._mapping["a"])153 154 print("Column b: %s" % row._mapping[table.c.b])155 156.. versionadded:: 1.4 The :class:`.RowMapping` object replaces the157 mapping-like access previously provided by a database result row,158 which now seeks to behave mostly like a named tuple.159 160r# c � � g rF r# r^ s r* rk �RowMapping.__getitem__f s � �Sr- c �, � [ U R 5 $ rF )r� rB r2 s r* � _values_impl�RowMapping._values_implk s � ��D�J�J� � r- c �< � S U R R 5 $ )Nc 3 �. # � U H oc M Uv � M
g 7frF r# )�.0r� s r* � <genexpr>�&RowMapping.__iter__.<locals>.<genexpr>o s � � �>�,�a���,�s �� �r@ r� r2 s r* r� �RowMapping.__iter__n s � �>�4�<�<�,�,�>�>r- c �, � [ U R 5 $ rF )r� rB r2 s r* r� �RowMapping.__len__q s � ��4�:�:�� r- c �8 � U R R U5 $ rF )r@ rT r^ s r* r` �RowMapping.__contains__t s � ��|�|�$�$�S�)�)r- c �* � [ [ U 5 5 $ rF )r� r� r2 s r* r� �RowMapping.__repr__w s � ��D��J� � r- c �f � [ X R 5 Vs/ s H oX 4PM161 sn5 $ s snf )zUReturn a view of key/value tuples for the elements in the162underlying :class:`.Row`.163 164)r� r� r^ s r* r� �RowMapping.itemsz s1 � �165 "� �y�y�{�;�{����#�{�;�166� 167��;s �.168c �. � U R R $ )z^Return a view of 'keys' for string column names represented169by the underlying :class:`.Row`.170 171r� r2 s r* r� �RowMapping.keys� s � � �|�|� � � r- c �4 � [ X R 5 5 $ )zUReturn a view of values for the values represented in the172underlying :class:`.Row`.173 174)r� r� r2 s r* �values�RowMapping.values� s � �175 '�t�->�->�-@�A�Ar- N)r_ r rS r )rS z List[Any])rS z
Iterator[str]r� )r_ �objectrS r� r� )rS r� )rS r )rS r� )r� r� r� r� r� r� r rk r �_get_by_key_impl_mappingr� r� r� r` r� r� r� r� r� r# r- r* r? r? H sJ � ��2 �I��8� �6�6� � �?� �*� �176�!�Br- r? )1r� �177__future__r �abcr �collections.abcrN rp �typingr r r r r r178 r r r
r r r r r r �sqlr r� r � util._has_cyr �_py_rowr �"sqlalchemy.cyextension.resultproxy�resultr r r r r r! � BaseRowProxy�RowProxyr� �KeysView�179ValuesViewr� � ItemsViewr� r? 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-