How to insert relations based on a nested array in Laravel?

Question

I have 3 tables tests, questions, options.

As you can imagine

a test has many questions
a question belongs to a test
a question has many options
an option belongs to a question

These relations are set up in the models already.

I got the data from the front end in this form:

array:3 [
  "name" => "First Test"
  "preparation" => "First Test prep"
  "questions" => array:2 [
    0 => array:2 [
      "title" => "Some question"
      "options" => array:4 [
        0 => "a"
        1 => "b"
        2 => "c"
        3 => "d"
      ]
    ]
    1 => array:2 [
      "title" => "Another question"
      "options" => array:4 [
        0 => "e"
        1 => "f"
        2 => "g"
        3 => "h"
      ]
    ]
  ]
]

This data perfectly represents these relationships. In fact if I were using a NoSql database I would simply store this in the database.

My question is "what is the best way to store all of this data at once while using eloquent in Laravel"?

Note: It is in the form of Laravel's collection.

Yusup Bugacheev · Accepted Answer · 2016-01-13 06:39:59Z

1

 class Test extends Model {

    $table = 'tests';
    function questions(){
                return $this->hasMany(Question::class, 'test_id');
            }

 }

class Question extends Model {

    $table = 'questions';
    function answers(){
        return $this->hasMany(Answer::class, 'question_id');
            }

    function test(){
        return $this->belongsTo(Test::class, 'test_id');
    }

}

class Answer extends Model {

    $table = 'answers';

    function question(){
        return $this->belongsTo(Question::class, 'question_id');
    }

}

of course i showed only relations ,tables and foreign keys. you can add any additional data to your models.

answered Jan 13, 2016 at 6:39

Yusup Bugacheev

5111 gold badge4 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mateusz Sip · Accepted Answer · 2016-01-13 05:17:45Z

0

You have to create a structure of model objects from given data. JMS Serializer is a great library to do that, and it has laravel integration.

answered Jan 13, 2016 at 5:17

Mateusz Sip

1,2801 gold badge11 silver badges11 bronze badges

Collectives™ on Stack Overflow

How to insert relations based on a nested array in Laravel?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related