issue on save json field (array)

[chiendv]

Hello,

I using reliese version 1.1.3. When I tried to save record on this model what I get in field "params" is json value of whole record included "params" inside liked bellow

model define

use Reliese\Database\Eloquent\Model;

class CourseAutomation extends Model

	protected $casts = [
                  ...
		'params' => 'array' //this is json field
                ...
	];
	protected $fillable = [
		...
		'params',
		...
	];
}

save record

$record = CourseAutomation::firstOrFail(16);
$data['params'] = ["check_days_value" => "2", "check_days_type" => "month"];
$record->update($data);

data was saved

but here is what I got in database:

{
    "id": 16,
    "course_id": 3,
    "start_at": 0,
    "end_at": 15,
    "child_days": 60,
    "compare": "days",
    "title": "...",
    "content": "...",
    "created_at": "2022-01-11 20:44:17",
    "updated_at": "2022-01-14 16:58:26",
    "section": false,
    "notify": false,
    "chat": false,
    "remind": true,
    "params": {
        "id": 16,
        "course_id": 3,
        "start_at": 0,
        "end_at": 15,
        "child_days": 60,
        "compare": "days",
        "title": "...",
        "content": "...",
        "created_at": "2022-01-11 20:44:17",
        "updated_at": "2022-01-14 16:58:00",
        "section": false,
        "notify": false,
        "chat": false,
        "remind": true,
        "params": {
            "check_days_value": "2",
            "check_days_type": "month"
        },
        "status": true
    },
    "status": true
}

When I change extends of model to Illuminate\Database\Eloquent\Model it working fine.

Hope it could be fine with reliese in next version.

[finiteinfinity]

Hi @chiendv,

Try changing the cast to object rather than array

protected $casts = [
    ...
    'params' => 'object' //this is json field
    ...
];

The issue has been reported a few times, here and here but I've yet to look at what the underlying cause is.

Hope this helps.

[CristianLlanos]

I'm sorry for writing this, but it is not advised to use Reliese\Database\Eloquent\Model; please use Illuminate\Database\Eloquent\Model instead. The former was a proof of concept for an old version of Laravel and unfortunately was not fully tested. It was removed from the default configurations and it should be deprecated. Once again, I'm sorry for the inconvenience it may have caused.