Skip to main content

nashvegas is a management command for managing Django database migrations

Project description

The purpose of this app is to enable a plug and play method for managing database changes.

It really just abstracting out into a reusable app, a script that I have been using in a four person development team quite successfully for more than 6 months now.

Database migrations is a large topic with a lot of different approaches. This approach worked well for my needs so I thought I’d put it out on the “Interwebs” and let the community judge it for it’s usefulness.

How to Use

  • Add the application to your PYTHON_PATH

  • Add the application to your INSTALLED_APPS list in your settings.py file.

  • Execute the command line:

    $ ./manage.py upgradedb –list|–execute [–path /path/to/scripts]

Options

  • –list - Lists all the scripts that will need to be executed.

  • –execute - Executes all the scripts that need to be executed.

  • –path - The fully qualified path to the where the database scripts are located.

    This defaults to {{ PROJECT_PATH }}/db

Conventions

Part of the simplicity of this solution is based on the naming conventions of the sql scripts. They should be named:

YYYYMMDD-##.sql

Where YYYY is the 4 digit year, MM is the two digit month, and DD is the two digit day.

A tabled called versions will be created in your database the first time this command executes. The rows in this table track which scripts have been executed. You should rarely if ever need to examine this table, or even be aware of its existence.

Project details


Download files

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

Source Distribution

nashvegas-0.1a1.dev1.tar.gz (5.5 kB view details)

Uploaded Source

File details

Details for the file nashvegas-0.1a1.dev1.tar.gz.

File metadata

File hashes

Hashes for nashvegas-0.1a1.dev1.tar.gz
Algorithm Hash digest
SHA256 ac41809bb8991ffb91c522a52c85af25a66d51c31e7e465a733a28073d45b1c4
MD5 55ef20e89398a310fa714bcd6d04a43e
BLAKE2b-256 d8a479a55ea655eb8ec4de50594da938ed847148011f08b10b81cf7815ef9d4e

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page