diff options
author | Iru Cai <mytbk920423@gmail.com> | 2018-08-25 00:16:14 +0800 |
---|---|---|
committer | Iru Cai <mytbk920423@gmail.com> | 2018-08-25 00:17:27 +0800 |
commit | d85513c6f24968abd35181c902819dc8e489f7e7 (patch) | |
tree | 72d3561c42af8dde758788da35ef77c98c201684 /mxclean/clean_local_store.sh | |
parent | e5fab7b6ee72d8c7b9701bc1e007a875a37c2f2c (diff) | |
download | matrix-synapse-scripts-d85513c6f24968abd35181c902819dc8e489f7e7.tar.xz |
Diffstat (limited to 'mxclean/clean_local_store.sh')
-rw-r--r-- | mxclean/clean_local_store.sh | 31 |
1 files changed, 31 insertions, 0 deletions
diff --git a/mxclean/clean_local_store.sh b/mxclean/clean_local_store.sh new file mode 100644 index 0000000..12402e7 --- /dev/null +++ b/mxclean/clean_local_store.sh @@ -0,0 +1,31 @@ +#!/bin/sh + +set -e + +purge_ts=$(($(date +%s)-$((3600*24*30))))000 +server=matrixim.cc +content_dir=/var/lib/matrix-synapse/media_store/local_content +tmp=/tmp/mxclean +CLEANER="$(pwd)/clean_files" + +make "${CLEANER}" +cd "${content_dir}" +mkdir -p "${tmp}" +find -type f > ${tmp}/filelist + +# for avatars in state events +# E2EE messages doesn't have the URI in the events, so do not rely on it on all events +echo 'select content from events' | psql -d synapse -Aqt | grep -F "mxc://${server}/" > ${tmp}/file_in_db +jq -r .avatar_url ${tmp}/file_in_db | awk -F '/' '{print $NF}' | sed '/null/d' > ${tmp}/dbfiles +jq -r .url ${tmp}/file_in_db | awk -F '/' '{print $NF}' | sed '/null/d' >> ${tmp}/dbfiles + +# profile avatars +echo 'select avatar_url from profiles' | psql -d synapse -Aqt | sed '/^$/d' | awk -F '/' '{print $NF}' > ${tmp}/avatars + +echo "select media_id from local_media_repository where created_ts > ${purge_ts}" \ + | psql -d synapse -Aqt > ${tmp}/recent_media + +cat ${tmp}/dbfiles ${tmp}/avatars ${tmp}/recent_media | sort -u > ${tmp}/files_to_keep +${CLEANER} + +echo "Please run 'cd ${content_dir} && sh ${tmp}/remove.sh' to clean the local content." |