+hyIdZddlZddlmZddlmZddlmZdZ ddl m Z dZ dZ d Z dZ d Z dd l mZd ZGddeej(ZGddeZeZeZGddej2ej4ej6ZGddeej:Zy#e $rdZ YwxYw#e $rd ZGddeZYwxYw)z.Define row constructs including :class:`.Row`.N)util)collections_abcsafe_rowproxy_reconstructorct||SNr)clsstates H/var/www/html/venv/lib/python3.12/site-packages/sqlalchemy/engine/row.pyrowproxy_reconstructorr s*366cJ|j|}|j||Sr )__new__ __setstate__)r r objs r r r $s#kk#  r)BaseRowTFcVeZdZdZdZdZdZdZdZdZ dZ d Z d Z e Z d Zd Zy )r)_parent_data_keymap _key_stylec ntj|d||rHtj|dtt||Dcgc]\}}|r||n|c}}n tj|dt|tj|d|tj|d|ycc}}w)z4Row objects are constructed by CursorResult objects.rrrrN)object __setattr__tuplezip)selfparent processorskeymap key_styledataprocvalues r __init__zBaseRow.__init__Bs   tY 7""03:t/D +e,0DKU: ""4%+>   tY 7   t\9 =sB1cFt|j|jffSr )r __class__ __getstate__r s r __reduce__zBaseRow.__reduce__Ys$&!2!2!45 rcpt|j||j|j|jSr )Rowrrrr)r filterss r _filter_on_valueszBaseRow._filter_on_values_s.    rct|Sr listr,s r _values_implzBaseRow._values_implhs : rc,t|jSr )iterrr,s r __iter__zBaseRow.__iter__k # #rc,t|jSr lenrr,s r __len__zBaseRow.__len__nstzz? "rc,t|jSr )hashrr,s r __hash__zBaseRow.__hash__qr9rc |j|Sr rr keys r _get_by_int_implzBaseRow._get_by_int_implts::c? "rct|jjvr|j|S|jt k(r|j j| |j|}|t}||j j!|n3|jt"k(r ||k7r|j j%||j|S#t$rS}t|trt|j|cYd}~S|j j||}Yd}~d}~wt$r,t|trt|j|cYSwxYwr )intr*__mro__rrKEY_INTEGER_ONLYr_raise_for_nonintrKeyError isinstanceslicer _key_fallback TypeErrorMD_INDEX _raise_for_ambiguous_column_nameKEY_OBJECTS_BUT_WARN_warn_for_nonintr rDreckemdindexs r _get_by_key_implzBaseRow._get_by_key_implwscmm+++zz#&"22 ..s3 ll3'(mG ==cB$88W^ --c2::g& &% >c5) C11,,44S"=C c5) C11  s*C E"'D*E" D**4E" E"cf |j|}|t}||jj |n:|j tk(r't|jjvr t||j|S#t$r&}|jj||}Yd}~d}~wwxYwr ) rrKrrNrPrQrKEY_OBJECTS_ONLYrGr*rHrrTs r _get_by_key_impl_mappingz BaseRow._get_by_key_impl_mappings :ll3'(mG ==cB#333==000sm#::g& & :ll00b9 :sB B0 B++B0c |j|S#t$r7}tjt |j d|Yd}~yd}~wwxYw)Nr)replace_context)r[rKrraise_AttributeErrorargs)r namees r __getattr__zBaseRow.__getattr__sI J44T:: J N166!95qII Js A-AAN)__name__ __module__ __qualname__ __slots__r(r-r1r5r8r=r@rErX __getitem__r[rcrr rr?sGA  >.     $ # $ # 'J'  '" JrrceZdZdZdZeZdZdZe dZ dZ e dZ e dZ d Zd Zd Zd Zej&Zd ZdZdZdZdZdZdZej8dddZe dZdZdZ e dZ!y)r/aRepresent 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. :class:`.LegacyRow` - Compatibility interface introduced in SQLAlchemy 1.4. .. 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, but will remain available in SQLAlchemy 1.x series via the :class:`.LegacyRow` class that is used by :class:`_engine.LegacyCursorResult`. See :ref:`change_4710_core` for background on this change. rictd)Nzcan't set attributer_)r rar's r rzRow.__setattr__s233rctd)Nzcan't delete attributerl)r ras r __delattr__zRow.__delattr__s566rcxt|jd|jtj|jS)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, however in the 1.4 series of SQLAlchemy, the :class:`.LegacyRow` class is still used by Core which continues to have mapping-like behaviors against the row object itself. .. seealso:: :attr:`.Row._fields` .. versionadded:: 1.4 N) RowMappingrr_default_key_stylerr,s r _mappingz Row._mappings2$ LL  LL  ) ) JJ   rc$tfd}|S)z3Handle ambiguous names such as "count" and "index" cnjjrjSfd}|S)NcLttjg|i|Sr )getattrrSequence)argkwrar s r methz4Row._special_name_accessor..go..meths2B7?#;#;TB"&(r)r_has_keyrc)r rzras` r goz&Row._special_name_accessor..gos2||$$T*''--  r)property)rar|s` r _special_name_accessorzRow._special_name_accessors     rcountindexc||jvSr rBrCs r __contains__zRow.__contains__sdjj  rcJ|j|j|jdS)Nrrrrr,s r r+zRow.__getstate__s!||ZZ//  rc|d}tj|d|tj|d|dtj|d|jtj|d|dy)Nrrrr)rrr)r r r!s r rzRow.__setstate__say!4F34%.94FNN;4u\/BCrc|t|tr|t|t|S|t||Sr )rLr/r)r otherops r _opzRow._op#s<%% uT{E%L ) E$K' rcB|j|tjSr )roperatorltr rs r __lt__z Row.__lt__,xxx{{++rcB|j|tjSr )rrlers r __le__z Row.__le__/rrcB|j|tjSr )rrgers r __ge__z Row.__ge__2rrcB|j|tjSr )rrgtrs r __gt__z Row.__gt__5rrcB|j|tjSr )rreqrs r __eq__z Row.__eq__8rrcB|j|tjSr )rrners r __ne__z Row.__ne__;rrc>ttj|Sr )reprsql_util _repr_rowr,s r __repr__z Row.__repr__>sH&&t,--rz:meth:`.Row.keys`zqUse the namedtuple standard accessor :attr:`.Row._fields`, or for full mapping behavior use row._mapping.keys() ) alternativec.|jjS)aReturn the list of keys as strings 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 method is analogous to the Python dictionary ``.keys()`` method, except that it returns a list, not an iterator. .. seealso:: :attr:`.Row._fields` :attr:`.Row._mapping` rkeysr,s r rzRow.keysAs0||   rclt|jjDcgc]}|| c}Scc}w)aReturn 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` )rrr)r ks r _fieldsz Row._fields[s+&!2!2DAamaDEEDs11c,t|jS)amReturn 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` )dictrrr,s r _asdictz Row._asdictpsDMM""rctr NotImplementedErrorr,s r _replacez Row._replaces !##rctr rr,s r _field_defaultszRow._field_defaultss !##rN)"rdrerf__doc__rgrRrqrrnr}rrr~rrrr+rrrr@rrrrrrrr deprecated_20rrrrrrirr r/r/sBI.47  2$ #7 +E "7 +E! D H,,,,,,.T !  !(FF(#"$$$rr/c6eZdZdZdZej reZne ZdZ ejdddZ ejdddZ ejdd d Zejdd d Zejdd dZy) LegacyRowaA subclass of :class:`.Row` that delivers 1.x SQLAlchemy behaviors for Core. The :class:`.LegacyRow` class is where most of the Python mapping (i.e. dictionary-like) behaviors are implemented for the row object. The mapping behavior of :class:`.Row` going forward is accessible via the :class:`.Row._mapping` attribute. .. versionadded:: 1.4 - added :class:`.LegacyRow` which encapsulates most of the deprecated behaviors of :class:`.Row`. ric:|jj||Sr )r _containsrCs r rzLegacyRow.__contains__s||%%c400rz1.4zThe :meth:`.LegacyRow.has_key` method is deprecated and will be removed in a future release. To test for key membership, use the :attr:`Row._mapping` attribute, i.e. 'key in row._mapping`.c8|jj|S)aReturn True if this :class:`.LegacyRow` contains the given key. Through the SQLAlchemy 1.x series, the ``__contains__()`` method of :class:`.Row` (or :class:`.LegacyRow` as of SQLAlchemy 1.4) also links to :meth:`.Row.has_key`, in that an expression such as :: "some_col" in row Will return True if the row contains a column named ``"some_col"``, in the way that a Python mapping works. However, it is planned that the 2.0 series of SQLAlchemy will reverse this behavior so that ``__contains__()`` will refer to a value being present in the row, in the way that a Python tuple works. .. seealso:: :ref:`change_4710_core` rr{rCs r has_keyzLegacyRow.has_keys8||$$S))rzThe :meth:`.LegacyRow.items` method is deprecated and will be removed in a future release. Use the :attr:`Row._mapping` attribute, i.e., 'row._mapping.items()'.cR|jDcgc] }|||f c}Scc}w)zReturn a list of tuples, each tuple containing a key/value pair. This method is analogous to the Python dictionary ``.items()`` method, except that it returns a list, not an iterator. )rrCs r itemszLegacyRow.itemss'-1IIK8Sd3i 888s$zThe :meth:`.LegacyRow.iterkeys` method is deprecated and will be removed in a future release. Use the :attr:`Row._mapping` attribute, i.e., 'row._mapping.keys()'.c@t|jjS)zReturn a an iterator against the :meth:`.Row.keys` method. This method is analogous to the Python-2-only dictionary ``.iterkeys()`` method. )r7rrr,s r iterkeyszLegacyRow.iterkeyssDLL%%&&rzThe :meth:`.LegacyRow.itervalues` method is deprecated and will be removed in a future release. Use the :attr:`Row._mapping` attribute, i.e., 'row._mapping.values()'.ct|S)zReturn a an iterator against the :meth:`.Row.values` method. This method is analogous to the Python-2-only dictionary ``.itervalues()`` method. )r7r,s r itervalueszLegacyRow.itervaluessDzrzThe :meth:`.LegacyRow.values` method is deprecated and will be removed in a future release. Use the :attr:`Row._mapping` attribute, i.e., 'row._mapping.values()'.c"|jS)zReturn the values represented by this :class:`.Row` as a list. This method is analogous to the Python dictionary ``.values()`` method, except that it returns a list, not an iterator. )r5r,s r valueszLegacyRow.valuess  ""rN)rdrerfrrgrSQLALCHEMY_WARN_20rRrqKEY_OBJECTS_NO_WARNr deprecatedrrrrrrirr rrs I 101T__  J *  *0T__  3 9  9T__  2 '  'T__  4   T__  4 #  #rrc:eZdZdZdZdZdZdZdZdZ dZ y ) ROMappingViewrr_itemsc ||_||_yr r)r mappingrs r r(zROMappingView.__init__s  rc,t|jSr )r<rr,s r r=zROMappingView.__len__s4;;rc$dj|S)Nz&{0.__class__.__name__}({0._mapping!r}))formatr,s r rzROMappingView.__repr__s7>>tDDrc,t|jSr )r7rr,s r r8zROMappingView.__iter__sDKK  rc||jvSr )r)r items r rzROMappingView.__contains__ st{{""rc0t|t|k(Sr r3rs r rzROMappingView.__eq__#E{d4j((rc0t|t|k7Sr r3rs r rzROMappingView.__ne__&rrN) rdrerfrgr(r=rr8rrrrirr rr s- I  E!#))rrcdeZdZdZdZeZesejZ dZ dZ dZ dZdZdZd Zd Zy ) rpaA ``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. ric,t|jSr )r4rr,s r r5zRowMapping._values_implMr9rc<d|jjDS)Nc3&K|] }|| ywr ri).0rs r z&RowMapping.__iter__..Qs>a >srr,s r r8zRowMapping.__iter__Ps>4<<,,>>rc,t|jSr r;r,s r r=zRowMapping.__len__Ss4::rc8|jj|Sr rrCs r rzRowMapping.__contains__Vs||$$S))rc*tt|Sr )rrr,s r rzRowMapping.__repr__YsDJrc ft||jDcgc] }|||f c}Scc}w)zeReturn a view of key/value tuples for the elements in the underlying :class:`.Row`. )rrrCs r rzRowMapping.items\s. T #LS$s)$4#LMM#Ls. c.|jjS)znReturn a view of 'keys' for string column names represented by the underlying :class:`.Row`. rr,s r rzRowMapping.keyscs ||   rc6t||jS)zeReturn a view of values for the values represented in the underlying :class:`.Row`. )rr5r,s r rzRowMapping.valuesks T4#4#4#677rN)rdrerfrrgrZrq_baserow_usecextrr[rhr5r8r=rrrrrrirr rprp*sK4I) 66  $?* N!8rrp)rrrsqlr util.compatrrPsqlalchemy.cresultproxyrr ImportErrorrIrZrRrrrrrwr/r BaseRowProxyRowProxyKeysView ValuesView ItemsViewrMappingrprirr rs5") D 7HN2{J/vP$'?++P$fy#y#x ))BF8/11F8Q4wJtJ&tJwJs" B!B/!B,+B,/CC