spatie / laravel-model-cleanup
This package deletes unneeded records in a database.
Fund package maintenance!
spatie
Installs: 564 834
Dependents: 3
Suggesters: 0
Security: 0
Stars: 406
Watchers: 13
Forks: 39
Open Issues: 0
Requires
- php: ^7.4|^8.0
- illuminate/support: ^7.28|^8.0
Requires (Dev)
- mockery/mockery: ^1.0
- orchestra/testbench: ^5.3|^6.0
- pestphp/pest: ^0.3.0
- pestphp/pest-plugin-laravel: ^0.3.0
- phpunit/phpunit: ^9.0
- spatie/test-time: ^1.2
- vimeo/psalm: ^4.2
README
🚨 THIS PACKAGE IS NO LONGER MAINTAINED, WE RECOMMEND TO USE LARAVEL'S BUILT IN PRUNABLE 🚨
Clean up unneeded records
This package will clean up old records.
The models you wish to clean up should have a method cleanUp
which returns the configuration how the model should be cleaned up. Here's an example where all records older than 5 days will be cleaned up.
use Illuminate\Database\Eloquent\Model; use Spatie\ModelCleanup\CleanupConfig; use Spatie\ModelCleanup\GetsCleanedUp; class YourModel extends Model implements GetsCleanedUp { ... public function cleanUp(CleanupConfig $config): void { $config->olderThanDays(5); } }
After registering the model in the config file, running the clean:models
artisan command will delete all records that have been created more than 5 days ago.
The package contains various other methods for specifying which records should be deleted.
Support us
We invest a lot of resources into creating best in class open source packages. You can support us by buying one of our paid products.
We highly appreciate you sending us a postcard from your hometown, mentioning which of our package(s) you are using. You'll find our address on our contact page. We publish all received postcards on our virtual postcard wall.
Installation
You can install the package via composer:
composer require spatie/laravel-model-cleanup
Next, you must publish the config file:
php artisan vendor:publish --provider="Spatie\ModelCleanup\ModelCleanupServiceProvider"
This is the content of the published config file model-cleanup.php
.
return [ /* * All models in this array that implement `Spatie\ModelCleanup\GetsCleanedUp` * will be cleaned. */ 'models' => [ // App\Models\YourModel::class, ], ];
Optionally, you can schedule the Spatie\ModelCleanup\Commands\CleanUpModelsCommand
to run at a frequency of which you want to clean up models. Here's an example where all models will be cleaned up every day at midnight.
// in app/Console/Kernel.php protected function schedule(Schedule $schedule) { $schedule->command(\Spatie\ModelCleanup\Commands\CleanUpModelsCommand::class)->daily(); }
Usage
All models that you want to clean up must implement the GetsCleanedUp
-interface. In the required
cleanUp
-method you can specify which records are considered old and should be deleted.
Here's an example where all records older than 5 days will be cleaned up.
use Illuminate\Database\Eloquent\Model; use Spatie\ModelCleanup\CleanupConfig; use Spatie\ModelCleanup\GetsCleanedUp; class YourModel extends Model implements GetsCleanedUp { ... public function cleanUp(CleanupConfig $config): void { $config->olderThanDays(5); } }
Next, you should register this model in the models
key of the model-cleanup
config file.
// in config/model-cleanup.php return [ 'models' => [ App\Models\YourModel::class, ], // ... ]
When running the console command clean:models
all models older than 5 days will be deleted.
Soft deleted models
This package also supports cleaning up models that have soft deleting enabled.
Models that use the Illuminate\Database\Eloquent\SoftDeletes
trait and are considered old, will be permanently removed from your database instead of being marked as deleted.
Available methods on CleanupConfig
olderThanDays
Using this method you can mark records that have a created_at
value older than a given number of days as old.
Here's an example where all models older than 5 days are considered old.
public function cleanUp(CleanupConfig $config): void { $config->olderThanDays(5); }
olderThan
The olderThan
method accepts an instance of Carbon
. All models with a created_at
value before that instance, will be considered old.
Here's an example where all models older than a year are considered old.
public function cleanUp(CleanupConfig $config): void { $config->olderThan(now()->subYear()); }
useDateAttribute
When using olderThanDays
and olderThan
methods, the deletion query that is built up behind the scenes will use the created_at
column. You can specify an alternative column, using the useDateAttribute
method.
public function cleanUp(CleanupConfig $config): void { $config ->olderThanDays(5) ->useDateAttribute('custom_date_column'); }
scope
Using the scope
method you can make the query that will delete old records more specific.
Assume that your model has a status
attribute. Only records with a status inactive
may be cleaned up. Here's an example where all records with an inactive
status that are older than 5 days will be cleaned up.
public function cleanUp(CleanupConfig $config): void { $config ->olderThanDays(5) ->scope(fn (Illuminate\Database\Eloquent\Builder $query) => $query->where('status', 'inactive')); }
chunk
By default, models get cleaned up by performing a single delete
query. When you want to clean up a very large table, this single query could lock your table for a long time. It even might not be possible to get the lock in the first place.
To solve this, the package can delete records in chunks using the chunk
method.
In this example, all records older than 5 days will be deleted in chucks of a 1000 records.
public function cleanUp(CleanupConfig $config): void { $config ->olderThanDays(5) ->chunk(1000); }
The package will stop deleting records when there are no more left that should be deleted.
If you need more fine-grained control over when to stop deleting, you can pass a closure as a second argument to chunk
. Returning false
in the closure will stop the deletion process.
In the example below, the deletion process will continue until all records older than 5 days are deleted or the record count of the model goes below 5000.
public function cleanUp(CleanupConfig $config): void { $config ->olderThanDays(5) ->chunk(1000, fn() => YourModel::count() > 5000); }
Events
After the model has been cleaned Spatie\ModelCleanup\Events\ModelCleanedUp
will be fired even if there were no records deleted.
It has two public properties: model
, which contains an instance of the model which was cleaned up. and numberOfDeletedRecords
.
Changelog
Please see CHANGELOG for more information on what has changed recently.
Testing
composer test
Contributing
Please see CONTRIBUTING for details.
Security
If you discover any security related issues, please email freek@spatie.be instead of using the issue tracker.
Postcardware
You're free to use this package, but if it makes it to your production environment we highly appreciate you sending us a postcard from your hometown, mentioning which of our package(s) you are using.
Our address is: Spatie, Kruikstraat 22, 2018 Antwerp, Belgium.
We publish all received postcards on our company website.
Credits
License
The MIT License (MIT). Please see License File for more information.