Django Unit Tests for CATMAID

If you want to be able to run the unit tests, you will need to allow the catmaid database user (catmaid_user by default) to create new databases.

Start a postgres shell with:

sudo -u postgres psql

You can change the role with:

postgres=# ALTER USER catmaid_user CREATEDB;
ALTER ROLE

... and you should also add this line at the top of /etc/postgresql/XversionX/main/pg_hba.conf:

local test_catmaid catmaid_user md5

... and then restart PostgreSQL:

sudo /etc/init.d/postgresql restart

Running tests

You can run the tests with:

./manage.py test

If you see an error:

DatabaseError: must be owner of extension plpgsql

Fix it with:

sudo -u postgres psql
ALTER ROLE catmaid_user WITH superuser;

Loading the test fixtures (schema and data) into a new CATMAID database

Directly editing the data in the test fixtures (django/applications/catmaid/fixtures/catmaid_testdata.json) would be very error-prone. A better idea is to create a new CATMAID instance pointing to a database that only contains the fixture data. Then you should only very carefully make changes to the CATMAID instance where they are required to support a new test you want to add.

To create such an instance, follow the usual installation instructions for CATMAID up to the point where you would use the createuser.sh script, and make sure that you specify a new database name, e.g. catmaid_fixture:

scripts/createuser.sh catmaid_fixture catmaid_user p4ssw0rd | sudo -u postgres psql

Then, rather than loading the usual example data, just import the fixture data:

psql -U catmaid_user catmaid_fixture < django/applications/catmaid/fixtures/catmaid_testdata.json

If you want to start again and reload the fixture data into the test database, you can do:

sudo -u postgres dropdb catmaid_fixture
scripts/createuser.sh catmaid_fixture catmaid_user p4ssw0rd | sudo -u postgres psql
psql -U catmaid_user catmaid_fixture < django/applications/catmaid/fixtures/catmaid_testdata.json

Dumping changes in a CATMAID instance back to the test fixtures

Suppose that to create the data for your test, you needed to add a skeleton and a neuron in your CATMAID instance. You should then dump the database back to the fixture files afterwards:

cd ~/catmaid
scripts/database/dump-database.sh catmaid_fixture > django/applications/catmaid/fixtures/catmaid_testdata.json

Then run git diff to check that the additions to the fixtures make sense. (It’s a good idea to check how these changes to the fixtures affect which tests pass.)

Test coverage

If you install coverage.py (pip install coverage in your virtualenv) you can generate test coverage statistics with:

coverage run ./manage.py test catmaid

Then run:

coverage html

... to generate HTML output in htmlcov/index.html.