Find multiple objects by attribute values

Question

I have Products.

Products have unique sizes. Sizes are attributes.

I want to change the status of Products with sizes 10, 20 and 30 exclusively.

How do I query them in one go?

I looking for something as simple as:

Products.find_by(size: [10, 20, 30])

What is size? an attribute on the model? Another model? If an attribute what you've put should work — j-dexx
– j-dexx, Commented Feb 26, 2015 at 17:07
This shows no research. If you read the ActiveRecord docs, or simply play around in the Rails console, you would easily find an answer. — user229044
– user229044 ♦, Commented Feb 26, 2015 at 17:08

Arup Rakshit · Accepted Answer · 2015-02-26 17:12:38Z

3

Well you can use #update_all and #update

# if you don't want to confirm validation
Products.where(size: [10, 20, 30]).update_all(status : 'x')
# if you do want to confirm validation
Products.where(size: [10, 20, 30]).find_each do |product|
 product.update(status : 'x')
end

edited Feb 26, 2015 at 17:12

answered Feb 26, 2015 at 17:07

Arup Rakshit

119k30 gold badges270 silver badges328 bronze badges

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

Collectives™ on Stack Overflow

Find multiple objects by attribute values

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