Channels
#exposed
Title
# exposed
c
cincue
09/04/2019, 2:30 PMHi! Is there any way to simulate a select failure with DSL API during testing?
e
Evan R.
09/04/2019, 8:41 PMYou could use MockK to mock your table to throw
ExposedSQLExceptionc
cincue
09/05/2019, 3:43 PMHi Evan! Could you provide an example? Thanks!
e
Evan R.
09/05/2019, 4:02 PMAssuming you already have a database table such as this (doing this without an IDE, calls may be slightly incorrect):
Copy code
object MyTable : IntIdTable {
val name = varchar("name", 128)
} Copy code
mockkObject(MyTable)
every { MyTable.select(any()) } throws ExposedSQLException( /* Add params for exception here */ )
assertThrows(ExposedSQLException) { MyTable.select { MyTable.id eq 1 } }
// Use this to undo mock
unmockkObject(MyTable)c
cincue
09/05/2019, 6:08 PMI'm trying Mockk and I have the same problem as with Mockito, I get "java.lang.IllegalStateException: No transaction in context.", I suspected that It could happen. Any ideas?
e
Evan R.
09/06/2019, 4:40 PMSounds like you may be mocking the wrong method. That exception shouldn’t be thrown if the actual method is mocked
c
cincue
09/06/2019, 5:24 PMI tried with your snippet and It didn't work.
e
Evan R.
09/06/2019, 6:02 PMFound the issue. Turns out
.select() Copy code
mockkStatic("org.jetbrains.exposed.sql.QueriesKt")
every { MyTable.select(any<Op<Boolean>>()) } throws mockk<ExposedSQLException>()
assertThrows<ExposedSQLException> { MyTable.select { MyTable.id eq 5 } }Extension functions aren’t actually part of the object itself, they are compiled to static methods on a synthetic class created for the file.
To mock it you need to perform a static mock of the file containing the extension function, in this case QueriesKt (from
org.jetbrains.exposed.sql.Queries.ktc
cincue
09/10/2019, 5:06 PMGreat!! Thanks Evan! It works
e
Evan R.
09/11/2019, 3:41 PMGlad to hear it!
22 Views