Need sql to return an array of objects not an array of hashes

Question

For some reason my query is now returning an array of hashes when I need an array of objects. I can't figure out what to do.

inbox_sql = self.mailbox.inbox.where('conversations.id IN (?)', active_conversations).reorder('').to_sql
sentbox_sql = self.mailbox.sentbox.reorder('').to_sql

sql = "#{inbox_sql} UNION #{sentbox_sql}"
conversations = Profile.connection.execute(sql)

When

self.inbox.mailbox.first.class

returns

Conversation(id: integer, subject: string, created_at: datetime, updated_at: datetime)

BUT

ActiveRecord::Base.connection.execute(sql).first.class

returns hash, which is problematic and ruining the rest of my code in the views. [ Used to return a Conversation object in a less optimal way], but I need it to return a Conversation(..) object

Do you really need all the UNION and to_sql stuff ? It seems too complicated and may be rewritten with a simple where that would return Conversations. What are the relation between self, mailbox and inbox/sentbox ? — Baldrick
– Baldrick, Commented Jun 25, 2014 at 21:25

Shalev Shalit · Accepted Answer · 2014-06-25 21:30:37Z

1

In rails you don't execute things, you use rails ActiveRecord functions.

read about it here: http://guides.rubyonrails.org/active_record_querying.html

for example:

Conversation.where(...)

will execute a sql query and will return Conversation instances

answered Jun 25, 2014 at 21:30

Shalev Shalit

1,9634 gold badges24 silver badges34 bronze badges

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

Collectives™ on Stack Overflow

Need sql to return an array of objects not an array of hashes

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related