Level 73
You can do this to create five names.
Name::factory()->count(5)->create();
Dec 27, 2020
5
Level 14
How to insert multiple rows using factory create?
If I have a pre-defined array of values that I would like to insert into the database with one query (instead of looping over them and running n queries), is this possible?
For example:
$names = ['john', 'bob', 'martin', 'eric', 'joe', 'chris'];
foreach($names as $name) {
Name::factory()->create([
'name' => $name,
]);
}
Not too bad for 6 names but if I had defined 6000 names long array, then that would result in 6000 queries... yikes...
Level 14
@tray2 but I want to use my pre-defined array and create the names - john, bob, martin etc.
Level 73
Then you have to loop over them. Or create a call for each name.
However factories should be used to create test data. If you are seeding the database you should use seeders instead.
1 like
Level 3
You can insert array in database with one query like this:
$prepared = collect($names['data'])->map(function($item) use ($timestamp) {
$item['created_at'] = $timestamp;
$item['updated_at'] = $timestamp;
return $item;
});
Name::insert($prepared->toArray());
but as Tray2 suggested, factories should be used to create test data.
1 like
Level 3
i think it is too late, but if somebody will search this solution:
https://laravel.com/docs/10.x/eloquent-factories#sequences
you can just use sequence() method:
$users = User::factory()
->count(2)
->sequence(
['name' => 'First User'],
['name' => 'Second User'],
)
->create();
9 likes
Please or to participate in this conversation.