カテゴリ内のユーザーのメッセージを全削除

サポート
1

Hi guys,

Recently I had the need to delete all posts from a user in a specific category. Leaving aside “debates” on deleting content I thought “oh, easy, just use the search and then pick all the results using the checkboxes and delete them”.

However, it seems that doing so allows me to delete The Topics and not so much the messages, even though the search is giving me the messages as results, not necessarily the topics (although they are there as well, yes).

Is there a “safe” way of doing this? At first I thought that I would be something very extreme to the DB (and I don’t discard that possibility) but since I can bulk-delete 50+ topics from the UI… maybe there is a way of doing that for messages only? (Or a way using the console, I just don’t want to “try” and blow up the DB :stuck_out_tongue: )

Thanks!

「いいね！」 1
2

I don’t have personal experience of these, but I believe you can ‘soft’ delete using the API -

And there are a few topics on ‘hard’ deleting if you search for ‘rails delete post’.

If you can give a few more details about what you’re trying to achieve, people may have more specific tips.

3

Hi @JammyDodger

Thanks for the links.

I just want to delete all messages from a user in a specific category. :stuck_out_tongue:

PD: Maybe using the Console? I just don’t want to nuke my DB…

「いいね！」 1
4

There’s some ongoing discussion about a similar thing in this topic: Delete deleted-posts permanently in bulk?

Hopefully that can provide some inspiration?

5

遅れて申し訳ありませんが、必要であれば新しい投稿を作成します。

私たちには政治カテゴリがあり、一部のユーザーは明らかな理由でこのカテゴリのすべての投稿を削除したいと考えています。彼らのためにこれを簡単に行う方法はありますか？

6

Rais コンソールを使用するという方法もあります。

cd /var/discourse
./launcher enter app
rails c

その後、category slug と username を入力して、以下の形式に従ってください。
コードをコピーしてコンソールに貼り付けます。

注意:

  • トピックが削除されるのを防ぐため、最初の投稿は削除されません。
  • サブカテゴリを対象とする場合は、親を指定してください。例: parent_cat_slug/cat_slug。

:warning: 変更を加える前に、必ずバックアップを作成してください。

Category
  .find_by_slug_path_with_id("=CATEGORY_SLUG=")
  .tap do |c|
    u = User.find_by_username("=USERNAME=")
    Post
      .joins(:topic)
      .where(user_id: u.id)
      .where("topics.category_id = ?", c.id)
      .where.not(post_number: 1)
      .where(deleted_at: nil)
      .find_each { |p| PostDestroyer.new(Discourse.system_user, p).destroy }
  end
「いいね！」 1
7

ありがとうございます！これは素晴らしいです。