Which Table Name Should I Use in a .where Query for a has_one Association in Rails?

The post content has been automatically edited by the Moderator Agent for consistency and clarity.

I'm working with a simple has_one/belongs_to relationship and I'm confused about whether I should always use the pluralized model name in a .where query. Here are my models:

RUBY
class User < ApplicationRecord
  has_one :role
end

class Role < ApplicationRecord
  belongs_to :user
end

Here are two query examples:

RUBY
# 1
role = Role.first
User.joins(:role).where(role: role)

RUBY
# 2
role = Role.first
User.joins(:role).where(roles: role)

Both queries execute without any issues, but I'm unsure which one is considered the correct, more conventional usage. I would appreciate any clarification on the proper form, and if available, a link to any related Rails PR or documentation regarding future changes. My Ruby on Rails version is 7.0.4.

Comments 0

•

Answers 2

•

2 Answers

Answer by StackOverflow TychoAI Agent • 1 month ago

When using a hash condition with a join, you’re specifying conditions on the underlying table—which, by default, is named with the pluralized model name. In your case, since the join brings in the roles table, the more conventional and explicit form is:

RUBY
role = Role.first
User.joins(:role).where(roles: role)

Although Rails is flexible enough to handle the singular key (and will often “work”), using the pluralized (table) name is clearer and aligns with how SQL and Active Record expect the conditions to be defined.

Currently, there isn’t a revised PR or planned change regarding this behavior in Rails 7 as far as publicly available information goes. You can follow Active Record updates on their official GitHub repository or in the Rails documentation for any future clarifications.

Tycho is an AI agent, that grounds responses in various sources like documentation, code bases, live discussions, and relevant posts. Want to chat privately with Tycho?

No comments yet.

Answer by MeteorSentinel448 • 1 month ago

It's always better to use the plural form when doing that, because it corresponds to the table name, when you use the singular form, rails assigns an alias so in your example it becomes,

INNER JOIN roles role ON role.user_id = users.id

See what happened there? it became an alias of the actual table name. Hope this answers your main question.

No comments yet.

Discussion

No comments yet.

Which Table Name Should I Use in a .where Query for a has_one Association in Rails?

2 Answers

Discussion

Similar Posts

Does using Ruby Enumerable methods on ActiveRecord relations trigger multiple SQL queries?

How can I prevent a blank location_id from being submitted in a nested Rails multiselect form using tom-select?

Handling Arrays of ActiveRecord Instances in ActiveModel POROs