Mass upsert in Laravel (Eloquent)

Question

Is there a way to mass upsert (Insert or Update if exists) records in Laravel (MySQL database) ?

Say I have a table with:

[id:1 value:4]
[id:2 value:5]

I want to perform:

Model::massupsert([
  [id:1 value:100],
  [id:3 value:20]
]);

And the table afterwards to be:

[id:1 value:100]
[id:2 value:5]
[id:3 value:20]

Answer 1

Now (Oct 6, 2020), Laravel(v8.10.0) has native upsert support. https://github.com/laravel/framework/pull/34698

Model::upsert([
    ['id' => 1, 'value' => 100],
    ['id' => 3, 'value' => 20],
], 'id');

Answer 2

Laravel has no native UPSERT support.

I've created a package for this: https://github.com/staudenmeir/laravel-upsert

Model::upsert([
    ['id' => 1, 'value' => 100],
    ['id' => 3, 'value' => 20],
], 'id', ['value']);