database/seeders/Development/CustomersSeeder.php (30 lines of code) (raw):
<?php
namespace Database\Seeders\Development;
use Illuminate\Database\Seeder;
use Illuminate\Support\Facades\DB;
class CustomersSeeder extends Seeder
{
public function run()
{
$handle = fopen(__DIR__.'/Data/customers.csv', 'r');
if (!$handle) {
return;
}
while ($data = fgetcsv($handle)) {
$insert[] = [
'id' => $data[0],
'full_name' => $data[1],
'company_name' => $data[2],
'email' => $data[3],
'address' => $data[4],
'postal_code' => $data[5],
'city' => $data[6],
'country' => $data[7],
];
}
foreach (array_chunk($insert, 100, true) as $chunkData) {
DB::table('customers')->insert($chunkData);
}
fclose($handle);
}
}