Laravel development: How to soft delete and restore fragments using Laravel?

Laravel Development: How to soft delete and restore fragments using Laravel?

In the Laravel framework, Soft Delete is a very practical function, which can help us handle data deletion operations very well. In practical applications, some data is not deleted in the true sense, but is only marked and can be restored within a certain time limit.

Laravel provides a very convenient soft deletion mechanism, which can simply implement the soft deletion function by adding soft deletion related configurations to the model. Below we will explain in detail how to soft delete and restore fragments using Laravel.

1. Configure model soft deletion

1. In the model, add the following code:

use IlluminateDatabaseEloquentSoftDeletes;

class MyModel extends Model
{
    use SoftDeletes;

    protected $dates = ['deleted_at'];

    // ...
}

2. Use Laravel's SoftDeletes trait, which will be in the model The soft delete function is automatically enabled in .

3. The $dates attribute is a default date format conversion of the Laravel framework. It is generally used on datetime, date or timestamp fields in the database. It accepts an array of this field and is used to automatically convert the field. into a Carbon instance and format it.

4. In the model, a deleted_at field will be automatically added to the corresponding data table, and when the deletion operation is performed, the field will be set to the current time, thereby realizing the soft deletion function.

2. Query model soft-deleted data

Laravel provides a very simple function of querying soft-deleted data. Just add withTrashed() to the query statement.

// 获取软删除的对象
MyModel::withTrashed()->where('id', 1)->get();

// 获取全部的对象，包括软删除的
MyModel::withTrashed()->get();

// 只获取软删除的对象
MyModel::onlyTrashed()->get();

3. Restore soft-deleted data

If you need to restore soft-deleted data, you need to call the restore() method.

// 恢复某一条被软删除的数据
MyModel::withTrashed()->find($id)->restore();

// 按条件恢复符合条件的数据
MyModel::withTrashed()->where('is_visible', true)->restore();

4. Completely delete the soft-deleted data

If some soft-deleted data is no longer needed, we can completely delete it with one line of code.

// 彻底删除某一条软删除的数据
MyModel::withTrashed()->find($id)->forceDelete();

// 按条件彻底删除符合条件的数据
MyModel::withTrashed()->where('is_visible', true)->forceDelete();

In summary, using Laravel's soft deletion and recovery fragment functions can greatly enhance the rollbackability of data without actually deleting the data, reducing the risk of misoperation. At the same time, its implementation is also very simple, you only need to enable relevant functions in the model.

The above is the detailed content of Laravel development: How to soft delete and restore fragments using Laravel?. For more information, please follow other related articles on the PHP Chinese website!