Empty table after seeding in laravel8?

Asked Feb 02 '21 at 17:17

Active Feb 02 '21 at 21:45

Viewed 561 times

I just started working with Laravel and i'm trying to seed my DB. I have a many to many relationship between the users and shops table.

When i'm running php artisan DB:seed the seeder for shops isn't running. And if i run php artisan db:seed --class=ShopsTableSeeder i'm getting an Error SQLSTATE[HY000]: General error: 1364 Field 'user_id' doesn't have a default value

The factory file :

<?php

/** @var \Illuminate\Database\Eloquent\Factory $factory */

use App\Models\Shop;

$factory->define(Shop::class, function () {
    $faker = Faker\Factory::create('fr_FR');

    return [
        'title' => $faker->text($maxNbChars = 20),
        'description' => $faker->text(250),
        ...
        'phone' => $faker->phoneNumber,
        'active_until' => $faker->dateTimeBetween('+0 days', '+2 years'),
    ];
});

And the seeding file :

<?php

namespace Database\Seeders;

use App\Models\Shop;
use App\Models\User;
use Illuminate\Database\Seeder;

class ShopsTableSeeder extends Seeder
{

    public function run()
    {
        factory(Shop::class, 10)->create();

        foreach (Shop::all() as $shop){
            $users = User::inRandomOrder()->take(rand(1,3))->pluck('id');
            $shop->users()->attach($users);
        }
    }
}

how can i set the column user_id in the factory to connect a shop to user ?

edited Feb 02 '21 at 21:45

asked Feb 02 '21 at 17:17

Abdo Rabah

1,670
2
15
31

The error is pretty clear. The column user_id in your shops table **cannot** be null and your factory doesn't set it. – IGP Feb 02 '21 at 21:31
`$shop->users()->attach($users);` this line shouldn't do that ? – Abdo Rabah Feb 02 '21 at 21:35
`factory(...)->create()` – IGP Feb 02 '21 at 21:58
I didn't understand your answer – Abdo Rabah Feb 02 '21 at 22:02
Your shop factory does not return a user_id column. – IGP Feb 02 '21 at 22:58
How can i connect it to a user_id from the User Table ? – Abdo Rabah Feb 02 '21 at 23:00
I suppose you could add the key `'user_id' => User::inRandomOrder()->first()->id` to the shop factory definition. – IGP Feb 02 '21 at 23:02

Empty table after seeding in laravel8?

0 Answers0