How to toggle a boolean field for multiple records generating just one SQL query

Question

I'm trying to write a migration to update a boolean field where the field will mean the exact opposite of what it means currently. Therefore I need to toggle every record to update the records where this field is true to false and vice-versa.

Example:

class ChangePostsVisibleToArchived < ActiveRecord::Migration[6.1]
  def change
    rename_column :posts, :visible, :archived

    # Toggle all tracked topics
    # What I DON'T want to do:
    Post.all.each { |post| post.toggle! :archived }
  end
end

The way I described above will generate one SQL command per Post record. Is there a way I can toggle all records within a single SQL command using rails ActiveRecord syntax?

Yes @LaurenzAlbe, I can use ActiveRecord::Base.connection.execute('UPDATE posts SET archived = NOT archived') but I wonder if there's an alternative in Rails ActiveRecord. — Breno
– Breno, Commented Aug 16, 2022 at 19:31

smathy · Accepted Answer · 2022-08-17 15:00:23Z

2

Post.update_all "archived = NOT archived"

answered Aug 17, 2022 at 15:00

smathy

28k5 gold badges51 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to toggle a boolean field for multiple records generating just one SQL query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related