관리-도구
편집 파일: dbapi_proxy.cpython-311.pyc
� �܋f� � � � d Z ddlmZ ddlmZ ddlmZ i Z ej dd� � d� � � Zd � Z G d � d e � � Z d S ) z�DBAPI proxy utility. Provides transparent connection pooling on top of a Python DBAPI. This is legacy SQLAlchemy functionality that is not typically used today. � )� QueuePool� )�util)� threadingz1.3zYThe :func:`.pool.manage` function is deprecated, and will be removed in a future release.c � � t | S # t $ r) t � | t | fi |��� � cY S w xY w)aH Return a proxy for a DB-API module that automatically pools connections. Given a DB-API 2.0 module and pool management parameters, returns a proxy for the module that will automatically pool connections, creating new connection pools for each distinct set of connection arguments sent to the decorated module's connect() function. :param module: a DB-API 2.0 database module :param poolclass: the class used by the pool module to provide pooling. Defaults to :class:`.QueuePool`. :param \**params: will be passed through to *poolclass* )�proxies�KeyError� setdefault�_DBProxy)�module�paramss �R/opt/cloudlinux/venv/lib64/python3.11/site-packages/sqlalchemy/pool/dbapi_proxy.py�manager s] � �,F��v�� �� � F� F� F��!�!�&�(�6�*D�*D�V�*D�*D�E�E�E�E�E�F���s � �0A�Ac � � t � � � D ]} | � � � �t � � � dS )zYRemove all current DB-API 2.0 managers. All pools and connections are disposed. N)r �values�close�clear)�managers r �clear_managersr 5 s= � � �>�>�#�#� � ��� � ����� �M�M�O�O�O�O�O� c �F � e Zd ZdZefd�Zd� Zd� Zd� Zd� Z d� Z d� Z d � Z d S ) r a Layers connection pooling behavior on top of a standard DB-API module. Proxies a DB-API 2.0 connect() call to a connection pool keyed to the specific connect parameters. Other functions and attributes are delegated to the underlying DB-API module. c �n � || _ || _ || _ i | _ t j � � | _ dS )z�Initializes a new proxy. module a DB-API 2.0 module poolclass a Pool class, defaulting to QueuePool Other parameters are sent to the Pool object's constructor. N)r �kw� poolclass�poolsr �Lock�_create_pool_mutex)�selfr r r s r �__init__z_DBProxy.__init__I s6 � � �� ����"����� �"+�.�"2�"2�� � � r c �D � t | j � � D ] }| j |= � d S �N)�listr �r �keys r r z_DBProxy.close\ s0 � ��� �#�#� � �C�� �3��� � r c �. � | � � � d S r! )r )r s r �__del__z_DBProxy.__del__` s � � � � � � � � � r c �, � t | j |� � S r! )�getattrr r# s r � __getattr__z_DBProxy.__getattr__c s � ��t�{�C�(�(�(r c �� � ��� � j �i ���} � j | S # t $ r� � j � � � |� j vrU�� dd � � � j ��� fd�fi � j ��}|� j |< |� j � � � cY S � j | � j � � � cY S # � j � � � w xY ww xY w)N� sa_pool_keyc �( �� �j j � i ���S r! )r �connect)�argsr r s ���r �<lambda>z#_DBProxy.get_pool.<locals>.<lambda>p s �� � 3�� � 3�T� @�R� @� @� r ) � _serializer r r �acquire�popr r �release)r r. r r$ �pools ``` r �get_poolz_DBProxy.get_poolf s* ���� � �d�o�t�*�r�*�*�� 2��:�c�?� "��� 2� 2� 2� � #� +� +� -� -� -� 2��d�j�(�(��F�F�=�$�/�/�/�)�4�>�@�@�@�@�@�@� � �DH�G� � �D� '+�D�J�s�O� � �'�/�/�1�1�1�1�1�1� �:�c�?��'�/�/�1�1�1�1�1�1���'�/�/�1�1�1�1���� 2���s. � �#C(�AC �C(�! C �-C(� C$�$C(c �@ � | j |i |��� � � S )a, Activate a connection to the database. Connect to the database using this DBProxy's module and the given connect arguments. If the arguments match an existing pool, the connection will be returned from the pool's current thread-local connection instance, or if there is no thread-local connection instance it will be checked out from the set of pooled connections. If the pool has no available connections and allows new connections to be created, a new database connection will be made. )r5 r- �r r. r s r r- z_DBProxy.connecty s' � � �t�}�d�)�b�)�)�1�1�3�3�3r c �T � | j |i |��} | j |= dS # t $ r Y dS w xY w)z;Dispose the pool referenced by the given connect arguments.N)r0 r r )r r. r r$ s r �disposez_DBProxy.dispose� sN � � �d�o�t�*�r�*�*�� �� �3������ � � � �D�D� ���s � � '�'c � �� d�v r�d S t t |� � �fd�t �� � D � � z � � S )Nr+ c �$ �� g | ] }|�| f�� S � r< )�.0�kr s �r � <listcomp>z'_DBProxy._serialize.<locals>.<listcomp>� s! �� �"B�"B�"B�!�A�r�!�u�:�"B�"B�"Br )�tupler" �sortedr7 s `r r0 z_DBProxy._serialize� sM �� � �B� � ��m�$� $��T�$�Z�Z�"B�"B�"B�"B�v�b�z�z�"B�"B�"B�B�C�C�Cr N) �__name__� __module__� __qualname__�__doc__r r r r& r) r5 r- r9 r0 r< r r r r @ s� � � � � � �� � *3� 3� 3� 3� 3�& � � �� � �)� )� )�2� 2� 2�&4� 4� 4� � � �D� D� D� D� Dr r N) rE �implr � r r r � deprecatedr r �objectr r< r r �<module>rJ s� ��� � � � � � � � � � � � � � � � � � � � �� �� � �#�� � F� F� � � F�.� � �VD� VD� VD� VD� VD�v� VD� VD� VD� VD� VDr