PHP Generator

generate.php

php

<?php

namespace App\Process;

use App\Models\Model;

class Generate
{
    public int $offset = 0;
    public int $limit = 2000;
    public int $total = 20000;

    private function getData(): array
    {
      $collection = Model::query()
            ->offset($this->offset)
            ->limit($this->limit)
            ->get();

      if ($collection->count()) {
          
            $this->offset += $this->limit;
          
            // or you want to do insert qu its up to you
            return $collection->toArray();
      }

        return [];
    }

    private function cursor(): \Generator
    {
        while ($this->total > $this->offset) {
            yield from $this->getData();
        }
    }
}