I would like to create an array in my controller from the underlying database, which I will eventually render in JSON.
The database is called User with the fields name:string and value:integer
At the moment I have the following in my controller:
class GraphController < ApplicationController
def index
end
def data
render :json => User.select('value')
end
end
but this returns a hash of id and value whereas I would like an array of value numbers only. How can I achieve this?
Either map the ActiveRecord::Relation to be an array of your specification, or use .pluck() to do it in one step.
class GraphController < ApplicationController
def index
end
def data
render :json => User.select('value').map(&:value)
# or
# render :json => User.pluck('value')
end
end
You can store Arrays and Hashes using ActiveRecord's serialize declaration:
class GraphController < ApplicationController
def index
serialize :value
end
def data
render :json => User.value['value1', 'value2'] //etc
end
end
User.select('value').values