#!/bin/bash
PATH=/usr/sbin:/usr/bin:/sbin:/bin
rm /home/<USER>/cache_filepaths
sudo -Hiu mailman psql -d mailman -t -A -c "SELECT substring(file_id, 1, 4) as filepath FROM file_cache" > /home/<USER>/cache_filepaths
sed -i 's/./&\//2; s/$/\/\*/' cache_filepaths
cat /home/<USER>/cache_filepaths
for list in `cat /home/<USER>/cache_filepaths`
do
CACHE=$list
rm /opt/mailman/mm/var/cache/$CACHE
done
sudo -Hiu mailman psql -d mailman -t -A -c "DELETE FROM file_cache"
exit 0