2017 © Pedro Peláez
 

silverstripe-module silverstripe-artefactcleaner

Find and optionally delete disused tables and fields in a SilverStripe database

image

oddnoc/silverstripe-artefactcleaner

Find and optionally delete disused tables and fields in a SilverStripe database

  • Friday, July 1, 2016
  • by oddnoc
  • Repository
  • 1 Watchers
  • 8 Stars
  • 3,086 Installations
  • PHP
  • 0 Dependents
  • 0 Suggesters
  • 5 Forks
  • 1 Open issues
  • 7 Versions
  • 7 % Grown

The README.md

Silverstripe Database Artefact Cleaner

The Silverstripe Database Artefact Cleaner identifies and offers the option to remove unused tables, columns, and indexes in a Silverstripe database., (*1)

Over time, as the database schema evolves, Silverstripe's schema management tools may leave behind obsolete tables, columns, and indexes. This package assists developers by displaying these unnecessary artefacts and provides the option to delete them, ensuring a cleaner and optimized database., (*2)

Installation

To install the Artefact Cleaner, use the following composer command:, (*3)

composer require --dev oddnoc/silverstripe-artefactcleaner

Usage

You can run the cleaner task using either the command line or directly through the browser. For MariaDB users (version 10+), the ifexists=1 option can be added to prevent errors if the targeted column or index doesn't exist during the dropping=1 operation., (*4)

Command Line

vendor/bin/sake dev/tasks/ArtefactCleanTask
vendor/bin/sake dev/tasks/ArtefactCleanTask dropping=1
vendor/bin/sake dev/tasks/ArtefactCleanTask dropping=1 ifexists=1

Browser

  • https://example.org/dev/tasks/ArtefactCleanTask
  • https://example.org/dev/tasks/ArtefactCleanTask?ifexists=1
  • https://example.org/dev/tasks/ArtefactCleanTask?dropping=1
  • https://example.org/dev/tasks/ArtefactCleanTask?dropping=1&ifexists=1

Acknowledgements

This package was inspired by silverstripe-dbplumber by smindel., (*5)

Version

4.1.0, (*6)

The Versions

01/07 2016

dev-develop

dev-develop https://github.com/oddnoc/silverstripe-artefactcleaner

Find and optionally delete disused tables and fields in a SilverStripe database

  Sources   Download

MIT

The Requires

 

database framework utility silverstripe

01/07 2016

dev-master

9999999-dev https://github.com/oddnoc/silverstripe-artefactcleaner

Find and optionally delete disused tables and fields in a SilverStripe database

  Sources   Download

MIT

The Requires

 

database framework utility silverstripe

01/07 2016

3.0.0

3.0.0.0 https://github.com/oddnoc/silverstripe-artefactcleaner

Find and optionally delete disused tables and fields in a SilverStripe database

  Sources   Download

MIT

The Requires

 

database framework utility silverstripe

23/03 2016

2.0.1

2.0.1.0 https://github.com/oddnoc/silverstripe-artefactcleaner

Find and optionally delete disused tables and fields in a SilverStripe database

  Sources   Download

MIT

The Requires

 

database framework utility silverstripe

18/12 2015

2.0.0

2.0.0.0 https://github.com/oddnoc/silverstripe-artefactcleaner

Find and optionally delete disused tables and fields in a SilverStripe database

  Sources   Download

MIT

The Requires

 

database framework utility silverstripe

17/12 2015

1.0.3

1.0.3.0 https://github.com/oddnoc/silverstripe-artefactcleaner

Find and optionally delete disused tables and fields in a SilverStripe database

  Sources   Download

MIT

The Requires

 

database framework utility silverstripe

17/10 2013

1.0.2

1.0.2.0 https://github.com/oddnoc/silverstripe-artefactcleaner

Find and optionally delete disused tables and fields in a SilverStripe database

  Sources   Download

MIT

The Requires

 

database framework utility silverstripe