activerecord query for an array of arrays

Question

I have the following models:

Notification belongs_to :receiver, class_name: 'User' # has a sent_email boolean column default set to false User has_many :received_notifications, class_name: 'Notification', foreign_key: 'receiver_id', inverse_of: :receiver has_one :alert Alert belongs_to :user # has a frequency integer column

I want to grab all the notifications where the sent_email is false for all users who set their alert frequency to 1, and I want the return result to be something like this:

 [ {user object => [<all of the notifications for user 1>]}, {user object => [<all of the notifications for user 2>]} ]

I want it to be 1 or 2 queries at most.

What would the activerecord query look like?

Arup Rakshit · Accepted Answer · 2015-06-03 15:47:52Z

2

You can use includes.

u = User.includes(:received_notifications, :alert) .where("alerts.frequency_discussion_alerts = ? AND notifications.sent_email = ?", 1, false) .references(:notifications,:alerts)

Now in batch, you can fetch users and do your job.

 u.find_each { |u| u.received_notifications }

edited Jun 3, 2015 at 15:47

answered Jun 3, 2015 at 4:43

Arup Rakshit

119k30 gold badges270 silver badges328 bronze badges

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

8 Comments

Pavan Katepalli Over a year ago

Thanks @R_O_R but it returns all the records in a single array. Is there a way to get all the notifications for each specific reciever_id in its own array inside of an array?

Arup Rakshit Over a year ago

@PavanKatepalli Yes.. call map and build you hash.

Arup Rakshit Over a year ago

@PavanKatepalli what is your db client ? Postgresql?

Pavan Katepalli Over a year ago

The issue with .map could be that I have 20,000 notifications to map over. Do you see that being an issue?

Arup Rakshit Over a year ago

@PavanKatepalli try, .select("users.id*, notifications.*").group("users.id") ... map is not a good idea for large data.

|

Collectives™ on Stack Overflow

activerecord query for an array of arrays

1 Answer 1

8 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Related