Redact seems not to work

Support
#1

Hi,
I am trying to use “redact_sensitive.py” to search and replace sensitive data. With --wet it is telling me what it is doing, stating “Redacted event” for each occurence. Unfortunately it does not replace anything, so all data remains in the database. So it seems the line

aw.insert_event(bucket_id, e)

is not doing anything, not even giving an error.

Any ideas to that?

Cheers,
Joachim

#2

A possible working solution is to directly modify the database:
sqlite3 ~/.local/share/activitywatch/aw-server/peewee-sqlite.v2.db <<EOF
update eventmodel set datastr=’{“app”: “myApp”, “title”: “myNewTitle”}’ where datastr like ‘{“app”: “myApp”, “title”: "%myOldTitle%’;
EOF