Laravel Eloquent 中的軟刪除通過添加 deleted_at 列來標(biāo)記記錄為已刪除而非真正移除。1. 使用 SoftDeletes 特性并在模型中引入；2. 數(shù)據(jù)庫表需包含 deleted_at 列，通常通過遷移文件使用 $table->softDeletes() 添加；3. 調(diào)用 delete() 方法時(shí)僅設(shè)置 deleted_at 時(shí)間戳；4. 默認(rèn)查詢不包含軟刪除記錄，但可通過 withTrashed() 或 onlyTrashed() 獲??；5. 使用 forceDelete() 徹底刪除軟刪除記錄；6. 通過 restore() 方法恢復(fù)軟刪除記錄，支持批量恢復(fù)。該機(jī)制允許恢復(fù)數(shù)據(jù)且不影響正常查詢結(jié)果。

Soft deletes in Laravel Eloquent are a way to "delete" records from the database without actually removing them. Instead of permanently deleting a row, Laravel marks it as deleted by setting a deleted_at timestamp column. This allows you to restore the record later or filter it out from regular queries.

How Soft Deletes Work

When you enable soft deletes on a model, Laravel automatically modifies all query operations to exclude any records where deleted_at is not null. This means that unless you explicitly ask for soft-deleted records, they won't show up in your results.

To use soft deletes:

• Add the SoftDeletes trait to your model.
• Make sure your database table has a deleted_at column (usually created using $table->softDeletes(); in migrations).

Once set up, calling delete() on a model instance won’t remove it from the database — it will just set the deleted_at field to the current timestamp.

Enabling Soft Deletes in a Model

To enable soft deletes for a model, follow these steps:

1. Import and use the SoftDeletes trait:

   use Illuminate\Database\Eloquent\SoftDeletes;

2. Add the trait inside your model:

   class User extends Model
   {
       use SoftDeletes;
   }

3. Update the corresponding migration file to include the deleted_at column:

   $table->softDeletes();

This setup ensures that when you delete a record, it’s only marked as deleted, not removed.

Note: If you're modifying an existing table, make sure to create a new migration to add the deleted_at column.

Querying Soft Deleted Records

By default, Eloquent hides soft-deleted records. But sometimes, you may want to retrieve them:

• Use withTrashed() to include soft-deleted records in your query:

  User::withTrashed()->find(1);

• Use onlyTrashed() to get only the soft-deleted ones:

  User::onlyTrashed()->get();

These methods are useful when you need to display or restore previously deleted data.

If you want to completely remove a soft-deleted record from the database, use forceDelete():

$user = User::onlyTrashed()->find(1);
$user->forceDelete();

Restoring Soft Deleted Records

You can bring back a soft-deleted record by calling the restore() method:

$user = User::onlyTrashed()->find(1);
$user->restore();

This clears the deleted_at value and makes the record visible again in normal queries.

Restoring multiple records at once? No problem:

User::onlyTrashed()->where('created_at', '<', '2024-01-01')->restore();

Just remember, restoring doesn’t affect relationships by default. You’ll have to handle those manually if needed.

基本上就這些。

以上是軟刪除如何在Laravel雄辯中起作用？的詳細(xì)內(nèi)容。更多信息請(qǐng)關(guān)注PHP中文網(wǎng)其他相關(guān)文章！