관리-도구
편집 파일: api.cpython-311.pyc
� IMg� � � � d Z ddlZddlZddlmZ ddlmZmZmZ ddl m Z m Z m Z ddl mZ ej e� � Zd� Z e e de� � � d � � � Zd eeee f fd �Zd eeee f fd �Zd eeeeef f fd�Zd ee fd�Zd ee fd�Zd efd�Zd e fd�Z d ee fd�Z d� Z dS )z/Gather information from Plesk via DB querries. � N)� defaultdict)�Dict�List�Sequence)� CheckRunError� check_run�retry_on��PanelExceptionc � � K � t | i |���)Nr )�args�kwargss �\/opt/imunify360/venv/lib/python3.11/site-packages/defence360agent/subsys/panels/plesk/api.py�raise_panel_exceptionr s � � � � �$� )�&� )� )�)� � )� max_tries�on_errorc � �^ K � t dddd| g� � � d {V ��� � � S )N�plesk�dbz-Nz-e)r �decode��querys r � _run_queryr s= � � � ��W�d�D�$�� >�?�?� ?� ?� ?� ?� ?� ?� G� G� I� I�Ir �returnc � � K � t d� � � d{V ��� � � } t t � � }t | ddd� | ddd� � � D ]&\ }}|dk r|| � |� � �'|S )z'Return mapping: user -> user's domains.z�select login, name from domains left join hosting on dom_id = domains.id right join sys_users on hosting.sys_user_id = sys_users.idNr � � �NULL)r �splitr �list�zip�append)�result�result_mapping�user�domains r �get_user_to_domainr) s� � � � � � L� � � � � � � � � �e�g�g� � !��&�&�N��F�1�4�a�4�L�&���A��,�7�7� 0� 0� ��f� �V� � � �4� � '� '�� /� /� /�� �r c � � K � t d� � � d{V ��� � � } d� t | ddd� | ddd� � � D � � S )z Return mapping: domain -> user.z�select name, login from domains left join hosting on dom_id = domains.id left join sys_users on hosting.sys_user_id = sys_users.idNc � � i | ] \ }}||g�� S � r, )�.0r( r' s r � <dictcomp>z&get_domain_to_user.<locals>.<dictcomp>4 s � � O� O� O�|�v�t�F�T�F� O� O� Or r r r )r r! r# )r% s r �get_domain_to_userr/ ) s~ � � � � � K� � � � � � � � � �e�g�g� � P� O�s�6�!�$�Q�$�<����1�� �/N�/N� O� O� O�Or c � �� K � i } t d� � � d{V ��}|� d� � D ]:}|s�|� d� � \ }}}||� dd� � d�| |< �;| S )z{ Returns dict with user to email and locale pairs Not used, because MyImunify implemented for cPanel only yet z9SELECT CONCAT(login, ';',email, ';',locale) FROM clients;N� �;�-�_)�email�locale)r r! �replace)� user_details�results�recordr' r5 r6 s r �get_user_detailsr; 7 s� � � � � �L� �C�� � � � � � � �G� �-�-��%�%� � ��� � � $�l�l�3� /� /���e�V�� �n�n�S�#�.�.� � � �T��� �r c � �T K � t d� � � d{V ��� � � S )zReturn: list of domainszselect name from domainsN�r r! r, r r � get_domainsr> N s5 � � � � � 7�8�8� 8� 8� 8� 8� 8� 8� ?� ?� A� A�Ar c � �T K � t d� � � d{V ��� � � S )z#Return: users that created by Pleskz�SELECT sys_users.login FROM sys_users JOIN hosting ON hosting.sys_user_id=sys_users.id JOIN domains ON hosting.dom_id=domains.id AND domains.webspace_id=0Nr= r, r r � get_usersr@ T sI � � � � � C� � � � � � � � � �e�g�g� r c � �J K � t t d� � � d{V ��� � S )z=Return: count active customers with at least one (any) domainz_select count(distinct cl_id) from clients c join domains d on d.cl_id = c.id where c.status = 0N)�intr r, r r �"count_customers_with_subscriptionsrC ` sJ � � � � �� 0� � � � � � � � � � � r c � �n K � t d� � � d {V ��} d� | � d� � D � � S )Nz-SELECT email FROM clients WHERE type='admin';c � � g | ]}|�|��S r, r, )r- r5 s r � <listcomp>z$get_admin_emails.<locals>.<listcomp>m s � � ;� ;� ;�e�U� ;�E� ;� ;� ;r r1 r= )�emailss r �get_admin_emailsrH k sF � � � � � M�N�N� N� N� N� N� N� N�F� ;� ;�v�|�|�D� 1� 1� ;� ;� ;�;r c � �X K � d} t | � � � d {V ��� � � S )Nz.SELECT DISTINCT hosting.www_root FROM hosting;r= r s r � list_docrootsrJ p s7 � � � � <�E� �U�#�#� #� #� #� #� #� #� *� *� ,� ,�,r c � �v K � d} t | � � � d {V ��}d� |� d� � D � � }|S )Nz�select hosting.www_root, domains.name, sys_users.login from hosting inner join domains on hosting.dom_id = domains.id inner join sys_users on hosting.sys_user_id=sys_users.idc �: � g | ]}|�|� � � ��S r, )r! )r- �strings r rF z/list_docroots_domains_users.<locals>.<listcomp>} s% � � F� F� F��v� F�f�l�l�n�n� F� F� Fr r1 r= )�sql�data�retvals r �list_docroots_domains_usersrQ u sT � � � � D� � �C� � � � � � � � �D� F� F�4�:�:�d�+;�+;� F� F� F�F� �Mr ) �__doc__�logging�re� collectionsr �typingr r r �defence360agent.utilsr r r �"defence360agent.subsys.panels.baser � getLogger�__name__�loggerr r �strr) r/ r; r> r@ rB rC r" rH rJ rQ r, r r �<module>r] s ��� � ���� � � � � #� #� #� #� #� #� '� '� '� '� '� '� '� '� '� '� D� D� D� D� D� D� D� D� D� D� =� =� =� =� =� =� �� �8� $� $��*� *� *� ��-�1�/D�E�E�E�J� J� F�E�J��$�s�D��I�~�"6� � � � �" P�$�s�D��I�~�"6� P� P� P� P� ��S�$�s�C�x�.�%8� 9� � � � �.B�4��9� B� B� B� B� ��c�� � � � ��#� � � � �<�� <� <� <� <� -�X�c�]� -� -� -� -� � � � � r