how to save related models with non-null foreign k

Question

I have two models:

User

has_one :email

Email

belongs_to :user

I put the email_id foreign key (NOT NULL) inside users table. Now I'm trying to save it in the following way:

@email = Email.new(params[:email])
@email.user = User.new(params[:user])
@email.save

This raises a db exception, because the foreign key constraint is not met (NULL is inserted into email_id). How can I elegantly solve this or is my data modeling wrong?

Answer 1

Hum... Do you have

has_one :email

in your user model?

If it's the case, I think there is a problem. You should use has_one in the user model if it's the email table that has the foreign_key.

You should have a user_id column in the email table I think.

Answer 2

This should work as expected.

@email = Email.create(params[:email])
@email.user.create(params[:user])