class GoogleSafeBrowsing::FullHash

Public Class Methods

delete_subbed() click to toggle source
# File lib/google_safe_browsing/full_hash.rb, line 5
    def self.delete_subbed
      sub_join = <<-SQL
        INNER JOIN gsb_sub_shavars
        ON gsb_sub_shavars.add_chunk_number = gsb_full_hashes.add_chunk_number
        AND gsb_sub_shavars.list = gsb_full_hashes.list
      SQL

      hash_ids = joins(sub_join).pluck("distinct #{self.table_name}.id")
      where(id: hash_ids).delete_all
    end