-
Notifications
You must be signed in to change notification settings - Fork 496
/
HsqlTest.kt
44 lines (39 loc) · 1.25 KB
/
HsqlTest.kt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
package app.cash.sqldelight.hsql.integration
import app.cash.sqldelight.Query
import app.cash.sqldelight.driver.jdbc.JdbcDriver
import com.google.common.truth.Truth.assertThat
import org.junit.After
import org.junit.Before
import org.junit.Test
import java.sql.Connection
import java.sql.DriverManager
class HsqlTest {
val conn = DriverManager.getConnection("jdbc:hsqldb:mem:mymemdb")
val driver = object : JdbcDriver() {
override fun getConnection() = conn
override fun closeConnection(connection: Connection) = Unit
override fun addListener(listener: Query.Listener, queryKeys: Array<String>) = Unit
override fun removeListener(listener: Query.Listener, queryKeys: Array<String>) = Unit
override fun notifyListeners(queryKeys: Array<String>) = Unit
}
val database = MyDatabase(driver)
@Before fun before() {
MyDatabase.Schema.create(driver)
}
@After fun after() {
conn.close()
}
@Test fun simpleSelect() {
database.dogQueries.insertDog("Tilda", "Pomeranian", true, 1)
assertThat(database.dogQueries.selectDogs().executeAsOne())
.isEqualTo(
Dog(
name = "Tilda",
breed = "Pomeranian",
is_good = true,
id = 1,
id_bigger_than_ten = false,
),
)
}
}