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

You can do the same: spin up an Appwrite container. We do that in our integration tests.

Perfect thank you. Is there an example how you create a container for the tests on GitHub? I couldn’t find it

You could use the docker files here: https://appwrite.io/docs/advanced/self-hosting#manual