getAll

abstract suspend fun <RowType : Any> getAll(sql: String, parameters: List<Any?>? = listOf(), mapper: (SqlCursor) -> RowType): List<RowType>

Executes a read-only (SELECT) query and returns all results.

Return

A list of results.

Parameters

sql

The SQL query to execute.

parameters

The parameters for the query, or an empty list if none.

mapper

A function to map the result set to the desired type.

Throws

If a database error occurs.

If the operation is cancelled.