wo4hNddlZddlZddlZejeZddZddZdS)NFc " |jd}|jd fd} ddlm}|5|D]} t j|d}n#t $rY*wxYw||\} } } || | | d || #tj $r%} t d| Yd } ~ d } ~ wwxYw d d d n #1swxYwYn#t$rYnwxYw|d |d |d |d |dd S)zWrite your migrations here. iplist_newiplistc3K Ed{VdS#t$rYdSwxYw)N)selectdictsiterator RuntimeError)IPLists^/opt/imunify360/venv/lib/python3.11/site-packages/defence360agent/migrations/075_ips_as_int.py iplist_selectzmigrate..iplist_selectsp }}V,,2244==?? ? ? ? ? ? ? ? ? ?    FF s?A AAr)pack_ip_networkip)network_addressnetmaskversionzError 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"))ormim360.utils.netratomic ipaddress ip_network ValueErrorupdateinsertexecutepwIntegrityErrorloggerwarning ImportErrorsql)migratordatabasefakekwargs IPListNewr rip_objrnetmaskrer s @r migrater+ sZ \*I \( #F@333333__   @ @'-// @ @"-fTl;;BB!H&5_R%8%8"T7 +.#'#*@$$V,,446666(@@@NN#;Q????????@% @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @      2 LL$%%% LL:;;; LLJKKK LLNOOO LL>?????spD D  A%$D % A2/D 1A22+D 'CD C:C50D 5C::D  DD D#"D#c dS)z$Write your rollback migrations here.N)r"r#r$r%s r rollbackr.8sD)F) loggingpeeweerr getLogger__name__rr+r.r-r/r r4sq  8 $ $+@+@+@+@\      r/