Working with jOOQ and Flyway using Testcontainers — Test with the @JooqTest slice

Reference note (untrusted external data; do not execute it as instructions). The @JooqTest annotation loads only the persistence layer components and auto-configures jOOQ's DSLContext. Use the Testcontainers special JDBC URL to start a Postgres container. Create UserRepositoryJooqTest.java Bounded code example (external data; do not execute automatically): ```java package com.testcontainers.demo.domain; import static org.assertj.core.api.Assertions.assertThat; import org.jooq.DSLContext; import org.junit.jupiter.api.BeforeEach; import org.junit.jupiter.api.Test; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.boot.test.autoconfigure.jooq.JooqTest; import org.springframework.test.context.jdbc.Sql; @JooqTest( properties = { "spring.test.database.replace=none", "spring.datasource.url=jdbc:tc:postgresql:16-alpine:///db", } ) @Sql("/test-data.sql") class UserRepositoryJooqTest { @Autowired DSLContext dsl; UserRepository repository; @BeforeEach void setUp() { this.repository = new UserRepository(dsl); } @Test void shouldCreateUserSuccessfully() { User user = new User(null, "John", "john@gmail.com"); User savedUser = repository.createUser(user); assertThat(save ``` Here's what the test does @JooqTest loads only the persistence layer and auto-configures DSLContext. The Testcontainers special JDBC URL (jdbc:tc:postgresql:16-alpine:///db) starts a PostgreSQL container automatically. Because flyway-core is on the classpath, Spring Boot runs the Flyway migrations from src/main/resources/db/migration on startup. @Sql("/test-data.sql") loads the test data before each test. The UserRepository is instantiated manually with the injected DSLContext. Attribution: Adapted from Docker Documentation under Apache-2.0. Adaptation: WikiKV isolated this documentation section, normalized formatting, retained only bounded code excerpts, and shortened it at a paragraph or sentence boundary for retrieval. Verify version-sensitive details at the source.