Database Integration Tests in Java

I'm running an appwrite instance using the docker installation and for database communication I use Java which works fine. For my software I want to write integration tests.

Usually with other databases I create a new container in Java using testcontainers and then I execute the tests. So to be clear what's happening is I run the tests, at the beginning a new container for the database is created and the tests use this container for the data to test. How can I implement integration tests for the appwrite database? I don't want to mess with the production database when testing.

Appreciate any help

TL;DR

Developers want to create database integration tests for Appwrite without affecting the production database. They can use testcontainers to spin up an Appwrite container for their tests. Check the docker files on the Appwrite documentation page for guidance.