When developing an application that uses a database, it's important to test your application against a real database. As good as your unit tests may be, some issues can only be caught by running proper integration tests.
If you use Atlas to manage your database schema, it only makes sense to use Atlas to prepare your database for integration tests as well. One way to achieve this is by using docker-compose to create a test environment for your tests to run against. Docker-compose allows you to easily spin up a test database and run your migrations against it, so you can verify that the application works as expected with the updated schema.
On a high-level, the process of setting up integration tests with docker-compose looks like this:
- The database container is provisioned using docker-compose.
- When the database is ready, Atlas is run to apply all existing migrations on this database prior to the tests running.
- Integration tests are provided a connection string to the migrated, local database.
Suppose your project has the following directory structure:
1 directory, 3 files
docker-compose.yaml file looks like this:
test: mysqladmin ping -ppass
When you run
docker-compose up, this is what happens:
mysqlservice is started.
- As it takes a while for the database to start, Docker will probe the container's healthcheck until it returns a success status.
- Once the database is ready, the
migrateservice is started. Which runs the
atlas migrate applycommand to apply all migrations on the database.
After the migrations are applied, the database is ready to be used by your integration tests.
In conclusion, using
docker-compose to set up your integration tests allows you to easily spin up a test database and
apply your migrations to it. This ensures that your application is tested against an up-to-date database schema, and
allows you to catch any issues that may arise when running against a real database.
Have questions? Feedback? Find our team on our Discord server.