Eliminare tutti i messaggi di un utente in una categoria

[Iceman]

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 )

Thanks!

[JammyDodger]

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

Reverse engineer the Discourse API

Discourse is backed by a complete JSON api. Anything you can do on the site you can also do using the JSON api. Many of the endpoints are properly documented in the discourse_api gem, however some endpoints lack documentation. To determine how to do something with the JSON API here are some steps you can follow. Example: recategorize a topic. Go to a topic and start editing a category: [image] Open Chrome dev tools, switch to the Network tab, select XHR filter: [image] Perform the op…

@Iceman

(Or a way using the console, I just don’t want to “try” and blow up the DB )

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.

[Iceman]

Hi @JammyDodger

Thanks for the links.

@JammyDodger

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

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

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

[JammyDodger]

@Iceman

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

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

Hopefully that can provide some inspiration?

[Wingtip]

Scusa per il necro, sono felice di creare un nuovo post se necessario.

Abbiamo una categoria politica e alcuni utenti vorrebbero eliminare tutti i loro post da questa categoria per ovvi motivi. C’è un modo semplice per farlo per loro?

[Arkshine]

Una soluzione può essere quella di utilizzare la console di Rais.

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

Quindi puoi seguire il seguente modulo compilando lo slug della categoria e il nome utente.
Copia il codice e incollalo nella console.

Nota:

• Non elimina il primo post per evitare che l’argomento venga eliminato
• Se si seleziona una sottocategoria, fornire la categoria padre, ad esempio: slug_genitore/slug_categoria.

Si prega di effettuare un backup prima di apportare qualsiasi modifica.

[wrap=placeholder key=CATEGORY_SLUG description="Slug della categoria"][/wrap]
[wrap=placeholder key=USERNAME description="Nome utente"][/wrap]

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

[Wingtip]

Grazie! Questo è fantastico.