Laravel: how to run seeder with relationships

Question

Why "relationship" in my seeder code isn't working? It inserts to User model without any problem. But doesn't insert anything to UserMeta model. There is not even any error.
I have tested this code in controller. It was functioning fine with "relationship"

    <?php

use Illuminate\Database\Seeder;
use App\User;
use App\UserMeta;

class MyUsersTableSeeder extends Seeder
{
    /**
     * Auto generated seed file.
     *
     * @return void
     */
    public function run()
    {
        if (User::count() == 0) {

            $user = User::create([
                'name'           => 'Admin',
                'email'          => 'admin@admin.com',
                'password'       => bcrypt('password'),
                'remember_token' => str_random(60),
            ]);

            $user_meta = new UserMeta([
                'meta_key' => 'role',
                'meta_value' => 'admin',
            ]);
            $user->UserMeta()->save($user_meta);
        }
    }
}

Model User

public function UserMeta()
{
    return $this->hasOne('App\UserMeta', 'user_id');
}

Model UserMeta

public function user()
{
    return $this->belongsTo('App\User');
}

users table

       Schema::create('users', function (Blueprint $table) {
            $table->increments('id');
            $table->string('name');
            $table->string('email')->unique();
            $table->string('password');
            $table->rememberToken();
            $table->timestamps();
        });

usermeta table

        Schema::create('usermeta', function (Blueprint $table) {
            $table->increments('user_meta_id');
            $table->integer('user_id')->unsigned();
            $table->string('meta_key');
            $table->string('meta_value');
        });

show you both model relationships – Sreejith BS Aug 29 '17 at 11:16 — Sreejith BS, Aug 29 '17 at 11:16
does the user table has usermeta_id ? – Sletheren Aug 29 '17 at 11:26 — Sletheren, Aug 29 '17 at 11:26

Margus Pala · Answer 1 · 2017-08-29T11:59:23.097

1

Try following code:

$user_meta = new UserMeta([
                'meta_key' => 'role','user_id'=>$user_id,
            ]);
$user_meta->user_id=$user->id;
$user_meta->save();

edited Aug 29 '17 at 11:59

answered Aug 29 '17 at 11:41

Margus Pala

8,433
8
42
52

1

I introduced the table in the model. protected $table = 'usermeta'; – Miri Aug 29 '17 at 11:50
Removed mention to naming convention fro my answer – Margus Pala Aug 29 '17 at 12:00

score 1 · Accepted Answer · answered Aug 29 '17 at 12:02

Change your usermeta migration to

Schema::create('usermeta', function (Blueprint $table) {
    $table->increments('user_meta_id');
    $table->integer('user_id')->unsigned();

    // add foreign key constraint
    $table->foreign('user_id')->references('id')->on('users');

    $table->string('meta_key');
    $table->string('meta_value');
});

and re-run your migrations.

Laravel: how to run seeder with relationships

2 Answers2