Test containers for database testing in Spring Boot - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to start a PostgreSQL test container.

Spring Boot

PostgreSQLContainer<?> postgres = new PostgreSQLContainer<>("[1]:latest");
postgres.start();

Drag options to blanks, or click blank then click option'

Apostgres

Bpostgresql:latest

Cpostgresql

Dpostgres:latest

Attempts:

3 left

💡 Hint

Common Mistakes

Using just 'postgres' without tag

Using incorrect image name like 'postgresql' instead of 'postgres'

The correct Docker image name for PostgreSQL test container is postgres:latest.

2fill in blank

medium

Complete the code to get the JDBC URL from the running container.

Spring Boot

String jdbcUrl = postgres.[1]();

Drag options to blanks, or click blank then click option'

AgetJdbcUrl

BjdbcUrl

CgetJdbcURL

DgetUrl

Attempts:

3 left

💡 Hint

Common Mistakes

Using incorrect method name 'getJdbcURL' (case sensitive)

Using 'getUrl' which returns container URL, not JDBC URL

The method to get the JDBC URL from a PostgreSQLContainer is getJdbcUrl().

3fill in blank

hard

Fix the error in the annotation to use Testcontainers with JUnit 5.

Spring Boot

@[1]
public class MyDatabaseTest {
    // test code
}

Drag options to blanks, or click blank then click option'

AEnableTestcontainers

BTestcontainers

CExtendWith(TestcontainersExtension.class)

DRunWith(Testcontainers.class)

Attempts:

3 left

💡 Hint

Common Mistakes

Using JUnit 4 annotation @RunWith

Using @Testcontainers without extension

For JUnit 5, use @ExtendWith(TestcontainersExtension.class) to enable Testcontainers support.

4fill in blank

hard

Fill both blanks to define a Spring Boot test configuration that uses the container's JDBC URL and credentials.

Spring Boot

@DynamicPropertySource
static void datasourceProperties(DynamicPropertyRegistry registry) {
    registry.add("spring.datasource.url", () -> [1]);
    registry.add("spring.datasource.username", () -> [2]);
}

Drag options to blanks, or click blank then click option'

Apostgres.getJdbcUrl()

Bpostgres.getUsername()

Cpostgres.getPassword()

Dpostgres.getUrl()

Attempts:

3 left

💡 Hint

Common Mistakes

Using getUrl() instead of getJdbcUrl()

Using getPassword() for username

Use getJdbcUrl() for the datasource URL and getUsername() for the username from the container.

5fill in blank

hard

Fill all three blanks to create a Map of properties for Spring Boot datasource configuration using the container.

Spring Boot

Map<String, String> props = Map.of(
    "spring.datasource.url", [1],
    "spring.datasource.username", [2],
    "spring.datasource.password", [3]
);

Drag options to blanks, or click blank then click option'

Apostgres.getJdbcUrl()

Bpostgres.getUsername()

Cpostgres.getPassword()

Dpostgres.getUrl()

Attempts:

3 left

💡 Hint

Common Mistakes

Using getUrl() instead of getJdbcUrl()

Mixing up username and password methods

Use getJdbcUrl(), getUsername(), and getPassword() from the container to configure Spring Boot datasource properties.