La forma correcta de eliminar completamente cientos de temas mediante Rails?

sam · 21 Junio, 2018 10:28

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.

Tema		Respuestas	Vistas
Delete deleted-posts permanently in bulk? Support	59	5825	8 Enero 2022
Help Wiping all Posts from a Forum Support	18	2064	26 Agosto 2020
Updating topic count in categories after bulk delete & missing topics/posts Support	7	1653	8 Junio 2024
Clean up old topics Support	4	545	2 Febrero 2023
Bulk delete all topics in a category Self-Hosting how-to	0	5907	23 Septiembre 2018

La forma correcta de eliminar completamente cientos de temas mediante Rails?

Temas relacionados