CODEWITHSUNDEEP
ruby-on-railsrubymysql
Arun
Arun

Reputation: 885

Extract data from Mysql::Object in ruby on rails

I have code to run sql query in ruby as follows

sql = ActiveRecord::Base.connection()
sql.begin_db_transaction
report = sql.execute("select * from users;")
sql.commit_db_transaction

So after this report is an Mysql::object. Now I want to extract all fields and its corresponding data to array or hash.

thanks,

Upvotes: 2

Views: 856

Answers (1)

alex.zherdev
alex.zherdev

Reputation: 24174

execute method should produce a result which gives you a method called all_hashes - it will return an array of hashes corresponding to the rows of query's results, which seems to be what you need. So, call

report.all_hashes

Upvotes: 2

Related Questions