Ruby on Rails 3 howto make 'OR' condition

Question

I need an SQL statement that check if one condition is satisfied:

SELECT * FROM my_table WHERE my_table.x=1 OR my_table.y=1 

I want to do this the 'Rails 3' way. I was looking for something like:

Account.where(:id => 1).or.where(:id => 2) 

I know that I can always fallback to sql or a conditions string. However, in my experience this often leads to chaos when combining scopes. What is the best way to do this?

Another related question, is how can describe relationship that depends on an OR condition. The only way I found:

has_many :my_thing, :class_name => "MyTable",  :finder_sql => 'SELECT my_tables.* ' + 'FROM my_tables ' + 'WHERE my_tables.payer_id = #{id} OR my_tables.payee_id = #{id}' 

However, these again breaks when used in combinations. IS there a better way to specify this?

Answer 1

Account.where(id: [1,2]) no explanation needed.

Answer 2

This will works in Rails 5, see rails master :

Post.where('id = 1').or(Post.where('id = 2')) # => SELECT * FROM posts WHERE (id = 1) OR (id = 2) 

For Rails 3.0.4+:

accounts = Account.arel_table Account.where(accounts[:id].eq(1).or(accounts[:id].eq(2)))