How do I test for non-null in Ruby::Sequel?

Question

I'm looking to do something like

User.select(...).where(:name != nil)

without writing something like

User.select(...).to_a.find_all {|user| user.name}

I can select for null values, but not for non-null. Is there a trick, or outside Sequel's domain?

score 28 · Accepted Answer · answered May 26 '14 at 22:47

28

You can use exclude instead of where.

User.select(...).exclude(name: nil)

answered May 26 '14 at 22:47

Alex Peachey

score 5 · Answer 2 · answered May 26 '14 at 21:47

5

You can do this:

User.select(...).where('name IS NOT NULL')

answered May 26 '14 at 21:47

zishe

3

This won't work outside of ActiveRecord. However, `.where('name IS NOT NULL'.lit)` would. – Clamoris Aug 14 '17 at 12:03

score 2 · Answer 3 · answered Jul 22 '18 at 02:06

2

The answer you seek is .where(Sequel.~(name: nil))

answered Jul 22 '18 at 02:06

Mason Cloud

3 Answers3