{"id":1087,"date":"2023-09-30T14:30:53","date_gmt":"2023-09-30T14:30:53","guid":{"rendered":"https:\/\/www.devopssupport.in\/blog\/?p=1087"},"modified":"2023-10-01T14:35:45","modified_gmt":"2023-10-01T14:35:45","slug":"automatically-deleting-30-day-old-data-in-laravel","status":"publish","type":"post","link":"https:\/\/www.devopssupport.in\/blog\/automatically-deleting-30-day-old-data-in-laravel\/","title":{"rendered":"Automatically Deleting 30-Day Old Data in Laravel"},"content":{"rendered":"\n

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.<\/p>\n\n\n\n

Understanding the Code<\/strong><\/p>\n\n\n\n

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

Here’s a breakdown of the code.<\/p>\n\n\n\n

use App\\Http\\Controllers\\Controller;\r\nuse Illuminate\\Http\\Request;\r\nuse App\\Models\\Post;\r\n<\/code><\/pre>\n\n\n\n
First, we import the necessary dependencies, including the Post<\/code> model, which presumably represents the data we want to delete.<\/p>\n\n\n\n
public function index(Request $request)\r\n{\r\n    Post::whereDate('created_at', '<=', now()->subDays(30))->delete();\r\n}\r\n<\/code><\/pre>\n\n\n\n
Inside the index<\/code> method, we execute a database query using Eloquent. Here’s how it works:<\/p>\n\n\n\n
    \n
  • We use the Post<\/code> model to interact with the database.<\/li>\n\n\n\n
  • The whereDate<\/code> method filters the records based on the created_at<\/code> column of the Post<\/code> model.<\/li>\n\n\n\n
  • We specify that we want to delete records where the created_at<\/code> date is less than or equal to the current date minus 30 days, achieved using now()->subDays(30)<\/code>.<\/li>\n\n\n\n
  • Finally, the delete<\/code> method is called to remove the selected records from the database.<\/li>\n<\/ul>\n\n\n\n
    Implementing the Automatic Deletion Process<\/strong><\/p>\n\n\n\n
    To make this code execute automatically, you can use Laravel’s task scheduling feature. Here’s how to set it up:<\/p>\n\n\n\n
      \n
    1. Open the app\/Console\/Kernel.php<\/code> file in your Laravel project.<\/li>\n\n\n\n
    2. In the schedule<\/code> method, add the following code to schedule the index<\/code> method of PostController<\/code> to run daily.<\/li>\n<\/ol>\n\n\n\n
      <\/p>\n\n\n\n
      protected function schedule(Schedule $schedule)\r\n{\r\n    $schedule->call([new \\App\\Http\\Controllers\\PostController, 'index'])->daily();\r\n}\r\n<\/code><\/pre>\n\n\n\n
        \n
      1. Save the file.<\/li>\n<\/ol>\n\n\n\n
        Now, Laravel will automatically run the index<\/code> method of the PostController<\/code> daily. This means that any data in the Post<\/code> model’s table that is older than 30 days will be deleted automatically.<\/p>\n","protected":false},"excerpt":{"rendered":"
        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… <\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[399,398,206],"class_list":["post-1087","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-automatically-deleting","tag-automatically-deleting-30-day-old-data-in-laravel","tag-database"],"_links":{"self":[{"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/posts\/1087","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/comments?post=1087"}],"version-history":[{"count":1,"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/posts\/1087\/revisions"}],"predecessor-version":[{"id":1088,"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/posts\/1087\/revisions\/1088"}],"wp:attachment":[{"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/media?parent=1087"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/categories?post=1087"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopssupport.in\/blog\/wp-json\/wp\/v2\/tags?post=1087"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}