6.16. Server Database_pruner¶
The Server Database_pruner connects to a database using a connection string
and cleans out a table based on a date.
It requires the MySQL-python module.
Arguments¶
| Parameter name | Requirement |
|---|---|
-h –help |
optional |
-table |
optional |
-column |
optional |
-date |
optional |
-dry-run |
optional |
-otype |
optional |
-
-h¶ help
-
-table¶ Name of table in database
-
-column¶ Name of column to check for data
-
-date¶ Delete data before the entered date
-
-dry-run¶ Nothing gets deleted, just the summary of what will be deleted
-
-otype¶ Terminal output type. If none is selected, no output will be written.
Configuration¶
An encrypted connection string needs to be generated and loaded from the conn.lucy configuration file located in the Lucy configuration directory.