Automatically delete old versioned Silverstripe records from the database
An extension for Silverstripe to automatically delete old versioned DataObject records from your database when a record is published, following predefined retention policies (see configuration).
When a record is being edited (such as a Page), no changes are made until it is published, so it could have 50 draft versions while you work on the copy. When you publish the page, the module prunes the (by default) all draft copies, leaving just the 10 latest published versions (configurable).
- Delete all but the last XX published versions of a DataObject on publish
- Delete all but the last YY draft versions of a DataObject on publish
- Optionally keep old SiteTree objects where the URLSegment has changed (to preserve redirects)
The module adds three manual tasks to:
- Force a run over the entire database - this task is generally not needed unless you either just install the module and wish to tidy up, or change your DataObject configurations.
- Silverstripe does not currently delete any File records once the file had been physically deleted (probably due to the immediate post-delete functionality relating to internal file linking). I cannot see any purpose of keeping these records after this, so this task will remove all records pertaining to deleted files/folders.
- Force a "reset", keeping only the latest published version of each currently published DataObject (regardless of policy). Unpublished / modified DataObjects are not touched.
- Delete all archived DataObjects.
The tasks can be run via
- Silverstripe ^4.5 || ^5.0
composer require axllent/silverstripe-version-truncator
Configuration is optional (see Default config), however you can create a YML file (eg:
MyCustomObject: keep_versions: 5 keep_drafts: 5
To skip pruning altogether for a particular DataObject, set
keep_versions: 0 for that object class.
To overwrite the global defaults, see
SilverStripe\CMS\Model\SiteTree: keep_versions: 20 keep_drafts: 10
SiteTree (and extending classes eg: Page etc)
On publish, the last 10 published versions are kept, and all draft copied are removed. The only exception is if the
ParentID is has changed, in which case the module will keep a single record for each differing URLSegment to allow auto-redirection.
All other DataObjects
For all other versioned DataObjects, only the latest published version is kept, and all drafts deleted. This can be adjusted per DataObject, or globally (see above).