JezK
Edit File: row.pyc
� 1��fc @ sg d Z d d l Z d d l m Z d d l m Z d d l m Z d Z y d d l m Z d � Z Wn e k r� d � Z n Xd Z d Z d Z d Z y d d l m Z e Z Wn- e k r� e Z d e f d � � YZ n Xd e e j f d � � YZ d e f d � � YZ e Z e Z d e j e j e j f d � � YZ d e e j f d � � YZ d S( s. Define row constructs including :class:`.Row`.i����Ni ( t util( t collections_abci ( t safe_rowproxy_reconstructorc C s t | | � S( N( R ( t clst state( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyt rowproxy_reconstructor s c C s | j | � } | j | � | S( N( t __new__t __setstate__( R R t obj( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyR $ s i i ( t BaseRowR c B sw e Z d Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z e Z d � Z d � Z RS( t _parentt _datat _keymapt _key_stylec C s� t j | d | � | ri t j | d t g t | | � D]$ \ } } | rV | | � n | ^ q8 � � n t j | d t | � � t j | d | � t j | d | � d S( s4 Row objects are constructed by CursorResult objects.R R R R N( t objectt __setattr__t tuplet zip( t selft parentt processorst keymapt key_stylet datat proct value( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyt __init__B s >c C s t | j | j � f f S( N( R t __class__t __getstate__( R ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyt __reduce__Y s c C s" t | j | | j | j | j � S( N( t RowR R R R ( R t filters( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyt _filter_on_values_ s c C s t | � S( N( t list( R ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyt _values_implh s c C s t | j � S( N( t iterR ( R ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyt __iter__k s c C s t | j � S( N( t lenR ( R ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyt __len__n s c C s t | j � S( N( t hashR ( R ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyt __hash__q s c C s | j | S( N( R ( R t key( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyt _get_by_int_implt s c C s0 t | j j k r | j | S| j t k r? | j j | � n y | j | } Wn{ t k r� } t | t � r� t | j | � S| j j | | � } n4 t k r� t | t � r� t | j | � S� n X| t } | d k r� | j j | � n. | j t k r%| | k r%| j j | � n | j | S( N( t intR t __mro__R R t KEY_INTEGER_ONLYR t _raise_for_nonintR t KeyErrort isinstancet sliceR t _key_fallbackt TypeErrort MD_INDEXt Nonet _raise_for_ambiguous_column_namet KEY_OBJECTS_BUT_WARNt _warn_for_nonint( R R) t rect ket mdindex( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyt _get_by_key_implw s( c C s� y | j | } Wn( t k r; } | j j | | � } n X| t } | d k re | j j | � n0 | j t k r� t | j j k r� t | � � n | j | S( N( R R/ R R2 R4 R5 R6 R t KEY_OBJECTS_ONLYR+ R R, R ( R R) R9 R: R; ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyt _get_by_key_impl_mapping� s c C sK y | j | � SWn3 t k rF } t j t | j d � d | �n Xd S( Ni t replace_context( R> R/ R t raise_t AttributeErrort args( R t namet e( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyt __getattr__� s ( R R R R ( t __name__t __module__t __slots__R R R R" R$ R& R( R* R< t __getitem__R> RE ( ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyR ? s % R c B s e Z d Z d Z e Z d � Z d � Z e d � � Z d � Z e d � Z e d � Z d � Z d � Z d � Z d � Z e j Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z e j d d d �d � � Z e d � � Z d � Z d � Z e d � � Z RS( s 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. :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. c C s t d � � d S( Ns can't set attribute( RA ( R RC R ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyR � s c C s t d � � d S( Ns can't delete attribute( RA ( R RC ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyt __delattr__� s c C s" t | j d | j t j | j � S( s 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( t RowMappingR R5 R t _default_key_styleR ( R ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyt _mapping� s c s t � f d � � } | S( s3 Handle ambiguous names such as "count" and "index" c s9 � j j � � r � j � � S� � f d � } | Sd S( Nc s t t j � � � | | � S( N( t getattrR t Sequence( t argt kw( RC R ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyt meth s ( R t _has_keyRE ( R RR ( RC ( R sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyt go s ( t property( RC RT ( ( RC sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyt _special_name_accessor� s t countt indexc C s | | j k S( N( R ( R R) ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyt __contains__ s c C s" i | j d 6| j d 6| j d 6S( NR R R ( R R R ( R ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyR s c C se | d } t j | d | � t j | d | d � t j | d | j � t j | d | d � d S( NR R R R ( R R R ( R R R ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyR s c C s; t | t � r( | t | � t | � � S| t | � | � S( N( R0 R R ( R t othert op( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyt _op# s (c C s | j | t j � S( N( R\ t operatort lt( R RZ ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyt __lt__, s c C s | j | t j � S( N( R\ R] t le( R RZ ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyt __le__/ s c C s | j | t j � S( N( R\ R] t ge( R RZ ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyt __ge__2 s c C s | j | t j � S( N( R\ R] t gt( R RZ ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyt __gt__5 s c C s | j | t j � S( N( R\ R] t eq( R RZ ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyt __eq__8 s c C s | j | t j � S( N( R\ R] t ne( R RZ ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyt __ne__; s c C s t t j | � � S( N( t reprt sql_utilt _repr_row( R ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyt __repr__> s s :meth:`.Row.keys`t alternativesq Use the namedtuple standard accessor :attr:`.Row._fields`, or for full mapping behavior use row._mapping.keys() c C s | j j S( s� Return 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` ( R t keys( R ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyRo A s c C s/ t g | j j D] } | d k r | ^ q � S( s� 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` N( R R Ro R5 ( R t k( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyt _fields[ s c C s t | j � S( sm 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` ( t dictRM ( R ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyt _asdictp s c C s t � � d S( N( t NotImplementedError( R ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyt _replace� s c C s t � � d S( N( Rt ( R ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyt _field_defaults� s ( (! RF RG t __doc__RH R7 RL R RJ RU RM RV RW RX RY R R R\ R R( R_ Ra Rc Re Rg Ri Rm R t deprecated_20Ro Rq Rs Ru Rv ( ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyR � s8 t LegacyRowc B s� e Z d Z d Z e j r$ e Z n e Z d � Z e j d d � d � � Z e j d d � d � � Z e j d d � d � � Z e j d d � d � � Z e j d d � d � � Z RS( s� A 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`. c C s | j j | | � S( N( R t _contains( R R) ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyRY � s s 1.4s� The :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`.c C s | j j | � S( s� Return 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` ( R RS ( R R) ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyt has_key� s s� The :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()'.c C s' g | j � D] } | | | f ^ q S( s� Return 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. ( Ro ( R R) ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyt items� s s� The :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 C s t | j j � S( s� Return a an iterator against the :meth:`.Row.keys` method. This method is analogous to the Python-2-only dictionary ``.iterkeys()`` method. ( R# R Ro ( R ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyt iterkeys� s s� The :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()'.c C s t | � S( s� Return a an iterator against the :meth:`.Row.values` method. This method is analogous to the Python-2-only dictionary ``.itervalues()`` method. ( R# ( R ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyt itervalues� s s� The :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 C s | j � S( s� Return 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. ( R" ( R ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyt values� s ( ( RF RG Rw RH R t SQLALCHEMY_WARN_20R7 RL t KEY_OBJECTS_NO_WARNRY t deprecatedR{ R| R} R~ R ( ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyRy � s* t ROMappingViewc B sM e Z d Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z RS( RM t _itemsc C s | | _ | | _ d S( N( RM R� ( R t mappingR| ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyR s c C s t | j � S( N( R% R� ( R ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyR& s c C s d j | � S( Ns& {0.__class__.__name__}({0._mapping!r})( t format( R ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyRm s c C s t | j � S( N( R# R� ( R ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyR$ s c C s | | j k S( N( R� ( R t item( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyRY s c C s t | � t | � k S( N( R! ( R RZ ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyRg # s c C s t | � t | � k S( N( R! ( R RZ ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyRi & s ( RM R� ( RF RG RH R R& Rm R$ RY Rg Ri ( ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyR� s RK c B st e Z d Z d Z e Z e s3 e j Z d � Z n d � Z d � Z d � Z d � Z d � Z d � Z d � Z RS( s� 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. c C s t | j � S( N( R! R ( R ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyR" M s c C s d � | j j D� S( Nc s s! | ] } | d k r | Vq d S( N( R5 ( t .0Rp ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pys <genexpr>Q s ( R Ro ( R ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyR$ P s c C s t | j � S( N( R% R ( R ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyR& S s c C s | j j | � S( N( R RS ( R R) ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyRY V s c C s t t | � � S( N( Rj Rr ( R ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyRm Y s c C s0 t | g | j � D] } | | | f ^ q � S( se Return a view of key/value tuples for the elements in the underlying :class:`.Row`. ( R� Ro ( R R) ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyR| \ s c C s | j j S( sn Return a view of 'keys' for string column names represented by the underlying :class:`.Row`. ( R Ro ( R ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyRo c s c C s t | | j � � S( se Return a view of values for the values represented in the underlying :class:`.Row`. ( R� R" ( R ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyR k s ( ( RF RG Rw RH R= RL t _baserow_usecextR R> RI R" R$ R& RY Rm R| Ro R ( ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyRK * s (! Rw R] t R t sqlRk t util.compatR R4 t sqlalchemy.cresultproxyR R t ImportErrorR- R= R7 R� R t TrueR� t FalseR RO R Ry t BaseRowProxyt RowProxyt KeysViewt ValuesViewt ItemsViewR� t MappingRK ( ( ( sH /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/row.pyt <module> s: w �|