o ƒ¡g¬ã@s\dZddlZddlmZGdd„dejƒZGdd„dƒZGdd „d eƒZGd d „d eƒZdS) z`Connection pooling for psycopg2 This module implements thread-safe (and not) connection pools. éN)Ú extensionsc@s eZdZdS)Ú PoolErrorN)Ú__name__Ú __module__Ú __qualname__©rrúb/var/www/primordialfields.com/dashboard_backend/venv/lib/python3.10/site-packages/psycopg2/pool.pyr src@sFeZdZdZdd„Zddd„Zdd„Zdd d „Zdd d „Zdd„Z dS)ÚAbstractConnectionPoolzGeneric key-based pooling code.cOsZt|ƒ|_t|ƒ|_d|_||_||_g|_i|_i|_d|_ t |jƒD]}|  ¡q$dS)zèInitialize the connection pool. New 'minconn' connections are created immediately calling 'connfunc' with given parameters. The connection pool will support a maximum of about 'maxconn' connections. FrN) ÚintÚminconnÚmaxconnÚclosedÚ_argsÚ_kwargsÚ_poolÚ_usedÚ_rusedÚ_keysÚrangeÚ_connect)Úselfr r ÚargsÚkwargsÚirrrÚ__init__'s   ÿzAbstractConnectionPool.__init__NcCsHtj|ji|j¤Ž}|dur||j|<||jt|ƒ<|S|j |¡|S)z;Create a new connection and assign it to 'key' if not None.N) Úpsycopg2ÚconnectrrrrÚidrÚappend©rÚkeyÚconnrrrr=s  ÿzAbstractConnectionPool._connectcCs|jd7_|jS)zReturn a new unique key.é)r©rrrrÚ_getkeyGszAbstractConnectionPool._getkeycCs€|jrtdƒ‚|dur| ¡}||jvr|j|S|jr/|j ¡|j|<}||jt|ƒ<|St|jƒ|j kr;tdƒ‚|  |¡S)ú9Get a free connection and assign it to 'key' if not None.úconnection pool is closedNzconnection pool exhausted) r rr$rrÚpoprrÚlenr rrrrrÚ_getconnLs   zAbstractConnectionPool._getconnFcCsÎ|jrtdƒ‚|dur|j t|ƒ¡}|durtdƒ‚t|jƒ|jkrM|sM|jsL|jj }|t j kr6|  ¡n|t j krF| ¡|j |¡n |j |¡n|  ¡|jrY||jvre|j|=|jt|ƒ=dSdS)zPut away a connection.r&Nz trying to put unkeyed connection)r rrÚgetrr(rr ÚinfoÚtransaction_statusÚ_extÚTRANSACTION_STATUS_UNKNOWNÚcloseÚTRANSACTION_STATUS_IDLEÚrollbackrr)rr!r r/ÚstatusrrrÚ_putconn_s*    €þzAbstractConnectionPool._putconnc CsP|jrtdƒ‚|jt|j ¡ƒD]}z| ¡Wqty"Yqwd|_dS)z×Close all connections. Note that this can lead to some code fail badly when trying to use an already closed connection. If you call .closeall() make sure your code can deal with it. r&TN)r rrÚlistrÚvaluesr/Ú Exception)rr!rrrÚ _closeall‚s  ÿ z AbstractConnectionPool._closeall©N)NF) rrrÚ__doc__rrr$r)r3r7rrrrr $s    #r c@s"eZdZdZejZejZej Z dS)ÚSimpleConnectionPoolz@A connection pool that can't be shared across different threads.N) rrrr9r r)Úgetconnr3Úputconnr7Úcloseallrrrrr:“s  r:c@s4eZdZdZdd„Zd dd„Zd dd „Zd d „ZdS)ÚThreadedConnectionPoolz7A connection pool that works with the threading module.cOs2ddl}tj|||g|¢Ri|¤Ž| ¡|_dS)zInitialize the threading lock.rN)Ú threadingr rÚLockÚ_lock)rr r rrr?rrrržsÿÿÿzThreadedConnectionPool.__init__NcCs.|j ¡z | |¡W|j ¡S|j ¡w)r%)rAÚacquirer)Úrelease)rr rrrr;¥s  zThreadedConnectionPool.getconnFcCs6|j ¡z| |||¡W|j ¡dS|j ¡w)zPut away an unused connection.N)rArBr3rC)rr!r r/rrrr<­s zThreadedConnectionPool.putconncCs0|j ¡z | ¡W|j ¡dS|j ¡w)z6Close all connections (even the one currently in use.)N)rArBr7rCr#rrrr=µs  zThreadedConnectionPool.closeallr8)NNF)rrrr9rr;r<r=rrrrr>›s    r>) r9rrr-ÚErrorrr r:r>rrrrÚs o