Skip to main content

A Django app used to remove oldest records from specific db tables.

Project description

tables_cleaner is a Django app used to remove oldest records from specific db tables.

It is intended to be used in production to keep under control the size of growing tables containing temporary data (used for logging, auditing, …), but preserving the most recent records according to the constraints assigned by design (see TABLES_CLEANER_TABLES setting).

Quick start

  1. Installation:

    pip install django-tables-cleaner
    
    or
    
    pip install git+https://github.com/morlandi/django-tables-cleaner
    
  2. Add “tables_cleaner” to your INSTALLED_APPS setting like this:

    INSTALLED_APPS = [
        ...
        'tables_cleaner',
    ]
    
  3. Run the management command periodically (i.e. with cron)

    python manage.py clean_tables
    

Usage

The first option is to recall periodically the management command clean_tables, for example via cron:

usage: manage.py clean_tables [-h] [--database DATABASE] [-d] [--vacuum]
                              [--version] [-v {0,1,2,3}] [--settings SETTINGS]
                              [--pythonpath PYTHONPATH] [--traceback]
                              [--no-color]

optional arguments:
  -h, --help            show this help message and exit
  --database DATABASE   Nominates a specific database to load fixtures into.
                        Defaults to the "default" database.
  -d, --dry-run         Don't actually delete records (default: False)
  --vacuum              Run VACUUM after deletion
  --version             show program's version number and exit
  -v {0,1,2,3}, --verbosity {0,1,2,3}
                        Verbosity level; 0=minimal output, 1=normal output,
                        2=verbose output, 3=very verbose output
  --settings SETTINGS   The Python path to a settings module, e.g.
                        "myproject.settings.main". If this isn't provided, the
                        DJANGO_SETTINGS_MODULE environment variable will be
                        used.
  --pythonpath PYTHONPATH
                        A directory to add to the Python path, e.g.
                        "/home/djangoprojects/myproject".
  --traceback           Raise on CommandError exceptions
  --no-color            Don't colorize the command output.

Or, when using a different scheduling strategy (for example with django-cron) you can call from Python code the following function:

clean_tables(logger=None, dry_run=False)

For example:

import tables_cleaner
tables_cleaner.clean_tables()

Finally, for very specific needs, you can recall the real workhorse directly:

def clean_table(model_name, keep_records, keep_since_days, keep_since_hours, get_latest_by=None, logger=None, dry_run=False)

which act on a single table, and doesn’t require any setting.

Settings

TABLES_CLEANER_TABLES

The list of models to be cleaned;

options:

  • keep_records: n. of most recent records to be preserved; 0=unused
  • keep_since_days: always preserve records more recent than this; 0=unused
  • keep_since_hourse: always preserve records more recent than this; 0=unused

Example:

TABLES_CLEANER_TABLES = [
    {
        'model_name': 'backend.log',
        'keep_records': 1000,
        'keep_since_days': 1,
        'keep_since_hours': 0,
    }, {
        'model_name': 'tasks.updatedevicetask',
        'keep_records': 100,
        'keep_since_days': 0,
        'keep_since_hours': 12,
        'get_latest_by': 'created',
    },
]

get_latest_by attribute is optional; if not supplied, Model’s Meta get_latest_by is used instead.

Vacuum strategy

“VACUUM” is optionally executed as a final activity (‘–vacuum’).

Since version v0.1.0, we opted to use “VACUUM” instead of “VACUUM FULL”, since that seems more appropriate for ordinary database maintenance, for the following reasons:

  • it’s available for Postgresql and Sqlite (and, hopefully, for other databases too)
  • database owners are allowed to vacuum all tables in their databases
  • an exclusive lock is not required
  • it’s potentially much faster

PostgreSQL documentation explicitly states that The FULL option is not recommended for routine use; see: VACUUM — garbage-collect and optionally analyze a database

Thanks to John Vandenberg for bringing my attention to this.

FileFields and ImageFields

Removing rows in the database when the Model contains one or more FileField or ImageField is not enough, since some garbage is left in the Media folder.

I normally use django-cleanup to cope with this.

Does it work?

A few unit tests have been provided.

Prepare the virtual environment as follows:

python -m pip install -r requirements.txt

then:

./runtests.py

or:

coverage run --source='.' runtests.py
coverage report

License

This code is distributed under the terms of the MIT license.

History

v0.1.4

  • Example project added
  • Refactoring: app logic moved to standalone Python functions
  • Unit tests added

v0.1.3

  • Python and Django classifiers added to setup.py

v0.1.2

  • apply vacuum only when supported by db engines

v0.1.1

  • published on PyPI

v0.1.0

  • prepare for publishing on PyPI
  • use “VACUUM” instead of “VACUUM FULL”
  • dry run option renamed as “-d” (was “-n”)

v0.0.5

  • Fix for Django 2.x: call super() from Command.__init__() as required

v0.0.4

  • Customizable ‘get_latest_by’ attribute
  • Remove EmptyResultSet import which is not available in older versions of Django

v0.0.3

  • Setup fix

v0.0.2

  • First working implementation

v0.0.1

  • Initial setup

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for django-tables-cleaner, version 0.1.4
Filename, size File type Python version Upload date Hashes
Filename, size django_tables_cleaner-0.1.4-py2.py3-none-any.whl (15.7 kB) File type Wheel Python version py2.py3 Upload date Hashes View

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring DigiCert DigiCert EV certificate Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page