gq f d Z ddlmZ ddlZddlZddlmZ ddlmZ ddlmZ ddlm Z dd lm
Z
dd
l
m Z e
j d Z
e
j d Z e
j d
Z G d de Z G d de j Z G d de Z ddZ e Z G d de ZdS )z'Base constructs for connection pools.
)dequeN )event)exc)
interfaces)log)util) threadingreset_rollback reset_commit
reset_nonec * e Zd ZdZd Zd Zd Zd ZdS ) _ConnDialectzpartial implementation of :class:`.Dialect`
which provides DBAPI connection methods.
When a :class:`_pool.Pool` is combined with an :class:`_engine.Engine`,
the :class:`_engine.Engine` replaces this with its own
:class:`.Dialect`.
c . | d S N)rollbackselfdbapi_connections h/builddir/build/BUILD/cloudlinux-venv-1.0.10/venv/lib64/python3.11/site-packages/sqlalchemy/pool/base.py do_rollbackz_ConnDialect.do_rollback) s !!##### c . | d S r )commitr s r do_commitz_ConnDialect.do_commit, s !!!!!r c . | d S r )closer s r do_closez_ConnDialect.do_close/ s r c t d )NzJThe ping feature requires that a dialect is passed to the connection pool.NotImplementedErrorr s r do_pingz_ConnDialect.do_ping2 s !
-
r N)__name__
__module__ __qualname____doc__r r r r" r r r r sZ $ $ $" " "! ! !
r r c & e Zd ZdZ e Z ej dd dd Ze d
Z
e
j d Z
d Z d
Z
ej dd d Zd Zd Zd dZd Zd Zd Zd Zd Zd Zd ZdS ) Poolz)Abstract base class for connection pools.)z1.3zkThe :paramref:`_pool.Pool.use_threadlocal` parameter is deprecated and will be removed in a future release.)0.7z:class:`.PoolListener` is deprecated in favor of the :class:`_events.PoolEvents` listener interface. The :paramref:`_pool.Pool.listeners` parameter will be removed in a future release.)use_threadlocal listenersNFTc 4 |r|x| _ | _ nd| _ t j | | t j | _ || _ || _ d| _ || _
|
| _ t j
|t ddgt g dt" dgidd
| _ || _ | r | j | d | r| | _ |r |D ]\ } }
t/ j | |
| |r|D ]}| | dS dS ) a-
Construct a Pool.
:param creator: a callable function that returns a DB-API
connection object. The function will be called with
parameters.
:param recycle: If set to a value other than -1, number of
seconds between connection recycling, which means upon
checkout, if this timeout is surpassed the connection will be
closed and replaced with a newly opened connection. Defaults to -1.
:param logging_name: String identifier which will be used within
the "name" field of logging records generated within the
"sqlalchemy.pool" logger. Defaults to a hexstring of the object's
id.
:param echo: if True, the connection pool will log
informational output such as when connections are invalidated
as well as when connections are recycled to the default log handler,
which defaults to ``sys.stdout`` for output.. If set to the string
``"debug"``, the logging will include pool checkouts and checkins.
The :paramref:`_pool.Pool.echo` parameter can also be set from the
:func:`_sa.create_engine` call by using the
:paramref:`_sa.create_engine.echo_pool` parameter.
.. seealso::
:ref:`dbengine_logging` - further detail on how to configure
logging.
:param use_threadlocal: If set to True, repeated calls to
:meth:`connect` within the same application thread will be
guaranteed to return the same connection object that is already
checked out. This is a legacy use case and the flag has no
effect when using the pool with a :class:`_engine.Engine` object.
:param reset_on_return: Determine steps to take on
connections as they are returned to the pool.
reset_on_return can have any of these values:
* ``"rollback"`` - call rollback() on the connection,
to release locks and transaction resources.
This is the default value. The vast majority
of use cases should leave this value set.
* ``True`` - same as 'rollback', this is here for
backwards compatibility.
* ``"commit"`` - call commit() on the connection,
to release locks and transaction resources.
A commit here may be desirable for databases that
cache query plans if a commit is emitted,
such as Microsoft SQL Server. However, this
value is more dangerous than 'rollback' because
any data changes present on the transaction
are committed unconditionally.
* ``None`` - don't do anything on the connection.
This setting should generally only be made on a database
that has no transaction support at all,
namely MySQL MyISAM; when used on this backend, performance
can be improved as the "rollback" call is still expensive on
MySQL. It is **strongly recommended** that this setting not be
used for transaction-supporting databases in conjunction with
a persistent pool such as :class:`.QueuePool`, as it opens
the possibility for connections still in a transaction to be
idle in the pool. The setting may be appropriate in the
case of :class:`.NullPool` or special circumstances where
the connection pool in use is not being used to maintain connection
lifecycle.
* ``False`` - same as None, this is here for
backwards compatibility.
:param events: a list of 2-tuples, each of the form
``(callable, target)`` which will be passed to :func:`.event.listen`
upon construction. Provided here so that event listeners
can be assigned via :func:`_sa.create_engine` before dialect-level
listeners are applied.
:param listeners: A list of :class:`.PoolListener`-like objects or
dictionaries of callables that receive events when DB-API
connections are created, checked out and checked in to the
pool.
:param dialect: a :class:`.Dialect` that will handle the job
of calling rollback(), close(), or commit() on DBAPI connections.
If omitted, a built-in "stub" dialect is used. Applications that
make use of :func:`_sa.create_engine` should not use this parameter
as it is handled by the engine creation strategy.
.. versionadded:: 1.1 - ``dialect`` is now a public parameter
to the :class:`_pool.Pool`.
:param pre_ping: if True, the pool will emit a "ping" (typically
"SELECT 1", but is dialect-specific) on the connection
upon checkout, to test if the connection is alive or not. If not,
the connection is transparently re-connected and upon success, all
other pooled connections established prior to that timestamp are
invalidated. Requires that a dialect is passed as well to
interpret the disconnection error.
.. versionadded:: 1.2
N)echoflagr r T)noneNFr reset_on_returnF)resolve_symbol_names)only_propagate) logging_name_orig_logging_namer instance_loggerr
local _threadconns_creator_recycle_invalidate_time_use_threadlocal _pre_pingr symbolparse_user_argumentr r
r _reset_on_returnechodispatch_update_dialectr listen add_listener)r creatorrecyclerA r+ r4 r1 r, eventsdialectpre_ping _dispatchfntargetls r __init__z
Pool.__init__? sp H +:F FD 7 7&*D # D40000 %O - -
! / ! $ ? ? T 2 1 1 1 xj
!& !@ !
!
C M ! !)E ! B B B $ #DM / $
/
/
F T62.... %
%
%!!!$$$$ % %
%
%r c | j d S Nr9 )__dict__r s r r9 z
Pool._creator s }Z((r c N || j d< | | | _ d S rR )rS _should_wrap_creator_invoke_creator)r rG s r r9 z
Pool._creator s* $+
j! # 8 8 A A r c & t j | j d }n# t $ r fdcY S w xY w|d durt |d pd}t |d |z
}|d |d fdgdfk rS |d k rS fd
S ) zlDetect if creator accepts a single argument, or is sent
as a legacy style no-arg function.
T)no_selfc S r r' crecrG s r z+Pool._should_wrap_creator..
r Nr connection_recordr c S r r' r[ s r r] z+Pool._should_wrap_creator.. r^ r )r get_callable_argspecr9 TypeErrorlen)r rG argspec defaulted positionalss ` r rV zPool._should_wrap_creator s */
tLLLGG * * *)))) ) ) ) * AJd*>s71:C! '!*oo 1
AJ
#)<(=w'G G GN
A
N *))) )s 11c | j d| | j | d S # t $ r! | j d|d Y d S w xY w)NzClosing connection %rz Exception closing connection %rTexc_info)loggerdebugrD r Exceptionerror)r
connections r _close_connectionzPool._close_connection
s 1:>>> M " ": . . . . . K 1:
s 9 'A$#A$r* zThe :meth:`_pool.Pool.add_listener` method is deprecated and will be removed in a future release. Please use the :class:`_events.PoolEvents` listener interface.c F t j | | dS )a Add a :class:`.PoolListener`-like object to this pool.
``listener`` may be an object that implements some or all of
PoolListener, or a dictionary of callables containing implementations
of some or all of the named methods in PoolListener.
N)r PoolListener_adapt_listener)r listeners r rF zPool.add_listener s# //h?????r c 6 t | S )a Produce a DBAPI connection that is not referenced by any
thread-local context.
This method is equivalent to :meth:`_pool.Pool.connect` when the
:paramref:`_pool.Pool.use_threadlocal` flag is not set to True.
When :paramref:`_pool.Pool.use_threadlocal` is True, the
:meth:`_pool.Pool.unique_connection`
method provides a means of bypassing
the threadlocal context.
)_ConnectionFairy _checkoutrT s r unique_connectionzPool.unique_connection$ s ))$///r c t | S )z6Called by subclasses to create a new ConnectionRecord.)_ConnectionRecordrT s r _create_connectionzPool._create_connection2 s !&&&r c t |dd }|r| j |j k rt j | _ |r(t |dd r| | dS dS dS )a Mark all connections established within the generation
of the given connection as invalidated.
If this pool's last invalidate time is before when the given
connection was created, update the timestamp til now. Otherwise,
no action is performed.
Connections with a start time prior to this pool's invalidation
time will be recycled upon next checkout.
_connection_recordNis_validF)getattrr; starttimetime
invalidate)r rp exception_checkinrecs r _invalidatezPool._invalidate7 s j"6== 0d+cm;;$(IKKD ! -
J>> - ! !) , , , , , - - - -r c t )a" Return a new :class:`_pool.Pool`, of the same class as this one
and configured with identical creation arguments.
This method is used in conjunction with :meth:`dispose`
to close out an entire :class:`_pool.Pool` and create a new one in
its place.
r rT s r recreatez
Pool.recreateH s "###r c t )zDispose of this pool.
This method leaves the possibility of checked-out connections
remaining open, as it only affects connections that are
idle in the pool.
.. seealso::
:meth:`Pool.recreate`
r rT s r disposez Pool.disposeT s "###r c | j st | S | j }|| S n# t $ r Y nw xY wt | | j S )zReturn a DBAPI connection from the pool.
The connection is instrumented such that when its
``close()`` method is called, the connection will be returned to
the pool.
)r< rw rx r8 current_checkout_existingAttributeErrorr r s r connectz Pool.connectc s $ 4#--d33 3 0#++--C --/// D ))$0ABBBs A
A A c p | j r | j `n# t $ r Y nw xY w| | dS )zGiven a _ConnectionRecord, return it to the :class:`_pool.Pool`.
This method is called when an instrumented DBAPI connection
has its ``close()`` method called.
N)r< r8 r r _do_return_conn)r records r _return_connzPool._return_connx sZ
%--!
V$$$$$s
c t )z7Implementation for :meth:`get`, supplied by subclasses.r rT s r _do_getz Pool._do_get "###r c t )z?Implementation for :meth:`return_conn`, supplied by subclasses.r )r conns r r zPool._do_return_conn r r c t r r rT s r statusz Pool.status s !###r )
r- NFNTNNNFN)NT)r# r$ r% r& r rD r deprecated_paramsrP propertyr9 setterrV rq
deprecatedrF ry r| r r r r r r r r r' r r r) r) 9 s 33|~~HT
"
X% X% X%
X%t ) ) X) _B B _B* * *4 T_
: @ @
@ 0 0 0 ' ' '
- - - -"
$
$
$
$
$
$ C C C* % % % $ $ $
$ $ $
$ $ $ $ $r r) c e Zd ZdZddZdZdZdZ dZe j
d Z e j
d Z e
d Zd Zdd Zed Zed
Zd ZddZd Zd ZddZdS )r{ a Internal object which maintains an individual DBAPI connection
referenced by a :class:`_pool.Pool`.
The :class:`._ConnectionRecord` object always exists for any particular
DBAPI connection whether or not that DBAPI connection has been
"checked out". This is in contrast to the :class:`._ConnectionFairy`
which is only a public facade to the DBAPI connection while it is checked
out.
A :class:`._ConnectionRecord` may exist for a span longer than that
of a single DBAPI connection. For example, if the
:meth:`._ConnectionRecord.invalidate`
method is called, the DBAPI connection associated with this
:class:`._ConnectionRecord`
will be discarded, but the :class:`._ConnectionRecord` may be used again,
in which case a new DBAPI connection is produced when the
:class:`_pool.Pool`
next uses this record.
The :class:`._ConnectionRecord` is delivered along with connection
pool events, including :meth:`_events.PoolEvents.connect` and
:meth:`_events.PoolEvents.checkout`, however :class:`._ConnectionRecord`
still
remains an internal object whose API and internals may change.
.. seealso::
:class:`._ConnectionFairy`
Tc j || _ |r| d t | _ d S )NT)first_connect_check)_ConnectionRecord__pool_ConnectionRecord__connectr finalize_callback)r poolr s r rP z_ConnectionRecord.__init__ s7 5 NNtN 4 4 4!& r Nr c i S )a` The ``.info`` dictionary associated with the DBAPI connection.
This dictionary is shared among the :attr:`._ConnectionFairy.info`
and :attr:`_engine.Connection.info` accessors.
.. note::
The lifespan of this dictionary is linked to the
DBAPI connection itself, meaning that it is **discarded** each time
the DBAPI connection is closed and/or invalidated. The
:attr:`._ConnectionRecord.record_info` dictionary remains
persistent throughout the lifespan of the
:class:`._ConnectionRecord` container.
r' rT s r infoz_ConnectionRecord.info s " r c i S )a An "info' dictionary associated with the connection record
itself.
Unlike the :attr:`._ConnectionRecord.info` dictionary, which is linked
to the lifespan of the DBAPI connection, this dictionary is linked
to the lifespan of the :class:`._ConnectionRecord` container itself
and will remain persistent throughout the life of the
:class:`._ConnectionRecord`.
.. versionadded:: 1.1
r' rT s r record_infoz _ConnectionRecord.record_info s r c }nW# t $ rJ}t j 5 | d d d n # 1 swxY w Y Y d }~nd }~ww xY w t | }t j |fd _
t rj
d| |S )Nc 8 t ot d | S r )_finalize_fairy)refrA r r s r r] z,_ConnectionRecord.checkout.. s" < c4d;; r z#Connection %r checked out from pool)r get_connectionrn r safe_reraise_checkin_failed_should_log_debugrw weakrefr fairy_ref_refsaddrl rm )clsr r errfairyrA r s ` @@r checkoutz_ConnectionRecord.checkout sa llnn ) " 1 1 3 3 ) ) )"$$
)
)##C(((
)
)
)
)
)
)
)
)
)
)
)
)
)
)
) ) %%'' !13==
<
<
<
<
<
<
# K 57G
s8 .
BA= A-! A=-A1 1A=4A1 5A==Bc ^ | | | d d S )NeT)
_no_fairy_ref)r checkin)r r s r r z!_ConnectionRecord._checkin_failed s0 # 4 (((((r Fc P | j |st j d| z d S d | _ | j }| j }| j r+| j } || | j +|j j r|j || | | d S )Nz Double checkin attempted on %s)
r r warnrp r r poprB r r )r r rp r finalizers r r z_ConnectionRecord.checkin s > !- ! I6= > > > F _
{$ " .2244I Ij ! ! ! $ " = 4 M ! !*d 3 3 3 $ r c | j d uS r )r rT s r in_usez_ConnectionRecord.in_use s ~T))r c | j S r )r rT s r last_connect_timez#_ConnectionRecord.last_connect_time s
~ r c @ | j | d S d S r )rp _ConnectionRecord__closerT s r r z_ConnectionRecord.close s# ? & LLNNNNN ' &r c | j dS |r'| j j | j | | n&| j j | j | | |7| j j d|rdnd| j |j j | n*| j j d|rdnd| j |rt j | _
dS | d| _ dS )a Invalidate the DBAPI connection held by this :class:`._ConnectionRecord`.
This method is called for all connection invalidations, including
when the :meth:`._ConnectionFairy.invalidate` or
:meth:`_engine.Connection.invalidate` methods are called,
as well as when any
so-called "automatic invalidation" condition occurs.
:param e: an exception object indicating a reason for the invalidation.
:param soft: if True, the connection isn't closed; instead, this
connection will be recycled on next checkout.
.. versionadded:: 1.0.3
.. seealso::
:ref:`pool_connection_invalidation`
Nz*%sInvalidate connection %r (reason: %s:%s)zSoft z%sInvalidate connection %r) rp r rB soft_invalidater rl r __class__r# r _soft_invalidate_timer r r softs r r z _ConnectionRecord.invalidate! s
, ? " F F K 0 0 $ J J J J K + +DOT1 E E E = K # #< 'R $
K # #, 'R
#)-D & & & LLNNN "DOOOr c d}| j .| j | n| j j dk rQt
j | j z
| j j k r(| j j d| j d}nt| j j | j k r(| j j d| j d}n7| j
| j k r'| j j d| j d}|rA| | j | | j S )NFr- z)Connection %r exceeded timeout; recyclingTz=Connection %r invalidated due to pool invalidation; recyclingzCConnection %r invalidated due to local soft invalidation; recycling) rp r clearr r r: r r rl r; r r )r rH s r r z _ConnectionRecord.get_connectionQ sO ? " IOO NN K 2 % % dn,t{/CCC K # #;T_
GG
[
)DN
:
: K # #
GG
'$.
8
8 K # #
G LLNNN IOO NN r c | j | j j j r%| j j | j | | j | j d | _ d S r )r r r rB r rp rq rT s r __closez_ConnectionRecord.__close sg $$&&& ; % > K & &t = = = %%do666 r c d | j }d | _ t j | _ | | }|j d| || _ |r=|j j |j
| j | |j j r"|j | j | d S d S # t $ rW}t j 5 |j d| d d d n# 1 swxY w Y Y d }~d S Y d }~d S d }~ww xY w)NzCreated new connection %rzError on connect(): %s)r rp r r rW rl rm rB
first_connect
for_modifyexec_once_unless_exceptionr rn r r )r r r rp r s r __connectz_ConnectionRecord.__connect s { = !Y[[DN --d33J K 9: F F F (DO
#
D
+66M ,,T_dCCC}$
=
%%dot<<<<<
=
= ? ? ?"$$
?
? !!":A>>>
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
? ?s< AC
D/D*+ D D*D D*D D**D/)T)FNF)r# r$ r% r& rP r r rp r r memoized_propertyr r classmethodr r r r r r r r r r r r' r r r{ r{ sW >) ) ) ) IIJ $
[*) ) ) * * X* X .# .# .# .#`. . . ` = = = = = =r r{ c t | ||j |urdS | J |j } | |r |r|j d| |pt
| || }|j | u sJ | | |s;|j j r|j | |
| na# t $ rT}|j dd |r|
| t |t s Y d}~nd}~ww xY w|r |j | dS dS dS )zfCleanup for a :class:`._ConnectionFairy` whether or not it's already
been garbage collected.
Nz$Connection %r being returned to poolz!Exception during reset or similarTrj r )r discardr rp rl rm rw _resetrB close_detachedrq
BaseExceptionro r
isinstancern r )rp r` r r rA r r s r r r s
MM#$$$
&c 1 1 F!!!&1
K 6
- -t E #z1111 LL %
3=/ =M00<<<&&z222 K 3d
!
2!,,q,111 a++
$ . 8 D!!#####$ $ D Ds A0C
D$A
D D$c e Zd ZdZd ZdZ dZ dZ edd Z d Z
d Z e Z d Z
ed Zed Zej d
Zed Zdd
Zd Zd Zd Zd ZdS )rw ab Proxies a DBAPI connection and provides return-on-dereference
support.
This is an internal object used by the :class:`_pool.Pool` implementation
to provide context management to a DBAPI connection delivered by
that :class:`_pool.Pool`.
The name "fairy" is inspired by the fact that the
:class:`._ConnectionFairy` object's lifespan is transitory, as it lasts
only for the length of a specific DBAPI connection being checked out from
the pool, and additionally that as a transparent proxy, it is mostly
invisible.
.. seealso::
:class:`._ConnectionRecord`
c 0 || _ || _ || _ d S r )rp r~ _echo)r r r` rA s r rP z_ConnectionFairy.__init__ s *"3
r Nc |sCt | }||_ d|_ |t j | |_ |j t j d |xj dz
c_ |j
j s|j r |j dk r|S d}|dk r |j r|j r |j
d|j |j |j }|s:|j r |j
d|j t j |j
|j |j | |S # t j $ r}|j rN|j
d| |j | | ||d n;|j
d
|j | |j | |j |_ n\# t2 $ rO}t5 j 5 |j | d d d n # 1 swxY w Y Y d }~nd }~ww xY w|dz }Y d }~nd }~ww xY w|dk |j
d | t j d ) Nr zThis connection is closedra r z Pool pre-ping on connection %sz;Pool pre-ping on connection %s failed, will invalidate poolzoDisconnection detected on checkout, invalidating all pooled connections prior to current timestamp (reason: %r)F)r zVDisconnection detected on checkout, invalidating individual connection %s (reason: %r)z+Reconnection attempts exhausted on checkout) r{ r _pool_counterr r r rp r InvalidRequestErrorrB r= r rl rm rD r" InvalidatePoolErrorr~ DisconnectionErrorinvalidate_poolr r r r rn r r r )r r threadconnsr attemptsresultr r s r rx z_ConnectionFairy._checkout su 9%..t44E EK EN&&-k%&8&8 # #)*EFF F
!
& /3~
^q
L ll/
> 8 { )) N "] 2 253C D DF! 8 ; K - -!7 % 0
" 5 7 77
&&$e&> )
$ ;K$$9 ,77:::$$UA$>>>>K$$M ( ,77:::F 0??AA $$ ! F F F *,, F F 0@@EEEF F F F F F F F F F F F F F FF A
5
- lld
FGGG
%&ABBBsh B0E I7 BI2- H I2
I%I )I I I I I I I2 I%%I22I7c D t | j | S N)r )rw rx r rT s r r z#_ConnectionFairy._checkout_existingW s ))$*D)AAAr c t t | j | j | j d | j | d | _ d | _ d S r )r rp r~ r r rT s r r z_ConnectionFairy._checkinZ sK O # J J
"& r c B |j j r |j | | j |j t u r| j r*|j d| j | j rdnd | j rW| j j
s0t j d |j
| d S | j d S |j
| d S |j t u r| j r*|j d| j | j rdnd | j rW| j j
s0t j d |j
| d S | j d S |j
| d S d S )Nz"Connection %s rollback-on-return%sz , via agentr zlReset agent is not active. This should not occur unless there was already a connectivity error in progress.z Connection %s commit-on-return%s)rB resetr~ r@ r r rl rm rp _reset_agent is_activer r rD r r r r r )r r s r r z_ConnectionFairy._reseth s = ? M d&= > > > N 2 2z
!!8O%)%6>MMB
0(2 1I<
M--d33333%..00000
))$/////
"l
2
2z
!!6O%)%6>MMB
.(2 /I<
M++D11111%,,.....
''-----% 3
2r c | j j S r )r rl rT s r _loggerz_ConnectionFairy._logger s
z r c | j duS )zbReturn True if this :class:`._ConnectionFairy` still refers
to an active DBAPI connection.N)rp rT s r r z_ConnectionFairy.is_valid s
d**r c | j j S )a Info dictionary associated with the underlying DBAPI connection
referred to by this :class:`.ConnectionFairy`, allowing user-defined
data to be associated with the connection.
The data here will follow along with the DBAPI connection including
after it is returned to the connection pool and used again
in subsequent instances of :class:`._ConnectionFairy`. It is shared
with the :attr:`._ConnectionRecord.info` and
:attr:`_engine.Connection.info`
accessors.
The dictionary associated with a particular DBAPI connection is
discarded when the connection itself is discarded.
)r~ r rT s r r z_ConnectionFairy.info s " &++r c , | j r | j j S dS )a Info dictionary associated with the :class:`._ConnectionRecord
container referred to by this :class:`.ConnectionFairy`.
Unlike the :attr:`._ConnectionFairy.info` dictionary, the lifespan
of this dictionary is persistent across connections that are
disconnected and/or invalidated within the lifespan of a
:class:`._ConnectionRecord`.
.. versionadded:: 1.1
N)r~ r rT s r r z _ConnectionFairy.record_info s " *6 64r Fc | j t j d dS | j r | j || |s d| _ | dS dS )a Mark this connection as invalidated.
This method can be called directly, and is also called as a result
of the :meth:`_engine.Connection.invalidate` method. When invoked,
the DBAPI connection is immediately closed and discarded from
further use by the pool. The invalidation mechanism proceeds
via the :meth:`._ConnectionRecord.invalidate` internal method.
:param e: an exception object indicating a reason for the invalidation.
:param soft: if True, the connection isn't closed; instead, this
connection will be recycled on next checkout.
.. versionadded:: 1.0.3
.. seealso::
:ref:`pool_connection_invalidation`
Nz.Can't invalidate an already-closed connection.)r r )rp r r r~ r r r s r r z_ConnectionFairy.invalidate ss , ? " IF G G G F " ? # . . . > > > "DO MMOOOOO r c & | j j |i |S )zReturn a new DBAPI cursor for the underlying connection.
This method is a proxy for the ``connection.cursor()`` DBAPI
method.
)rp cursor)r argskwargss r r z_ConnectionFairy.cursor s &t%t6v666r c , t | j | S r )r rp )r keys r __getattr__z _ConnectionFairy.__getattr__ s t,,,r c n | j | j }t | d|_ d|_ | j | j | j | _ d| _ | j j j
r)| j j
| j | dS dS dS )a" Separate this connection from its Pool.
This means that the connection will no longer be returned to the
pool when closed, and will instead be literally closed. The
containing ConnectionRecord is separated from the DB-API connection,
and will create a new connection when next used.
Note that any overall connection limiting constraints imposed by a
Pool implementation may be violated after a detach, as the detached
connection is removed from the pool's knowledge and control.
N) r~ r remover rp r r r copyrB detachr s r r z_ConnectionFairy.detach s " .)C LL CM !CN J & &t'> ? ? ? ((DI&*D #z")
A
#**4?C@@@@@ / .
A
Ar c h | xj dz c_ | j dk r| d S d S )Nra r )r r rT s r r z_ConnectionFairy.close s8
=A MMOOOOO r )NNr )r# r$ r% r& rP rp r~ r r rx r r _closer r r r r r r r r r r r r r' r r rw rw sr &
JC L" MC MC MC [MC^B B B
'
'
' F(. (. (.T ! ! X! + + X+
, , ,$ X" >7 7 7- - -A A A4 r rw r )r& collectionsr r r r r r r r r r
r> r r r
objectr
Identifiedr) r{ r setr rw r' r r r s -..t{>**
T[
&
&
6
6X$ X$ X$ X$ X$3> X$ X$ X$v
H= H= H= H= H= H= H= H=X ;?+$ +$ +$ +$\ z z z z z v z z z z z r