Laravel Eloquent ORM in Bangla Part-Deleting Models)

Detailed below are different methods to delete records from database using Laravel Eloquent ORM. It provides easy and efficient way to delete data.

1. Deleting a single record:

delete() method using:

A particular record can be deleted from the database using

delete() method.

use App\Models\Post;

// রেকর্ড খুঁজে বের করুন
$post = Post::find(1);

// রেকর্ড মুছে ফেলুন
$post->delete();

Remember: After deletion, the record will no longer be in the database.

2. Deleting multiple records:

Using the

method with the wheredelete() clause:

To delete multiple records, use the where method with the delete() clause.

use App\Models\Post;

// 'draft' স্ট্যাটাসের সকল রেকর্ড মুছে ফেলুন
Post::where('status', 'draft')->delete();

3. Using the destroy() method:

One or more records can be deleted using the

destroy() method.

use App\Models\Post;

// একক রেকর্ড মুছে ফেলুন
Post::destroy(1);

// একাধিক রেকর্ড মুছে ফেলুন
Post::destroy([2, 3, 4]);

Remember: The destroy() method directly deletes records using the primary key.

4. Using model event:

Model Events are triggered when Eloquent models are deleted.

• event: Triggered before the record is deleted.deleting
• Event: Triggered after record is deleted.deleted

class Post extends Model
{
    protected static function booted()
    {
        static::deleting(function ($post) {
            // মুছে ফেলার আগে করণীয় কাজ
            Log::info('Post is being deleted: ' . $post->id);
        });

        static::deleted(function ($post) {
            // মুছে ফেলার পর করণীয় কাজ
            Log::info('Post deleted: ' . $post->id);
        });
    }
}

5. Soft Deletes:

What is soft delete?

Soft delete records are not physically deleted by appending a timestamp to the

column.deleted_at

To use soft delete:

The

trait must be added to the SoftDeletes model.

use App\Models\Post;

// রেকর্ড খুঁজে বের করুন
$post = Post::find(1);

// রেকর্ড মুছে ফেলুন
$post->delete();

Soft delete:

use App\Models\Post;

// 'draft' স্ট্যাটাসের সকল রেকর্ড মুছে ফেলুন
Post::where('status', 'draft')->delete();

Recovering soft deleted records:

use App\Models\Post;

// একক রেকর্ড মুছে ফেলুন
Post::destroy(1);

// একাধিক রেকর্ড মুছে ফেলুন
Post::destroy([2, 3, 4]);

Force Delete:

class Post extends Model
{
    protected static function booted()
    {
        static::deleting(function ($post) {
            // মুছে ফেলার আগে করণীয় কাজ
            Log::info('Post is being deleted: ' . $post->id);
        });

        static::deleted(function ($post) {
            // মুছে ফেলার পর করণীয় কাজ
            Log::info('Post deleted: ' . $post->id);
        });
    }
}

Querying soft deleted records:

• withTrashed(): Returns both soft deleted and non-deleted records.
• onlyTrashed(): will restore only soft deleted records.

6. Direct deletion from database:

Records can be deleted directly with SQL queries using Laravel's DB facade.

use Illuminate\Database\Eloquent\SoftDeletes;

class Post extends Model
{
    use SoftDeletes;

    protected $dates = ['deleted_at'];
}

The above is the detailed content of Laravel Eloquent ORM in Bangla Part-Deleting Models). For more information, please follow other related articles on the PHP Chinese website!