Skip to main content
Help us improve Python packaging – donate today!

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.

Database migrations is a large topic with a lot of different approaches. This approach worked well for my needs and maybe it will for you as well.

How to Use

  • pip install nashvegas

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

  • Execute the command line:

    $ ./manage.py upgradedb –create|–list|–execute

Options

  • --create - Compares database with current models in apps that are
    installed and outputs the sql for them so that you can easily pipe the contents to a migration.
  • --list - Lists all the scripts that will need to be executed.
  • --execute - Executes all the scripts that need to be executed.
  • --seed - Populates Migration model with scripts that have already been
    applied to your database and effectively want to skip execution.

Conventions

Part of the simplicity of this solution is based on the naming conventions of the sql scripts. They should be named in a manner that enforces order. Some examples include:

0001_short_comment_about_migration.sql
0001.sql

The model, nashvegas.Migration will get synced into your database if it doesn’t exist when you go to execute any of the upgradedb commands. In this model the scripts that have been executed will be recorded, effectively versioning your database.

In addition to sql scripts, --execute will also execute python scripts that are in the directory. This are run in filename order interleaved with the sql scripts. For example:

0001.sql
0002.py
0003.sql

The Python script will be executed 2nd between 0000.sql and 0003.sql. The script will only be executed if the module contains a callable named migrate. It is a good idea to put all your executing code within a class or series of functions or within a singe migrate() function so as to avoid code executing upon import.

For example, your script might light like this if you need to update all your product codes on next release:

from store.models import Product

def migrate():
    for product in Product.objects.all():
        product.code = "NEW-%s" % product.code
        product.save()

Release history Release notifications

History Node

0.8b1

History Node

0.7

History Node

0.6.4

History Node

0.6.3

History Node

0.6.2

History Node

0.6.1

History Node

0.6

History Node

0.6a1.dev1

History Node

0.5.2

History Node

0.5.1

History Node

0.5

This version
History Node

0.4.1

History Node

0.4

History Node

0.3.1

History Node

0.3

History Node

0.2.1

History Node

0.2

History Node

0.2a1.dev4

History Node

0.2a1.dev3

History Node

0.2a1.dev2

History Node

0.2a1.dev1

History Node

0.1a1.dev2

History Node

0.1a1.dev1

Download files

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

Filename, size & hash SHA256 hash help File type Python version Upload date
nashvegas-0.4.1.tar.gz (8.2 kB) Copy SHA256 hash SHA256 Source None Jan 23, 2011

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging CloudAMQP CloudAMQP RabbitMQ AWS AWS Cloud computing Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page