حذف رکوردهای پایگاه داده با Laravel Eloquent

1docker-compose exec app php artisan make:command ListDelete

1app/Console/Commands/ListDelete.php

1<?php23namespace App\Console\Commands;45use App\Models\Link;67use App\Models\LinkList;89use Illuminate\Console\Command;1011class ListDelete extends Command1213{1415/**1617* The name and signature of the console command.1819*2021* @var string2223*/2425protected $signature = 'list:delete {list_slug}';2627/**2829* The console command description.3031*3233* @var string3435*/3637protected $description = 'Delete Lists';3839/**4041* Create a new command instance.4243*4445* @return void4647*/4849public function __construct()5051{5253parent::__construct();5455}5657/**5859* Execute the console command.6061*6263* @return int6465*/6667public function handle()6869{7071$list_slug = $this->argument('list_slug');7273$list = LinkList::firstWhere('slug', $list_slug);7475if ($list === null) {7677$this->error("Invalid or non-existent List.");7879return 1;8081}8283if ($this->confirm("Confirm deleting the list '$list->title'? Links will be reassigned to the default list.")) {8485$default_list = LinkList::firstWhere('slug', 'default');8687if (!$default_list) {8889$default_list = new LinkList();9091$default_list->title = 'default';9293$default_list->slug = 'default';9495$default_list->save();9697}9899$this->info("Reassigning links to default list...");100101Link::where('link_list_id', $list->id)->update(['link_list_id' => $default_list->id]);102103$list->delete();104105$this->info("List Deleted.");106107}108109return 0;110111}112113}

1docker-compose exec app php artisan link:show

1+----+-------------------------------------------------+--------------+----------------------------------+23| id | url                                             | list         | description                      |45+----+-------------------------------------------------+--------------+----------------------------------+67| 1  | https://ariaservice.net/community              | ariaservice | DO Community                     |89| 2  | https://ariaservice.net//community/tags/laravel | ariaservice | Laravel Tutorias at AriaService |1011| 3  | https://ariaservice.net//community/tags/php     | ariaservice | PHP Tutorials at AriaService    |1213| 4  | https://twitter.com/ariaservice                | social       | Twitter                          |1415| 5  | https://dev.to/ariaservice                     | social       | DEV.to                           |1617| 6  | https://laravel.com/docs/8.x/eloquent           | default      | Laravel Eloquent Docs            |1819+----+-------------------------------------------------+--------------+----------------------------------+

1docker-compose exec app php artisan list:delete ariaservice

1Confirm deleting the list 'ariaservice'? Links will be reassigned to the default list. (yes/no) :23> y45Reassigning links to default list...67List Deleted.

1+----+-------------------------------------------------+---------+----------------------------------+23| id | url                                             | list    | description                      |45+----+-------------------------------------------------+---------+----------------------------------+67| 1  | https://ariaservice.net/community              | default | DO Community                     |89| 2  | https://ariaservice.net/community/tags/laravel | default | Laravel Tutorias at AriaService |1011| 3  | https://ariaservice.net/community/tags/php     | default | PHP Tutorials at AriaService    |1213| 4  | https://twitter.com/ariaservice                  | social  | Twitter                          |1415| 5  | https://dev.to/ariaservice                       | social  | DEV.to                           |1617| 6  | https://laravel.com/docs/8.x/eloquent           | default | Laravel Eloquent Docs            |1819+----+-------------------------------------------------+---------+----------------------------------+