16
17
18
19
20
21
22
23
24
25
26
27
28
29
|
# File 'lib/closure_tree/numeric_order_support.rb', line 16
def reorder_with_parent_id(parent_id, minimum_sort_order_value = nil)
min_where = if minimum_sort_order_value
"AND #{quoted_order_column} >= #{minimum_sort_order_value}"
else
""
end
connection.execute 'SET @i = 0'
connection.execute <<-SQL.strip_heredoc
UPDATE #{quoted_table_name}
SET #{quoted_order_column} = (@i := @i + 1) + #{minimum_sort_order_value.to_i - 1}
WHERE #{where_eq(parent_column_name, parent_id)} #{min_where}
ORDER BY #{nulls_last_order_by}
SQL
end
|