Bulk/Batch upserts

[ndarproj]

Is your feature request related to a problem?

RuntimeException with message 'This database engine does not support upserts.

Describe the solution you'd like

batch upsert https://laravel.com/docs/8.x/eloquent#upserts

Describe alternatives you've considered

foreach updateorcreate is very slow

[ianrussel]

@ndarproj did you manage to have a work around ?

[DishantPal]

for the moment I was able to get it working like this

PostModel::raw(function ($collection) use($data) {
            $bulkResp = collect($data)
                ->reduce(function($acc, $itm) {
                    $acc[] = [
                        'updateOne' => [
                                ['transaction_id' => $itm['key1']], // update condition
                                ['$set' => $itm, '$setOnInsert' => ['key2' => null]], // set the update object data
                                ['upsert' => true]
                            ]
                    ];
                    return $acc;
                }, []);

            if (!empty($bulkResp))
                $collection->bulkWrite($bulkResp);
            return;
        });

ref: https://github.com/jenssegers/laravel-mongodb#:~:text=You%20can%20also%20perform%20raw%20expressions%20on%20the%20internal%20MongoCollection%20object.%20If%20this%20is%20executed%20on%20the%20model%20class,%20it%20will%20return%20a%20collection%20of%20models.

https://i.imgur.com/XdLcyyN.png

https://www.mongodb.com/docs/php-library/current/reference/method/MongoDBCollection-bulkWrite/

[GromNaN]

Tracker in PHPORM-114