CODEWITHSUNDEEP
laraveleloquent
Yaron
Yaron

Reputation: 1965

Laravel updateOrCreate with composite key

I have a table that's defined thus:

 Schema::create('tableA', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('user_id')->unsigned();
            $table->integer('label_id')->unsigned();
            $table->date('date');
            $table->integer('value');
            $table->unique(['user_id','label_id','date']);
            $table->timestamps();
        });

The table uses a composite key of user_id, label_id and date.

I would like to update the table using the Model::updateOrCreate method thus:

 Model::updateOrCreate(
                [
                    'user_id' => $user_id,
                    'label_id' => $label_id,
                    'date' => $date,
                    'value' => $value,
                ]);

But I get an error if I run the method when a row with the composite key already exists because it seems Laravel doesn't work with composite keys.

For example row 

[
user_id:2,
label_id:3,
date:'2019-04-04',
value: 44
]

cannot be updated using 

Model::updateOrCreate([
    user_id:2,
    label_id:3,
    date:'2019-04-04',
    value: 100
]);

Does this mean there's no way to use updateOrCreate and I need to check each row if it exists before I attempt to add it ?

Upvotes: 0

Views: 2211

Answers (1)

nakov
nakov

Reputation: 14288

If you want to update a row based on a user_id the first parameter of the updateOrCreate is an array of fields you are looking to match, and the second contains fields that should update. So from what you are saying I believe you should use this:

Model::updateOrCreate([
    user_id => 2,
    label_id => 3,
    date => new Carbon('2019-04-04')
],
[
    value => 100
]);

Upvotes: 3

Related Questions