I am trying to do a permanent delete of previously deleted rows with softdeletes, but when there are no rows to delete my function stops working, I need an “if” for so that this does not happen
my function
JavaScript
x
public function handle()
{
$mailMessage = MailMessage::query()->whereNotNull('deleted_at');
$mailMessage->onDelete();
$mailTask = MailTask::query()->whereNotNull('deleted_at');
$mailTask->onDelete();
$meo = Meo::query()->whereNotNull('deleted_at');
$meo->onDelete();
$this->info('Display this on the screen');
}
for example I’m trying to verify that the variable “$mailMessage” is not empty to continue with my function
thanks for read me 🙂
Advertisement
Answer
you can use simple delete:
JavaScript
public function handle()
{
MailMessage::query()->whereNotNull('deleted_at')->delete();
MailTask::query()->whereNotNull('deleted_at')->delete();
Meo::query()->whereNotNull('deleted_at')->delete();
$this->info('Display this on the screen');
}
added by author: replacing delete for forceDelete is working for me