MOTOSHARE ๐Ÿš—๐Ÿ๏ธ
Turning Idle Vehicles into Shared Rides & Earnings

From Idle to Income. From Parked to Purpose.
Earn by Sharing, Ride by Renting.
Where Owners Earn, Riders Move.
Owners Earn. Riders Move. Motoshare Connects.

With Motoshare, every parked vehicle finds a purpose. Owners earn. Renters ride.
๐Ÿš€ Everyone wins.

Start Your Journey with Motoshare

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

Engineering Operations Assessment: Identifying Gaps and Building a Roadmap for Improvement

Consider a mid-sized software company that has invested heavily in its technical stack. Its applications run on managed Kubernetes clusters, infrastructure is defined in Terraform, pipelines deploy…

Read More

GitLab CI/CD Getting Started Guide: Build Your First Automated Pipeline

1. Introduction: Your First Step Into GitLab CI/CD Software development becomes significantly slower and more error-prone when teams rely on manual steps to build, test, and release…

Read More

How NoOps Is Changing the Way Modern IT Teams Manage Infrastructure

Modern information technology moves at a pace that often leaves traditional operational structures struggling to keep up. For a growing technology company, success brings rapid user adoption,…

Read More

How to Use GitHub Actions for DevOps Automation & Pipelines

In modern software engineering, moving code from a local branch to production traditionally requires a series of manual builds, tests, security checks, and deployments that slow delivery…

Read More

How to Use Jenkins for CI/CD: A Step-by-Step Guide

In modern software development, writing code is only half the journey. Getting that code safely, quickly, and reliably into the hands of users is where the real…

Read More

Navigating the Pulse: A Comprehensive Guide to Mumbai Local Train Commuting and Urban Transit

Few urban experiences match the sheer momentum of Mumbai during peak hours. The city moves to a relentless, rhythmic heartbeat dictated by its suburban railway network, a…

Read More
0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
0
Would love your thoughts, please comment.x
()
x