How to adjust the data to display a graph in a Ruby on Rails application?

Question

Ruby on Rails

Please help.
There is an ActiveRecord request

<%= pie_chart Uk.find_by_sql("SELECT uks.MEANING, SUM(OPLATA) FROM oplata o, uks WHERE o.UK_ID = uks.UK_ID GROUP BY uks.MEANING") %>

Returning the following data:

[{"meaning":"Имя1","sum(oplata)":448616,"id":null},{"meaning":"Имя 2","sum(oplata)":112154,"id":null},{"meaning":"Имя 3","sum(oplata)":224308,"id":null}]

How can the received data be converted into something like this:
{"Имя 1":448616,"Имя 2":224308,"Имя 3":112154}
Or how can I correctly write down an ActiveRecord query without SQL injection?
uk.rb

class Uk < ActiveRecord::Base
    has_many :oplata
end

oplata.rb

class Oplata < ActiveRecord::Base
    belongs_to :uks
end

Answer 1

Unfortunately, there is not enough experience, and this is probably why all attempts to run through the array with all sorts of map, each, etc. were not crowned with success. Helped apidoc and query TableName.connection.select_rows("SQL")
In the future I hope to be able to correctly rewrite this query through ActiveRecord without SQL.

Answer 2

You can iterate over your resulting array and make the desired hash, as an option

Answer 3

b = a.map{|x| {x['meaning'] => x['sum(oplata)']}}
I wrote exactly how to convert the data without thinking about what it all means. Didn't check.