Laravel: UpdateOrCreate on Relation?

Question

A user hasOne car.

users

id | name
1  | Bob
2  | Alice

cars

idMember |  color  |  energy
   1     |  blue   |    0.95

Inside the User class I have

public function car()
{
  return $this->hasOne('App\Car','idMember');
}

I want to call updateOrCreate on the relation Model like this:

$user->car()->updateOrCreate(['idMember' => $user->id], ['color' => 'red', 'energy' => '0.1']);

However, I get the error message

"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'where clause' (SQL: update cars set color = red, energy = 0.1, updated_at = 2018-01-12 15:26:47 where id is null)

Why is he looking for

id is null

?

Laravel expect each entity to have an auto-incrementing primary key with the name id , having a primary key is also a relational requirement (though it may be a composite key which laravel does not support). Just save your sanity and add an auto incrementing id column in that table so everything has a unique id. Also by convention laravel expects the foreign key to be <singular other table>_id i.e. in your case idMember should be user_id (but you can change that in your hasOne parameters) — apokryfos
– apokryfos, Commented Jan 12, 2018 at 15:41
@apokryfos oh yeah your right.. forgot about that. But I rather change the primaryKeyof my car model since no AI key is needed in a hasOne relation. — Adam
– Adam, Commented Jan 12, 2018 at 15:48
On one to one relationships having the foreign key as the primary key as you have done is also an option. — apokryfos
– apokryfos, Commented Jan 12, 2018 at 15:51

agm1984 · Accepted Answer · 2020-06-20 17:16:14Z

14

To be clear, your original syntax is correct. You can use it on a relation:

$user->car()->updateOrCreate(['idMember' => $user->id], [
    'color' => 'red',
    'energy' => '0.1',
]);

This will check if there is a car with idMember === $user->id; if so, update color and energy. If not, it will create a car record with idMember, color, and energy.

I haven't tested, but based on the first parameter's array type, you should be able to pass in multiple match conditions, such as

['idMember' => $user->id, 'day' => 'tuesday']

answered Jun 20, 2020 at 17:16

agm1984

17.4k6 gold badges108 silver badges120 bronze badges

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

1 Comment

tinystone Over a year ago

updateOrCreate / upserts in laravel doc and laravel news 1

Matteus Barbosa · Accepted Answer · 2018-01-12 15:41:09Z

2

Your cars model should have a primary key, commonly called "id". Create it.

answered Jan 12, 2018 at 15:41

Matteus Barbosa

2,7731 gold badge23 silver badges22 bronze badges

1 Comment

Adam Over a year ago

Thank you! That of course one way how to solve it. But I prefere the solution witouth AI in cars table

Adam · Accepted Answer · 2018-01-12 15:46:57Z

1

This is how I solved my problem without adding an unnecessary auto incrementing id to the cars model:

class Car extends Model
{

  protected $primaryKey   = 'idMember';
  public    $incrementing = false;

answered Jan 12, 2018 at 15:46

Adam

29.6k30 gold badges187 silver badges281 bronze badges

2 Comments

JJWesterkamp Over a year ago

That is fine now, but you'll run into trouble if you're at some point going to decide that a User can hasMany Cars, because at that point there is nothing left in the cars table that is 'quaranteed' to be unique.

Adam Over a year ago

@JeffreyWesterkamp well for a car a hasone makes not really sense, because people may ahve more then one.. but in my complicated real life scenario I have a hasone relation that will never be a hasmany :). But even if I would want to change it, all I would have to do would change hasOne to hasMany, add the AI and remove the two top lines from the Car model.

Raza Rafaideen · Accepted Answer · 2018-05-21 12:32:26Z

-3

In your model mention the primaryKey if primarykey is not "ID"

protected $primaryKey = "Your Primary Key";

If you do not need icnrementing for your primary key

public    $incrementing = false;

Thats it ..

answered May 21, 2018 at 12:32

Raza Rafaideen

2,2511 gold badge22 silver badges30 bronze badges

Collectives™ on Stack Overflow

Laravel: UpdateOrCreate on Relation?

4 Answers 4

1 Comment

1 Comment

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

1 Comment

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related