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      |
+===================================+==================+
+-----------------------------------+------------------+
|:option:`-h` `--help`              | optional         |
+-----------------------------------+------------------+
|:option:`-table`                   | optional         |
+-----------------------------------+------------------+
|:option:`-column`                  | optional         |
+-----------------------------------+------------------+
|:option:`-date`                    | optional         |
+-----------------------------------+------------------+
|:option:`-dry-run`                 | optional         |
+-----------------------------------+------------------+
|:option:`-otype`                   | optional         |
+-----------------------------------+------------------+

.. option:: -h

    help

.. option:: -table

    Name of table in database

.. option:: -column

    Name of column to check for data

.. option:: -date

    Delete data before the entered date

.. option:: -dry-run

    Nothing gets deleted, just the summary of what will be deleted

.. option:: -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.