ActiveRecord's `where.not` makes queries easier to read:

ActiveRecord's where.not

ActiveRecord's `where.not` makes queries easier to read:

Gabe Berke-Williams January 22, 2014 rails Rails 4.0 introduced a helpful new method for ActiveRecord queries: where.not . It can make clunky queries easier to read. Usage This query: User.where.not(name: 'Gabe') is effectively the same as this: User.where('name != ?', 'Gabe') It's "effectively" the same because where.not has some extra juice: it will fully qualify the column name with the table name, continue to work if the table or column get aliased (during a left outer join clause with includes), and will continue to work if the database implementation is switched. I've usually seen it used for NOT NULL queries: # Old and busted # User.where('name IS NOT NULL') # New hotness User.where.not(name: nil) But it works with arrays too: # Without `where.not` # Something.where("name NOT IN ?", User.unverified.pluck(:name)) # With `where.not` Something.where.not(name: User.unve...

Full article: http://robots.thoughtbot.com/activerecords-wherenot

Tweets

@cowerks » 06 Feb '14, 3pm
Using Model.where.not(attribute: 'whatever') in #activerecord in #rails4 [link] - thanks @scottw for sharing...
@jsayar » 28 Jan '14, 5pm
ActiveRecord's where.not in Rails 4 [link] #ruby #rails
@scicasoft » 25 Jan '14, 7pm
#ActiveRecord's where.not [link] #ruby #dev
@jerodsanto » 25 Jan '14, 3pm
I follow Rails release notes pretty closely, but somehow I missed `where.not` being added to ActiveRecord in 4.0. [link]
@dipth » 24 Jan '14, 9pm
Oh yes please! [link] Too bad I’m stuck on rails 3.1 XD
@gabebw » 24 Jan '14, 8pm
I continue to write blog posts at a breakneck pace. This one's on ActiveRecord's `where.not`: [link]
@cupakromer » 24 Jan '14, 7pm
RT @thoughtbot: ActiveRecord's `where.not` makes queries easier to read: [link]
@ischroedi » 24 Jan '14, 7pm
thoughtbot news: ActiveRecord's where.not: Rails 4.0 introduced a helpful new method fo... [link] [link]
@thoughtbot » 24 Jan '14, 7pm
ActiveRecord's `where.not` makes queries easier to read: [link]
@gnapse » 24 Jan '14, 8pm
RT @thoughtbot: ActiveRecord's `where.not` makes queries easier to read: [link]
@linuxonrails » 24 Jan '14, 8pm
RT @thoughtbot: ActiveRecord's `where.not` makes queries easier to read: [link]
@jeremy_w_rowe » 24 Jan '14, 7pm
RT @thoughtbot: ActiveRecord's `where.not` makes queries easier to read: [link]
@dsgnrsy » 24 Jan '14, 7pm
ActiveRecord's where.not [link]