Apply diffs in Postgres

apply_diffs_to_map_document_data.rb

module Interactors
  module ApplyDiffsToMapDocumentData
    def self.call(map_id:, diffs:)
      return if diffs.empty?

      sql = <<-SQL
        UPDATE maps SET document_data =
        #{diffs.count.times.map { 'jsonb_set(' }.join('')}
        document_data
        #{diffs.each_with_index.map { |diff, i| ", '{#{diff[:path].join(',')}}', :value_#{i})" }.join('')}
        WHERE maps.id = :map_id
      SQL

      sql_data = { map_id: map_id }
      diffs.each_with_index do |diff, index|
        sql_data["value_#{index}".to_sym] = diff[:value]
      end
      query = ActiveRecord::Base.send(:sanitize_sql_array, [sql, sql_data])

      ActiveRecord::Base.connection.execute(query)
    end
  end
end