Skip to content

Instantly share code, notes, and snippets.

@taketo1113

taketo1113/ActiveRecord conditions not containing null or empty.md

Last active October 28, 2017 14:10
Show Gist options
  • Save taketo1113/04ea82bb16b619b70e084081082fb724 to your computer and use it in GitHub Desktop.
Save taketo1113/04ea82bb16b619b70e084081082fb724 to your computer and use it in GitHub Desktop.
Download ZIP
How to write an ActiveRecord conditions not containing null or empty
Raw
ActiveRecord conditions not containing null or empty.md

ActiveRecord conditions not containing null or empty

> User.where.not(email: [nil, '']).to_sql
=> "SELECT \"users\".* FROM \"users\" WHERE (NOT ((\"users\".\"email\" = '' OR \"users\".\"email\" IS NULL)))"
  • env
    • ruby: 2.4.1
    • rails: 5.0.2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment