build.gradle.kts

dependencies {
  implementation("org.jetbrains.exposed:exposed-jdbc:0.40.1")
  testImplementation("com.h2database:h2:2.1.214")
}

ExposedCatsRepoTest.kt

import org.h2.jdbcx.JdbcDataSource
import org.jetbrains.exposed.sql.Database
import org.jetbrains.exposed.sql.SchemaUtils
import org.jetbrains.exposed.sql.transactions.transaction
import java.util.UUID
import javax.sql.DataSource

private fun testDb(): Database {
    val dataSource: DataSource = JdbcDataSource().apply {
        setURL("jdbc:h2:mem:${UUID.randomUUID()};MODE=MySQL;DB_CLOSE_DELAY=-1")
        this.user = "sa"
        this.password = ""
    }
    val db = Database.connect(dataSource)
    transaction(db) {
        SchemaUtils.create(CatsTable)
    }
    return db
}

class ExposedCatsRepoTest: CatsRepoContract(ExposedCatsRepo(testDb()))