Ruby on rails-convert activeRecord to arrays

If you just want to convert the sql object into array, you can simply do this:

data = Info.where('compoundName = ?',params[:cmpName]).to_a

and it will perform the fetch.

All you have to do is this,

data_hash = Info.where('compoundName = ?',params[:cmpName]).first.as_json.select{|v| v=~ /^t[02468]*/}

a1 = data_hash.keys
a2 = data_hash.values

As suggested by @suslov ...

First, I'd rename your "Info" class to "Compound" to make it apparent what you're working with :-)

That said, Info.where() is returning all records that match, so if there's only one (or you only care about one) then use Info.where().first.

If you want to refer to your tN properties as "keys" and "values" then define those methods in your model.

Use as_json:

Info.where(compoundName: params[:cmpName]).as_json

So you can use .keys and .values methods.

So the query is currently returning all records which match on compoundName. If you only want one, you should make the query: data = Info.where('compoundName = ?',params[:cmpName]).first

I assume keys and values are methods on the Info model? Maybe something like models/info.rb:

class Info < ActiveRecord::Base
  def keys
    (0..24).map { |n| "t#{n}" }
  end

  def values
    keys.map { |key| self[key] }
  end
end

And make sure you're calling those methods on individual Info records.

You should look into storing the data in array form in the database though.