Sorting query results using a model method

Question

I have the following mapping (@location_matches represents a standard SQL query`:

 @matches = @location_matches.map { |listing|

    }.compact

When I go to my view, I can access @matches.username, etc, etc, etc.

However when I add this model method, I lose all access to any of the info!

 @matches = @location_matches.map { |listing|
           listing.compute_score(current_user)

    }.compact

any ideas why? is there a better way to do this? thank ya

map returns an array of the results of the block applied, so all you're getting is an array of computed scores. What were you after originally? — jimworm
– jimworm, Commented Jul 27, 2011 at 17:11
I stink at this! I'm trying to compute a score based on what is returned from the query and then I want to sort the results by that computed score. I'm trying everything every which way (and wrong way). Any ideas? Your help is really appreciated. — stewart715
– stewart715, Commented Jul 27, 2011 at 17:14

jimworm · Accepted Answer · 2011-07-28 10:16:56Z

2

Here's sorting by computed score:

@matches = @location_matches.sort_by{|location| location.compute_score(current_user)}

http://www.ruby-doc.org/core/classes/Enumerable.html#M001481

Put .reverse at the end if you want it reverse-sorted.

edited Jul 28, 2011 at 10:16

answered Jul 27, 2011 at 17:20

jimworm

2,74118 silver badges26 bronze badges

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

7 Comments

stewart715 Over a year ago

Awesome, thanks! What do l1 and l2 represent? I'm sure this works, just wondering if you could help me understand. Thanks again!

jimworm Over a year ago

Haha you're more confident than me, please try it first. sort does a comparison sort, so l1 and l2 represents each pair of values being compared... in this case, each of your matched objects.

stewart715 Over a year ago

haha thanks - i'll give it a shot, when you mean pair of values being compared what are you referring to? do you mean it's like a step by step comparison? like it will compare the first to next and so on?

jimworm Over a year ago

Here's a question that goes into Ruby's sort algorithms: stackoverflow.com/questions/855773/…

mu is too short Over a year ago

I think sort_by would be a better call than sort for anything expensive (like compute_score probably is).

|

Collectives™ on Stack Overflow

Sorting query results using a model method

1 Answer 1

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related