CODEWITHSUNDEEP
cakephp
pll
pll

Reputation: 297

CakePHP hasOne association conditions

Hi I am building my User model to have only one profile picture, which is an example of an Image model. I want the conditions of the hasOne to only include the image where the Image.id is equal to the "picture" column in the user table. I know there is something wrong...here is the relevant part of code.

    var $hasOne = array(
            'ProfileImage' => array(
                    'className' => 'Image',
                    'conditions' => array('ProfileImage.id' => 'User.picture'),
                    'dependent' => false,
                    'foreignKey' => 'user_id',
            )
    );

What is wrong with my conditions? How do I specifc ProfileImage.id to be equal to the picture column in the User model? Thanks!

Upvotes: 2

Views: 4106

Answers (1)

deceze
deceze

Reputation: 522091

If the foreign key (picture) is in the User model, then your association should be User belongsTo Image. If the image can only be used by one user at a time, the reverse would be Image hasOne user. If an image can be used by multiple users, it would be Image hasMany User.

But, if the image can only be used by one user at a time, the better data structure would be to add a user_id column to the images table. Then you have a User hasOne Image/Image belongsTo User relationship.

For neither you need conditions, only the foreignKey.

After your clarification of the issue, your condition needs to look like:

'conditions' => array('ProfileImage.id = User.picture')

Otherwise Cake thinks ProfileImage.id should equal the string "User.picture".

Upvotes: 4

Related Questions