Edit File: 135_export_proactive.cpython-311.opt-1.pyc
� �*vh� � � � d dl Z d dlZd dlZ ej e� � Zd\ ZZdZd� e� � Z dZ d� Z d d�Z d d �ZdS ) � N)z proactive.csvzproactive_env.csvz�SELECT id, timestamp, ip, ip_int, ip_version, ip_country_id, description, action, host, path, url, count, uid, gid, rule_id, rule_name FROM proactive ORDER BY timestamp DESC LIMIT ?z� SELECT proactive_env.event_id, proactive_env.name, proactive_env.value FROM proactive_env INNER JOIN ({}) pa ON proactive_env.event_id=pa.id z%/var/lib/imunify360-php-daemon/exportc �\ � t t ft t ffD ]�\ }}| � ||f� � }t t j � ||� � ddd�� � 5 }t j |� � }|� |� � d d d � � n # 1 swxY w Y ��d S )N�w� zutf-8)�newline�encoding) � PROACTIVE_CSV� PROACTIVE_SQL�PROACTIVE_ENV_CSV�PROACTIVE_ENV_SQL� execute_sql�open�os�path�join�csv�writer� writerows)�database� target_dir� events_num�filename�query�cur�csvfile� csv_writers �d/opt/imunify360/venv/lib/python3.11/site-packages/defence360agent/migrations/135_export_proactive.py�exportr s� � � � �&� � -�.� � &� &���%� �"�"�5�:�-�8�8�� � �G�L�L��X� .� .� �� � � � � &� � ��G�,�,�J� � � �� %� %� %� &� &� &� &� &� &� &� &� &� &� &���� &� &� &� &�� &� &s �**B � B$ �'B$ Fc �� � |rd S t j t d�� � t |t d� � d S # t $ r t � d� � Y d S w xY w)NT)�exist_oki� z'Failed to export proactive defence data)r �makedirs� EXPORT_DIRr � Exception�logger� exception��migratorr �fake�kwargss r �migrater) % s � � � ���D� � �J��.�.�.�.��x��T�*�*�*�*�*�� � D� D� D����B�C�C�C�C�C�C�D���s �19 �$A!� A!c � � d S )N� r% s r �rollbackr, 0 s � ��D� )F)r r �logging� getLogger�__name__r# r r r �formatr r! r r) r, r+ r- r �<module>r2 s� �� � � � � � � � � ���� �� �8� $� $��#G� � � �2� �� �F��� � � 5� � &� &� &� D� D� D� D� � � � � � r-
Back to File Manager