Edit File: 087_ignored_by_port_fields.cpython-311.pyc
� �*vh� � �J � d dl Z d dlmZ e j e� � Zdd�Zdd�ZdS )� N)� ip_networkFc � � | j d } ddlm} |� |j � � � � � � � � }d� |D � � }n# t $ r g }Y nw xY w|D ]�} |t |� � � � \ } } }|� | | |�� � � |j |k � � � � � �f# t $ r` t � d|� � |� � � � |j |k � � � � � Y ��w xY w|r� ddlm} |� � � 5 } |D ][}| � |� � }|� |�� � � |j |k � � � � � �\ d d d � � n# 1 swxY w Y n1# t t( f$ r t � d � � Y nw xY w| � |d � � | � |d� � | � |d� � d S ) N�ignored_by_port_protor )�pack_ip_networkc � � g | ]\ }|��S � r )�.0�ips �j/opt/imunify360/venv/lib/python3.11/site-packages/defence360agent/migrations/087_ignored_by_port_fields.py� <listcomp>zmigrate.<locals>.<listcomp> s � ����c�b�r���� )�network_address�netmask�versionzInvalid IP network %s)�geo)�countryz2Failed to update countries data in ignored_by_portr r r )�orm�im360.utils.netr �selectr �distinct�tuples�ImportErrorr �update�where�execute� ValueError�logger�warning�delete�im360.internalsr �reader�get_id�OSError�add_not_null)�migrator�database�fake�kwargs� IgnoredByPortr �q�ipsr �net�maskr r � geo_readerr s r �migrater/ s� � ��L�!8�9�M� �3�3�3�3�3�3� � � ��!1�2�2�;�;�=�=�D�D�F�F����Q������� � � � ��������� � 6� 6�� 6�!0���B���!@�!@��C��w� � � � #�T�7� !� � ��e�M�$��*�+�+�G�G�I�I�I�I�� � K� K� K��N�N�2�B�7�7�7�� � �"�"�(�(��)9�R�)?�@�@�H�H�J�J�J�J�J� K���� � � �+�+�+�+�+�+������ >��� >� >�B�(�/�/��3�3�G�!�(�(� '� )� � ��e�M�,��2�3�3�G�G�I�I�I�I� >� >� >� >� >� >� >� >� >� >� >� >���� >� >� >� >��� �W�%� � � ��N�N�D� � � � � � ���� ���-�):�;�;�;������� � � ���-��3�3�3�3�3s[ �A � A/�.A/�7C�A'E�E� G �$AG�G �G�G �G�G �+H � H c �P � | j d }| � |ddd� � d S )Nr r r r )r � drop_not_null)r% r&