CoderFunda
  • Home
  • About us
    • Contact Us
    • Disclaimer
    • Privacy Policy
    • About us
  • Home
  • Php
  • HTML
  • CSS
  • JavaScript
    • JavaScript
    • Jquery
    • JqueryUI
    • Stock
  • SQL
  • Vue.Js
  • Python
  • Wordpress
  • C++
    • C++
    • C
  • Laravel
    • Laravel
      • Overview
      • Namespaces
      • Middleware
      • Routing
      • Configuration
      • Application Structure
      • Installation
    • Overview
  • DBMS
    • DBMS
      • PL/SQL
      • SQLite
      • MongoDB
      • Cassandra
      • MySQL
      • Oracle
      • CouchDB
      • Neo4j
      • DB2
      • Quiz
    • Overview
  • Entertainment
    • TV Series Update
    • Movie Review
    • Movie Review
  • More
    • Vue. Js
    • Php Question
    • Php Interview Question
    • Laravel Interview Question
    • SQL Interview Question
    • IAS Interview Question
    • PCS Interview Question
    • Technology
    • Other

02 March, 2023

Laravel Deleted Models Package

 Programing Coderfunda     March 02, 2023     Laravel, Packages, php     No comments   

 The Laravel Deleted Models package by Spatie automatically copies deleted models to a separate table:

According to Freek's writeup about the package, you can think of this package as a "recycle bin for models. The package achieves this through a database table called deleted_models and adding a KeepsDeletedModels trait to your models that you want to save backups of deleted models:

use Illuminate\Database\Eloquent\Model;
use Spatie\DeletedModels\Models\Concerns\KeepsDeletedModels;
 
class BlogPost extends Model
{
use KeepsDeletedModels;
}

This package can also attempt to restore deleted models using a few different methods:

// $blogPost will be restored and returned
$blogPost = BlogPost::restore(5);
 
// $blogPost will be returned, but it is not saved in the DB yet
$blogPost = Blogpost::makeRestored($id);
 
BlogPost::restoreQuietly(5);

You can also tap into the restore process with a Closure if you want to modify the model during the restoration process. This package has other configuration options and considerations, like pruning the deleted models table on a schedule and how often that table is pruned.

You might wonder why you would use this package vs. the built-in soft deletes feature in Laravel core. Freek Van der Herten's writeup does an excellent job of comparing the tradeoffs of both approaches.

In summary, here are some pros and cons of soft deletes:

  • ➕ Soft deletes is very convenient
  • ➕ No data copying needed when "deleting" a model
  • ➕ Deleted records benefit from any future alterations to the table schema
  • ➕ You must keep soft deletes in mind when querying the database (i.e., scope where deleted_at=null)
  • ➖ Referential integrity when soft deleting model associations, this must be done manually
  • ➖ Undelete can be complex when restoring a model (and related models)

And according to Freek, here are some pros and cons of using a separate deleted models table:

  • ➕ No need to adjust queries to account for deleted_at=null
  • ➕ The database can protect referential integrity—deleting a record will also delete all associated records
  • ➕ Easy to permanently delete old data
  • ➖ Harder to restore deleted data as you must copy it back (vs. setting the deleted_at=null to restore a model with simple soft deletes)

You can learn more about this package, get full installation instructions, and view the source code on GitHub.

  • Share This:  
  •  Facebook
  •  Twitter
  •  Google+
  •  Stumble
  •  Digg
Email ThisBlogThis!Share to XShare to Facebook
Newer Post Older Post Home

0 comments:

Post a Comment

Thanks

Meta

Popular Posts

  • How to monitor process status during process lifetime
    I need to track the process status ps axf during executable lifetime. Let's say I have executable main.exec and want to store into a fi...
  • Show page numbers as navigation in Laravel pagination
      Answer Sorted by:                                                Highest score (default)                                                  ...
  • Use Flags For Countries & Languages in Laravel Blade Views
      Blade Flags   is a package to efficiently use   TwEmoji Countries & Languages Flags   in your Laravel Blade views. You can use it easi...
  • How to Run a Python File on a Specific Virtual Desktop Only?
    I want to run a Python script on a specific virtual desktop without affecting other desktops. Currently, when I execute my Python file us...
  • Different output in VisualStudio and Codeblocks
    I need a linear interpolation in 2D array. The output in Codeblocks is correct, but in VisualStudio is not. I got 2 main functions. ...

Categories

  • Ajax (26)
  • Bootstrap (30)
  • DBMS (42)
  • HTML (12)
  • HTML5 (45)
  • JavaScript (10)
  • Jquery (34)
  • Jquery UI (2)
  • JqueryUI (32)
  • Laravel (1017)
  • Laravel Tutorials (23)
  • Laravel-Question (6)
  • Magento (9)
  • Magento 2 (95)
  • MariaDB (1)
  • MySql Tutorial (2)
  • PHP-Interview-Questions (3)
  • Php Question (13)
  • Python (36)
  • RDBMS (13)
  • SQL Tutorial (79)
  • Vue.js Tutorial (69)
  • Wordpress (150)
  • Wordpress Theme (3)
  • codeigniter (108)
  • oops (4)
  • php (853)

Social Media Links

  • Follow on Twitter
  • Like on Facebook
  • Subscribe on Youtube
  • Follow on Instagram

Pages

  • Home
  • Contact Us
  • Privacy Policy
  • About us

Blog Archive

  • July (4)
  • September (100)
  • August (50)
  • July (56)
  • June (46)
  • May (59)
  • April (50)
  • March (60)
  • February (42)
  • January (53)
  • December (58)
  • November (61)
  • October (39)
  • September (36)
  • August (36)
  • July (34)
  • June (34)
  • May (36)
  • April (29)
  • March (82)
  • February (1)
  • January (8)
  • December (14)
  • November (41)
  • October (13)
  • September (5)
  • August (48)
  • July (9)
  • June (6)
  • May (119)
  • April (259)
  • March (122)
  • February (368)
  • January (33)
  • October (2)
  • July (11)
  • June (29)
  • May (25)
  • April (168)
  • March (93)
  • February (60)
  • January (28)
  • December (195)
  • November (24)
  • October (40)
  • September (55)
  • August (6)
  • July (48)
  • May (2)
  • January (2)
  • July (6)
  • June (6)
  • February (17)
  • January (69)
  • December (122)
  • November (56)
  • October (92)
  • September (76)
  • August (6)

Loading...

Laravel News

Loading...

Copyright © CoderFunda | Powered by Blogger
Design by Coderfunda | Blogger Theme by Coderfunda | Distributed By Coderfunda