CleanSQLiteTest-javaadvent2024.java

@ExtendWith(SQLiteExtension.class)
@SpringBootTest(webEnvironment = SpringBootTest.WebEnvironment.RANDOM_PORT, properties = {
        // We need to enable lazy initialization to avoid the EntityManager creation during the context loading
        "spring.main.lazy-initialization=true"
})
class CleanSQLiteTest {
    @Autowired
    EntityManager entityManager;

    @Test
    void test() {
        // Query data
        var result = entityManager.createNativeQuery("SELECT COUNT(*) FROM user").getSingleResult();
        assertThat(result).isEqualTo(2);
    }
}