Dependant destroy with altered _id name in join table

rubyonrails-talk
1

I have a "Dependant destroy" and it wont work as its reference is not standard . By this I mean that I have changed the XXX_id to be something else as I had clashes: ambiguous relationships.

class Product < ActiveRecord::Base   belongs_to :company   has_many :allocations, :dependent => :destroy   has_many :companies, :through => :allocations

class Company < ActiveRecord::Base   has_many :products, :dependent => :destroy   has_many :allocations, :dependent => :destroy   has_many :allocated_products, :through => :allocations

And the joining table with an extra field class Allocation < ActiveRecord::Base   belongs_to :company   belongs_to :allocated_product, :class_name => 'Product' end

I realize the error I get when testing deleting a company is due to the fact that its looking to delete product_id from the allocations table but cannot find it.

"Mysql::Error: Unknown column 'allocations.product_id' in 'where clause': SELECT * FROM `allocations` WHERE (`allocations`.product_id = 3)"

I have looked for options on the call but cant see any suitable Can I best do this by using an after delete filter, and how?

Thanks

2

Maybe you need to set the :foreign_key option on your association to "some_other_id"...

3

Sir, This Shiva,I’m a web designer I would like to know about the Ruby on rails and would like to learn more bout it,can you explain bout it??&need to know the advantages of this concept

4

I have a "Dependant destroy" and it wont work as its reference is not standard . By this I mean that I have changed the XXX_id to be something else as I had clashes: ambiguous relationships.

class Product < ActiveRecord::Base belongs_to :company has_many :allocations, :dependent => :destroy

I think you need to specify :foreign_key => 'allocated_product_id' on the above.

Colin

5

Beautiful, than-you

Just so people can see solution:

class Company < ActiveRecord::Base   has_many :memberships, :dependent => :destroy   has_many :notes, :dependent => :destroy   has_many :contacts, :through => :memberships   has_many :products, :dependent => :destroy   has_many :allocations, :dependent => :destroy, :foreign_key => 'allocated_product_id'   #, :dependent => :destroy   has_many :allocated_products, :through => :allocations