Managing a Camelot project

Release:0.1
Date:July 02, 2010

Once a project has been created and set up as described in the tutorial Creating a Movie Database Application, it needs to be maintained and managed over time.

Two tools exist to assist in the management of Camelot projects: camelot_admin.py and camelot_manage.py.

camelot_admin.py

camelot_admin is a tool to assist in the creation and development of Camelot projects.

startproject
Starts a new project, use startproject project_name.
makemessages
Outputs a message file with all field names of all entities. This command
requires settings.py of the project to be in the PYTHONPATH

camelot_manage.py

camelot_manage is oriented towards administrators of an installed camelot application. It is used for interacting the database, the model and migration of the database to a certain schema revision.

To use this application, PYTHONPATH should contain a valid settings.py file that will be used to resolve the database engine and the model.

console

Launches a python console with the model all setup for command line interaction.

Within the example movie project one could do the following to print a list of all movie titles to the screen:

from model import Movie
for movie in Movie.query.all():
print movie.title
db_version
Get the version of the database schema from the current database
version
Get the latest available database schema version
upgrade
Upgrade or downgrade the database to the specified version, use upgrade version_number.
version_control
Put the database under version control
schema_display
Generate a graph of the database schema. The result is stored in schema.png. This option requires pydot to be installed.
../_images/schema.png

Table Of Contents

Previous topic

Fixtures : handling static data in the database

Next topic

Schema Revisions and Migrations

This Page