Login

freshdb management command

Author:
tomzee
Posted:
December 24, 2007
Language:
Python
Version:
.96
Tags:
db database management
Score:
2 (after 2 ratings)

This is useful especially during the model-creation stage, when things are in constant flux. The freshdb command will drop the project's database, then create a new one. A common use case:

manage.py freshdb

manage.py syncdb

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
"""
put in your project's management/commands/freshdb.py
"""

from django.core.management.base import BaseCommand

class Command(BaseCommand):
    help = "Drops and re-creates the database"

    def handle(self, *args, **options):
        from django.db import connection
        from django.conf import settings
        c = connection.cursor()
        c.execute("DROP DATABASE " + settings.DATABASE_NAME)
        c.execute("CREATE DATABASE " + settings.DATABASE_NAME)
        print 'Created new database: %s' % settings.DATABASE_NAME
        c.close()

More like this

Comments

Please login first before commenting.