Relationship in Laravel-5.6

Question

I have three tables like below.

posts
    _id   - integer
    name - string

sentences
    _id      - integer
    post_id - integer
    name    - string

translations (word by word)
    _id          - integer
    post_id     - integer
    sentence_id - integer
    word_id     - integer
    name        - string

In PostController.php I am trying to fetch data like below

return Post::with(['sentences', 'sentences.translations'])->limit(2)->get();

I have function in post.php model is like below

protected $primaryKey = '_id';
public function sentences()
{
    return $this->hasMany('App\Model\sentence', 'post_id','_id');
}

I have function in sentences.php model is like below

protected $primaryKey = '_id';
public function translations()
{
    return $this->hasMany('App\Model\translation', 'sentence_id','_id');
}

I would like to fetch posts along with sentences and translations.

I can fetch post and sentences but I am facing issue while I am trying to fetch translations.

I am getting all the translations which sentence_id is matched with idof sentences table, but post_id is not matching with the current post id of post table.

What issue are you facing? Do you mean Post::with('sentences.translations')->get()? — Jonas Staudenmeir
– Jonas Staudenmeir, Commented Jul 13, 2018 at 13:18
Your translations relationship is correct, but somehow Laravel uses it with different columns. — Jonas Staudenmeir
– Jonas Staudenmeir, Commented Jul 13, 2018 at 15:32
You haven't overridden the getForeign function in the sentence model have you? — Brian Lee
– Brian Lee, Commented Jul 13, 2018 at 21:57

Brian Lee · Accepted Answer · 2018-07-14 05:16:50Z

1

If you've named your primary keys any thing other than id, you need to set the primary key name on each model:

class Post extends Model {
    protected $primaryKey = '_id';
}

Match your relations to the correct name also:

return $this->hasMany(Sentence::class, 'post_id','_id');

answered Jul 14, 2018 at 5:16

Brian Lee

18.3k3 gold badges45 silver badges55 bronze badges

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

3 Comments

abu abu Over a year ago

Thanks @DigitalDrifter. Actually I set the primary key name on each model like this protected $primaryKey = '_id'; but I forgot to mention here. My issue is like this ... I am getting all the translations which sentence_id is matched with id of sentences table, but post_id is not matching with the current post id of post table.

Brian Lee Over a year ago

In that case it seems you've correctly setup the relations, I'm curious what does $post->getForeignKey() return?

abu abu Over a year ago

Thanks @DigitalDrifter. $post->getForeignKey() returns post_id. Thanks.

Collectives™ on Stack Overflow

Relationship in Laravel-5.6

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related