在Laravel Eloquent中自动更新日期时间字段的首选方法是什么

Question

I have a table with 3 datetime fields: 1.created_at (generated and handled by Laravel), 2.updated_at (generated and handled by Laravel), 3.custom_date (created by mine, it will be changed every time created_at or updated_at is changed).

I would that every time that a new record is created or the first two fields are changed, the custom_date is updated using a callback. How can achieve this using Eloquent in Laravel 5.7?

I have already tried using a mutator but I would avoid it because I would update the field every time created_at or updated_at are changed.

Answer 1

You should have made the configuration on your migration file like so:

$table->timestamp('custom_date')->default(DB::raw('CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP'));

This way, the custom_date field will update:

1.) When the row was created together with created_at field (on you laravel app).

2.) When the row was updated together with updated_at field (on you laravel app).

3.) When you made any modification directly to the database.