purge Gitlab Dependency proxy blobs from the database if the corresponding local file is missing

purge-gitlab-depproxy.rb

# purge Gitlab Dependency proxy blobs from the database if the corresponding local file is missing
DependencyProxy::Blob.where(file_store: [nil, ::DependencyProxy::FileUploader::Store::LOCAL]).find_in_batches do |batch|
  batch.each { |blob|
    begin
      blob.open
    rescue Errno::ENOENT => e
      puts "Blob #{blob.id} corrupted, deleting"
      blob.destroy
    end
  }
end