Edit File: mysql_lib.cpython-311.opt-1.pyc
� � e � �� � d dl Z d dlmZ d dlZd dlmZ n$# e$ r d dlZd dlmZ n # e$ r dZY nw xY wY nw xY wd dl m Z d dl m Z dZ dZdZ G d � d � � Zd � Zd efd �ZdS )� N)�Optional)� DictCursor)� load_fast)� NoPackagez/etc/psa/psa.confz /etc/my.cnfz/etc/mysql/my.cnfc � � e Zd Zddefd�Zd� Zd� Zdd�Zdd �Zdd �Z d � Z e d � � � Z dd e dee defd�Zede deddfd�� � ZdS )�MySQLConnectorF�as_dictc �� � t �t d� � �| � |� dd� � |� � d | _ |rt nd | _ || _ d S )NzFCan not connect to database; MySQL-client libraries are not installed.�host� localhost)�pymysqlr � add_unix_socket_if_localhost�get� _connectionr � _cursor_type�_connect_kwargs)�selfr �kwargss ��/builddir/build/BUILDROOT/alt-python27-cllib-3.3.5-1.el8.cloudlinux.x86_64/opt/cloudlinux/venv/lib/python3.11/site-packages/clcommon/mysql_lib.py�__init__zMySQLConnector.__init__# si � � �?��X�� � � �)�)�&�*�*�V�[�*I�*I�6�R�R�R� ���*1� ;�J�J�t��� %�� � � � c �* � | � � � S �N)�connect�r s r � __enter__zMySQLConnector.__enter__/ s � ��|�|�~�~� r c �. � | � � � d S r )�close)r �exc_type� exc_value� tracebacks r �__exit__zMySQLConnector.__exit__2 s � � � � � � � � � r �returnc �< � t j di | j ��| _ | S )N� )r r r r r s r r zMySQLConnector.connect5 s" � �"�?�B�B�T�-A�B�B���� r Nc �J � | j �| j � � � d S d S r )r r r s r r zMySQLConnector.close9 s. � � � � '� � � "� "� $� $� $� $� $� (� 'r c �J � | j �| j � � � d S d S r )r �commitr s r r( zMySQLConnector.commit= s. � � � � '� � � #� #� %� %� %� %� %� (� 'r c �@ � | j � | j � � S r )� connection�cursorr r s r r+ zMySQLConnector.cursorA s � ���%�%�d�&7�8�8�8r c �F � | j �| � � � | j S r )r r r s r r* zMySQLConnector.connectionD s! � � � � #� �L�L�N�N�N�� � r � sql_query�argsc �� � | j � | j � � 5 }|� ||�� � |� � � cddd� � S # 1 swxY w Y dS )z: Execute SQL query and return the result. )r. N)r* r+ r �execute�fetchall)r r- r. r+ s r � execute_queryz MySQLConnector.execute_queryJ s� � � �_� #� #�D�$5� 6� 6� %�&� �N�N�9�4�N� 0� 0� 0��?�?�$�$� %� %� %� %� %� %� %� %� %� %� %� %���� %� %� %� %� %� %s �+A�A � A r r c �D � | dk rd|vrt � � |d< dS dS dS )ag Add 'unix_socket' to kwargs if host is 'localhost'. It seems that when the host is set to 'localhost', establishing a connection through TCP/IP might encounter issues due to some MySQL configuration options. To prioritize a Unix socket connection, we should include the 'unix_socket' query parameter. r � unix_socketN)�get_unix_socket_path)r r s r r z+MySQLConnector.add_unix_socket_if_localhostR s= � � �;� � �=��#>�#>�$8�$:�$:�F�=� !� !� !� � �#>�#>r )F)r# r )r# Nr )�__name__� __module__� __qualname__�boolr r r" r r r( r+ �propertyr* �strr �tupler2 � staticmethod�dictr r% r r r r ! s � � � � � � &� &�� &� &� &� &� � � �� � �� � � �%� %� %� %�&� &� &� &�9� 9� 9� � � � �X� � %� %�s� %�(�5�/� %�U� %� %� %� %� � ;�3� ;�� ;�� ;� ;� ;� �\� ;� ;� ;r r c �P � t � | j | j � � | S )zF Get a modified RFC 1738 URL for a MySQL database connection. )r r r �query)�urls r �get_rfc1738_db_urirB a s# � � �/�/���#�)�D�D�D� �Jr r# c �` � t j � t � � r/t t d�� � } | � d� � }|�|S t t fD ]K}t j � |� � r*t |� � }|� d� � }|�|c S �LdS )z� Get the Unix socket path for MySQL connection. Check Plesk and MySQL config files for the socket path. If found, return that path. If not, return default socket path. � )� delimiter� MYSQL_SOCKETN�socketz/var/lib/mysql/mysql.sock)�os�path�isfile�PLESK_CONFIG_PATHr r �MY_CONFIG_PATH�MY_CONFIG_PATH2)�psa_conf�psa_conf_socket� my_conf_path�my_conf�my_conf_sockets r r5 r5 i s� � � �w�~�~�'�(�(� #� � .�#�>�>�>��"�,�,�~�6�6�� � &�"� "�'� �9� &� &� � �7�>�>�,� '� '� &� � �-�-�G� $�[�[�� 2� 2�N� �)�%�%�%�%�� &� &r )rH �typingr r �pymysql.cursorsr � ImportError�MySQLdb�MySQLdb.cursors�clcommon.clconfparsr � clcommon.cpapi.cpapiexceptionsr rK rL rM r rB r; r5 r% r r �<module>rZ sG �� � � � � � � � � � � +��N�N�N� +�*�*�*�*�*�*�� � /� /� /�/�!�!�!�!� /�.�.�.�.�.�.�� � � � �����������/���� *� )� )� )� )� )� 4� 4� 4� 4� 4� 4�'� � ��%��=;� =;� =;� =;� =;� =;� =;� =;�@� � �'�c� '� '� '� '� '� 's$ � �8�(�8�2�8�2�8�8