module ActsAsSortable
  extend ActiveSupport::Concern

  module ClassMethods

    def update_numbers!(*ids, parent:)
      # Ensure only records belonging to this parent are included.
      ids = ids.map(&:to_i) & parent.public_send("#{model_name.singular}_ids")
      return if ids.empty?
      case connection.adapter_name
      when "PostgreSQL" then update_numbers_postgresql!(ids)
      when "Mysql2"     then update_numbers_mysql2!(ids)
      else
        update_numbers_sequentially!(ids)
      end
    end

    private

    def update_numbers_postgresql!(ids)
      # Build an Array with each ID and its relative position in the Array
      values = ids.each_with_index.map { |id, i| "(#{id}, #{i + 1})" }.join(",")
      # Run a single UPDATE query for all records.
      query = <<~SQL
      UPDATE #{table_name} \
      SET number = svals.number \
      FROM (VALUES #{sanitize_sql(values)}) AS svals(id, number) \
      WHERE svals.id = #{table_name}.id;
      SQL
      connection.execute(query)
    end

    def self.update_numbers_mysql2!(ids)
      ids_string = ids.map { |id| "'#{id}'" }.join(",")
      update_all(%Q{ number = FIELD(id, #{sanitize_sql(ids_string)}) })
    end

    def self.update_numbers_sequentially!(ids)
      ids.each_with_index.map do |id, number|
        find(id).update_attribute(:number, number + 1)
      end
    end
  end
end