bh-e%SrSSKJr SSKrSSKrSSKrSSKrSSKrSSKJ r SSK J r J r J r JrJrJrJrJr SSKJrJr SSKJr SSKrSSKrSrS S KJrJrJ r J!r!J"r" S S K#J$r$J%r%J&r& S SK'J(r( \ (aS SK)J*r* \RV"5r,Sr-Sr.\R^"S5r0\(4r1S\2S'0r3S\2S'SSjr4S Sjr5S!Sjr6S"Sjr7"SS5r8"SS5r9g!\a S rNf=f)#z5Implementing pooling of connections to MySQL servers.) annotationsN) TracebackType) TYPE_CHECKINGAnyDictNoReturnOptionalTupleTypeUnion)UUIDuuid4) CNX_POOL_ARGSTF)ErrorInterfaceErrorNotSupportedError PoolErrorProgrammingError)DEFAULT_CONFIGURATIONgenerate_pool_nameread_option_files)MySQLConnection)MySQLConnectionAbstract @z[^a-zA-Z0-9._:\-*$#]zUnion[type, Tuple[type, ...]]MYSQL_CNX_CLASSzDict[str, MySQLConnectionPool]_CONNECTION_POOLSPooledMySQLConnectionc4# SU;aUSO [S0UD6nU[;aL[S0UD6nUR5IShvN [IShvN U[U'SSS5IShvN OI[ [U[5(a-[UR nSU;aUSU:wa [S5e[UR5IShvN $NNNr!,IShvN (df  N==fN$![a [SUS35Sef=f7f)z!Return a pooled MySQL connection. pool_nameN pool_sizez)Size can not be changed for active pools.z%Failed getting connection from pool '') rrMySQLConnectionPoolinitialize_poolCONNECTION_POOL_LOCK isinstancer#rget_connectionAttributeErrorr)kwargsr"pool check_sizes d/var/www/home/psychics-availability/venv/lib/python3.13/site-packages/mysql/connector/aio/pooling.py_get_pooled_connectionr0Ls +f4{:L:Vv:V ))",V,""$$$''+/ i (('' %i02E F F&y1;; & VK%8J%FGH H&y1@@BBB %''''C 3I;a @  s?DCDCD C D)C*AD9C:C8C:DDDC5$C' % C51D8C::DDc# UR5nUSnUS 1SknSnUHn[UR 55U- nU(a5[ U5S:aSOSnS R U5n[S US U35e[US 5(aUS- nURS S 5US 'US S:d US S :a[SUS 35e[US [5(aM[SUS 35e SUs=:a[ U5:aO O [S5e0n /n [USSS9H@nUS U ;aU/XS 'U RUS 5 M*XS RU5 MB U Hn Xn [[ U 55Hn [ U 5S- n[ R""SU5nU R%U5nUR5nUR'U5 UR%S S5 [)S0UD6IShvN s s $ M [S5e![a [S5Sef=fN3![*a Mf=f7f)aReturn a MySQL connection and try to failover if needed. An InterfaceError is raise when no MySQL is available. ValueError is raised when the failover server configuration contains an illegal connection argument. Supported arguments are user, password, host, port, unix_socket and database. ValueError is also raised when the failover argument was not provided. Returns MySQLConnection instance. failoverzfailover argument not providedN> hostportuserdatabasepasswordpriorityr"r# unix_socketrrsz, z Unsupported connection argument z in failover: r8dz9Priority value should be in the range of 0 to 100, got : zDPriority value should be an integer in the range of 0 to 100, got : z\You must either assign no priority to any of the routers or give a priority for every routerc US$)Nr8r%xs r/*_get_failover_connection..s:T)keyreversez,Unable to connect to any of the target hostsr%)copyKeyError ValueErrorsetkeyslenjoinhasattrgetrr)intrsortedappendrangerandomrandintpopupdateconnectr)r,configr2support_cnx_argspriority_countserverdiffarglstserver_directoryserver_priority_listr8 failover_list_lastindex new_configs r/_get_failover_connectionreis[[]FE*% z N6;;=!$44 TQ#BC))D/C23%~cUK  6: & & a N#ZZ C8z *  !VJ%7#%=  +,. &,c22 $Z013 %. >)CM)   '>M * %5 54:8 J/ 0 ' 'z(: ; J/ 0 7 7 ? N)(2 s=)*A}%)DNN1d+E"&&u-FJ   f % NN:t , $2z222+) G HHQ E9:DEF3  sYIH$C I'DI<I H> II$H;;I>I I I IIc^# ST;aTRS5OSn[U[5(d [S5eU(Ga [(d [S5eST;a [S5eST;a [S5eS T;a [S 5eS T;a [ S TS '[ RRTS S 5IS hvN n/nUHNnURURRSS9URURUR S.5 MP UR#SS9 UVs/sH oUS USS.PM snTS 'S T;a[%S0TD6IS hvN $['U4Sj[(55(a[+S0TD6IS hvN $ST;aTSTS'TRS5 ST;a[/S0TD6n[1S0UD6IS hvN $ST;aTS [3U0TD6nUR15IS hvN U$GNF![ RRa [STS S35S ef=fs snfNN![,a Nf=fNNY7f)aCreates a MySQL connection object. In its simpliest form, `connect()` will open a connection to a MySQL server and return a `MySQLConnectionAbstract` subclass object such as `MySQLConnection` or `CMySQLConnection`. Args: *args: N/A. **kwargs: For a complete list of possible arguments, see [1]. If no arguments are given, it uses the already configured or default values. Returns: A `MySQLConnectionAbstract` subclass instance (such as `MySQLConnection`) or a `PooledMySQLConnection` instance. Raises: `mysql.connector.errors.NotSupportedError`: if pooled connection is not supported for the Python version and OS that are being used. Examples: A connection with the MySQL server can be established using either the `mysql.connector.aio.connect()` method or a `MySQLConnectionAbstract` subclass: ``` >>> from mysql.connector.aio import MySQLConnection >>> >>> cnx1 = await mysql.connector.aio.connect(user='joe', database='test') >>> cnx2 = MySQLConnection(user='joe', database='test') >>> ``` References: [1]: https://dev.mysql.com/doc/connector-python/en/connector-python-connectargs.html dns_srvFz(The value of 'dns-srv' must be a booleanztMySQL host configuration requested DNS SRV. This requires the Python dnspython module. Please refer to documentationr9zs r/r@connect..sQz]Qx[L$ArB)rC)r3r4c3,># UH oT;v M g7fNr%).0rCr,s r/ connect.. s6 f} sread_default_file option_filesuse_purer%)rTr)boolrHAVE_DNSPYTHONrdns asyncresolverquery exception DNSExceptionrPtargetto_textr4r8rjsortreanyrr0 NameErrorrrVr)argsr,rg srv_recordsr2srvrdcnxs ` r/rVrVsH(1F':fjj#G gt $ $GHH~ 8  F " N  V  M    S   26:F6N  # 1 1 7 7v NNK C OOJJ..d.CHH # !jj    A BBJ BJ3[#f+ 6( z V-7777 6 6 6 6/9&99 9 7f$!'(;!<~ &'&00 *z***V :  4 *6 *C ++- JaO}}))  26&>2B!D  " 8 :    + sBI"!&HH H A*I"6I I"$I %I"*,II IAI"I+I"I I" H2I I" I II"II" I"c[Rn[RS:Xa-URS:XaUR S::a [ S5eggg)zSRaises error if the Python version and OS combination is not supported for Pooling.nt zSPooled connections are not supported for Python versions lower than 3.11 on WindowsN)sys version_infoosnamemajorminorr)py_version_infos r/_check_supportr7sR&&O ww$?00A5/:O:OSU:U )  ;V5rBc\rSrSrSrS SjrS SjrSSjrSSjrSSjr \ SSj5r \ SS j5r S rg )r iBahClass holding a MySQL Connection in a pool PooledMySQLConnection is used by MySQLConnectionPool to return an instance holding a MySQL connection. It works like a MySQLConnection except for methods like close() and config(). The close()-method will add the connection back to the pool rather than disconnecting from the MySQL server. Configuring the connection have to be done through the MySQLConnectionPool method set_config(). Using config() on pooled connection will raise a PoolError. Attributes: pool_name (str): Returns the name of the connection pool to which the connection belongs. c[5 [U[5(d [S5e[U[5(d [S5eXlX lg)zwConstructor. Args: pool: A `MySQLConnectionPool` instance. cnx: A `MySQLConnectionAbstract` subclass instance. z/pool must be an instance of MySQLConnectionPoolz,cnx should be an instance of MySQLConnectionN)rr)r&r+r _cnx_pool_cnx)selfr-rs r/__init__PooledMySQLConnection.__init__QsG $ 344 !RS S#// !OP P.2-0 rBc# U$7frnr%rs r/ __aenter__ PooledMySQLConnection.__aenter__`s  sc@# UR5IShvN gN7frn)close)rexc_type exc_value tracebacks r/ __aexit__PooledMySQLConnection.__aexit__cs jjls c.[URU5$)z0Calls attributes of the MySQLConnection instance)getattrr)rattrs r/ __getattr__!PooledMySQLConnection.__getattr__kstyy$''rBc# URnURR(a5UR5IShvN (aUR 5IShvN URR U5IShvN SUlgNLN1N!URR U5IShvN SUlf=f7f)aDo not close, but adds connection back to pool. For a pooled connection, close() does not actually close it but returns it to the pool and makes it available for subsequent connection requests. If the pool configuration parameters are changed, a returned connection is closed and reopened with the new configuration before being returned from the pool again in response to a connection request. N)rrcan_reset_session is_connected reset_sessionadd_connectionrrs r/rPooledMySQLConnection.closeosii ~~//#:J:J:L4L4L'')))..//4 4 4DI 5M) 4$..//4 4 4DIs\ C.BB BB B C>B? C B BCB>0B31 B>>Cc [S5e)zConfiguration is done through the pool. For pooled connections, the `config()` method raises a `PoolError` exception. Configuration for pooled connections should be done using the pool object. zKConfiguration for pooled connections should be done through the pool itself)r)r,s r/rWPooledMySQLConnection.configs   rBc.URR$)zHReturns the name of the connection pool to which the connection belongs.)rr"rs r/r"PooledMySQLConnection.pool_names~~'''rB)rrN)r-r&rrreturnNonerr )rzType[BaseException]r BaseExceptionrrrr)rrrrrr)r,rrrrstr)__name__ __module__ __qualname____firstlineno____doc__rrrrr staticmethodrWpropertyr"__static_attributes__r%rBr/r r Bsn  1%!!   (     ((rBc\rSrSrSrSSSjjrSSjr\SSj5r\SSj5r \SSj5r SS jr SS jr SS jr SS jrSSS jjrSSjrSSjrSSjrSrg)r&iz*Class defining a pool of MySQL connectionsNc [5 SUlSUlX0lUR U5 U(aUR U5 X@l[R"UR5Ul [5Ul g)aConstructor. Initialize a MySQL connection pool with a maximum number of connections set to `pool_size`. NOTE: The coroutine `await cnxpool.initialize_pool(**dbconfig)` must be called after initializing this class to open up the pool of required number of database connections and making the instance of MySQLConnectionPool ready-to-use. Contents of `dbconfig` is described in [1]. Args: pool_name: The pool name. If this argument is not given, Connector/Python automatically generates the name, composed from whichever of the host, port, user, and database connection arguments are given in kwargs, in that order. pool_size: The pool size. If this argument is not given, the default is 5. pool_reset_session: Whether to reset session variables when the connection is returned to the pool. Examples: ``` >>> dbconfig = { >>> "database": "test", >>> "user": "joe", >>> } >>> # initialize the MySQLConnectionPool instance >>> cnxpool = mysql.connector.aio.pooling.MySQLConnectionPool( >>> pool_name = "mypool", >>> pool_size = 3, >>> ) >>> # Open up the pool of connections >>> await cnxpool.initialize_pool(**dbconfig) >>> # cnxpool is ready to be used ... ``` References: [1]: https://dev.mysql.com/doc/connector-python/en/connector-python-connectargs.html N) r _pool_size _pool_name_reset_session_set_pool_size_set_pool_name _cnx_configasyncioQueue _cnx_queuer_config_version)rr#r"pool_reset_sessionr,s r/rMySQLConnectionPool.__init__shX )-)-$6 I&     *+1BI-- OOC &+WrBc# UR(dC[IShvN UR[S0URD65 SSS5IShvN UR(aeUR "S0URD6IShvN SnXR :a/UR5IShvN US- nXR :aM.gggNN}!,IShvN (df  N=fNdN=7f)aOpens the connection pool and fill with MySQL database connections. This coroutine must be called after initializing an instance of MySQLConnectionPool to make the build the pool of connections and make the instance ready to be used. Args: **kwargs: Connection arguments, as described in [1]. References: [1]: https://dev.mysql.com/doc/connector-python/en/connector-python-connectargs.html Nrrr%)rr(rrr set_configrr)rcnts r/r'#MySQLConnectionPool.initialize_pools++##$6$J9I9I$JK,+   //5D$4$45 5 5C'))+++q' ,+++ 6,shC0CC0%C C0C4C0C,(C00C.1C0 C0C0C)C  C)%C0.C0cUR$)z(Returns the name of the connection pool.)rrs r/r"MySQLConnectionPool.pool_namerBcUR$)z2Returns number of connections managed by the pool.)rrs r/r#MySQLConnectionPool.pool_sizerrBcUR$)z!Returns whether to reset session.)rrs r/r%MySQLConnectionPool.can_reset_sessions"""rBcb# U(dg[S0UD6IShvN nUR5IShvN [IShvN Xl[ 5UlSSS5IShvN gNQN;N.N !,IShvN (df  g=f![ an[SU35UeSnAff=f7f)aPSet the connection configuration for `MySQLConnectionAbstract` subclass instances. This method sets the configuration used for creating `MySQLConnectionAbstract` subclass instances such as `MySQLConnection`. See [1] for valid connection arguments. Args: **kwargs: Connection arguments - for a complete list of possible arguments, see [1]. Raises: PoolError: When a connection argument is not valid, missing or not supported by `MySQLConnectionAbstract`. References: [1]: https://dev.mysql.com/doc/connector-python/en/connector-python-connectargs.html Nz$Connection configuration not valid: r%)rV disconnectr(rrr Exceptionr)rr,rerrs r/rMySQLConnectionPool.set_configs  S)&))C.." " "++#) ',w$,++* "++++ SB3%HIs R Ss B/BA,BA.BA0BA4 B&A2'B+B/,B.B0B2B4B :A= ; B B B/ B B,B''B,,B/cTUS::d U[:a[S[35eXlg)zSet the size of the pool This method sets the size of the pool but it will not resize the pool. Raises an AttributeError when the pool_size is not valid. Invalid size is 0, negative or higher than pooling.CNX_POOL_MAXSIZE. rz8Pool size should be higher than 0 and lower or equal to N)CNX_POOL_MAXSIZEr+r)rr#s r/r"MySQLConnectionPool._set_pool_sizes5 >Y)99 J#$& $rBc[RU5(a[SUS35e[U5[:a[SUS35eXlg)zSet the name of the pool. This method checks the validity and sets the name of the pool. Raises an AttributeError when pool_name contains illegal characters ([^a-zA-Z0-9._\-*$#]) or is longer than pooling.CNX_POOL_MAXNAMESIZE. z Pool name 'z' contains illegal charactersz ' is too longN)CNX_POOL_NAMEREGEXsearchr+rJCNX_POOL_MAXNAMESIZEr)rr"s r/r"MySQLConnectionPool._set_pool_namesP  $ $Y / / ;yk9V!WX X y>0 0 ;yk!GH H#rBc[U[5(d [S5eURR U5 g![ R an[S5UeSnAff=f)zPut connection back in the queue This method is putting a connection back in the queue. It will not acquire a lock as the methods using _queue_connection() will have it set. Raises `PoolError` on errors. ;Connection instance not subclass of MySQLConnectionAbstract'Failed adding connection; queue is fullN)r)rrr put_nowaitr QueueFullrrrs r/_queue_connection%MySQLConnectionPool._queue_connection's_#//M  P OO & &s +   PEFC O Ps>A# AA#c# UR(d [S5eURR5(a [S5eU(dt[ S0URD6IShvN nUR (a3URS(aUR 5S:a [S5eURUl O [U[5(d [S5eURU5 gN![a NRf=f7f) aAdds a connection to the pool. This method instantiates a `MySQLConnection` using the configuration passed when initializing the `MySQLConnectionPool` instance or using the `set_config()` method. If cnx is a `MySQLConnection` instance, it will be added to the queue. Args: cnx: The `MySQLConnectionAbstract` subclass object to be added to the pool. If this argument is missing (aka `None`), the pool creates a new connection and adds it. Raises: PoolError: When no configuration is set, when no more connection can be added (maximum reached) or when the connection can not be instantiated. z&Connection configuration not availablerNcompress)rz^Pool reset session is not supported with compression for MySQL server version 5.7.2 or earlierrr%)rrrfullrVrget_server_versionrrFrpool_config_versionr)rrrs r/r"MySQLConnectionPool.add_connection8s$DE E ??   ! !EF F3$"2"233C ''((4..09<+%'+&:&:C #c?33Q s#-4  s8A&D(C6)D.AC82AD8 DDDDc# URR5nUR 5IShvN (aUR UR:waFUR"S0URD6 UR5IShvN UR Ul[X5$![Ran[ S5UeSnAff=fNNJ![a URU5 ef=f7f)aJGets a connection from the pool. This method returns an PooledMySQLConnection instance which has a reference to the pool that created it, and the next available MySQL connection. When the MySQL connection is not connect, a reconnect is attempted. Returns: A `PooledMySQLConnection` instance. Raises: PoolError: On errors. z)Failed getting connection; pool exhaustedNr%)r get_nowaitr QueueEmptyrrrr_set_connection_optionsr reconnectrrr rs r/r*"MySQLConnectionPool.get_connectionis R//,,.C &&(((##s'>'>> ++?d.>.>?mmo%%'+&:&:C #$T//!! RGHc Q R) &! &&s+ s[C2B&C2C#C2/CCC C2&C : CC  C2CC//C2cD# SnURnUR5(aEUR5nUR5IShvN US- nUR5(aMEU$N"![R a Us$[ a e[a NHf=f7f)aClose all connections This method closes all connections and returns the number of connections it closed. This method should be used internally while cleaning-up the connection pool by closing each and every active connection objects currently residing in the pool. Returns: An integer defining the number of open connections closed during clean-up. Raises: PoolError: On errors while fetching connections from the pool or while disconnecting an open connection. rNr)rqsizerrrrrr)rrcnxqrs r/_remove_connections'MySQLConnectionPool._remove_connectionssjjll oo'nn&&&q jjll '%%     sL$B #A/ A- A/B +B -A//BB BB BB c># UR5IShvN $N7f)aCleans up the connection pool This public method gracefully shuts down the connection pool by disconnecting all of the open connections currently active in the pool. Returns: An integer defining the number of open connections closed while shutting down the pool. Raises: PoolError: On errors while fetching connections from the pool or while disconnecting an open connection. N)rrs r/ close_poolMySQLConnectionPool.close_pools--////s )rrrrrr)rNT) r#rNr"z Optional[str]rrur,rrrrr)rrN)rru)r,rrr)r#rNrr)r"rrr)rrrrrn)rz!Optional[MySQLConnectionAbstract]rrr)rrrrrrr'rr"r#rrrrrrr*rrrr%rBr/r&r&s4#'#' 8-8-!8-! 8-  8-  8-t,##S6 $ $P$8</$4/$ /$b0>: 0rBr&)r,rrr )r,rr5Union[PooledMySQLConnection, MySQLConnectionAbstract])rrr,rrrr):r __future__rrrrRrertypesrtypingrrrrr r r r uuidr rmysql.connector.constantsrdns.asyncresolverrw dns.exceptionrv ImportErrorerrorsrrrrrpoolingrrr connectionr abstractsrLockr(rrcompilerr__annotations__rr0rerVrr r&r%rBr/rs:<" SSS3NSR'2||~ZZ 782A1C.C4616:XIXI:XIvp pp:pf L(L(^_0_0C NsC%%C0/C0