Hey! I'm trying to test an application with an in ...

# exposed

[Nomantis Knight]

Hey!
I'm trying to test an application with an in memory sqlite database. My test class looks like this:

class ProjectRepositoryTest {
    companion object {
        val database = Database.connect("jdbc:sqlite:file:test?mode=memory&cache=shared", "org.sqlite.JDBC")
        val projectRepository = ProjectRepository(database)
        const val initialNumberOfProjects = 10

        @BeforeAll
        @JvmStatic
        fun setUp() {
            database.transactionManager.defaultIsolationLevel = Connection.TRANSACTION_SERIALIZABLE
            database.transactionManager.defaultRepetitionAttempts = 1
        }
    }

    @BeforeEach
    fun setUpEach() {
        transaction(database) {
            addLogger(StdOutSqlLogger)
            SchemaUtils.create(ProjectsTable)
        }
    }

    @Test
    fun testGetAllProjects() {
        println("Creating initial projects.")
        transaction(database) {
            addLogger(StdOutSqlLogger)
            repeat(initialNumberOfProjects) { i ->
                println("\tCreated project $i.")
                ProjectEntity.new {
                    name = "Project $i"
                    description = "Description $i"
                    archived = 0b0
                }
            }
        }
        ...
    }

    @AfterEach
    fun tearDown() {
        transaction(database) {
            SchemaUtils.drop(ProjectsTable)
        }
    }
}

I'm getting a database does not exist exception, saying that the Projects table doesn't exist. What am I doing wrong?

[Leonid Yavorskyi]

Try to create table inside @BeforeAll block

[Nomantis Knight]

I tried that now. it still throws the same error.

[Nomantis Knight]

@Leonid Yavorskyi Could it be because of the execution order of the transactions?

[spand]

I suspect its cleared once the number of connections to the db reaches 0 which seems to be right after setUpEach() .

[Nomantis Knight]

Found the solution. For some reason if you connect to sqlite with this connection string jdbc:sqlite:file:test?mode=memory&cache=shared , then it does not work, and throws the error I said above. If you use jdbc:sqlite:test:?mode=memory&cache=shared though, then it works no problem.