Any api to purge old deleted posts / uploads

[nathank (Nathan Kershaw)]

Chiamata all’aiuto!

Può una persona intelligente guidarmi nel combinare:

@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
  )

E

@zogstrip

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

per creare un fantastico pulitore di caricamenti orfani da eseguire dalla console?

Ho notato che quando uso rails db, mi viene chiesta la Password per l'utente discourse:. Cosa devo fare con quella?