,hJSrSSKJr SSKrSSKrSSKrSSKJr SSKJr SSKJr SSKJ r SSKJ r SS KJ r SS KJ r SS KJ r SSKrS S KJr S SKJr S SKJr S SKJr S SKJr S SKJr S SKJr S SKJr SSKJr SSKJr SSKJr SSKJr SSKJr \R(aSSK J!r! "SS\5r""SS\"5r#"S S!\#5r$"S"S#\5r%"S$S%\5r&"S&S'\5r'"S(S)\5r(g)*zPool implementation classes. ) annotationsN)Any)cast)List)Optional)Set)Type) TYPE_CHECKING)Union)_AsyncConnDialect)_ConnectionFairy_ConnectionRecord)_CreatorFnType)_CreatorWRecFnType)ConnectionPoolEntry)Pool)PoolProxiedConnection)exc)util)chop_traceback)queue)Literal)DBAPIConnectionc\rSrSr%SrSr\RrS\ S'S\ S'SSSjjr SS jr SS jr SS jr SS jrSS jrSSjrSSjrS SjrS!SjrS SjrS SjrS SjrSrg)" QueuePool-aA :class:`_pool.Pool` that imposes a limit on the number of open connections. :class:`.QueuePool` is the default pooling implementation used for all :class:`_engine.Engine` objects other than SQLite with a ``:memory:`` database. The :class:`.QueuePool` class **is not compatible** with asyncio and :func:`_asyncio.create_async_engine`. The :class:`.AsyncAdaptedQueuePool` class is used automatically when using :func:`_asyncio.create_async_engine`, if no other kind of pool is specified. .. seealso:: :class:`.AsyncAdaptedQueuePool` F1Type[sqla_queue.QueueCommon[ConnectionPoolEntry]] _queue_classz+sqla_queue.QueueCommon[ConnectionPoolEntry]_poolc [R"X40UD6 URX%S9UlSU- UlUS:XaSOUUlX@l[R"5Ul g)a Construct a QueuePool. :param creator: a callable function that returns a DB-API connection object, same as that of :paramref:`_pool.Pool.creator`. :param pool_size: The size of the pool to be maintained, defaults to 5. This is the largest number of connections that will be kept persistently in the pool. Note that the pool begins with no connections; once this number of connections is requested, that number of connections will remain. ``pool_size`` can be set to 0 to indicate no size limit; to disable pooling, use a :class:`~sqlalchemy.pool.NullPool` instead. :param max_overflow: The maximum overflow size of the pool. When the number of checked-out connections reaches the size set in pool_size, additional connections will be returned up to this limit. When those additional connections are returned to the pool, they are disconnected and discarded. It follows then that the total number of simultaneous connections the pool will allow is pool_size + `max_overflow`, and the total number of "sleeping" connections the pool will allow is pool_size. `max_overflow` can be set to -1 to indicate no overflow limit; no limit will be placed on the total number of concurrent connections. Defaults to 10. :param timeout: The number of seconds to wait before giving up on returning a connection. Defaults to 30.0. This can be a float but is subject to the limitations of Python time functions which may not be reliable in the tens of milliseconds. :param use_lifo: use LIFO (last-in-first-out) when retrieving connections instead of FIFO (first-in-first-out). Using LIFO, a server-side timeout scheme can reduce the number of connections used during non-peak periods of use. When planning for server-side timeouts, ensure that a recycle or pre-ping strategy is in use to gracefully handle stale connections. .. versionadded:: 1.3 .. seealso:: :ref:`pool_use_lifo` :ref:`pool_disconnects` :param \**kw: Other keyword arguments including :paramref:`_pool.Pool.recycle`, :paramref:`_pool.Pool.echo`, :paramref:`_pool.Pool.reset_on_return` and others are passed to the :class:`_pool.Pool` constructor. )use_liforN) r__init__r!r" _overflow _max_overflow_timeout threadingLock_overflow_lock)selfcreator pool_size max_overflowtimeoutr$kws L/var/www/auris/envauris/lib/python3.13/site-packages/sqlalchemy/pool/impl.pyr&QueuePool.__init__IsZ@ d*r*&&y&D Y#,>R| 'nn.cURRUS5 g![Ra9 UR 5 UR 5 g!UR 5 f=ff=fNF)r"put sqla_queueFullclose _dec_overflowr-records r3_do_return_connQueuePool._do_return_connsS % JJNN65 ) % % ""$""$  %s A,AA,A((A,cURS:nU=(a URUR:nURRX R5$![ R a Of=fU(arURUR:aXU(dUR5$[R"SUR5UR5UR4-SS9eUR5(aVUR5$! [R"5 UR!5 SSS5 e!,(df  e=f=fUR5$)Nr%zSQueuePool limit of size %d overflow %d reached, connection timed out, timeout %0.2f3o7r)code)r(r'r"getr)r9Empty_do_getr TimeoutErrorsizeoverflow _inc_overflow_create_connectionr safe_reraiser<)r- use_overflowwaits r3rFQueuePool._do_gets&))B. D$2D2D D ::>>$ 6 6     DNNd.@.@@||~%&&:yy{DMMOT]]CD       ..00 &&(&&())(<<> !s5$AA/.A/DE(E9 E E EcURS:XaU=RS- slgUR URUR:aU=RS- slSSS5 gSSS5 g!,(df  g=f)Nr%r TFr(r'r,r-s r3rJQueuePool._inc_overflowsf    # NNa N  ~~ 2 22!#!  ! s1A7-A77 BcURS:XaU=RS-slgUR U=RS-slSSS5 g!,(df  g=f)Nr%r TrQrRs r3r<QueuePool._dec_overflowsG    # NNa N  NNa N! s A A!cURRS5 URURURR UR URURRURURURURURURURS9 $)NPool recreating) r/r0pre_pingr$r1recycleecho logging_namereset_on_return _dispatchdialect)loggerinfo __class___creatorr"maxsizer( _pre_pingr$r)_recyclerZ_orig_logging_name_reset_on_returndispatch_dialectrRs r3recreateQueuePool.recreates *+~~ MMjj((++^^ZZ((MMMM00 11mmMM  r5cURRS5nUR5 M.![Ra Of=fSUR 5- UlURRSUR55 g)NFrzPool disposed. %s) r"rDr;r9rErHr'r_r`statusr-conns r3disposeQueuePool.disposesr zz~~e, ##  TYY[ ,dkkm    !   r5c.URR$N)r"rcrRs r3rHQueuePool.sizeszz!!!r5cUR$rw)r)rRs r3r1QueuePool.timeouts }}r5c6URR5$rw)r"qsizerRs r3rsQueuePool.checkedinszz!!r5cTURR(a UR$S$)Nr)r"rcr'rRs r3rIQueuePool.overflows!%!3!3t~~::r5c~URRURR5- UR-$rw)r"rcr|r'rRs r3rtQueuePool.checkedouts-zz!!DJJ$4$4$66GGr5)r(r'r,r"r)N) g>@F) r.)Union[_CreatorFnType, _CreatorWRecFnType]r/intr0rr1floatr$boolr2rr>rreturnNonerr)rr)rz Literal[True])rrrrrstr)rr)rr)__name__ __module__ __qualname____firstlineno____doc__ _is_asyncior9Queuer!__annotations__r&r?rFrJr<rjrprmrHr1rsrIrt__static_attributes__r5r3rr-s&K C 76  E/:E/E/ E/  E/  E/E/N%"@  " =  "";Hr5rcN\rSrSr%SrSr\RrS\ S'\ "5r Sr g)AsyncAdaptedQueuePooliaAn asyncio-compatible version of :class:`.QueuePool`. This pool is used by default when using :class:`.AsyncEngine` engines that were generated from :func:`_asyncio.create_async_engine`. It uses an asyncio-compatible queue implementation that does not use ``threading.Lock``. The arguments and operation of :class:`.AsyncAdaptedQueuePool` are otherwise identical to that of :class:`.QueuePool`. Tr r!rN) rrrrrrr9AsyncAdaptedQueuer!rr rirrr5r3rrs. K$$C!"Hr5rc,\rSrSr\R rSrg)FallbackAsyncAdaptedQueuePoolirN)rrrrr9FallbackAsyncAdaptedQueuer!rrr5r3rrs 77Lr5rcJ\rSrSrSrS SjrS SjrS SjrS SjrSSjr Sr g )NullPooliaA Pool which does not pool connections. Instead it literally opens and closes the underlying DB-API connection per each connection open/close. Reconnect-related functions such as ``recycle`` and connection invalidation are not supported by this Pool implementation, since no connections are held persistently. The :class:`.NullPool` class **is compatible** with asyncio and :func:`_asyncio.create_async_engine`. cg)NrrrRs r3rmNullPool.status-sr5c$UR5 grw)r;r=s r3r?NullPool._do_return_conn0s  r5c"UR5$rw)rKrRs r3rFNullPool._do_get3s&&((r5c URRS5 URURURUR UR URURURURS9$)NrW)rYrZr[r\rXr]r^) r_r`rarbrerZrfrgrdrhrirRs r3rjNullPool.recreate6sg *+~~ MMMM00 11^^mmMM  r5cgrwrrRs r3rpNullPool.disposeD r5rNrrr)rrr) rrrrrrmr?rFrjrprrr5r3rrs  )   r5rc|\rSrSrSrSrSSSjjrSSjrSSjrSSjr SSjr SS jr SS jr SS jr S rg )SingletonThreadPooliHaA Pool that maintains one connection per thread. Maintains one connection per each thread, never moving a connection to a thread other than the one which it was created in. .. warning:: the :class:`.SingletonThreadPool` will call ``.close()`` on arbitrary connections that exist beyond the size setting of ``pool_size``, e.g. if more unique **thread identities** than what ``pool_size`` states are used. This cleanup is non-deterministic and not sensitive to whether or not the connections linked to those thread identities are currently in use. :class:`.SingletonThreadPool` may be improved in a future release, however in its current status it is generally used only for test scenarios using a SQLite ``:memory:`` database and is not recommended for production use. The :class:`.SingletonThreadPool` class **is not compatible** with asyncio and :func:`_asyncio.create_async_engine`. Options are the same as those of :class:`_pool.Pool`, as well as: :param pool_size: The number of threads in which to maintain connections at once. Defaults to five. :class:`.SingletonThreadPool` is used by the SQLite dialect automatically when a memory-based database is used. See :ref:`sqlite_toplevel`. Fc [R"X40UD6 [R"5Ul[R"5Ul[ 5UlX lgrw) rr&r*local_conn_fairyset _all_connsrH)r-r.r/r2s r3r&SingletonThreadPool.__init__ks? d*r*__& oo' 47E r5c URRS5 URURURUR UR URURURURURS9 $)NrW)r/rYrZrXr[r\r]r^) r_r`rarbrHrerZrdrfrgrhrirRs r3rjSingletonThreadPool.recreatewsn *+~~ MMiiMM^^00 11mmMM  r5cURHnUR5 M URR5 g![a M@f=f)zDispose of this pool.N)rr; Exceptionclearrns r3rpSingletonThreadPool.disposesHOOD  $    sA A Ac[UR5UR:aPURR5nUR 5 [UR5UR:aMOggrw)lenrrHpopr;r-cs r3_cleanupSingletonThreadPool._cleanupsI$//"dii/##%A GGI$//"dii/r5cHS[U5[UR54-$)Nz"SingletonThreadPool id:%d size: %d)idrrrRs r3rmSingletonThreadPool.statuss'3 tH  7   r5c>UR?g![a gf=frw)rcurrentAttributeErrorr=s r3r?#SingletonThreadPool._do_return_conns#  #   s  c[(a)[[URR 55nOURR 5nU(aU$UR 5n[R"U5URl[UR5UR:aUR5 URRU5 U$![ a Nf=frw)r rrrrrrKweakrefrefrrrHraddrs r3rFSingletonThreadPool._do_gets },djj.@.@.BCJJ&&(  # # %$[[^  t 499 , MMO A   sAC C,+C,c[[URR55nUbUR 5$[R "XR5$![ a N,f=frw)rrrr_checkout_existingr _checkoutr-recs r3connectSingletonThreadPool.connectsg 0')<)<)>?C--// ))$ <<    s(A A+*A+)rrrrHN)r)r.rr/rr2r)rrrrrr)rr)rrrrrrr&rjrprrmr?rFrrrr5r3rrHsX@K  :          " =r5rc\rSrSrSr\R S Sj5rSSjrSSjr SSjr SSjr SSjr SS jr SS jrS rg ) StaticPooliafA Pool of exactly one connection, used for all requests. Reconnect-related functions such as ``recycle`` and connection invalidation (which is also used to support auto-reconnect) are only partially supported right now and may not yield good results. The :class:`.StaticPool` class **is compatible** with asyncio and :func:`_asyncio.create_async_engine`. c[U5$rwrrRs r3 connectionStaticPool.connections  &&r5cg)NrrrRs r3rmStaticPool.statussr5cSUR;a@URRb(URR5 URS gggNr)__dict__rdbapi_connectionr;rRs r3rpStaticPool.disposesD DMM )00< OO ! ! # l+= *r5c URRS5 URURURUR UR URURURURS9$)NrW)r.rYr\rXrZr[r]r^) r_r`rarbrergrdrZrfrhrirRs r3rjStaticPool.recreatesg *+~~MMMM 11^^00mmMM  r5c"^SU4SjjnX lg)Nc>>TRRnUceU$rw)rr)rroother_static_pools r3r.*StaticPool._transfer_from..creators%$//@@D# ##Kr5)rrrr_invoke_creator)r-rr.s ` r3_transfer_fromStaticPool._transfer_froms  'r5c[5erw)NotImplementedErrorrRs r3rKStaticPool._create_connections !##r5cgrwrr=s r3r?StaticPool._do_return_connrr5czURnUR5(aURS URnU$r)r_is_hard_or_soft_invalidatedrrs r3rFStaticPool._do_gets4oo  + + - - l+//C r5rN)rrrr)rr)rrrrrr)rrrrrrmemoized_propertyrrmrprjrrKr?rFrrr5r3rrsD  '',  '$ r5rcj\rSrSr%SrS\S'S\S'SSjrSSjrSS jrSS jr SS jr SS jr S r g) AssertionPooliaaA :class:`_pool.Pool` that allows at most one checked out connection at any given time. This will raise an exception if more than one connection is checked out at a time. Useful for debugging code that is using more connections than desired. The :class:`.AssertionPool` class **is compatible** with asyncio and :func:`_asyncio.create_async_engine`. zOptional[ConnectionPoolEntry]rzOptional[List[str]]_checkout_tracebackcSUlSUlURSS5UlSUl[ R "U/UQ70UD6 g)NFstore_tracebackT)r _checked_outr_store_tracebackrrr&)r-argsr2s r3r&AssertionPool.__init__sC ! "'8$ ?#'  d(T(R(r5cg)NrrrRs r3rmAssertionPool.statussr5cjUR(d [S5eSUlXRLdeg)Nzconnection is not checked outF)rAssertionErrorrr=s r3r?AssertionPool._do_return_conns/   !@A A!###r5cjSUlUR(aURR5 ggr7)rrr;rRs r3rpAssertionPool.dispose#s&! :: JJ    r5c URRS5 URURURUR UR URURURURS9$)NrW)rZrXrYr\r[r]r^) r_r`rarbrZrdrergrfrhrirRs r3rjAssertionPool.recreate(sg *+~~ MM^^MM 1100mmMM  r5c~UR(aIUR(a(SSR[UR55-nOSn[ SU-5eUR (dUR 5UlSUlUR(a[R"5UlUR $)Nz at: %sz!connection is already checked outT) rrjoinrrrrKr traceback format_stack)r-suffixs r3rFAssertionPool._do_get5s   ''#bgg"4#;#;<' !Dv!MN Nzz002DJ   '0'='='?D $zzr5)rrrrN)rrr2rrrr)rrr) rrrrrrr&rmr?rprjrFrrr5r3rrs3  )(,,)$   r5r))r __future__rr*r typingrrrrrr r r rbaser rrrrrrrrrrrrr9 util.typingrengine.interfacesrrrrrrrrrr5r3rs#  #"# $%'!&! 3UHUHp#I#*8$98' t' Tw=$w=t>>BBDBr5