� wo4hD��(�ddlmZd�Zdd�Zdd�ZdS)�)� TemporaryFilec�<�|�dd��dS)N�||��maxsplitr)�split)�descriptions �i/opt/imunify360/venv/lib/python3.11/site-packages/defence360agent/migrations/070_modsec_incident_names.py�extract_namers ��T�A��.�.�q�1�1�Fc �� |jd� � fd�}td��5}|��D];\}}|�d�|t |��<|�d��|��5|D]}|�dd� ��\}} � �| � �� jt|��k�� ddd��n#1swxYwYddd��dS#1swxYwYdS)z� This migration extracts incident name from whole mod_security message Centos6 version of sqlite does not have instr(), using slow python-based way �incidentc3�R�K� ��j�j��jdk��j�d��Ed{V��dS#t$rYdSwxYw)N�modsecr) �select�idr �where�plugin�contains�tuples�iterator�RuntimeError)rs�r�select_incidentsz!migrate..select_incidentss�� X�-A�B�B��x��(�2�3�3��x�+�4�4�T�:�:�;�;�� F�F� ��s�BB� B&�%B&zw+)�modez{},{} r�,rr)�nameN)�ormr�write�formatr�seek�atomicr �update�striprr�int�execute)�migrator�database�fake�kwargsr�f�id_�desc�linerrs @r�migrater/s��|�J�'�H� � � � � � �D� !� !� !� �Q�)�)�+�+� ?� ?�I�C�� G�G�I�$�$�S�,�t�*<�*<�=�=�>�>�>�>� ��q� � � � �_�_� � � � �� J�J�s�Q�J�7�7� ��T��T�Z�Z�\�\��2�2�8�8��K�3�s�8�8�+��'�)�)�)�)� � � � � � � � � � � � �� s7�A0D<�BD$�D<�$D( �(D<�+D( �,D<�r4sY��"�"�"�"�"�"�2�2�2��B � � � � � r