Eager loading not pulling relationship model

Question

Eager loading not pulling relation model.

Hi, Im using Laravel 6. Our database was created with Zend so our model is a bit strange; I have to set the primary keys.


// Customer model

protected $table = 'customer';
protected $primaryKey = 'Customer_ID';

/**
 * Get all appointments for the customer.
 */
public function appointments()
{
    return $this->hasMany('App\Appointment');
}

Then for the appointments


protected $table = 'appointment';
protected $primaryKey = 'Appointment_ID';

/**
 * Get the customer assigned to this appointment.
 */
public function customer()
{
    return $this->belongsTo('App\Customer');
}

Now, in a controller:

$appointments = App\Appointment::with('customer')->take(5)->get();
return response()->json($appointments, 200);

The array has the appointments but customer is null:

{... Customer_ID: 1234, customer: null}

Any ideas? Thanks

which is the external key of the appointment table for the customer? — Giacomo M, Jan 21 '20 at 13:27
This might seem obvious, but you definitely have a customer record for the appointment you're querying right? — GBWDev, Jan 21 '20 at 13:28
@GiacomoM that would be “Customer_ID”. It shows on the appointments results so the association is there. — Sylar, Jan 21 '20 at 13:33
try to specify primary key, foreign key and table on the relations — Alberto Sinigaglia, Jan 21 '20 at 13:35

score 1 · Accepted Answer · answered Jan 21 '20 at 13:35

1

When you create the relationship in the model, you can tell laravel which is the field of the foreign key.
If you do not do it, laravel supposes the foreign key is id, which is not your case.

The definition of the relationship should becomes:

public function customer()
{
    return $this->belongsTo('App\Customer', 'Customer_ID');
}

answered Jan 21 '20 at 13:35

Giacomo M

4,450
7
28
57

I think I’ve seen this somewhere. Thanks. I’ll try in 15/30mins – Sylar Jan 21 '20 at 13:37
Thank you very, very much!! – Sylar Jan 21 '20 at 13:54

Eager loading not pulling relationship model

1 Answers1