touch or delete (if csv rows over 500k)

not_in.rb

csv = CSV.open(path, headers: true)
touched = []

csv.each do |row|
  params = row.to_h
  ProductUpdateWorker.perform_async(params)
  touched << params['code']
end

Product.where.not(code: touched).destroy_all

timestamp.rb

csv = CSV.open(path, headers: true)
begin_at = Time.zone.now

csv.each do |row|
  params = row.to_h
  ProductUpdateWorker.perform_async(params)
  Product.find_by(code: params['code'])&.touch
end

Product.where('updated_at < ?', begin_at).destroy_all

IN句はOracleだと1000要素までと言う制限があるし、そもそも50万要素あるIN句を投げるのはばかばかしい…