wo4hddlZddlZddlZejeZd\ZZdZd eZ dZ dZ d dZ d d ZdS) N)z proactive.csvzproactive_env.csvzSELECT 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\ttfttffD]\}}|||f}t t j||ddd5}tj |}| |dddn #1swxYwYdS)Nwzutf-8)newlineencoding) PROACTIVE_CSV PROACTIVE_SQLPROACTIVE_ENV_CSVPROACTIVE_ENV_SQL execute_sqlopenospathjoincsvwriter writerows)database target_dir events_numfilenamequerycurcsvfile csv_writers d/opt/imunify360/venv/lib/python3.11/site-packages/defence360agent/migrations/135_export_proactive.pyexportrs  & -. & &%""5:-88  GLLX . .      & G,,J   % % % & & & & & & & & & & & & & & & & &s**B  B$ 'B$ Fc |rdS tjtdt|tddS#t$rt dYdSwxYw)NT)exist_okiz'Failed to export proactive defence data)rmakedirs EXPORT_DIRr Exceptionlogger exceptionmigratorrfakekwargss rmigrater)%s D J....xT***** DDDBCCCCCCDs19$A! A!c dS)Nr%s rrollbackr,0sD)F)rrlogging getLogger__name__r#rr r formatr r!rr)r,r+r-rr2s   8 $ $#G  2  F 5  & & & DDDD      r-