media repository moderations

[jjj333-p]

• probably steal from spaetz's script, though im likely not going to use python so its more for inspiration (need to ask permission)
• allow purging of specific mxc:// urls
• if possible delete all media uploaded by a specific user
• just deleting entries which would allow the media to refederate if not deleted from the originating server

  • could modify the db entry to point at one file, perhaps one saying "this media is blacklisted"
  • perhaps replace media orignating localy to one such as "this media is blacklisted" so that instead of causing errors it tells the users of any server that didnt already cache the media that it is now gone

• since this is intended to be running whenever dendrite is online and will have to touch the media table anyways, perhaps this could be used to automatedly enforce media retention policies, i.e. hourly purging any remote media over a week old

[jjj333-p]

sample entry for reference

dendrite=# select * from mediaapi_media_repository limit 1;
                             media_id                             | media_origin | content_type | file_size_bytes |  creation_ts  | upload_name |                 base64hash                  |       user_id       
------------------------------------------------------------------+--------------+--------------+-----------------+---------------+-------------+---------------------------------------------+---------------------
 17b02f956043ff5c94ed49e8c38092a3fe2e7243ae9d17b4914433f16f266a9c | pain.agency  | image/png    |           53843 | 1694142275962 | works.png   | osSwtAvXJ7MEGokTHuFZmz8GOGdbRubyVHZEUZ7JT0M | @jjj333:pain.agency
(1 row)

dendrite=# 

[jjj333-p]

in this case it seems clear that it would be easy to delete specific media from a user or server, however it seems i was incorrect with how the storage of the files work. perhaps still the file size could be edited and then the script writes an alias to a file in place of where it is in the media folder. i know if the size doesnt match though it will error and not serve the media.