36 lines
905 B
PHP
36 lines
905 B
PHP
<?php
|
|
|
|
namespace App\Tasks\Mass\MassUpdate\Group1;
|
|
|
|
use App\Models\Transaction;
|
|
use Carbon\Carbon;
|
|
|
|
class MassUpdate2Task
|
|
{
|
|
/**
|
|
* Atualiza o campo data e valor, mas passando todos os ids das transações,
|
|
* Atualizando com where id in(1,2,3...).
|
|
*
|
|
* 1_000 ...... 19.87ms DONE
|
|
* 10_000 ..... 149.19ms DONE
|
|
* 100_000 ........... 1s DONE
|
|
* 1_000_000 .......... 15s DONE
|
|
*/
|
|
public function handle()
|
|
{
|
|
Transaction::query()
|
|
->select([
|
|
'id',
|
|
])
|
|
->where('id', '>', 0)
|
|
->chunkById(1000, function ($transactions) {
|
|
Transaction::query()
|
|
->whereIn('id', $transactions->pluck('id'))
|
|
->update([
|
|
'date' => Carbon::now(),
|
|
'value' => 1,
|
|
]);
|
|
});
|
|
}
|
|
}
|