20470: Update priorities with a single stored query
[arvados.git] / services / api / lib / update_priorities.rb
1 # Copyright (C) The Arvados Authors. All rights reserved.
2 #
3 # SPDX-License-Identifier: AGPL-3.0
4
5 def update_priorities starting_container_uuid
6   ActiveRecord::Base.connection.exec_query %{
7 update containers set priority=computed.priority from (select pri_container_uuid, priority from update_priorities($1) order by pri_container_uuid) as computed
8  where containers.uuid = computed.pri_container_uuid
9 }, 'update_priorities', [[nil, starting_container_uuid]]
10 end