Make DrawingRevision.zip_url nil for company

clear_cached_drawing_revisions_zip_url.rb

class ClearCachedDrawingRevisionZipUrl
  def self.clear_drawing_revision_zip_urls_for_companies(company_ids)
    Company.where(id: company_ids).each do |company|
      DrawingRevision.
        joins("JOIN drawing_areas ON drawing_areas.id = drawing_revisions.drawing_area_id").
        joins("JOIN projects ON projects.id = drawing_areas.project_id").
        joins("JOIN companies ON companies.id = projects.company_id").
        update_all(zip_url: nil)
    end
  end 
end