rails group by and order by column

Question

In my controller I'm getting all Extras grouped by Category:

Click to copy

def index
  @categories = Extra.all.group_by(&:category)
end

The result is something like an Array of Hashes:

Click to copy

{#<Category id:1, sort:2> => [#<Extra id:1>,#<Extra id:2],
 #<Category id:2, sort: 1> => [#<Extra id:3>,#<Extra id:4>]}

I want to sort by category "sort" column instead of id, which should look like this:

Click to copy

{#<Category id:2, sort:1> => [#<Extra id:3>,#<Extra id:4],
 #<Category id:1, sort: 2> => [#<Extra id:1>,#<Extra id:2>]}

When I try:

Click to copy

def index
  @categories = Extra.all.group_by(&:category).sort_by{|s| s[:sort]}
end

I get "no implicit conversion of Symbol into Integer". Is that because I used a symbol in the "sort_by"?

Answer 1

Try this, group_by will return you hash and you are trying to call [:sort] on an Array of [#<Category id:2, sort:1>, [#<Extra id:3>,#<Extra id:4]]

You should take them in two variables |key, value| and the key will be category

Click to copy

def index
  @categories = Extra.all.group_by(&:category).sort_by{|category, _extras| category.sort }
end

Answer 2

Use the order method to do the sorting at the database:

Click to copy

@categories = Extra.order(sort: :asc).group_by(&:category)