How to use php artisan tinker with relationship

I want to use php tinker to post data into my db, but i am having issues because of the relationships involved.

 public function up()
    {
        Schema::create('questions', function (Blueprint $table) {
            $table->id();
            $table->string('the_question');
            $table->unsignedBigInteger('user_id');
            $table->foreign('user_id')->references('id')->on('users');
            $table->timestamps();
        });
    }

public function up()
    {
        Schema::create('options', function (Blueprint $table) {
            $table->increments('id');
            $table->string('the_option');
            $table->unsignedBigInteger('question_id');
            $table->foreign('question_id')->references('id')->on('questions');
            $table->timestamps();
        });
    }

public function up()
    {
        Schema::create('answers', function (Blueprint $table) {
            $table->increments('id');
            $table->string('correct_answer');
            $table->unsignedBigInteger('question_id');
            $table->foreign('question_id')->references('id')->on('questions');
            $table->timestamps();
        });
    }

or how can i use factory or seeder to go about it. One question with four options and the correct answer

Nakov

4 years ago

Best Answer

Level 73

Based on your last comment, I think you are expecting someone to write the code for you, right?

Here is how you write seeder: https://laravel.com/docs/9.x/seeding#using-model-factories

and the example has uses a factory with a relationship.

1 like

TimiAde

4 years ago

Level 7

@Nakov

public function run()
{
    User::factory()
            ->count(1)
            ->hasQuestions(1)->hasOptions(4)
												->hasAnswer(1)
            ->create();
}

please i dont know how to write it since laravel only gives a single example

Nakov

4 years ago

Level 73

@TimiAde create factories: https://laravel.com/docs/9.x/database-testing#defining-model-factories

Laravel is to show an example on how should be done, of course Laravel does not know what you need to do, and the documentation does not provide solutions, just examples.

1 like

Please or to participate in this conversation.