django-dba focuses on creating an interface for developers working with django applications. It is intended to ease maintaining and administering your database, for common dba operations such as viewing tables status, re-initiating database (drop & create), viewing table storage, viewing collation setup, comparing physical tables with django app models.
You can either install directly using github as below
$ pip install git+https://github.com/mo-mughrabi/django-dba/
You can also download a copy of the code and unzip into your project folder
Once installed you can add "dj_dba" into your INSTALLED_APPS tuple. Only couple configuration available as of date of writing this document
DJ_DBA_DEFAULT_FIXTURES = ( 'ABSOLUTE_PATH_TO_FIXTURE_FILE', ) DJ_DBA_POST_FIXTURE_COMMANDS = ( 'COMMAND_LINE', )
will create the database using credential from settings.py or will prompt to recreate in case database already exists
will show table of analysis ran into each table in the database engine
will show each table name, collation, rows, engine type
this command can be used to compare between use django app models and actual tables in the database and vice versa.