Micronaut to reuse testcontainer

user_1534925 0
Viewed 697

I am using Micronaut 2.4.0 and using testContainers for SQL Server Integration testing.

Here is my gradle.build

    testImplementation("org.testcontainers:testcontainers")
    testImplementation("org.testcontainers:junit-jupiter")
    testImplementation("org.testcontainers:mssqlserver")

Here is application.yml for test

    url: jdbc:tc:sqlserver://localhost;databaseName=test-db
    username: sa
    password: sa
    driverClassName: org.testcontainers.jdbc.ContainerDatabaseDriver

These are the only changes and micronaut handles creating and starting of testcontainers.

Problem

For each test classes, it creates new container. Most of the time test takes is in container creation.

Is there a way we can re-use the container ? (clearing the DB might still be okay)

testcontainers-junit5 micronaut testcontainers
3 Answers

Late reply but, in case someone stumbles on this.

Try adding TC_REUSABLE=true into the jdbc URL

i.e: jdbc:tc:sqlserver://localhost;databaseName=test-db/TC_INITSCRIPT=db/customer_database_schema.sql&TC_REUSABLE=true

user_131382270

The other answer could be right.

I got it working with TC_DAEMON=true parameter in jdbc URL

So, it becomes

url: jdbc:tc:sqlserver://localhost;databaseName=mydb?TC_DAEMON=true

Edit

Eventually I moved away from test containers and now starting with docker manually

user_15349250

Actually better approach will be creating singleton class with reusable container and applying it to every test which uses database

@Testcontainers
public class PostgresContainer implements TestPropertyProvider {

    private static final PostgreSQLContainer POSTGRE_SQL_CONTAINER;

    static {
        POSTGRE_SQL_CONTAINER = new PostgreSQLContainer(DockerImageName.parse("postgres:latest"))
                .withDatabaseName("test")
                .withPassword("test")
                .withUsername("test");
        POSTGRE_SQL_CONTAINER.start();
    }

    @Override
    public Map<String, String> getProperties() {
        return Map.of(
                "datasource.default.jdbc-url", POSTGRE_SQL_CONTAINER.getJdbcUrl(),
                "datasource.default.username", POSTGRE_SQL_CONTAINER.getUsername(),
                "datasource.default.password", POSTGRE_SQL_CONTAINER.getPassword()
        );
    }
}

@MicronautTest
class BaseDatabaseTest extends PostgresContainer {...}

Note that with Singleton pattern, container will be created only once and be reused in every single test class

user_107364510
Related