l)d d dl Z d dlZd dlZ ej e Zd\ ZZdZd e Z
dZ d Z 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 \ t t ft t ffD ]\ }}| ||f }t t j || ddd 5 }t j
| }| | d d d n # 1 swxY w Y d S )Nw zutf-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.pyexportr s
& -. & &% ""5:-88
GLLX . .
&
G,,J % % % & & & & & & & & & & & & & & & & &s **B B$ 'B$ Fc |rd S t j t d t |t d d S # t $ r t
d Y d S w xY w)NT)exist_oki z'Failed to export proactive defence data)r makedirs
EXPORT_DIRr Exceptionlogger exceptionmigratorr fakekwargss r migrater) % s D
J....xT***** D D DBCCCCCCDs 19 $A! A!c d S )N r% s r rollbackr, 0 s D )F)r r logging getLogger__name__r# r r
r formatr r! r r) r, r+ r- r r2 s
8 $ $#G
2
F 5
&
&
& D D D D r-