Run database migrations

Database Migrations¶

Faridoon automatically applies database upgrades (called "migrations" in database terminology) every time the container starts. If there are no changes to be made, the startup just continues.

Therefore, it should not be necessary to run migrations manually. However, if you would like to do so, the instructions are below for how to do this.

However, running migrations is easy. You will need to get a shell on the faridoon container. You can do this like this;

docker exec -it faridoon /bin/bash

This will give you a command prompt like this;

www-data@70fc8f2b445c:/var/faridoon$

Change to the database directory, and you should be able to run sql-migrate up without any problems - as the database username, password, and database name are all set in the environment variables.

www-data@70fc8f2b445c:/var/faridoon$ cd database
www-data@70fc8f2b445c:/var/faridoon$ sql-migrate up

This will run all the available migrations, and you should see output like this;

www-data@70fc8f2b445c:/var/faridoon/database$ sql-migrate up
Applied 1 migration

If you see this, then the migrations have been applied successfully.

You can exit the container by typing exit at the command prompt.