Help needed for error in foreign key validation

I have two models bank and country. User should only associate a Bank
with
a country id present in the country table and I put validates presence
of
country to enforce it but i get error mysql2::Error: Unknown column
‘countries.bank_id’ in ‘where clause’: SELECT countries.* FROM
countries WHERE countries.bank_id = 17 LIMIT 1 when updating the
bank
table

Can you tell me how to fix the issue? If I remove the
validates_presence_of :country I get a database error as expected when
i
update bank table with a country id not in country table.

class Bank < ActiveRecord::Base

attr_accessible :name,:country_id

has_one :country

validates :name, :presence => true

validates_presence_of :country

end

class Country < ActiveRecord::Base

attr_accessible :name

end

On Nov 17, 10:19am, rubyrookie [email protected] wrote:

has_one :country
Your association is wrong - if bank has a country_id column then the
association should be a belongs_to

Fred

Thanks worked.

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs