🧹 Write Script For Deleting A Post/User & Its Relational Data 💻

[robin-macpherson]

Problem

• Spam posts have really become a big problem on the platform, see #818 for more details on this issue.
• When spam posts come to my attention, either through policing the platform or our wonderful users taking time out of their day to report them - it's become an incredibly stressful task for me to stay on top of because it takes forever to delete even just one post.
• This is because there are a bunch of relational records that need to be deleted in a specific sequence, so it might take me 15 mins to delete one post, and we now have a big backlog.
• This is also very error-prone with huge risks since we're dealing with deleting user data directly from the DB.

Solution

• Let's write a script we can run that can handle all of this for us.
• It could take a post ID, or perhaps even an array of post IDs.

Open Questions

• Should we do the same for deleting users who have brazenly violated the policy? (blatant spam as opposed to a legitimate user that simply crossed the line on self-promotion, for example)