Seeding Data more than 500 records failed in SQLite

[danangprass]

hello @lakuapik ,
I encountered an issue when seeding data in SQLite. The process failed when inserting more than 500 records (specifically in the District and Village datasets). I was able to resolve it by adding the following line of code::

in District:

From:

District::insert($this->mapVillagesData($data));

To:

   DB::transaction(function () use ($data) {
            foreach (array_chunk($this->mapDistrictsData($data), 500) as $chunk) {
                District::insert($chunk);
            }
        });

in Village:

From:

Village::insert($this->mapVillagesData($data));

To:

   DB::transaction(function () use ($data) {
            foreach (array_chunk($this->mapVillagesData($data), 500) as $chunk) {
                Village::insert($chunk);
            }
        });

It’s a minor issue, but I believe implementing this fix could enhance seeding reliability in SQLite.

[lakuapik]

@danangprass thanks for finding this issue, a PR is welcome.

[danangprass]

Hi @lakuapik , I wanna create PR but I don't have permission.
Please grant the access, thanks