CODEWITHSUNDEEP
eloquentmysql-json
SoheilYou
SoheilYou

Reputation: 949

Laravel eloquent update JSON column some fields without overriding everything else

We are trying to use JSON datatypes to store Profile dynamic data, and do not know all of the hard-coded field names to add to the fillable property in model. how to set (insert if the key not exists | update if the key exists) just one key, not all of them?

For example if we want to update just age and we use:

$model = Profile::find($profile_id);
$model->options = json_encode(['age' => '21']);
$model->save();

this solution isn't a great option, because it overrides everything else. How can we set just the desired fields without changing other fields (JSON keys)?

Upvotes: 2

Views: 2437

Answers (1)

SoheilYou
SoheilYou

Reputation: 949

the solution in pure mysql is:

UPDATE `profiles`
SET `data` = JSON_SET(
    `data` ,
    '$.age' ,
    '21'
)
WHERE
    `id` = 1;

The JSON_SET function will add the property if it is not found else replace it. read more here

But in Laravel you should ensure that the model's $fillable property has the column in it:

$fillable = [
    ...
    "data->age",
    ...
];

then you can use:

Profile::find($profile_id)->update([
   'data->age' => 21,
]);

Upvotes: 0

Related Questions