When to use singular vs plural form in activerecord queries

Asked Dec 31 '15 at 08:07

Active Dec 31 '15 at 08:07

Viewed 588 times

I'm confused about singular vs plural forms in active record association queries.

Here are my two models:

class Biography < ActiveRecord::Base
  has_one :lifestyle, dependent: :destroy
end

class Lifestyle < ActiveRecord::Base
  belongs_to :biography
end

And I've a search form, through which I'm finding lifestyles of a biography where diet is of a certain kind.

query = Biography
query = query.joins(:lifestyle).where(lifestyles:  { diet: params[:diet_ids] }) if params[:diet_ids]
result = query.all

I can understand why joins(:lifestyle) is singular because it is a one to one relationship. But why is lifestyles in where(lifestyles...) plural? Is it because the table name is plural? But I've seen examples on the web where it is not plural as in this link stackoverflow link

edited May 23 '17 at 12:04

Community

asked Dec 31 '15 at 08:07

user1801879

3

It is plural because it is a table name as explained [here](http://api.rubyonrails.org/classes/ActiveRecord/QueryMethods.html#method-i-where) (see `Joins` paragraph). IMO query in the answer in linked material doesn't work, answer below that one is correct. – Mareq Dec 31 '15 at 08:41
Thanks for the link, makes sense. – user1801879 Dec 31 '15 at 19:08
Is there a better way to write the query posted above in question? – user1801879 Dec 31 '15 at 19:09
I'd do it the same way. – Mareq Jan 01 '16 at 11:36

When to use singular vs plural form in activerecord queries

0 Answers0