How to recover a deleted topic using the rails console

[will_io]

This is how the accidental deletion occurred:

cd /var/discourse
./launcher enter app
rails c
Topic.where(:id=><id>).destroy_all

The <id> I deleted was the wrong one and of course it just so happened to be a topic that a number of users were tuned into it. The important thing is I stopped, did not panic and did not execute another action after the accidental deletion occurred.

Stop, Do Not Panic and Do Not Execute

How I recovered the accidentally deleted topic using the rails console:

destroyed_topic = _  
destroyed_topic.each do |destroyed_record|
  Topic.create(destroyed_record.attributes)
end

For future reference are there other ways could I have achieved this? If so, how?

[sam (Sam Saffron)]

Hard to put a time machine on this, but destroy really should be reserved for absolute triple confirmed cases. Do a backup first. I am not sure if your recovery there will cascade and return all the records you need.

Instead:

Topic.find_by(id: <id>).trash!

To recover:

Topic.with_deleted.where(id: <id>).recover!