Upgrade & Secure Your Future with DevOps, SRE, DevSecOps, MLOps!

We spend hours on Instagram and YouTube and waste money on coffee and fast food, but won’t spend 30 minutes a day learning skills to boost our careers.
Master in DevOps, SRE, DevSecOps & MLOps!

Learn from Guru Rajesh Kumar and double your salary in just one year.



Get Started Now!

Automatically Deleting 30-Day Old Data in Laravel

Managing data in a Laravel application is a critical task to ensure optimal performance and prevent database clutter. In this guide, we’ll explore how to automatically delete data that is older than 30 days from your Laravel application’s database. We’ll use a Laravel controller and Eloquent to achieve this task efficiently.

Understanding the Code

The provided code snippet is a part of a Laravel controller named PostController. It contains a method named index, which is responsible for deleting data that is 30 days old.

Here’s a breakdown of the code.

use App\Http\Controllers\Controller;
use Illuminate\Http\Request;
use App\Models\Post;

First, we import the necessary dependencies, including the Post model, which presumably represents the data we want to delete.

public function index(Request $request)
{
    Post::whereDate('created_at', '<=', now()->subDays(30))->delete();
}

Inside the index method, we execute a database query using Eloquent. Here’s how it works:

  • We use the Post model to interact with the database.
  • The whereDate method filters the records based on the created_at column of the Post model.
  • We specify that we want to delete records where the created_at date is less than or equal to the current date minus 30 days, achieved using now()->subDays(30).
  • Finally, the delete method is called to remove the selected records from the database.

Implementing the Automatic Deletion Process

To make this code execute automatically, you can use Laravel’s task scheduling feature. Here’s how to set it up:

  1. Open the app/Console/Kernel.php file in your Laravel project.
  2. In the schedule method, add the following code to schedule the index method of PostController to run daily.

protected function schedule(Schedule $schedule)
{
    $schedule->call([new \App\Http\Controllers\PostController, 'index'])->daily();
}
  1. Save the file.

Now, Laravel will automatically run the index method of the PostController daily. This means that any data in the Post model’s table that is older than 30 days will be deleted automatically.

Related Posts

How We Fixed “sonar-scanner: command not found” and Successfully Analyzed Our Project with SonarQube

Running static code analysis with SonarQube is essential for maintaining clean, quality code. Recently, while working on our Laravel microservice project mhn-doctors-ms, we hit a common yet…

Is SonarQube Community free Edition Good for Laravel Projects?

When working on web development projects using Laravel, JavaScript, and jQuery, maintaining code quality becomes just as important as building features. That’s where tools like SonarQube come…

Laravel Throttle Middleware: How to Increase API Rate Limit Safely and for 429 Too Many Requests

If you’re working with Laravel APIs, you might have encountered this default throttle setting: This line lives in your app/Http/Kernel.php file and controls how many requests a…

Fixing MySQL Error: Incorrect Definition of mysql.column_stats Table

The Problem While working on your MySQL server, you might come across this error in your error log: This error usually shows up after an upgrade or…

Fixing Laravel Migration Error: “Unknown Collation: utf8mb4_0900_ai_ci”

While working with Laravel and MySQL, you might run into an error during migrations like this one: Why This Happens The collation utf8mb4_0900_ai_ci is introduced in MySQL…

Why Dental Surgery Is Good and Important

Dental health plays a vital role in our overall well-being, yet it’s often overlooked until problems become serious. Dental surgery is a powerful solution that not only…

0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x