Any api to purge old deleted posts / uploads

[nathank (Nathan Kershaw)]

求助呼吁！

有没有聪明的人能指导我如何将以下两部分结合起来：

@adopilot

SELECT 
    post_uploads.id
--    ,uploads.filesize
 --   ,posts.id
    --,topics.id
FROM 
  public.topics
  INNER JOIN public.posts ON topics.id = posts.topic_id
  INNER JOIN public.post_uploads ON posts.id = post_uploads.post_id
  INNER JOIN public.uploads ON post_uploads.upload_id = uploads.id
WHERE 
    topics.deleted_by_id IS NOT NULL
  )

以及

@zogstrip

./launcher enter app
rails db
DELETE FROM post_uploads WHERE post_id IN (SELECT id FROM posts WHERE deleted_at IS NOT NULL)

以便在控制台中运行一个强大的孤立文件清理程序？

我注意到，当我使用 rails db 时，系统会提示输入 Password for user discourse:（discourse 用户的密码）。我该如何处理？