Setting Variables in the pivot table on many to many

Question

Setting Variables in the pivot table on many to many

Trent Ramseyer Dec '16

Created Dec '16	Last Reply Dec '16	Replies 2	Views 490	Votes 0

Trent Ramseyer 22.7k

Dec '16

I have the tables Users, Emails, and UserEmails. in the UserEmails pivot table I have a flag for Primary, where would I set that in this scenario when saving?

 // Initiate User Information
        $user = new \Api\Models\User();

        // Add Emails to User
        $email = new  \Api\Models\Email();
        $email->setEmail($_POST['email']);
        $email->setPrimary(1);  // Creates error because this flag is on the pivot table
        $emails[] = $email;
        $user->emails = $emails;
        $user->create();

Thanks

le51 · Answer 1 · 2016-12-12T05:14:23-07:00

Hi,

there is no method setPrimary defined in Phalcon\Mvc\Model so I guess it's one that you'have created by your own ...

What do you want to achiecve exactly ? If it's setting towo composite primary keys the pivot table, it looks like it is not available:

https://github.com/phalcon/cphalcon/issues/1160#issuecomment-23495879

Just a question regarding you app: is it accurate that an email hasMany User ?

Trent Ramseyer · Answer 2 · 2016-12-12T10:21:40-07:00

I just had to switch to trickle down code, the setPrimary() is a getter/setter. I use those to control variable types

 $user = new \Api\Models\User();

// Create Pivot Entry
$userEmail = new \Api\Models\UserEmail();
$userEmail->setPrimary(1);

// Add Emails to User
$email = new  \Api\Models\Email();
$email->setEmail($_POST['email']);

$userEmail->email = $email;
$user->user_email = $userEmail;

le51 · Answer 3 · 2016-12-12T12:14:35-07:00

the setPrimary() is a getter/setter

so you use it to set a primary key (wich one) to a given value ? Or I do still do not understand what you're trying to do ... Anyway, if it's something like that, I think it is not implemented see above.

otherwise, ....


$email = new  \Api\Models\Email();
    // you store email data in Email model
    $email->setEmail($_POST['email']);

    // you store it in the pivot model
    $userEmail->email = $email;
    // and then in the User model
    $user->user_email = $userEmail;