• Stars
    star
    294
  • Rank 141,303 (Top 3 %)
  • Language
    PHP
  • License
    MIT License
  • Created almost 2 years ago
  • Updated 5 months ago

Reviews

There are no reviews yet. Be the first to send feedback to the community and the maintainers!

Repository Details

Automatically copy deleted records to a separate table

Automatically copy deleted records to a separate table

Latest Version on Packagist GitHub Tests Action Status GitHub Code Style Action Status Total Downloads

When deleting an Eloquent model, this package will copy the attributes of that model to a new table called deleted_models. You can view this as a sort of "Recycle bin for models".

$blogPost = BlogPost::find(5); // an Eloquent model

$blogPost->delete(); // values will be copied to the `deleted_models` table.

To restore a previous model you can call restore and pass the id.

$blogPost = BlogPost::restore(5); // $blogPost will be restored and returned

This way of preserving information when deleting can be seen as an alternative to soft deletes. You can read more on the trade-offs in this blog post.

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-deleted-models

To create the deleted_models table, you can publish and run the migrations with:

php artisan vendor:publish --tag="deleted-models-migrations"
php artisan migrate

Optionally, you can publish the config file with:

php artisan vendor:publish --tag="deleted-models-config"

This is the contents of the published config file:

return [
    /*
     * The model uses to store deleted models.
     */
    'model' => Spatie\DeletedModels\Models\DeletedModel::class,

    /*
     * After this amount of days, the records in `deleted_models` will be deleted
     *
     * This functionality uses Laravel's native pruning feature.
     */
    'prune_after_days' => 365,
];

The pruning of the deleted_models table depends on Laravel's native pruning feature. Don't forget to schedule the model:prune as instructed in Laravel's docs.

$schedule->command('model:prune', [
    '--model' => [\Spatie\DeletedModels\Models\DeletedModel::class],
])->daily();

Usage

You should add the KeepsDeletedModels trait to all models whose attributes should be written to deleted_models whenever the model is deleted.

use Illuminate\Database\Eloquent\Model;
use Spatie\DeletedModels\Models\Concerns\KeepsDeletedModels;

class BlogPost extends Model
{
    use KeepsDeletedModels;
}

With this in place, the attributes will be written to deleted_models when the model is deleted.

$blogPost = BlogPost::find(5);

$blogPost->delete(); // values will be copied to the `deleted_models` table.

To restore a previous model you can call restore and pass the id.

$blogPost = BlogPost::restore(5); // $blogPost will be restored and returned

If the model to be restored can't be found in the deleted_models table, a Spatie\DeletedModels\Exceptions\NoModelFoundToRestore exception will be thrown.

Restoring without saving

To restore in memory, without actually saving it, you can call makeRestored. Keep in mind that calling this method will also remove the record in the deleted_models_table.

// $blogPost will be return, but it is not saved in the db yet
$blogPost = Blogpost::makeRestored($id); 

$blogPost->save();

If the model to be restored can't be found in the deleted_models table, null will be returned by makeRestored.

Restoring without emitting events

By default, the Spatie\DeletedModels\Events\RestoringDeletedModelEvent and Spatie\DeletedModels\Events\DeletedModelEvent will be dispatched when calling restore on a model.

If you don't want these events to be dispatched, call restoreQuietly.

BlogPost::restoreQuietly(); // no events will be dispatched

Customizing the restore process

Using closures passed to restore

The restore function accepts a callable as the second argument. The beforeSaving callable will be executed when the restored model was created in memory, but before saving it in the db.

BlogPost::restore(5, function(BlogPost $post, DeletedModel $deletedModel) {
    $post->title = "{$post->title} (restored)";
})

Using methods on the model

If you need to run some logic to before and after restoring a model, you can implement beforeRestoringModel and afterRestoringModel on your model.

use Illuminate\Database\Eloquent\Model;
use Spatie\DeletedModels\Models\Concerns\KeepsDeletedModels;

class BlogPost extends Model
{
    use KeepsDeletedModels;
    
    public static function beforeRestoringModel(DeletedModel $deletedModel): void
    {
        // this will be executed right before restoring a model
    }

    public static function afterRestoringModel(
        Model $restoredMode,
        DeletedModel $deletedModel
    ): void
    {
        // this will be executed right after restoring a model
    }
}

To determine which attributes and values should be kept in deleted_models, you can implement attributesToKeep

use Illuminate\Database\Eloquent\Model;
use Spatie\DeletedModels\Models\Concerns\KeepsDeletedModels;

class BlogPost extends Model
{
    use KeepsDeletedModels;
    
    public function attributesToKeep(): array
    {
        // here you can customize which values should be kept. This is
        // the default implementation.
        
        return $this->toArray();
    }
}

Pruning deleted models

After a while, the deleted_models table can become large. The DeletedModel implements Laravel's native MassPrunable trait.

You can configure the number of days records in the deleted_models will be pruned in the prune_after_days key of the deleted-models.php config file. By default, all deleted models will be kept for 365 days.

Don't forget to schedule the model:prune as instructed in Laravel's docs.

Low-level customization of the delete and restoration process

The DeletedModel model implements most logic to keep and restore deleted models. You can modify any of the behaviour by creating a class that extends Spatie\DeletedModels\Models\DeletedModel. You should put the class name of your extended class in the model key of the deleted-models.php config file.

With this in place you can override any of the methods in DeletedModel.

use Spatie\DeletedModels\Models\DeletedModel;

class CustomDeletedModel extends DeletedModel
{
    protected function makeRestoredModel(string $modelClass): mixed
    {
        // add custom logic
    
        return parent::makeRestoredModel($modelClass)
    }
}

Testing

composer test

Changelog

Please see CHANGELOG for more information on what has changed recently.

Contributing

Please see CONTRIBUTING for details.

Security Vulnerabilities

Please review our security policy on how to report security vulnerabilities.

Credits

This package was inspired by these two blog posts:

License

The MIT License (MIT). Please see License File for more information.

More Repositories

1

laravel-permission

Associate users with roles and permissions
PHP
11,600
star
2

laravel-medialibrary

Associate files with Eloquent models
PHP
5,427
star
3

laravel-backup

A package to backup your Laravel app
PHP
5,337
star
4

laravel-activitylog

Log activity inside your Laravel app
PHP
5,316
star
5

browsershot

Convert HTML to an image, PDF or string
PHP
4,434
star
6

laravel-query-builder

Easily build Eloquent queries from API requests
PHP
3,675
star
7

laravel-analytics

A Laravel package to retrieve pageviews and other data from Google Analytics
PHP
2,948
star
8

image-optimizer

Easily optimize images using PHP
PHP
2,450
star
9

async

Easily run code asynchronously
PHP
2,401
star
10

crawler

An easy to use, powerful crawler implemented in PHP. Can execute Javascript.
PHP
2,400
star
11

laravel-responsecache

Speed up a Laravel app by caching the entire response
PHP
2,248
star
12

data-transfer-object

Data transfer objects with batteries included
PHP
2,220
star
13

laravel-translatable

Making Eloquent models translatable
PHP
2,030
star
14

laravel-sitemap

Create and generate sitemaps with ease
PHP
2,011
star
15

dashboard.spatie.be

The source code of dashboard.spatie.be
PHP
1,940
star
16

laravel-fractal

An easy to use Fractal wrapper built for Laravel and Lumen applications
PHP
1,845
star
17

package-skeleton-laravel

A skeleton repository for Spatie's Laravel Packages
PHP
1,714
star
18

period

Complex period comparisons
PHP
1,618
star
19

laravel-collection-macros

A set of useful Laravel collection macros
PHP
1,602
star
20

laravel-newsletter

Manage Mailcoach and MailChimp newsletters in Laravel
PHP
1,570
star
21

checklist-going-live

The checklist that is used when a project is going live
1,489
star
22

laravel-tags

Add tags and taggable behaviour to your Laravel app
PHP
1,454
star
23

opening-hours

Query and format a set of opening hours
PHP
1,340
star
24

schema-org

A fluent builder Schema.org types and ld+json generator
PHP
1,337
star
25

eloquent-sortable

Sortable behaviour for Eloquent models
PHP
1,268
star
26

laravel-cookie-consent

Make your Laravel app comply with the crazy EU cookie law
PHP
1,268
star
27

laravel-data

Powerful data objects for Laravel
PHP
1,240
star
28

laravel-sluggable

An opinionated package to create slugs for Eloquent models
PHP
1,236
star
29

laravel-settings

Store strongly typed application settings
PHP
1,218
star
30

laravel-searchable

Pragmatically search through models and other sources
PHP
1,217
star
31

pdf-to-image

Convert a pdf to an image
PHP
1,207
star
32

laravel-mail-preview

A mail driver to quickly preview mail
PHP
1,171
star
33

once

A magic memoization function
PHP
1,159
star
34

laravel-honeypot

Preventing spam submitted through forms
PHP
1,134
star
35

laravel-image-optimizer

Optimize images in your Laravel app
PHP
1,121
star
36

laravel-google-calendar

Manage events on a Google Calendar
PHP
1,119
star
37

regex

A sane interface for php's built in preg_* functions
PHP
1,097
star
38

laravel-multitenancy

Make your Laravel app usable by multiple tenants
PHP
1,092
star
39

image

Manipulate images with an expressive API
PHP
1,064
star
40

array-to-xml

A simple class to convert an array to xml
PHP
1,056
star
41

laravel-uptime-monitor

A powerful and easy to configure uptime and ssl monitor
PHP
1,020
star
42

db-dumper

Dump the contents of a database
PHP
987
star
43

laravel-webhook-client

Receive webhooks in Laravel apps
PHP
985
star
44

laravel-model-states

State support for models
PHP
968
star
45

laravel-view-models

View models in Laravel
PHP
963
star
46

simple-excel

Read and write simple Excel and CSV files
PHP
930
star
47

laravel-web-tinker

Tinker in your browser
JavaScript
925
star
48

laravel-webhook-server

Send webhooks from Laravel apps
PHP
920
star
49

calendar-links

Generate add to calendar links for Google, iCal and other calendar systems
PHP
904
star
50

laravel-db-snapshots

Quickly dump and load databases
PHP
889
star
51

laravel-mix-purgecss

Zero-config Purgecss for Laravel Mix
JavaScript
887
star
52

laravel-schemaless-attributes

Add schemaless attributes to Eloquent models
PHP
880
star
53

blender

The Laravel template used for our CMS like projects
PHP
879
star
54

fork

A lightweight solution for running code concurrently in PHP
PHP
863
star
55

laravel-schedule-monitor

Monitor scheduled tasks in a Laravel app
PHP
859
star
56

laravel-menu

Html menu generator for Laravel
PHP
854
star
57

phpunit-watcher

A tool to automatically rerun PHPUnit tests when source code changes
PHP
831
star
58

laravel-failed-job-monitor

Get notified when a queued job fails
PHP
826
star
59

laravel-model-status

Easily add statuses to your models
PHP
818
star
60

form-backend-validation

An easy way to validate forms using back end logic
JavaScript
800
star
61

temporary-directory

A simple class to work with a temporary directory
PHP
796
star
62

laravel-feed

Easily generate RSS feeds
PHP
789
star
63

laravel-event-sourcing

The easiest way to get started with event sourcing in Laravel
PHP
772
star
64

enum

Strongly typed enums in PHP supporting autocompletion and refactoring
PHP
769
star
65

laravel-server-monitor

Don't let your servers just melt down
PHP
769
star
66

laravel-package-tools

Tools for creating Laravel packages
PHP
767
star
67

laravel-tail

An artisan command to tail your application logs
PHP
726
star
68

valuestore

Easily store some values
PHP
722
star
69

laravel-health

Check the health of your Laravel app
PHP
719
star
70

geocoder

Geocode addresses to coordinates
PHP
709
star
71

pdf-to-text

Extract text from a pdf
PHP
707
star
72

ssh

A lightweight package to execute commands over an SSH connection
PHP
696
star
73

menu

Html menu generator
PHP
688
star
74

laravel-url-signer

Create and validate signed URLs with a limited lifetime
PHP
685
star
75

ssl-certificate

A class to validate SSL certificates
PHP
675
star
76

laravel-route-attributes

Use PHP 8 attributes to register routes in a Laravel app
PHP
674
star
77

laravel-validation-rules

A set of useful Laravel validation rules
PHP
663
star
78

laravel-pdf

Create PDF files in Laravel apps
PHP
661
star
79

url

Parse, build and manipulate URL's
PHP
659
star
80

laravel-html

Painless html generation
PHP
654
star
81

laravel-event-projector

Event sourcing for Artisans ๐Ÿ“ฝ
PHP
642
star
82

laravel-server-side-rendering

Server side rendering JavaScript in your Laravel application
PHP
636
star
83

vue-tabs-component

An easy way to display tabs with Vue
JavaScript
626
star
84

macroable

A trait to dynamically add methods to a class
PHP
621
star
85

laravel-blade-javascript

A Blade directive to export variables to JavaScript
PHP
618
star
86

laravel-onboard

A Laravel package to help track user onboarding steps
PHP
616
star
87

laravel-csp

Set content security policy headers in a Laravel app
PHP
614
star
88

laravel-cors

Send CORS headers in a Laravel application
PHP
607
star
89

laravel-short-schedule

Schedule artisan commands to run at a sub-minute frequency
PHP
607
star
90

laravel-translation-loader

Store your translations in the database or other sources
PHP
602
star
91

vue-table-component

A straight to the point Vue component to display tables
JavaScript
591
star
92

activitylog

A very simple activity logger to monitor the users of your website or application
PHP
586
star
93

phpunit-snapshot-assertions

A way to test without writing actual testย cases
PHP
584
star
94

http-status-check

CLI tool to crawl a website and check HTTP status codes
PHP
584
star
95

laravel-queueable-action

Queueable actions in Laravel
PHP
584
star
96

ray

Debug with Ray to fix problems faster
PHP
574
star
97

freek.dev

The sourcecode of freek.dev
PHP
571
star
98

server-side-rendering

Server side rendering JavaScript in a PHP application
PHP
568
star
99

string

String handling evolved
PHP
558
star
100

laravel-http-logger

Log HTTP requests in Laravel applications
PHP
538
star