Il modo corretto per eliminare completamente centinaia di argomenti tramite Rails?

sam · 21 Giugno 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.

Argomento		Risposte	Visualizzazioni
Delete deleted-posts permanently in bulk? Support	59	5825	Gennaio 8, 2022
Help Wiping all Posts from a Forum Support	18	2064	Agosto 26, 2020
Updating topic count in categories after bulk delete & missing topics/posts Support	7	1653	Giugno 8, 2024
Clean up old topics Support	4	544	Febbraio 2, 2023
Bulk delete all topics in a category Self-Hosting how-to	0	5906	Settembre 23, 2018

Il modo corretto per eliminare completamente centinaia di argomenti tramite Rails?

Argomenti correlati