Keep DB Connections Healthy in Long Jobs

                  class Maintenance::BackfillSnipScoresJob < ApplicationJob
  queue_as :maintenance

  def perform
    ActiveRecord::Base.connection_pool.with_connection do |conn|
      conn.verify!

      Snip.find_each(batch_size: 1000) do |snip|
        Snip.where(id: snip.id).update_all(score: snip.views)
      end
    end
  end
end