diff options
Diffstat (limited to 'spec/lib/gitlab/relative_positioning/mover_spec.rb')
-rw-r--r-- | spec/lib/gitlab/relative_positioning/mover_spec.rb | 17 |
1 files changed, 5 insertions, 12 deletions
diff --git a/spec/lib/gitlab/relative_positioning/mover_spec.rb b/spec/lib/gitlab/relative_positioning/mover_spec.rb index c49230c2415..dafd34585a8 100644 --- a/spec/lib/gitlab/relative_positioning/mover_spec.rb +++ b/spec/lib/gitlab/relative_positioning/mover_spec.rb @@ -37,18 +37,11 @@ RSpec.describe RelativePositioning::Mover do end def set_positions(positions) - vals = issues.zip(positions).map do |issue, pos| - issue.relative_position = pos - "(#{issue.id}, #{pos})" - end.join(', ') - - Issue.connection.exec_query(<<~SQL, 'set-positions') - WITH cte(cte_id, new_pos) AS ( - SELECT * FROM (VALUES #{vals}) as t (id, pos) - ) - UPDATE issues SET relative_position = new_pos FROM cte WHERE id = cte_id - ; - SQL + mapping = issues.zip(positions).to_h do |issue, pos| + [issue, { relative_position: pos }] + end + + ::Gitlab::Database::BulkUpdate.execute([:relative_position], mapping) end def ids_in_position_order |