
Drag and Drop Reordering in Rails
<p>Every app I worked on has a list that somebody wants in a very specific order. Carousel slides. Menu items. The steps of an onboarding flow. The plans on a pricing page.</p>
以下正文同步自 Hacker News 最新,版权归原站所有,已转换为易读排版。
reversible do |dir|
dir.up do
execute <<~SQL
UPDATE slides SET position = ranked.rank
FROM (
SELECT id, ROW_NUMBER() OVER (PARTITION BY carousel_id ORDER BY created_at, id) AS rank
FROM slides
) AS ranked
WHERE slides.id = ranked.id
SQL
end
end
add_index :slides, [:carousel_id, :position], unique: true
end end "> <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" viewbox="0 0 20 20" fill="currentColor" class="copy-icon"> <path d="M6 6V2c0-1.1.9-2 2-2h10a2 2 0 0 1 2 2v10a2 2 0 0 1-2 2h-4v4a2 2 0 0 1-2 2H2a2 2 0 0 1-2-2V8c0-1.1.9-2 2-2h4zm2 0h4a2 2 0 0 1 2 2v4h4V2H8v4zM2 8v10h10V8H2z"></path> </svg> </button>
<pre class="code-highlight ruby"><code><span class="k">class</span> <span class="nc">AddPositionToSlides</span> <span class="o"><</span> <span class="no">ActiveRecord</span><span class="o">::</span><span class="no">Migration</span><span class="p">[</span><span class="mf">8.1</span><span class="p">]</span> <span class="k">def</span> <span class="nf">change</span> <span class="n">add_column</span> <span class="ss">:slides</span><span class="p">,</span> <span class="ss">:position</span><span class="p">,</span> <span class="ss">:integer</span> <span class="n">reversible</span> <span class="k">do</span> <span class="o">|</span><span class="n">dir</span><span class="o">|</span> <span class="n">dir</span><span class="p">.</span><span class="nf">up</span> <span class="k">do</span> <span class="n">execute</span> <span class="o"><<~</span><span class="no">SQL</span><span class="sh"> UPDATE slides SET position = ranked.rank FROM ( SELECT id, ROW_NUMBER() OVER (PARTITION BY carousel_id ORDER BY created_at, id) AS rank FROM slides ) AS ranked WHERE slides.id = ranked.id </span><span class="no"> SQL</span> <span class="k">end</span> <span class="k">end</span> <span class="n">add_index</span> <span class="ss">:slides</span><span class="p">,</span> <span class="p">[</span><span class="ss">:carousel_id</span><span class="p">,</span> <span class="ss">:position</span><span class="p">],</span> <span class="ss">unique: </span><span class="kp">true</span> <span class="k">end</span> <span class="k">end</span> </code></pre> </div> <p>Don't skip the backfill. <code>acts_as_list</code> gets confused when some rows have a position and some are <code>NULL</code>, and on the first move you'll see records jumping to weird places. <code>PARTITION BY carousel_id</code> gives every carousel its own 1, 2, 3, which is what the scope from the next step expects.</p> <p>The backfill also makes the unique index safe to add. With that index in place, the database just refuses two slides at the same position. And <code>acts_as_list</code> is smart about it: when it sees a unique index it switches to updating rows one by one (<code>sequential_updates</code>), so it doesn't trip over it.</p> <p>(This SQL is PostgreSQL. On MySQL do it in Ruby with <code>each.with_index(1)</code> and <code>update_column</code>.)</p> <h3>2. Add <code>acts_as_list</code> with a scope</h3> <div class="code-highlight code-block-wrapper"> <button type="button" class="code-copy-button" data-controller="clipboard" data-clipboard-success-message-value="Copied!" data-clipboard-error-message-value="Failed to copy!" data-clipboard-text='# Gemfile gem "acts_as_list" '> <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" viewbox="0 0 20 20" fill="currentColor" class="copy-icon"> <path d="M6 6V2c0-1.1.9-2 2-2h10a2 2 0 0 1 2 2v10a2 2 0 0 1-2 2h-4v4a2 2 0 0 1-2 2H2a2 2 0 0 1-2-2V8c0-1.1.9-2 2-2h4zm2 0h4a2 2 0 0 1 2 2v4h4V2H8v4zM2 8v10h10V8H2z"></path> </svg> </button> <pre class="code-highlight ruby"><code><span class="c1"># Gemfile</span> <span class="n">gem</span> <span class="s2">"acts_as_list"</span> </code></pre> </div><div class="code-highlight code-block-wrapper"> <button type="button" class="code-copy-button" data-controller="clipboard" data-clipboard-success-message-value="Copied!" data-clipboard-error-message-value="Failed to copy!" data-clipboard-text="class Slide < ApplicationRecord belongs_to :carousel acts_as_list scope: :carousel endclass Carousel < ApplicationRecord has_many :slides, -> { order(:position) }, dependent: :destroy end "> <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" viewbox="0 0 20 20" fill="currentColor" class="copy-icon"> <path d="M6 6V2c0-1.1.9-2 2-2h10a2 2 0 0 1 2 2v10a2 2 0 0 1-2 2h-4v4a2 2 0 0 1-2 2H2a2 2 0 0 1-2-2V8c0-1.1.9-2 2-2h4zm2 0h4a2 2 0 0 1 2 2v4h4V2H8v4zM2 8v10h10V8H2z"></path> </svg> </button>
<pre class="code-highlight ruby"><code><span class="k">class</span> <span class="nc">Slide</span> <span class="o"><</span> <span class="no">ApplicationRecord</span> <span class="n">belongs_to</span> <span class="ss">:carousel</span> <span class="n">acts_as_list</span> <span class="ss">scope: :carousel</span> <span class="k">end</span> <span class="k">class</span> <span class="nc">Carousel</span> <span class="o"><</span> <span class="no">ApplicationRecord</span> <span class="n">has_many</span> <span class="ss">:slides</span><span class="p">,</span> <span class="o">-></span> <span class="p">{</span> <span class="n">order</span><span class="p">(</span><span class="ss">:position</span><span class="p">)</span> <span class="p">},</span> <span class="ss">dependent: :destroy</span> <span class="k">end</span> </code></pre> </div> <p>Now every slide gets <code>move_higher</code>, <code>move_lower</code>, <code>move_to_top</code>, <code>move_to_bottom</code> and <code>insert_at(n)</code>. New slides go to the bottom of their own carousel and positions start at 1.</p> <p>A small trap I want to warn you about: don't add <code>validates :position, presence: true</code>. <code>acts_as_list</code> sets the position after validations run, so a new slide fails a validation it would pass a millisecond later. The README mentions it, but it's very easy to miss.</p> <p><code>acts_as_list</code> has been around forever. It has more than 76 million downloads on RubyGems (October 2026), so whatever weird case you hit, someone else hit it before you.</p> <p>Also notice that the order lives on the <a href="https://avohq.io/glossary/associations" target="_blank">association</a> and not in a <code>default_scope</code> on <code>Slide</code>. I'll come back to that one.</p> <h3>3. A route and a controller action</h3> <div class="code-highlight code-block-wrapper"> <button type="button" class="code-copy-button" data-controller="clipboard" data-clipboard-success-message-value="Copied!" data-clipboard-error-message-value="Failed to copy!" data-clipboard-text="# config/routes.rb resources :carousels do resources :slides do patch :move, on: :member end end "> <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" viewbox="0 0 20 20" fill="currentColor" class="copy-icon"> <path d="M6 6V2c0-1.1.9-2 2-2h10a2 2 0 0 1 2 2v10a2 2 0 0 1-2 2h-4v4a2 2 0 0 1-2 2H2a2 2 0 0 1-2-2V8c0-1.1.9-2 2-2h4zm2 0h4a2 2 0 0 1 2 2v4h4V2H8v4zM2 8v10h10V8H2z"></path> </svg> </button> <pre class="code-highlight ruby"><code><span class="c1"># config/routes.rb</span> <span class="n">resources</span> <span class="ss">:carousels</span> <span class="k">do</span> <span class="n">resources</span> <span class="ss">:slides</span> <span class="k">do</span> <span class="n">patch</span> <span class="ss">:move</span><span class="p">,</span> <span class="ss">on: :member</span> <span class="k">end</span> <span class="k">end</span> </code></pre> </div><div class="code-highlight code-block-wrapper"> <button type="button" class="code-copy-button" data-controller="clipboard" data-clipboard-success-messa正文由 探How 从来源站点 RSS 同步,内容未经改写;遇到排版缺失或需要图片、视频时请以原文为准。