Combine two ActiveRecord Query results

Question

I currently have two active record queries that I would like to combine together

joins("join relationships ON user_id = followed_id").
              where("follower_id = #{user.id}")

and

where(:user_id => user.id)

Basically I want the results of the second one to appear with the first similar to a UNION statement in SQL. Can it be done in ActiveRecord in this way?

I would prefer to use a union rather that have to join all the followed_ids in a string and use the IN clause in sql.

Any ideas?

-----Edit------ I am looking for a way to get this to work with lazy loading

Answer 1

This was useful for me:

Model.where(...) | Model.where(...)

Answer 2

Use relation & relation:

Model.joins("join relationships ON user_id = followed_id").where("follower_id = {user.id}") & Model.where(:user_id => user.id)

Answer 3

This was useful for me:

An updated version of Rails/ActiveRecord may support this syntax natively. It would look similar to:

Model.where(foo: 'bar').or.where(bar: 'bar')

Or you can, simply sticking with the following works great:

Model.where('foo= ? OR bar= ?', 'bar', 'bar')

referred to this link