increment or decrement without using laravel methods mangodb jassengers

Question

I want to update documents and decrement specific column value. it is possible to use Model::where('','')->update(['count' => \DB::raw('count- 1')]); i'm using jenssegers/laravel-mongodb package.

I want decrement and update documents values together.

$result= Source::where('')
         ->where('');
$result->decrement('count');
$result->update([
   'column' => true,
]);

This code decrement count value but can not update column values.

score 0 · Answer 1 · answered Jul 24 '22 at 15:38

0

From the docs:

Perform increments or decrements (default 1) on specified attributes:

Cat::where('name', 'Kitty')->increment('age');

Car::where('name', 'Toyota')->decrement('weight', 50);

answered Jul 24 '22 at 15:38

Tymur Valiiev

637
9
25

what about Cat other fields update as well – Ali Raza Jul 24 '22 at 15:40
@AliRaza yes it can, read through docs (link already in my answer). And dont forget to approve my answer if you found it good :) – Tymur Valiiev Jul 26 '22 at 07:42

Ali Raza · Accepted Answer · 2022-07-26T08:50:23.187

0

i found it from laravel doc updated column value pass 3rd parameter as array in decrement method

Model::where('', null)
        ->where('', '')
        ->decrement('count', 1, [
            'column1' => value1,
            'column2' => value2,
            'column3' => value3,
        ]);

edited Jul 26 '22 at 08:50

answered Jul 25 '22 at 10:28

Ali Raza

670
5
15

increment or decrement without using laravel methods mangodb jassengers

2 Answers2