Applying database schema changes

Whenever changes are made to the database schema, these changes need to be applied to the databases in use.

In order to apply changes to e.g. the test template database you need to run:

database/schema/upgrade.py -d launchpad_ftest_template
database/schema/security.py -d launchpad_ftest_template

To migrate all of Launchpad’s databases in a standard development setup:

for db in launchpad_empty launchpad_dev_template launchpad_dev launchpad_ftest_template launchpad_ftest_playground; do
    database/schema/upgrade.py -d "$db"
    database/schema/security.py -d "$db"
done

A more heavyweight approach is the following command:

Note

Running this command will erase and rebuild everything.

make schema

If you only want to rebuild the test template database, please run the following command:

make -C database/schema test

If you only want to apply one specific patch for testing purposes, you can run the following command:

This comment will apply file (-f) <your-patch>.sql as a single transaction (-1) to the database named launchpad_dev.