Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Error while using `find_or_create_by` on a `has_many` `through` association

I am running in to a problem while using find_or_create_by on a has_many through association.

class Permission < ActiveRecord::Base
  belongs_to :user
  belongs_to :role
end

class Role < ActiveRecord::Base
  # DB columns: user_id, role_id

  has_many :permissions
  has_many :users, :through => :permissions
end

class User
  has_many :permissions
  has_many :roles, :through => :permissions
end

Rails throws an error when I invoke find_or_create_by on roles association of a User object.

u = User.first
u.roles.find_or_create_by_rolename("admin")

# Rails throws the following error
# NoMethodError: undefined method `user_id=' for #<Role id: nil, rolename: nil, 
#  created_at: nil, updated_at: nil>

I was able to work around the problem by changing my code as follows:

unless u.roles.exists?(:rolename => "admin")
  u.roles << Role.find_or_create_by_rolename("admin") 
end

I am curious to find if find_or_create_by works with has_many through associations.

like image 378
Harish Shetty Avatar asked Feb 09 '10 21:02

Harish Shetty


1 Answers

It works, but not with :through.

like image 106
Marcel Jackwerth Avatar answered Nov 15 '22 00:11

Marcel Jackwerth