Get ActiveRecord MySQL Query result as a hash, not array

Question

When running a mysql query with ActiveRecord with Class.connection.execute('query here'), the result is an array, as opposed to a hash in postgres. This is tested with both mysql and mysql2 adapters, even though the default for mysql2 is to return the query result as a hash.

How can I get ActiveRecord to change the configuration options on the connection to return query results as a hash? Can I just not use ActiveRecord for this and I should use the raw mysql2 client?

possible duplicate of Why does Rails 3 with Mysql2 Gem ActiveRecord::Base.connection.execute(sql) return Array not Hash? — sebkkom
– sebkkom, Commented Oct 28, 2014 at 10:42

Community · Accepted Answer · 2017-05-23 11:54:31Z

26

I had a similar problem and I found the solution on this answer:

You can do data = Class.connection.exec_query('query here') to get an ActiveRecord::Result

Then, you can do data.first for a hash, or use any of the other methods mentioned in the docs.

edited May 23, 2017 at 11:54

CommunityBot

11 silver badge

answered Oct 28, 2014 at 10:42

sebkkom

1,45617 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

244an Over a year ago

Thanks, it's exec_query that do the trick, I was testing with execute

sebkkom Over a year ago

@244an Glad this is still helpful! :)

Collectives™ on Stack Overflow

Get ActiveRecord MySQL Query result as a hash, not array

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related