Matchers SQL

Traducción Beta No Oficial

Esta página fue traducida por PageTurner AI (beta). No está respaldada oficialmente por el proyecto. ¿Encontraste un error? Reportar problema →

Los matchers para java.sql.ResultSet están incluidos en el módulo kotest-assertions-core. No se requiere ninguna dependencia adicional.

Estos matchers son exclusivos de la JVM.

ResultSet
resultSet.shouldHaveRows(count)	Asserts that the ResultSet is positioned at the given row number.
resultSet.shouldNotHaveRows(count)	Asserts that the ResultSet is not positioned at the given row number.
resultSet.shouldHaveColumns(count)	Asserts that the ResultSet has the given number of columns.
resultSet.shouldNotHaveColumns(count)	Asserts that the ResultSet does not have the given number of columns.
resultSet.shouldContainColumn(name)	Asserts that the ResultSet contains a column with the given name.
resultSet.shouldNotContainColumn(name)	Asserts that the ResultSet does not contain a column with the given name.
resultSet.shouldHaveColumn<T>(name) { values -> }	Asserts that the ResultSet contains a column with the given name, then collects all values from that column as List<T> and passes them to the lambda for further assertions.
resultSet.shouldHaveRow(rowNum) { values -> }	Navigates to the given row number and passes all column values from that row as List<Any> to the lambda for further assertions.

Ejemplos

// Simple assertions
resultSet shouldHaveRows 3
resultSet shouldHaveColumns 5
resultSet shouldContainColumn "user_id"

// Assert column values
resultSet.shouldHaveColumn<String>("username") { values ->
    values shouldContainAll listOf("alice", "bob")
}

// Assert a specific row
resultSet.shouldHaveRow(1) { row ->
    row shouldContain "alice"
    row shouldContain 42
}