Testing Repository Queries with @DataJpaTest and DynamicPropertyRegistry

@DataJpaTest
@AutoConfigureTestDatabase(replace = AutoConfigureTestDatabase.Replace.NONE)
@Testcontainers
class OrderRepositoryTests {
 
    @Container
    static PostgreSQLContainer<?> postgres = new PostgreSQLContainer<>("postgres:16-alpine");
 
    @DynamicPropertySource
    static void configureProperties(DynamicPropertyRegistry registry) {
        registry.add("spring.datasource.url", postgres::getJdbcUrl);
        registry.add("spring.datasource.username", postgres::getUsername);
        registry.add("spring.datasource.password", postgres::getPassword);
    }
 
    @Autowired
    private OrderRepository orderRepository;
 
    @Test
    void shouldFindOrdersByCustomerId() {
        orderRepository.save(new OrderEntity("cust-101", new BigDecimal("49.99")));
        List<OrderEntity> orders = orderRepository.findByCustomerId("cust-101");
        assertThat(orders).hasSize(1);
    }
}