Multiple attributes in updateOrCreate array (Eloquent)

Question

I'm trying to create a new row if there isn't one yet with the following condition:

['employee_id' => $id, 'competence_id' => $getCompetenceKey]

or if it exists already, I update it and set ['value' => $getCompetenceValue]

So I did this:

foreach($request->input('competence') as $getCompetenceKey => $getCompetenceValue) {
    EmployeeCompetence::updateOrCreate(
     ['employee_id' => $id,'competence_id' => $getCompetenceKey],
     ['value' => $getCompetenceValue]
    );
}

But it doesn't seem to work properly:

https://i.sstatic.net/8ndQt.png

I could do it like this though:

foreach ($request->input('competence') as $getCompetenceKey => $getCompetenceValue) {
    $e = EmployeeCompetence::where('employee_id', $id)->where('competence_id', $getCompetenceKey);
    if ($e->count() > 0) {
        $e->update(['value' => $getCompetenceValue]);
    } else {
            EmployeeCompetence::create(['employee_id' => $id,
                                      'competence_id' => $getCompetenceKey, 
                                              'value' => $getCompetenceValue]);
    }
}

But I really want to know why the updateOrCreate() function didn't work for me.

Thanks,

Kenny

What error laravel gives while updateOrCreate ?!

Hiren Makwana
– Hiren Makwana

2017-10-26 07:54:08 +00:00
Commented Oct 26, 2017 at 7:54 — Hiren Makwana
– Hiren Makwana, Commented Oct 26, 2017 at 7:54
@HirenMakwana no error, just wrong query.

Kenny Hietbrink
– Kenny Hietbrink

2017-10-26 07:55:23 +00:00
Commented Oct 26, 2017 at 7:55 — Kenny Hietbrink
– Kenny Hietbrink, Commented Oct 26, 2017 at 7:55
Thanks check my answer.

Hiren Makwana
– Hiren Makwana

2017-10-26 08:05:39 +00:00
Commented Oct 26, 2017 at 8:05 — Hiren Makwana
– Hiren Makwana, Commented Oct 26, 2017 at 8:05

MODEV · Accepted Answer · 2017-10-26 07:44:28Z

5

The first column is for update, but it should be also passed in the create function.

Example:

EmployeeCompetence::updateOrCreate(
    [
      'employee_id'   => $id, 
      'competence_id' => $getCompetenceKey
    ],
    [
      'value'         => $getCompetenceValue,
      'employee_id'   => $id, 
      'competence_id' => $getCompetenceKey
    ]
);

answered Oct 26, 2017 at 7:44

MODEV

896 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Kenny Hietbrink Over a year ago

Thanks for the comment, but it doesn't seem to fix it. Got the same queries :(

Hiren Makwana · Accepted Answer · 2017-10-26 08:05:02Z

0

I'm not sure this will work or not but as per my understanding.

updateOrCreate takes $primaryKey field as a query.

I'm not sure, may be this will solve your problem. Add below line in your model file and then try

protected $primaryKey = ['employee_id', 'competence_id'];

answered Oct 26, 2017 at 8:05

Hiren Makwana

2,1462 gold badges16 silver badges30 bronze badges

4 Comments

Kenny Hietbrink Over a year ago

Getting: ErrorException (E_WARNING) Illegal offset type

Hiren Makwana Over a year ago

Yes, Need to override some properties, You can find solutions here.. github.com/laravel/framework/issues/5355#issuecomment-161376267

Kenny Hietbrink Over a year ago

Declaration of App\EmployeeCompetence::setKeysForSaveQuery(App\Builder $query) should be compatible with Illuminate\Database\Eloquent\Model::setKeysForSaveQuery(Illuminate\Database\Eloquent\Builder $query)

Hiren Makwana Over a year ago

Have you set public $incrementing = false; ?!

rahul singh · Accepted Answer · 2020-06-09 09:22:54Z

0

I also faced issue with updateOrCreate method .

$user = user::updateOrCreate(
    ['email' =>  'xxx'],
    [
        'location' => 'yyy' ,
    ],
);

first I don't need to pass 'email' in 2nd element of argument. we need to create a fillable variable in model class with fields which we want to update .

protected $fillable = ['email' ,'location' ,'column1' ,'colun2'];

this worked for me so thought to post here.thanks.

answered Jun 9, 2020 at 9:22

rahul singh

4491 gold badge3 silver badges17 bronze badges

Collectives™ on Stack Overflow

Multiple attributes in updateOrCreate array (Eloquent)

3 Answers 3

1 Comment

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related