File: //opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyc
�
���ec @ s
d Z d d l Z d d l Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d
l
m Z d d l
m Z d d l
m Z d d
l
m Z d d l
m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z e j d � Z d Z d Z d Z d Z d Z d Z d Z d e f d � � YZ! d e! f d � � YZ" d e# f d � � YZ$ d e$ f d � � YZ% d! e% f d" � � YZ& e& � Z' d# e% f d$ � � YZ( e( � Z) d% e$ f d& � � YZ* e* � Z+ d' e* f d( � � YZ, d) e* f d* � � YZ- d+ e f d, � � YZ. d- e. f d. � � YZ/ e. � Z0 e/ � Z1 d/ e# f d0 � � YZ2 d1 e2 e f d2 � � YZ3 d3 e3 f d4 � � YZ4 e4 Z5 d5 e5 f d6 � � YZ6 d7 e5 f d8 � � YZ7 d9 e f d: � � YZ8 d; e5 f d< � � YZ9 d S(= sj Define cursor-specific result set constructs including
:class:`.BaseCursorResult`, :class:`.CursorResult`.i����Ni ( t Result( t ResultMetaData( t SimpleResultMetaData( t tuplegetter( t LegacyRowi ( t exc( t util( t
expression( t sqltypes( t _generative( t RM_NAME( t
RM_OBJECTS( t RM_RENDERED_NAME( t RM_TYPEt unpickledi i i i i t CursorResultMetaDatac B s� e Z d Z d Z e Z d � Z d
� Z d � Z d � Z d
� Z
d � Z d � Z d � Z
d � Z e e e d � � Z d � Z e d � Z d � Z e d � Z d � Z d � Z d � Z d � Z RS( s" Result metadata for DBAPI cursors.t _keymapt case_sensitivet _processorst _keyst _keymap_by_result_column_idxt _tuplefiltert _translated_indexest _safe_for_cachec C s
| | j k S( N( R ( t selft key( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyt _has_key? s c C s4 t | j d g | j D] } | j | t ^ q �S( Nt extra( R R R t
MD_OBJECTS( R R ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyt _for_freezeB s c C s9 t | j | � � } g | D] } | t ^ q } g | D] } | t ^ q9 } | j r{ g | D] } | j | ^ q_ } n t | � } | j j | j � } | j | _ | j | _ | | _
| | _ | | _ g t | j | � � D] \ } } | f | d ^ q� }
d � |
D� | _
| j
j d � |
D� � | S( Ni c S s i | ] } | | t � q S( ( t
MD_LOOKUP_KEY( t .0t rec( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pys
<dictcomp>^ s c S s0 i | ]& } | t p d D] } | | � q q S( ( ( R ( R t new_rect e( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pys
<dictcomp>e s ( t listt _metadata_for_keyst MD_INDEXR R R t __class__t __new__R R R R t enumerateR t update( R t keyst recsR t indexest new_keyst idxt tupt new_metadatat indext new_recs( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyt _reduceH s& # 6 c C s | j j s | S| j j } | j } | | k r5 | S| j j | j � } t | j � | _ | j } xL t | j
� D]; \ } } y | | } Wn t k
r� qu X| | j | <qu W| j | _ | j
| _
| j s� t � d | _ d | _ | j | _ | j | _ | j | _ | S( s[ When using a cached Compiled construct that has a _result_map,
for a new statement that used the cached Compiled, we need to ensure
the keymap has the Column objects from our new statement as keys.
So here we rewrite keymap with new entries for the new columns
as matched to those of the cached statement.
N( t compiledt _result_columnst statementt invoked_statementR& R' t dictR R R( t _all_selected_columnst KeyErrorR R R t AssertionErrort NoneR R R ( R t contextt compiled_statementR7 t mdt keymap_by_positionR. t newR ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyt _adapt_to_contextm s0
c C s� | j } | j } d | _ d | _ | j | _ t | _ | j ri | j \ } } } } } t | � }
n t } } }
} } } | j
| | | |
| | | | � } i | _ g | D] } | t ^ q� | _
| j r� d � | D� | _ n t g | D] } | t | f ^ q� � }
|
r�t |
� |
k r=i } t � } x� | D]� } x� | t f | t pfd D]c } | j r�t | t j � r�| j � } n | t } | j | | � | k rh| j | � qhqhWqFW| j j g | D]9 } | t r�| t D] } | | k r�| | f ^ q�q�� |
j d � | D� � q�| j j g | D]- } | t rM| t D] } | | f ^ qeqM� n | j j |
� |
r�| j r�| j j g | D]+ } | t r�| t | j | t f ^ q�� n d S( Nc S s i | ] } | | t � q S( ( t MD_RESULT_MAP_INDEX( R t metadata_entry( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pys
<dictcomp>� s c S s% i | ] } d d d | f | � q S( N( ( R< ( R R ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pys
<dictcomp>
s ( ( R= t dialectR< R R R t FalseR t result_column_structt lent _merge_cursor_descriptionR t MD_PROCESSORR R4 R R8 R t sett MD_RENDERED_NAMER t
isinstanceR t string_typest lowerR% t
setdefaultt addR) t _translate_colnamet MD_UNTRANSLATED( R t parentt cursor_descriptionR= RE t result_columnst cols_are_orderedt textual_orderedt ad_hoc_textualt loose_column_name_matchingt num_ctx_colst rawRD t by_keyt index_by_keyt dupesR R. t obj_elem( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyt __init__� st #
"
'
c C s� | j j } | r� | r� | r� | t | � k r� g | D] }
|
d ^ q8 | _ t | _ g t | � D]h \ } } | | | t | s� | t j � n | t | t
| j | t | t
| | d � d f ^ qg S| s� | rt | � | k rt | _ | j | | | � }
nE | r<t | _ | j | | | | � }
n t | _ | j | | � }
g |
D]E \ } } } } } } } | | | | | | j | | | � | f ^ q^Sd S( s" Merge a cursor.description with compiled result column information.
There are at least four separate strategies used here, selected
depending on the type of SQL construct used to start with.
The most common case is that of the compiled SQL expression construct,
which generated the column names present in the raw SQL string and
which has the identical number of columns as were reported by
cursor.description. In this case, we assume a 1-1 positional mapping
between the entries in cursor.description and the compiled object.
This is also the most performant case as we disregard extracting /
decoding the column names present in cursor.description since we
already have the desired name we generated in the compiled SQL
construct.
The next common case is that of the completely raw string SQL,
such as passed to connection.execute(). In this case we have no
compiled construct to work with, so we extract and decode the
names from cursor.description and index those as the primary
result row target keys.
The remaining fairly common case is that of the textual SQL
that includes at least partial column information; this is when
we use a :class:`_expression.TextualSelect` construct.
This construct may have
unordered or ordered column information. In the ordered case, we
merge the cursor.description and the compiled construct's information
positionally, and warn if there are additional description names
present, however we still decode the names in cursor.description
as we don't have a guarantee that the names in the columns match
on these. In the unordered case, we match names in cursor.description
to that of the compiled construct based on name matching.
In both of these cases, the cursor.description names and the column
expression objects and names are indexed as result row target keys.
The final case is much less common, where we have a compiled
non-textual SQL expression construct, but the number of columns
in cursor.description doesn't match what's in the compiled
construct. We make the guess here that there might be textual
column expressions in the compiled construct that themselves include
a comma in them causing them to split. We do the same name-matching
as with textual non-ordered columns.
The name-matched system of merging is the same as that used by
SQLAlchemy for all cases up through te 0.9 series. Positional
matching for compiled SQL expressions was introduced in 1.0 as a
major performance feature, and positional matching for textual
:class:`_expression.TextualSelect` objects in 1.1.
As name matching is no longer
a common case, it was acceptable to factor it into smaller generator-
oriented methods that are easier to understand, but incur slightly
more performance overhead.
i i N( RE R RH R t TrueR R( R R
RO R t get_result_processorR
R< t _merge_textual_cols_by_positionRF t _merge_cols_by_namet _merge_cols_by_none( R R= RU RV R[ RW RX RY RZ R t elemR. t
rmap_entryt raw_iteratort ridxt cursor_colnamet mapped_typet coltypet objt untranslated( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyRI ) s4 B v c
c s
| j } | j } | j } | j r- | j n d } | j rE | j n d } d } g | _ x� t | � D]� \ } }
|
d } |
d } | r� | | � } n | r� | | � \ } } n | r� | | � } n | j j
| � | s� | j � } n | | | | f Vqg Wd S( s� Extract column names and data types from a cursor.description.
Applies unicode decoding, column translation, "normalization",
and case sensitivity rules to the names based on the dialect.
i i N( RE R RR t description_encodingt _description_decoderR< t requires_name_normalizet normalize_nameR R( t appendRO (
R R= RU RE R t translate_colnamet description_decoderRs Ro R. R t colnameRm ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyt _colnames_from_description� s*
c c s | r t | � n d } | t | � k rJ t j d | t | � f � n t � } x� | j | | � D]� \ } } } } | | k r� | | }
|
t } | } |
t }
| d | k r� t j d | d � � n | j
| d � n t j }
d } d } | | | |
| | | f Vqf Wd S( NsV Number of columns in textual SQL (%d) is smaller than number of columns requested (%d)i s8 Duplicate column expression requested in textual SQL: %r(
RH R< R t warnRK Rx R R
R t InvalidRequestErrorRQ R t NULLTYPE( R R= RU RV R[ t seenR. Rw Ro Rm t ctx_recRn Rj Rl ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyRd � s, "
c c s� | j } | j } | j | | | � } x� | j | | � D]� \ } } }
} y | | } Wn& t k
r� t j }
d } d } n X| d } | d }
| d } | | | |
| | |
f Vq: Wd S( Ni i i ( RE R t _create_description_match_mapRx R: R R{ R< ( R R= RU RV RZ RE R t match_mapR. Rw Ro Rm R} Rl Rn t result_columns_idx( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyRe s, "
c
C s� i } x� t | � D]� \ } } | t } | s> | j � } n | | k r� | | \ } } }
} | | | t |
| f | | <n" | t | t | t | f | | <| r x= | t D]. } | j | | t | t | t | f � q� Wq q W| S( s� when matching cursor.description to a set of names that are present
in a Compiled object, as is the case with TextualSelect, get all the
names we expect might match those in cursor.description.
( R( R RO R R
R
RP (
t clsRV R RZ t dRj Rg R t e_namet e_objt e_typet e_ridxt r_key( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR~ 7 s
!"*c c sJ xC | j | | � D]/ \ } } } } | d | t j | d | f Vq Wd S( N( Rx R< R R{ ( R R= RU R. Rw Ro Rm ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyRf a s "c C s: | r2 t j t j d t j | � � d | �n d Sd S( Ns. Could not locate column in row for column '%s't replace_context( R t raise_R t NoSuchColumnErrort string_or_unprintableR< ( R R t errt raiseerr( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyt
_key_fallbackr s
c C s t j d | t � � d S( Ns< Ambiguous column name '%s' in result set column descriptions( R Rz R ( R R ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyt _raise_for_ambiguous_column_name~ s c C s� t | t � r | j | } n y | j | } Wn8 t k
rj } | j | | | � } | d k rk d Sn X| d } | d k r� | j | � n | S( Ni ( RM t intR R R: R� R< R� ( R R R� R t keR1 ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyt _index_for_key� s
c C sZ y& g | D] } | j | d ^ q
SWn- t k
rU } t j | | j d | � n Xd S( Ni ( R R: R R� t args( R R* R R� ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyt _indexes_for_keys� s &c c s� x� | D]� } t | j j k r/ | j | } n y | j | } Wn- t k
ro } t j | | j d | � n X| d } | d k r� | j
| � n | Vq Wd S( Ni ( R� R& t __mro__R R R: R R� R� R< R� ( R R* R R R� R1 ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR$ � s
c C sF i d � | j j � D� d 6| j d 6| j d 6| j d 6| j d 6S( Nc S sL i | ]B \ } } t | t j t j � r | t | t t | f | � q S( ( RM R RN t int_typesR% RC t
_UNPICKLED( R R R ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pys
<dictcomp>� s R R R R R ( R t itemsR R R R ( R ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyt __getstate__� s
c C s� g t t | d � � D] } d ^ q | _ | d | _ d � | j j � D� | _ | d | _ | d | _ | d r� | d | _ t
| j � | _ n d | _ | _ d S( NR R c S s i | ] } | | t � q S( ( RC ( R R ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pys
<dictcomp>� s R R ( t rangeRH R< R R t valuesR R R R R R ( R t statet _( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyt __setstate__� s ,
( R R R R R R R R ( t __name__t
__module__t __doc__t __slots__Rb t returns_rowsR R R3 RB Ra RI Rx Rd Re t classmethodRF R~ Rf R� R� R� R� R$ R� R� ( ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR - s< % . � � * # &%
t LegacyCursorResultMetaDatac B s5 e Z d Z d � Z e d � Z d � Z d � Z RS( c C sC | } | | j k r& t j d � t S| j | d t � d k Sd S( Ns� Using the 'in' operator to test for string or column keys, or integer indexes, in a :class:`.Row` object is deprecated and will be removed in a future release. Use the `Row._fields` or `Row._mapping` attribute, i.e. 'key in row._fields'( R R t warn_deprecated_20Rb R� R< RF ( R t valuet rowR ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyt _contains� s c C s | j } d } t | t j � rH | j | j r6 | n | j � � } nft | t j � r�| j
r� | j ru | j
n | j
j � | k r� | | j r� | j
n | j
j � } n^ t | d � r| j r� | j n | j j � | k r| | j r� | j n | j j � } n | d k rc| t
d t f k rcx. | t
D] } | j | � r=Pq=q=Wd } n | d k r�| t
t k r�t j d d d �q�t j d d d �q�n | d k r�| r�t j t j d t j | � � d | �q�d Sn
| | | <| S( Nt names� Retrieving row values using Column objects from a row that was unpickled is deprecated; adequate state cannot be pickled for this to be efficient. This usage will raise KeyError in a future release.t versions 1.4s� Retrieving row values using Column objects with only matching names as keys is deprecated, and will raise KeyError in a future release; only Column objects that are explicitly part of the statement object should be used.s. Could not locate column in row for column '%s'R� ( R R< RM R RN t getR RO R t
ColumnElementt _tq_labelt hasattrR� R R� t _compare_name_for_resultt warn_deprecatedR� R R� R� ( R R R� R� t map_t resultRn ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� � sT ' %
c C s t j d d d �d S( Ns� Using non-integer/slice indices on Row is deprecated and will be removed in version 2.0; please use row._mapping[<key>], or the mappings() accessor on the Result object.t
stackleveli ( R R� ( R R ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyt _warn_for_nonint. s c C s0 | | j k r t S| j | d t � d k Sd S( N( R Rb R� R< RF ( R R ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR 6 s ( ( R� R� R� R� Rb R� R� R ( ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� � s
M t ResultFetchStrategyc B s_ e Z d Z d Z d Z d � Z d � Z d � Z e d � Z
d d � Z d � Z d � Z
RS(
sQ Define a fetching strategy for a result object.
.. versionadded:: 1.4
c C s
t � � d S( N( t NotImplementedError( R R� t dbapi_cursor( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyt
soft_closeI s c C s
t � � d S( N( R� ( R R� R� ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyt
hard_closeL s c C s d S( N( ( R R� R� t num( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyt yield_perO s c C s
t � � d S( N( R� ( R R� R� R� ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyt fetchoneR s c C s
t � � d S( N( R� ( R R� R� t size( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyt fetchmanyU s c C s
t � � d S( N( R� ( R R� ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyt fetchallX s c C s
| � d S( N( ( R R� R� R� ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyt handle_exception[ s ( N( R� R� R� R� R< t alternate_cursor_descriptionR� R� R� RF R� R� R� R� ( ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� = s t NoCursorFetchStrategyc B sS e Z d Z d Z d � Z d � Z e d � Z d d � Z d � Z
d d � Z RS( s� Cursor strategy for a result that has no open cursor.
There are two varieties of this strategy, one for DQL and one for
DML (and also DDL), each of which represent a result that had a cursor
but no longer has one.
c C s d S( N( ( R R� R� ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� j s c C s d S( N( ( R R� R� ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� m s c C s | j | d � S( N( t _non_resultR< ( R R� R� R� ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� p s c C s | j | g � S( N( R� ( R R� R� R� ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� s s c C s | j | g � S( N( R� ( R R� R� ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� v s c C s
t � � d S( N( R� ( R R� t defaultR� ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� y s ( N( R� R� R� R� R� R� RF R� R< R� R� R� ( ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� _ s t NoCursorDQLFetchStrategyc B s e Z d Z d Z d d � Z RS( s� Cursor strategy for a DQL result that has no open cursor.
This is a result set that can return rows, i.e. for a SELECT, or for an
INSERT, UPDATE, DELETE that includes RETURNING. However it is in the state
where the cursor is closed and no rows remain available. The owning result
object may or may not be "hard closed", which determines if the fetch
methods send empty results or raise for closed result.
c C s0 | j r( t j t j d � d | �n | Sd S( Ns This result object is closed.R� ( t closedR R� R t ResourceClosedError( R R� R� R� ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� � s
( N( R� R� R� R� R< R� ( ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� } s t NoCursorDMLFetchStrategyc B s e Z d Z d Z d d � Z RS( s� Cursor strategy for a DML result that has no open cursor.
This is a result set that does not return rows, i.e. for an INSERT,
UPDATE, DELETE that does not include RETURNING.
c C s' | j j s t � | j j | � d S( N( t _metadataR� R; t _we_dont_return_rows( R R� R� R� ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� � s ( N( R� R� R� R� R< R� ( ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� � s t CursorFetchStrategyc B sY e Z d Z d Z d � Z d � Z d � Z d � Z e d � Z d d � Z d � Z RS(
s� Call fetch methods from a DBAPI cursor.
Alternate versions of this class may instead buffer the rows from
cursors or not use cursors at all.
c C s
t | _ d S( N( t _NO_CURSOR_DQLt cursor_strategy( R R� R� ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� � s c C s
t | _ d S( N( R� R� ( R R� R� ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� � s c C s# | j j | d d | | j � d S( N( t
connectiont _handle_dbapi_exceptionR< R= ( R R� R� R� ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� � s c C s/ t | i | d 6d t j � d d �| _ d S( Nt max_row_buffert initial_buffert
growth_factori ( t BufferedRowCursorFetchStrategyt collectionst dequeR� ( R R� R� R� ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� � s
c C s` y3 | j � } | d k r. | j d | � n | SWn& t k
r[ } | j | | | � n Xd S( Nt hard( R� R< t _soft_closet
BaseExceptionR� ( R R� R� R� R� R" ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� � s c C sr yE | d k r | j � } n | j | � } | s@ | j � n | SWn& t k
rm } | j | | | � n Xd S( N( R< R� R� R� R� ( R R� R� R� t lR" ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� � s
c C sK y | j � } | j � | SWn& t k
rF } | j | | | � n Xd S( N( R� R� R� R� ( R R� R� t rowsR" ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� � s
( N(
R� R� R� R� R� R� R� R� RF R� R< R� R� ( ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� � s
R� c B sw e Z d Z d Z d d d � Z e d � � Z d � Z d � Z d
� Z
d � Z e d � Z
d d
� Z d � Z RS( s� A cursor fetch strategy with row buffering behavior.
This strategy buffers the contents of a selection of rows
before ``fetchone()`` is called. This is to allow the results of
``cursor.description`` to be available immediately, when
interfacing with a DB-API that requires rows to be consumed before
this information is available (currently psycopg2, when used with
server-side cursors).
The pre-fetching behavior fetches only one row initially, and then
grows its buffer size by a fixed amount with each successive need
for additional rows up the ``max_row_buffer`` size, which defaults
to 1000::
with psycopg2_engine.connect() as conn:
result = conn.execution_options(
stream_results=True, max_row_buffer=50
).execute(text("select * from table"))
.. versionadded:: 1.4 ``max_row_buffer`` may now exceed 1000 rows.
.. seealso::
:ref:`psycopg2_execution_options`
t _max_row_buffert
_rowbuffert _bufsizet _growth_factori c C s� | j d d � | _ | d k r- | | _ n t j | j d � � | _ | | _ | rr t | j | j � | _ n | j | _ d S( NR� i� i (
R� R� R< R� R� R� R� R� t minR� ( R R� t execution_optionsR� R� ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyRa s c C s t | j | j j � S( N( R� t cursorR= R� ( R� R� ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyt create s c C s� | j } y. | d k r' | j � } n | j | � } Wn& t k
r_ } | j | | | � n X| sj d St j | � | _ | j r� | | j k r� t
| j | | j � | _ n d S( s* this is currently used only by fetchone().i N( R� R� R� R� R� R� R� R� R� R� R� ( R R� R� R� t new_rowsR" ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyt _buffer_rows" s c C s d | _ | | _ | _ d S( Ni ( R� R� R� ( R R� R� R� ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� 6 s c C s* | j j � t t | � j | | � d S( N( R� t cleart superR� R� ( R R� R� ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� : s
c C s* | j j � t t | � j | | � d S( N( R� R� R� R� R� ( R R� R� ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� @ s
c C ss | j sf | j | | � | j sf y | j d | � Wn& t k
r^ } | j | | | � n Xd Sn | j j � S( NR� ( R� R� R� R� R� R< t popleft( R R� R� R� R" ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� F s c C s� | d k r | j | | � St | j � } t | � } | | k r� y | j | | � } Wn& t k
r� } | j | | | � q� X| s� | j � q� | j | � n | d | !} t
j | | � | _ | S( Ni ( R< R� R# R� RH R� R� R� R� t extendR� R� ( R R� R� R� t buft lbRA R" ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� Q s
c C sk y> t | j � t | j � � } | j j � | j � | SWn& t k
rf } | j | | | � n Xd S( N( R# R� R� R� R� R� R� ( R R� R� t retR" ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� f s
( R� R� R� R� N( R� R� R� R� R< Ra R� R� R� R� R� R� RF R� R� R� ( ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� � s t FullyBufferedCursorFetchStrategyc B s_ e Z d Z d
Z d d d � Z d � Z d � Z d � Z e d � Z
d d � Z d � Z RS( s� A cursor strategy that buffers rows fully upon creation.
Used for operations where a result is to be delivered
after the database conversation can not be continued,
such as MSSQL INSERT...OUTPUT after an autocommit.
R� R� c C sF | | _ | d k r* t j | � | _ n t j | j � � | _ d S( N( R� R< R� R� R� R� ( R R� t alternate_descriptionR� ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyRa { s c C s d S( N( ( R R� R� R� ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� � s c C s* | j j � t t | � j | | � d S( N( R� R� R� R� R� ( R R� R� ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� � s
c C s* | j j � t t | � j | | � d S( N( R� R� R� R� R� ( R R� R� ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� � s
c C s. | j r | j j � S| j d | � d Sd S( NR� ( R� R� R� R< ( R R� R� R� ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� � s
c C se | d k r | j | | � St | j � } | d | !} t j | | � | _ | sa | j � n | S( Ni ( R< R� R# R� R� R� R� ( R R� R� R� R� R� ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� � s
c C s& | j } t j � | _ | j � | S( N( R� R� R� R� ( R R� R� R� ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� � s
( R� R� N(
R� R� R� R� R< Ra R� R� R� RF R� R� R� ( ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� p s t _NoResultMetaDatac B sY e Z d Z e Z d d � Z d � Z d � Z d � Z e
d � � Z e
d � � Z RS( c C s t j t j d � d | �d S( NsJ This result object does not return rows. It has been closed automatically.R� ( R R� R R� ( R R� ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� � s c C s | j � d S( N( R� ( R R* R� ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� � s c C s | j � d S( N( R� ( R R ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR$ � s c C s | j � d S( N( R� ( R R* ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR3 � s c C s | j � d S( N( R� ( R ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR � s c C s | j � d S( N( R� ( R ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR* � s ( N(
R� R� R� RF R� R< R� R� R$ R3 t propertyR R* ( ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� � s t _LegacyNoResultMetaDatac B s e Z e d � � Z RS( c C s t j d � g S( Ns� Calling the .keys() method on a result set that does not return rows is deprecated and will raise ResourceClosedError in SQLAlchemy 2.0.( R R� ( R ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR* � s ( R� R� R� R* ( ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� � s t BaseCursorResultc B s� e Z d Z d Z d Z e Z e Z d � Z d � Z
e d � Z e d � � Z
e d � � Z d � Z d � Z e d � � Z e d � � Z d
� Z d � Z d � Z d
� Z d � Z e j d � � Z e d � � Z e d � � Z e d � � Z RS( s' Base class for database result objects.c s/ | | _ | j | _ | j | _ | | _ | j | _ | j j oN | j j � | _ } | d k r | r� | j j j
� � f d � � � | _ n d � | j | | � } | j
} | j } | j } | j } t j | | | | | � � � r� � f d � }
n � }
| j d |
� n | j | _ d S( Nc s � d t j | � � | S( Ns Row %r( t sql_utilt _repr_row( R� ( t log( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyt log_row� s c s � | � } � | � | S( N( ( R� t made_row( t _make_rowR� ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyt make_row s
t _row_getter( R= RE R� R� t root_connectionR� t _echot enginet _should_log_debugR< t
_log_debugt _row_logging_fnt _init_metadataR R t _process_rowt _default_key_stylet functoolst partialt _set_memoized_attributet _no_result_metadataR� ( R R= R� RU t echot metadatat keymapt
processorst process_rowt key_styleR� ( ( R� R� R� sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyRa � s0 " c C s | j r� | j j r' | j j j } n* | j | | � } | j rQ | | j _ n | j } | r� | j r� | j | j j k r� | j j
d t � r� | j | j
k r� | j | � } n | | _ n | j | | � | _ } | j r | j j d t d � | D� � � n | S( Nt _result_disable_adapt_to_contexts Col %rc s s | ] } | d Vq d S( i N( ( R t x( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pys <genexpr>@ s ( R4 t _cached_metadataR= t _cursor_metadataR R5 t cache_hitRE t CACHE_HITR� R� RF R6 R7 RB R� R� R� R� t tuple( R R= RU R R4 ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR s*
c C s� | r | j s | r# | j r# d S| rK t | _ | j j | | j � n | j j | | j � | j s� | j } d | _ | j j | � t | _ n d S( s} Soft close this :class:`_engine.CursorResult`.
This releases all DBAPI cursor resources, but leaves the
CursorResult "open" from a semantic perspective, meaning the
fetchXXX() methods will continue to return empty results.
This method is called automatically when:
* all result rows are exhausted using the fetchXXX() methods.
* cursor.description is None.
This method is **not public**, but is documented in order to clarify
the "autoclose" process used.
.. versionadded:: 1.0.0
.. seealso::
:meth:`_engine.CursorResult.close`
N(
t _soft_closedR� Rb R� R� R� R� R< R� t _safe_close_cursor( R R� R� ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� D s c C sd | j j s t j d � � n< | j j s< t j d � � n | j j rZ t j d � � n | j j S( s� Return the value of
:attr:`_engine.CursorResult.inserted_primary_key`
as a row contained within a list; some dialects may support a
multiple row form as well.
.. note:: As indicated below, in current SQLAlchemy versions this
accessor is only useful beyond what's already supplied by
:attr:`_engine.CursorResult.inserted_primary_key` when using the
:ref:`postgresql_psycopg2` dialect. Future versions hope to
generalize this feature to more dialects.
This accessor is added to support dialects that offer the feature
that is currently implemented by the :ref:`psycopg2_executemany_mode`
feature, currently **only the psycopg2 dialect**, which provides
for many rows to be INSERTed at once while still retaining the
behavior of being able to return server-generated primary key values.
* **When using the psycopg2 dialect, or other dialects that may support
"fast executemany" style inserts in upcoming releases** : When
invoking an INSERT statement while passing a list of rows as the
second argument to :meth:`_engine.Connection.execute`, this accessor
will then provide a list of rows, where each row contains the primary
key value for each row that was INSERTed.
* **When using all other dialects / backends that don't yet support
this feature**: This accessor is only useful for **single row INSERT
statements**, and returns the same information as that of the
:attr:`_engine.CursorResult.inserted_primary_key` within a
single-element list. When an INSERT statement is executed in
conjunction with a list of rows to be INSERTed, the list will contain
one row per row inserted in the statement, however it will contain
``None`` for any server-generated values.
Future releases of SQLAlchemy will further generalize the
"fast execution helper" feature of psycopg2 to suit other dialects,
thus allowing this accessor to be of more general use.
.. versionadded:: 1.4
.. seealso::
:attr:`_engine.CursorResult.inserted_primary_key`
s1 Statement is not a compiled expression construct.s2 Statement is not an insert() expression construct.s9 Can't call inserted_primary_key when returning() is used.( R= R4 R Rz t isinsertt _is_explicit_returningt inserted_primary_key_rows( R ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR j s . c C s= | j j r t j d � � n | j } | r5 | d Sd Sd S( s� Return the primary key for the row just inserted.
The return value is a :class:`_result.Row` object representing
a named tuple of primary key values in the order in which the
primary key columns are configured in the source
:class:`_schema.Table`.
.. versionchanged:: 1.4.8 - the
:attr:`_engine.CursorResult.inserted_primary_key`
value is now a named tuple via the :class:`_result.Row` class,
rather than a plain tuple.
This accessor only applies to single row :func:`_expression.insert`
constructs which did not explicitly specify
:meth:`_expression.Insert.returning`. Support for multirow inserts,
while not yet available for most backends, would be accessed using
the :attr:`_engine.CursorResult.inserted_primary_key_rows` accessor.
Note that primary key columns which specify a server_default clause, or
otherwise do not qualify as "autoincrement" columns (see the notes at
:class:`_schema.Column`), and were generated using the database-side
default, will appear in this list as ``None`` unless the backend
supports "returning" and the insert statement executed with the
"implicit returning" enabled.
Raises :class:`~sqlalchemy.exc.InvalidRequestError` if the executed
statement is not a compiled expression construct
or is not an insert() construct.
su This statement was an executemany call; if primary key returning is supported, please use .inserted_primary_key_rows.i N( R= t executemanyR Rz R R< ( R t ikp( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyt inserted_primary_key� s ! c C sd | j j s t j d � � nB | j j s< t j d � � n$ | j j rR | j j S| j j d Sd S( s Return the collection of updated parameters from this
execution.
Raises :class:`~sqlalchemy.exc.InvalidRequestError` if the executed
statement is not a compiled expression construct
or is not an update() construct.
s1 Statement is not a compiled expression construct.s2 Statement is not an update() expression construct.i N( R= R4 R Rz t isupdateR t compiled_parameters( R ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyt last_updated_params� s
c C sd | j j s t j d � � nB | j j s< t j d � � n$ | j j rR | j j S| j j d Sd S( s Return the collection of inserted parameters from this
execution.
Raises :class:`~sqlalchemy.exc.InvalidRequestError` if the executed
statement is not a compiled expression construct
or is not an insert() construct.
s1 Statement is not a compiled expression construct.s2 Statement is not an insert() expression construct.i N( R= R4 R Rz R R R ( R ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyt last_inserted_params� s
c C s
| j j S( s Return a list of rows each containing the values of default
columns that were fetched using
the :meth:`.ValuesBase.return_defaults` feature.
The return value is a list of :class:`.Row` objects.
.. versionadded:: 1.4
( R= t returned_default_rows( R ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyt returned_defaults_rows s c C s@ | j j r t j d � � n | j j } | r8 | d Sd Sd S( s� Return the values of default columns that were fetched using
the :meth:`.ValuesBase.return_defaults` feature.
The value is an instance of :class:`.Row`, or ``None``
if :meth:`.ValuesBase.return_defaults` was not used or if the
backend does not support RETURNING.
.. versionadded:: 0.9.0
.. seealso::
:meth:`.ValuesBase.return_defaults`
sl This statement was an executemany call; if return defaults is supported, please use .returned_defaults_rows.i N( R= R R Rz R! R< ( R R� ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyt returned_defaults s c C s
| j j � S( s� Return ``lastrow_has_defaults()`` from the underlying
:class:`.ExecutionContext`.
See :class:`.ExecutionContext` for details.
( R= t lastrow_has_defaults( R ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR$ , s c C sT | j j s t j d � � n, | j j rJ | j j rJ t j d � � n | j j S( sM Return ``postfetch_cols()`` from the underlying
:class:`.ExecutionContext`.
See :class:`.ExecutionContext` for details.
Raises :class:`~sqlalchemy.exc.InvalidRequestError` if the executed
statement is not a compiled expression construct
or is not an insert() or update() construct.
s1 Statement is not a compiled expression construct.s> Statement is not an insert() or update() expression construct.( R= R4 R Rz R R t postfetch_cols( R ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR% 6 s c C sT | j j s t j d � � n, | j j rJ | j j rJ t j d � � n | j j S( sL Return ``prefetch_cols()`` from the underlying
:class:`.ExecutionContext`.
See :class:`.ExecutionContext` for details.
Raises :class:`~sqlalchemy.exc.InvalidRequestError` if the executed
statement is not a compiled expression construct
or is not an insert() or update() construct.
s1 Statement is not a compiled expression construct.s> Statement is not an insert() or update() expression construct.( R= R4 R Rz R R t
prefetch_cols( R ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR& M s c C s
| j j S( s� Return ``supports_sane_rowcount`` from the dialect.
See :attr:`_engine.CursorResult.rowcount` for background.
( RE t supports_sane_rowcount( R ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR' d s c C s
| j j S( s� Return ``supports_sane_multi_rowcount`` from the dialect.
See :attr:`_engine.CursorResult.rowcount` for background.
( RE t supports_sane_multi_rowcount( R ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR( m s c C sA y | j j SWn, t k
r< } | j j | | j | � n Xd S( s~ Return the 'rowcount' for this result.
The 'rowcount' reports the number of rows *matched*
by the WHERE criterion of an UPDATE or DELETE statement.
.. note::
Notes regarding :attr:`_engine.CursorResult.rowcount`:
* This attribute returns the number of rows *matched*,
which is not necessarily the same as the number of rows
that were actually *modified* - an UPDATE statement, for example,
may have no net change on a given row if the SET values
given are the same as those present in the row already.
Such a row would be matched but not modified.
On backends that feature both styles, such as MySQL,
rowcount is configured by default to return the match
count in all cases.
* :attr:`_engine.CursorResult.rowcount`
is *only* useful in conjunction
with an UPDATE or DELETE statement. Contrary to what the Python
DBAPI says, it does *not* return the
number of rows available from the results of a SELECT statement
as DBAPIs cannot support this functionality when rows are
unbuffered.
* :attr:`_engine.CursorResult.rowcount`
may not be fully implemented by
all dialects. In particular, most DBAPIs do not support an
aggregate rowcount result from an executemany call.
The :meth:`_engine.CursorResult.supports_sane_rowcount` and
:meth:`_engine.CursorResult.supports_sane_multi_rowcount` methods
will report from the dialect if each usage is known to be
supported.
* Statements that use RETURNING may not return a correct
rowcount.
.. seealso::
:ref:`tutorial_update_delete_rowcount` - in the :ref:`unified_tutorial`
N( R= t rowcountR� R� R� R� ( R R" ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR) v s 0c C sD y | j j � SWn, t k
r? } | j j | | j | � n Xd S( s0 Return the 'lastrowid' accessor on the DBAPI cursor.
This is a DBAPI specific method and is only functional
for those backends which support it, for statements
where it is appropriate. It's behavior is not
consistent across backends.
Usage of this method is normally unnecessary when
using insert() expression constructs; the
:attr:`~CursorResult.inserted_primary_key` attribute provides a
tuple of primary key values for a newly inserted row,
regardless of database backend.
N( R= t
get_lastrowidR� R� R� R� ( R R" ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyt lastrowid� s c C s
| j j S( sq True if this :class:`_engine.CursorResult` returns zero or more
rows.
I.e. if it is legal to call the methods
:meth:`_engine.CursorResult.fetchone`,
:meth:`_engine.CursorResult.fetchmany`
:meth:`_engine.CursorResult.fetchall`.
Overall, the value of :attr:`_engine.CursorResult.returns_rows` should
always be synonymous with whether or not the DBAPI cursor had a
``.description`` attribute, indicating the presence of result columns,
noting that a cursor that returns zero rows still has a
``.description`` if a row-returning statement was emitted.
This attribute should be True for all results that are against
SELECT statements, as well as for DML statements INSERT/UPDATE/DELETE
that use RETURNING. For INSERT/UPDATE/DELETE statements that were
not using RETURNING, the value will usually be False, however
there are some dialect-specific exceptions to this, such as when
using the MSSQL / pyodbc dialect a SELECT is emitted inline in
order to retrieve an inserted primary key value.
( R� R� ( R ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� � s c C s
| j j S( sl True if this :class:`_engine.CursorResult` is the result
of a executing an expression language compiled
:func:`_expression.insert` construct.
When True, this implies that the
:attr:`inserted_primary_key` attribute is accessible,
assuming the statement did not include
a user defined "returning" construct.
( R= R ( R ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyt is_insert� s N( R� R� R� R< t out_parametersR� RF R R� Ra R R� R� R R R R R" R# R$ R% R& R' R( R t memoized_propertyR) R+ R� R, ( ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� � s. 1 0 &>.
5 t CursorResultc B sz e Z d Z e Z e Z e Z e Z
d � Z e d � Z
d � Z d d � Z d � Z d � Z d � Z e d � � Z RS(
sH A Result that is representing state from a DBAPI cursor.
.. versionchanged:: 1.4 The :class:`.CursorResult` and
:class:`.LegacyCursorResult`
classes replace the previous :class:`.ResultProxy` interface.
These classes are based on the :class:`.Result` calling API
which provides an updated usage model and calling facade for
SQLAlchemy Core and SQLAlchemy ORM.
Returns database rows via the :class:`.Row` class, which provides
additional API features and behaviors on top of the raw data returned by
the DBAPI. Through the use of filters such as the :meth:`.Result.scalars`
method, other kinds of objects may also be returned.
Within the scope of the 1.x series of SQLAlchemy, Core SQL results in
version 1.4 return an instance of :class:`._engine.LegacyCursorResult`
which takes the place of the ``CursorResult`` class used for the 1.3 series
and previously. This object returns rows as :class:`.LegacyRow` objects,
which maintains Python mapping (i.e. dictionary) like behaviors upon the
object itself. Going forward, the :attr:`.Row._mapping` attribute should
be used for dictionary behaviors.
.. seealso::
:ref:`coretutorial_selecting` - introductory material for accessing
:class:`_engine.CursorResult` and :class:`.Row` objects.
c c sD | j j } x1 t r? | | | j � } | d k r7 Pn | Vq Wd S( N( R� R� Rb R� R< ( R R� R� ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyt _fetchiter_impl s c C s | j j | | j | � S( N( R� R� R� ( R R� ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyt _fetchone_impl s c C s | j j | | j � S( N( R� R� R� ( R ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyt _fetchall_impl s c C s | j j | | j | � S( N( R� R� R� ( R R� ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyt _fetchmany_impl s c C s
| j � S( N( R0 ( R ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyt _raw_row_iterator s c G sR t t | � j | � } | j j } | rN t d � | f | D� � | _ n | S( Nc s s | ] } | j Vq d S( N( R) ( R R� ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pys <genexpr>( s ( R� R/ t mergeR� R� t sumR) ( R t otherst
merged_resultt setup_rowcounts( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR5 # s
c C s | j d t � d S( s� Close this :class:`_engine.CursorResult`.
This closes out the underlying DBAPI cursor corresponding to the
statement execution, if one is still present. Note that the DBAPI
cursor is automatically released when the :class:`_engine.CursorResult`
exhausts all available rows. :meth:`_engine.CursorResult.close` is
generally an optional method except in the case when discarding a
:class:`_engine.CursorResult` that still has additional rows pending
for fetch.
After this method is called, it is no longer valid to call upon
the fetch methods, which will raise a :class:`.ResourceClosedError`
on subsequent use.
.. seealso::
:ref:`connections_toplevel`
R� N( R� Rb ( R ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyt close, s c C s& | | _ | j j | | j | � d S( N( t
_yield_perR� R� R� ( R R� ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� B s N( R� R� R� R R R� t _cursor_strategy_clst _NO_RESULT_METADATAR Rb t
_is_cursorR0 RF R1 R2 R< R3 R4 R5 R: R R� ( ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR/ � s t LegacyCursorResultc B sA e Z d Z e Z e Z e Z e Z
e Z d � Z
e d � Z RS( s
Legacy version of :class:`.CursorResult`.
This class includes connection "connection autoclose" behavior for use with
"connectionless" execution, as well as delivers rows using the
:class:`.LegacyRow` row implementation.
.. versionadded:: 1.4
c C s | j d t � d S( sE Close this :class:`_engine.LegacyCursorResult`.
This method has the same behavior as that of
:meth:`._engine.CursorResult`, but it also may close
the underlying :class:`.Connection` for the case of "connectionless"
execution.
.. deprecated:: 2.0 "connectionless" execution is deprecated and will
be removed in version 2.0. Version 2.0 will feature the
:class:`_future.Result`
object that will no longer affect the status
of the originating connection in any case.
After this method is called, it is no longer valid to call upon
the fetch methods, which will raise a :class:`.ResourceClosedError`
on subsequent use.
.. seealso::
:ref:`connections_toplevel`
:ref:`dbengine_implicit`
R� N( R� Rb ( R ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR: Z s c C sO | j } t t | � j d | � | rK | j rK | j rK | j j � n d S( NR� ( R R� R? R� t _autoclose_connectionR� R: ( R R� t soft_closed( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR� t s ( R� R� R� RF R@ R R R� R R� R< t _LEGACY_NO_RESULT_METADATAR R: R� ( ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyR? H s t BufferedRowResultProxyc B s e Z d Z e Z RS( s� A ResultProxy with row buffering behavior.
.. deprecated:: 1.4 this class is now supplied using a strategy object.
See :class:`.BufferedRowCursorFetchStrategy`.
( R� R� R� R� R< ( ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyRC � s t FullyBufferedResultProxyc B s e Z d Z e Z RS( s� A result proxy that buffers rows fully upon creation.
.. deprecated:: 1.4 this class is now supplied using a strategy object.
See :class:`.FullyBufferedCursorFetchStrategy`.
( R� R� R� R� R< ( ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyRD � s t BufferedColumnRowc B s e Z d Z RS( s& Row is now BufferedColumn in all cases( R� R� R� ( ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyRE � s t BufferedColumnResultProxyc B s e Z d Z e Z RS( s� A ResultProxy with column buffering behavior.
.. versionchanged:: 1.4 This is now the default behavior of the Row
and this class does not change behavior in any way.
( R� R� R� RE R ( ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyRF � s (: R� R� R R� R R R R R� R t R R t sqlR R R� t sql.baseR t sql.compilerR
R R R
t symbolR� R% RC R R RL RJ RS R R� t objectR� R� R� R� R� t _NO_CURSOR_DMLR� t _DEFAULT_FETCHR� R� R� R� R= RB R� R/ R? t ResultProxyRC RD RE RF ( ( ( sI /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/engine/cursor.pyt <module> sj � � �n" < �< � � ]7