The proper way to completely delete hundred of topics via rails?

sam · June 21, 2018, 10:28am

Interesting… we are missing a dependant destroy here, I am not sure why.

app/models/topic.rb

main


      
          
            infos.sort_by! { |i| -i[:width] * i[:height] }
          end
          
          def generate_thumbnails!(extra_sizes: [])
            return nil unless SiteSetting.create_thumbnails
            return nil unless original = image_upload
            return nil if original.filesize >= SiteSetting.max_image_size_kb.kilobytes
            return nil unless original.width && original.height
            extra_sizes = [] unless extra_sizes.kind_of?(Array)
          
            (Topic.thumbnail_sizes + extra_sizes).each do |dim|
              TopicThumbnail.find_or_create_for!(original, max_width: dim[0], max_height: dim[1])
            end
          end
          
          def image_url(enqueue_if_missing: false)
            thumbnail =
              topic_thumbnails.detect do |record|
                record.max_width == Topic.share_thumbnail_size[0] &&
                  record.max_height == Topic.share_thumbnail_size[1]

Easy to fix though

Post.where('topic_id not in (select id from topics)').limit(100).destroy_all

And repeat… till no results.

Topic		Replies	Views
Delete deleted-posts permanently in bulk? Support	59	5648	January 8, 2022
Help Wiping all Posts from a Forum Support	18	2034	August 26, 2020
Updating topic count in categories after bulk delete & missing topics/posts Support	7	1624	June 8, 2024
Clean up old topics Support	4	513	February 2, 2023
Bulk delete all topics in a category Self-Hosting how-to	0	5844	September 23, 2018

The proper way to completely delete hundred of topics via rails?

Related topics