Edit File: 075_ips_as_int.cpython-311.pyc
� a�nh� � �N � d dl Z d dlZd dlZ e j e� � Zdd�Zdd�ZdS )� NFc �" � � | j d }| j d � � fd�} ddlm} |� � � 5 |� � D ]�} t j |d � � }n# t $ r Y �*w xY w ||� � \ } } } |� | | | d�� � |� |� � � � � �# t j $ r%} t � d| � � Y d } ~ ��d } ~ ww xY w d d d � � n # 1 swxY w Y n# t $ r Y nw xY w| � d � � | � d � � | � d � � | � d � � | � d� � d S )zWrite your migrations here.� iplist_new�iplistc 3 � �K � � � � � � � � � � � � E d {V �� d S # t $ r Y d S w xY w)N)�select�dicts�iterator� RuntimeError)�IPLists ��^/opt/imunify360/venv/lib/python3.11/site-packages/defence360agent/migrations/075_ips_as_int.py� iplist_selectz migrate.<locals>.iplist_select sp �� � � � � �}�}�V�,�,�2�2�4�4�=�=�?�?� ?� ?� ?� ?� ?� ?� ?� ?� ?��� � � � �F�F� ���s �?A � A�Ar )�pack_ip_network�ip)�network_address�netmask�versionzError inserting IP: %sNzDROP TABLE iplistz'ALTER TABLE iplist_new RENAME TO iplistz7CREATE INDEX "iplist_listname" ON "iplist" ("listname")z;CREATE INDEX "iplist_expiration" ON "iplist" ("expiration")z+CREATE INDEX "iplist_ip" ON "iplist" ("ip"))�orm�im360.utils.netr �atomic� ipaddress� ip_network� ValueError�update�insert�execute�pw�IntegrityError�logger�warning� ImportError�sql)�migrator�database�fake�kwargs� IPListNewr r �ip_objr �net�maskr �er s @r �migrater+ sZ �� �� �\�*�I� �\�(� #�F�� � � � �@�3�3�3�3�3�3� �_�_� � � @� @�'�-�/�/� @� @�� �"�-�f�T�l�;�;�B�B��!� � � � �H� ���� &5�_�R�%8�%8�"��T�7�� � �+.�#'�#*�� �� � �@� �$�$�V�,�,�4�4�6�6�6�6���(� @� @� @��N�N�#;�Q�?�?�?�?�?�?�?�?�����@����% @� @� @� @� @� @� @� @� @� @� @� @���� @� @� @� @��� � � � � �� ����2 �L�L�$�%�%�%� �L�L�:�;�;�;� �L�L�J�K�K�K� �L�L�N�O�O�O� �L�L�>�?�?�?�?�?sp �D � D � A%�$D �% A2�/D �1A2�2+D � 'C�D �C:�C5�0D �5C:�:D � D�D� D#�"D#c � � dS )z$Write your rollback migrations here.N� )r" r# r$ r% s r �rollbackr. 8 s � ��D� )F) �logging�peeweer r � getLogger�__name__r r+ r. r- r/ r �<module>r4 sq �� ���� � � � � � � � � �� �8� $� $��+@� +@� +@� +@�\ � � � � � r/