UpdateOrCreate may not update timestamp
When the record is identical, the updated_at timestamp is not changed
Consider the following code which is part of a spreadsheet import of a product catalogue.
1
Item::updateOrCreate(
2
['code' => $row[0]],
3
[
4
'description'=> $row[1],
5
'category'=> $row[2],
6
'uom' => $row[3],
7
'case_quantity' => $row[4],
8
'each' => intval(strval($row[5]*100)),
9
'generic' => false
10
]);
Copied!
Using the Eloquent model:updateOrCreate(), if the spreadsheet contains any new items then a new record is added to the product catalogue.
If the Item already exists, but for instance, the price has changed then the existing record is found and updated.
However if the row in the spreadsheet is IDENTICAL to the record already in the database, then Eloquent knows that the record does not have any changes (is not dirty) and skips the write process. In this scenario, the updated_at field retains the previous value.
This might be ok for your use case, but in one project, the updated_at column was being used as part of a scope to show only current products to the user.
The solution is to add updated_at to the data to be written to force a new value, and to ensure that updated_at is in the $fillable array or unguarded.
1
Item::updateOrCreate(
2
['code' => $row[0]],
3
[
4
'description'=> $row[1],
5
'category'=> $row[2],
6
'uom' => $row[3],
7
'case_quantity' => $row[4],
8
'each' => intval(strval($row[5]*100)),
9
'generic' => false,
10
'updated_at' => now(),
11
]);
Copied!
Last modified 8mo ago
Copy link