Rails where with array returned data order

Question

I just want to make sure that if I used a where query like so:

product1, product2 = Product.where(id: [1, 2]) it will always return the data in that order specified in the array, so the assignment will always be correct.

Is that the behaviour or it might not return the data in that specific order at some time?

Andrey Deineko · Accepted Answer · 2016-02-04 11:58:55Z

2

Records will always be fetched from database in ascending order by id column (unless you specify another order).

So yea, this is the behavior and you'll always get the assignment right here.

edited Feb 4, 2016 at 11:58

answered Feb 4, 2016 at 11:53

Andrey Deineko

52.5k11 gold badges119 silver badges151 bronze badges

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

4 Comments

Wazery Over a year ago

That answers my question, but I have another one please, what if I don't know the IDs which I am passing, then how to make sure that I will get the correct assignment? Product.where(id: [id1, id2])

Andrey Deineko Over a year ago

can you provide the example, so I understand exactly what you mean?

Wazery Over a year ago

id1 = 2, id2 = 1 p1, p2 = Product.where(id: [id1, id2]) Sorting the IDs won't help, as the assignment ordering will not be sorted relatively.

Andrey Deineko Over a year ago

@IslamWazery I think you could find some hints in this article

Collectives™ on Stack Overflow

Rails where with array returned data order

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related