How to write this better? Ruby Sequel chaining OR

Question

In SQL it should look like this:

SELECT * FROM `categories_description_old` WHERE ((`categories_description` = '') OR (`categories_name` = '') OR (`categories_heading_title` = ''))

My (ugly) solution:

conditions = [:categories_name, :categories_heading_title, :categories_description]
b = table_categories_description_old.filter(conditions.pop => "")
conditions.each do |m|
 b = b.or(m => "")
end

Is there a better solution to chain the or conditions?

score 17 · Answer 1 · answered Nov 15 '10 at 18:21

17

 DB[:categories_description_old].
   filter({:categories_description=>'',
           :categories_name=>'',
           :categories_heading_title=>''}.sql_or)

answered Nov 15 '10 at 18:21

Jeremy Evans

11,959
27
26

score 3 · Accepted Answer · answered Nov 15 '10 at 16:06

3

You can do something like:

conditions.inject(table_categories_description_old.filter(true)){|acc, cond|
  acc.or(cond => '')
}

But in cases like this when you have already thought out SQL query, I find it easier to just type whole WHERE condition and use Sequel just to sanitize my query parameters.

answered Nov 15 '10 at 16:06

Mladen Jablanović

43,461
10
90
113

it should be `filter(false)` instead, otherwise conditions are not checked – brauliobo Mar 08 '16 at 12:57

How to write this better? Ruby Sequel chaining OR

2 Answers2