ruby 45 lines · 8 steps

Bulk task reordering with upsert_all in Rails

A controller action reorders tasks by mapping incoming IDs to positions and persisting them in one batched upsert.

Explained by highlit

Rails Intermediate bulk-update upsert authorization turbo-stream transactions

1class TasksController < ApplicationController
before_action :set_project
3 
def reorder
  ids = reorder_params.fetch(:task_ids)
  tasks = @project.tasks.where(id: ids).index_by(&:id)
7 
  updates = ids.each_with_index.map do |id, index|
    task = tasks[id.to_i]
    next unless task
11 
    { id: task.id, position: index + 1, updated_at: Time.current }
  end.compact
14 
  if updates.empty?
    head :unprocessable_entity
    return
  end
19 
  Task.transaction do
    Task.upsert_all(updates, unique_by: :id)
  end
23 
  respond_to do |format|
    format.turbo_stream do
      render turbo_stream: turbo_stream.replace(
        "project_#{@project.id}_tasks",
        partial: "tasks/list",
        locals: { tasks: @project.tasks.order(:position) }
      )
    end
    format.json { head :no_content }
  end
end
35 
private
37 
def set_project
  @project = current_user.projects.find(params[:project_id])
end
41 
def reorder_params
  params.permit(task_ids: [])
end
45end

01 / 01

STEP 01

Walkthrough

Space play ←→ step click any line

Three takeaways

1Loading records into a hash keyed by id avoids an N+1 lookup when matching against an ordered input list.
2upsert_all writes many rows in a single statement, far cheaper than saving each record in a loop.
3Scoping queries through the current user's associations enforces authorization without a separate check.

Related explainers

ruby

require "shellwords"
require "open3"
 
module Backup

Building safe shell commands in Ruby

shell-out subprocess command-injection

Intermediate 7 steps

php

<?php
 
namespace App\Services\Checkout;

Validating coupons with Laravel's Pipeline

pipeline chain of responsibility transactions

Intermediate 7 steps

ruby

class UserAgentParser
  BROWSERS = [
    [/Edg\/([\d.]+)/, "Edge"],
    [/OPR\/([\d.]+)/, "Opera"],

Parsing user-agent strings in Ruby

regex pattern-matching lookup-tables

Intermediate 8 steps

ruby

class LogAggregator
  BUCKET_FORMAT = "%Y-%m-%dT%H:%M"
 
  def initialize(entries)

Bucketing log entries by the minute in Ruby

aggregation hashing enumerable

Intermediate 5 steps

ruby

class WeeklySignupsReport
  DEFAULT_WEEKS = 12
 
  def initialize(weeks: DEFAULT_WEEKS, source: User.all)

Building a weekly signups report in Rails

service object aggregation group by

Intermediate 7 steps

ruby

class ApplicationController < ActionController::Base
  EXPERIMENTS = {
    checkout_button_color: %w[control blue green],
    onboarding_flow: %w[control streamlined]