Making My Synapse Squeaky Clean

test test

#!/usr/bin/env bash

set -eEuo pipefail

_parallelism=32
_retries=10
_synadm_limit=100000
_user_regex="^@discord_|^@signal_|^@facebook_|^@heisenbridge:|^@mufacebookbot:|^@musignalbot:|^@irc_|^@slack_"

_user_output_file="m_cleanup_users"
_room_output_file="m_cleanup_rooms"
_user_media_output_file="m_cleanup_user_media"
_room_media_output_file="m_cleanup_room_media"
_empty_room_output_file="m_cleanup_empty_rooms"

truncate --size=0 "$_user_output_file" "$_user_media_output_file" "$_room_media_output_file"

synadm user list --limit "$_synadm_limit" | jq --arg user_regex "$_user_regex" -cr '.users | to_entries[] | select((.value.name | test($user_regex)) and (.value.erased | not)) | .value.name' > "$_user_output_file"

{ tr ' ' '\n' | parallel --line-buffer --will-cite -j "$_parallelism" --retries "$_retries" --bar synadm user media {} --limit "$_synadm_limit" ; } < "$_user_output_file" | jq -scr '.[] | .media[]' > "$_room_output_file"

synadm room list --limit "$_synadm_limit" | jq --arg user_regex "$_user_regex" -cr '.rooms | to_entries[] | if .value.creator | test($user_regex) then { room_id: .value.room_id, creator: .value.creator } else null end | select (. != null)' > "$_room_output_file"

{ jq -rcs '.[] | .room_id' | parallel --line-buffer --will-cite -j "$_parallelism" --retries "$_retries" --bar synadm media list --room-id {} --limit "$_synadm_limit" ; } < "$_room_output_file" | jq -rcs  '.[] | .local[]' > "$_room_media_output_file"

synadm room list --limit "$_synadm_limit" | jq -rc '.rooms[] | select(.joined_local_members == 0) | .room_id' > "$_empty_room_output_file"

cat <<EOF
empty rooms: $(wc -l < "$_empty_room_output_file")

gathered:
 - $(wc -l < "$_user_media_output_file") user media
 - $(wc -l < "$_room_media_output_file") room media

from

 - $(wc -l < "$_user_output_file") users
 - $(wc -l < "$_room_output_file") rooms

EOF

read -p "proceed? [y/N] " _proceed

if [[ "$_proceed" != "y" ]] && [[ "$_proceed" != "yes" ]] ; then
  exit 1
fi

{ cut -f 4 -d '/' | parallel --line-buffer --will-cite -j "$_parallelism" --retries 2 --bar synadm --batch media delete --media-id {} ; } < "$_room_media_output_file"
{ cut -f 4 -d '/' | parallel --line-buffer --will-cite -j "$_parallelism" --retries 2 --bar synadm --batch media delete --media-id {} ; } < "$_user_media_output_file"
parallel --line-buffer --will-cite -j "$_parallelism" --retries "$_retries" --bar synadm --batch user deactivate {} < "$_user_output_file"
{ jq -rcs '.[] | .room_id' | parallel --line-buffer --will-cite -j "$_parallelism" --retries "$_retries" --bar synadm --batch room delete {} ; } < "$_room_output_file"
{ parallel --line-buffer --will-cite -j "$_parallelism" --retries "$_retries" --bar synadm --batch room delete {} ; } < "$_empty_room_output_file"