We have moved our forum to GitHub Discussions. For questions about Phalcon v3/v4/v5 you can visit here and for Phalcon v6 here.
  1. Home
  2. Database

Validate model FK field using default value

Hello guys!

I got such a strange issue... Defined one-to-many relation in DB between "profile" and "user" entities connected by "profileId" field. Then I had set the default value for "profileId" to 2. This number tells that if we create a new user the specific profile will be assigned to him automatically.

So how to organize this behavior using FK-check in models? I mean that one: $this->belongsTo('profileId', 'Profile', 'id', array('alias' => 'Profile', 'foreignKey' => true));

For now creation of a user gives such an error: "Value of field "profileId" does not exist on referenced table" This is because of that mentioned FK-check runs the query to DB to check that specific profile already exists. But it tries to ensure this by querying with the part similar to "... WHERE id = default". Of course, this query fails and gives us an error.

Already tried to $this->skipAttributesOnCreate(array('profileId')) but the problem still persists. I guess it doesn't affect the FK-checker...

Hope for your help! Thanks! Btw sorry for my english...



718
Accepted
answer

Hi,

try setup default value in your model User to profileId property.

class User extends \Phalcon\Mvc\Model {

    protected $profileId = 2;

    // other stuff...

}


2.6k

OK, set it up that way. Thanks!