/var/opt/nydus/ops/mysql/connector/__pycache__
Edit: /var/opt/nydus/ops/mysql/connector/__pycache__/pooling.cpython-312.pyc (27393B)
N jb U d Z ddlmZ ddlZddlZddlZddlZddlmZ ddl m
Z
m Z m Z m
Z
mZmZmZmZ ddlmZ ddlZddlZdZ d d
lmZ d d lm Z d d l m Z m Z d d
l m!Z!m"Z"m#Z#m$Z$m%Z% d dl&m'Z' e
rd dl(m)Z) ejT Z+dZ,dZ- ej\ d Z/dZ0ee ne efZ1de2d< i Z3de2d< d dZ4 d!dZ5 d"dZ6d#d Z7 G d d Z8 G d d Z9y# e$ r dZY w xY w# e$ r dZY w xY w)$z5Implementing pooling of connections to MySQL servers. ) annotationsN)
TracebackType)
TYPE_CHECKINGAnyDictNoReturnOptionalTupleTypeUnion)uuid4TF )CMySQLConnection)MySQLConnection)
CNX_POOL_ARGSDEFAULT_CONFIGURATION)ErrorInterfaceErrorNotSupportedError PoolErrorProgrammingError)read_option_files)MySQLConnectionAbstract @ z[^a-zA-Z0-9._:\-*$#]z0MySQL Connector/Python C Extension not availablez Union[type, Tuple[type, ...]]MYSQL_CNX_CLASSz Dict[str, MySQLConnectionPool]_CONNECTION_POOLSPooledMySQLConnectionc d| v r| d n
t d i | }| j d du rt t t t
5 |t vrt d i | t |< nAt t | t r*t | j }d| v r| d |k7 r t d ddd t | j S # 1 sw Y !xY w# t $ r t d| d dw xY w)
z!Return a pooled MySQL connection. pool_nameuse_pureFN pool_sizez)Size can not be changed for active pools.z%Failed getting connection from pool '' )generate_pool_namegetr ImportError
ERROR_NO_CEXTCONNECTION_POOL_LOCKr MySQLConnectionPool
isinstancer" r get_connectionAttributeErrorr )kwargsr
check_sizes H/opt/nydus/tmp/pip-target-a90h98xg/lib/python/mysql/connector/pooling.py_get_pooled_connectionr1 P s +f 4{:L:Vv:V zz* &+;+C-((
- -+>+H+H i (
))46I
J*95??Jf$ )<
)J KLL
+::<<
3I;a @
s A C )C C C&c ` | j } |d }|d= t g d }d}|D ] }t |j |z
}|r4t | dkD rdnd}d j
| }t d
| d | t |d r|dz
}|j d d
|d < |d dk s|d d
kD rt d|d t |d t rt d|d d|cxk rt | k r t d i } g }
t |d d D ]> }|d | vr |g| |d < |
j |d (| |d j | @ |
D ] } | | } t t | D ]y }
t | dz
}t! j" d| }| j% | }|j }|j' | |j% d d t) di |c c S t d # t $ r
t d dw xY w# t* $ r Y w xY w)a Return 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.
failoverz failover argument not providedN) userpasswordhostport unix_socketdatabaser r" priorityr r s z, z Unsupported connection argument z in failover: r: d z9Priority 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 | d S )Nr: r$ xs r0
z*_get_failover_connection.. s : T)keyreversez,Unable to connect to any of the target hostsr$ )copyKeyError
ValueErrorsetkeyslenjoinhasattrr& r r+ intr sortedappendrangerandomrandintpopupdateconnectr )r. configr3 support_cnx_argspriority_countserverdiffarglstserver_directoryserver_priority_listr:
failover_list_lastindex
new_configs r0 _get_failover_connectionrd m s [[]FE*% z
N6;;=!$44 TQ #BC))D/C 23%~cUK
6: & a N #ZZ
C 8z * !VJ%7#%=
+,.
&,c2 $Z 0 13
% . >)CM)
* '>M * %5 54:8 VJ / 0 ' 'z(: ; VJ / 0 7 7 ? N )(2
s=)*A}%)DNN1d+E"&&u-F J f % NN:t ,
,,, + ) G
HHU E9:DEL
s H +
H!H ! H-,H-c ^ dv rj d nd}t |t s t d |rt s t d dv r t d dv r t d d v r t d
d vr t
d d < t j j d d }g }|D ]P }|j |j j d |j |j |j d R |j# d |D cg c]
}|d |d d c}d < dv rd d< j d dv rt% di }t' di |S d v r t) di S t+ fdt, D r t/ di S j3 dd }dv rd= |st4 t7 t8 t4 r
|s t5 | i S t; | i S # t j j $ r t d
d d dw xY wc c}w # t0 $ r Y w xY w)a Creates or gets 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`.
When any connection pooling arguments are given, for example `pool_name`
or `pool_size`, a pool is created or a previously one is used to return
a `PooledMySQLConnection`.
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
`CMySQLConnection`) or a `PooledMySQLConnection` instance.
Examples:
A connection with the MySQL server can be established using either the
`mysql.connector.connect()` method or a `MySQLConnectionAbstract` subclass:
```
>>> from mysql.connector import MySQLConnection, HAVE_CEXT
>>>
>>> cnx1 = mysql.connector.connect(user='joe', database='test')
>>> cnx2 = MySQLConnection(user='joe', database='test')
>>>
>>> cnx3 = None
>>> if HAVE_CEXT:
>>> from mysql.connector import CMySQLConnection
>>> cnx3 = CMySQLConnection(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 documentationr8 z. s Qz]Qx[L$ArB )rC )r6 r7 read_default_file option_filesc 3 & K | ] }|v
y wNr$ ).0rC r. s r0 zconnect..4 s 6
sf}
s r! r$ ) rS r+ boolr HAVE_DNSPYTHONr dnsresolverquery exception DNSExceptionrO targetto_textr7 r: ri sortr rU rd anyr r1 NameErrorr& r r' r( r )argsr. rf srv_recordsr3 srvrc r! s ` r0 rU rU s R (1F':fjj#G gt $ GHH 8
F " N
V M
S
26 :F6N ,,,,VF^UCK C OO JJ . .d . C HH # !jj
A
BBJ
BJ3S[#f+ 6(
z
f$!'(;!<~
&' &00
$$$ V'1&11
6
6 6)3F3 3 7 zz*e,HV : , 4 m, , 000 D +F ++g }})) 26&>2B!D
"
*
s$ #G' H5"H '1H H,+H,c g }dD ] } |j t | | " |s t d dj | S # t $ r Y Lw xY w)zGenerate a pool name
This function takes keyword arguments, usually the connection
arguments for MySQLConnection, and tries to generate a name for
a pool.
Raises PoolError when no name can be generated.
Returns a string.
)r6 r7 r4 r9 z.Failed generating pool name; specify pool_namer` )rO strrF r rK )r. partsrC s r0 r% r% F s`
E3 LLVC[) * 4 HII 88E?
s A AAc l e Zd ZdZd
dZd dZ d dZd
dZddZe dd Z
e dd Z y )r a Class 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 t |t s t d t |t s t d || _ || _ y)zConstructor.
Args:
pool: A `MySQLConnectionPool` instance.
cnx: A `MySQLConnectionAbstract` subclass instance.
z$pool should be a MySQLConnectionPoolz cnx should be a MySQLConnectionN)r+ r* r- r _cnx_pool_cnx)selfpoolcnxs r0 __init__z PooledMySQLConnection.__init__q s? $ 34 !GH H#/ !BC C.2-0 rB c | S rn r$ r s r0 __enter__z PooledMySQLConnection.__enter__ s rB c $ | j y rn )close)r exc_type exc_value tracebacks r0 __exit__z PooledMySQLConnection.__exit__ s
rB c . t | j | S )z0Calls attributes of the MySQLConnection instance)getattrr )r attrs r0 __getattr__z!PooledMySQLConnection.__getattr__ s tyy$''rB c | j }| j j r|j | j j | d| _ y# | j j d| _ w xY w)a Do 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)r r
reset_sessionadd_connectionr r s r0 r zPooledMySQLConnection.close s_ ))C~~++!!# NN ) )# . DI
NN ) )# . DIs 2A $A;c t d )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 r0 rV z PooledMySQLConnection.config s
rB c . | j j S )zHReturns the name of the connection pool to which the connection belongs.)r r r s r0 r z PooledMySQLConnection.pool_name s ~~'''rB N)r r* r r returnNoner r )r zType[BaseException]r
BaseExceptionr r r r )r r r r )r r )r. r r r r r )
__name__
__module__ __qualname____doc__r r r r r staticmethodrV propertyr r$ rB r0 r r ^ sn $ 1 % ! !
( "
( (rB c e Zd ZdZ d ddZedd Zedd Zedd ZddZ ddZ
dd Z dd
Z ddd Z
dd Zdd
Zy)r* z*Class defining a pool of MySQL connectionsNc d| _ d| _ || _ | j | | j |xs t di | i | _ t j | j | _ t | _ |rJ | j di | d}|| j k r&| j |dz
}|| j k r%yyy)a Constructor.
Initialize a MySQL connection pool with a maximum number of
connections set to `pool_size`. The rest of the keywords
arguments, kwargs, are configuration arguments for MySQLConnection
instances.
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.
**kwargs: Optional additional connection arguments, as described in [1].
Examples:
```
>>> dbconfig = {
>>> "database": "test",
>>> "user": "joe",
>>> }
>>> cnxpool = mysql.connector.pooling.MySQLConnectionPool(pool_name = "mypool",
>>> pool_size = 3,
>>> **dbconfig)
```
References:
[1]: https://dev.mysql.com/doc/connector-python/en/connector-python-connectargs.html
Nr r r$ )
_pool_size
_pool_name_reset_session_set_pool_size_set_pool_namer% _cnx_configqueueQueue
_cnx_queuer
_config_version
set_configr )r r" r pool_reset_sessionr. cnts r0 r z MySQLConnectionPool.__init__ s L *.)- 0 I& I E);)Ef)EF+-@E OOA
%w DOO %f %C'##%q ' rB c | j S )z(Returns the name of the connection pool.)r r s r0 r z MySQLConnectionPool.pool_name rB c | j S )z2Returns number of connections managed by the pool.)r r s r0 r" z MySQLConnectionPool.pool_size r rB c | j S )z!Returns whether to reset session.)r r s r0 r z!MySQLConnectionPool.reset_session s """rB c |syt 5 t } |j di | || _ t | _ ddd y# t $ r}t d| |d}~ww xY w# 1 sw Y yxY w)a Set 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$ )r) rU rV r r
r r- r )r r. test_cnxerrs r0 r z MySQLConnectionPool.set_config sx $
!
W"9 )&)#) ',w$ "
! "
W "Fse LMSVV
W
"
!s( A(2A A%A A%%A((A1c R |dk s |t kD rt dt || _ y)a Set 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.
r z8Pool size should be higher than 0 and lower or equal to N)CNX_POOL_MAXSIZEr- r )r r" s r0 r z"MySQLConnectionPool._set_pool_size s7 >Y)9 9 J#$&
$rB c t j | rt d| d t | t kD rt d| d || _ y)a Set 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- rJ CNX_POOL_MAXNAMESIZEr )r r s r0 r z"MySQLConnectionPool._set_pool_name) sO $ $Y / ;yk9V!WX X y> 0 0 ;yk !GH H#rB c t |t s t d | j j |d y# t
j $ r}t d |d}~ww xY w)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 MySQLConnectionAbstractFblock'Failed adding connection; queue is fullN)r+ r r r putr Fullr r r s r0 _queue_connectionz%MySQLConnectionPool._queue_connection7 s_ #/M
P OO 5 1zz P EFC O Ps ; A AA c t 5 | j s t d | j j r t d |s]t di | j } | j r)| j d r|j dk r t d | j |_ nt |t s t d | j | ddd y# t $ r Y Rw xY w# 1 sw Y yxY w) a Adds 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 availabler compress) z^Pool reset session is not supported with compression for MySQL server version 5.7.2 or earlierr Nr$ )r) r r r fullrU r server_versionr rF r pool_config_versionr+ r r r s r0 r z"MySQLConnectionPool.add_connectionJ s & "## HII##% IJJ 1 0 01 ++ , ,Z 8 . . : / ) +/*>*>'!#7#U
" "3 '= "
!( ) "
!s0 AC' 5C>C' C$!C'#C$$C''C0c t 5 | j j d }|j
r| j |j k7 r> |j di | j |j | j |_ t | | cddd S # t j $ r}t d |d}~ww xY w# t $ r | j | w xY w# 1 sw Y yxY w)a Gets 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.
Fr z)Failed getting connection; pool exhaustedNr$ )r) r r& r Emptyr is_connectedr r rV r reconnectr r r r s r0 r, z"MySQLConnectionPool.get_connection} s "
Voo)))6
$$&''3+B+BB
.T - -.MMO
+/*>*>'(s3' "
! ;;
V KLRUU
V & **3/ "
!sF C' B!AC'+C; C'!C4 C CC' C$$C''C0c Z t 5 d}| j }|j r9 |j d }|j |dz
}|j r9|cddd S # t
j $ r |cY cddd S t $ r t $ r Y Ow xY w# 1 sw Y yxY w)zClose all connections
This method closes all connections. It returns the number
of connections it closed.
Used mostly for tests.
Returns int.
r Fr r N) r) r qsizer&
disconnectr r r r )r r cnxqr s r0 _remove_connectionsz'MySQLConnectionPool._remove_connections s "C??D**,
(((/CNN$1HC **, ! "
! {{ J "
! ! "
!s@ B!'A*B! B!*B ?B!
B B! B B!!B*)r NT)
r" rM r z
Optional[str]r rq r. r r r r )r rM )r rq )r. r r r )r" rM r r )r r r r )r r r r rn )r z!Optional[MySQLConnectionAbstract]r r r )r r r r r r r r" r r r r r r r, r r$ rB r0 r* r* s 4 #'#' 66 !6 ! 6
6
6p # # W<
$ $ P&1(f"4HrB r* )r. r r r )r. r r 5Union[PooledMySQLConnection, MySQLConnectionAbstract])r} r r. r r r )r. r r r ):r
__future__r r rQ re threadingtypesr typingr r r r r r
r r uuidr
dns.exceptionrs dns.resolverrr r' connection_cextr
connectionr constantsr r errorsr r r r r optionfilesr abstractsr RLockr) r r compiler r( r __annotations__r r1 rd rU r% r r* r$ rB r0 r sJ : < "
S S S N 1 ( ; +2&y( RZZ 78 B
'/OoGW5X . 57 1 6:ZIZI:ZIzy, y, y,:y,x0Q( Q(hI IM N s# C" C/ "C,+C,/C98C9