Ruby array sorting order

Question

I have this array returned by a activerecord query:

SELECT id, value FROM table ORDER BY value DESC
[1054, 86], [1062, 86], [1059, 84]

And I've created a simple array to compare with the first array:

array.sort_by! { |object| object.access_count }.reverse }

But when I compare the two arrays the result is different:

activerecord => [1054, 86], [1062, 86], [1059, 84]
array.sort_by! => [[1062, 86], [1054, 86], [1059, 84]

So in some cases the compare doesn't work because activerecord sorts one way and sort_by! sorts another.

How can I solve that ? Thanks.

What you are trying to achieve by comparing both? can you explain a bit more? @gui12344455 — Narasimha Reddy - Geeker
– Narasimha Reddy - Geeker, Commented Oct 13, 2017 at 12:01
yes, I'm using rspec to test my code and one test is to verify if the data returned is sorted correctly. — gui12344455
– gui12344455, Commented Oct 13, 2017 at 12:15
So you are trying test order method of Active record. Actually in RSpec we are responsible to test the code written by us. You no need to test order here. In case you are necessary to write test case for order, In the spec you can make a query like records = Model.only(:id, :name).order(:desc) and check like this expected(response_records).to eq(records) — Narasimha Reddy - Geeker
– Narasimha Reddy - Geeker, Commented Oct 13, 2017 at 12:37

Ronan Louarn · Accepted Answer · 2017-10-13 11:36:56Z

1

Can you try order Activerecord with second arg.

.order(value: :desc, id: :desc)

answered Oct 13, 2017 at 11:36

Ronan Louarn

4721 gold badge6 silver badges27 bronze badges

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

1 Answer 1