little-sql/little.sql/ResultSetMethods

ResultSetMethods

final implicit
class ResultSetMethods(resultSet: ResultSet) extends AnyVal

Provides extension methods for java.sql.ResultSet.

class AnyVal
trait Matchable
class Any

Value members

Concrete methods

def flatMap[T](f: ResultSet => Iterable[T]): Seq[T]

Maps remaining rows of ResultSet building a collection using elements returned from map function.

Maps remaining rows of ResultSet building a collection using elements returned from map function.

Value Params
f

map function

def fold[T](init: T)(op: (T, ResultSet) => T): T

Folds remaining rows of ResultSet to single value using given initial value and binary operator.

Folds remaining rows of ResultSet to single value using given initial value and binary operator.

Value Params
init

initial value

op

binary operator

def foreach(f: ResultSet => Unit): Unit

Invokes supplied function for each remaining row of ResultSet.

Invokes supplied function for each remaining row of ResultSet.

Value Params
f

function

def get[T](index: Int)(using getValue: GetValueByIndex[T]): T

Gets column value in current row.

Gets column value in current row.

Type Params
T

type of value to return

Value Params
index

column index

def get[T](label: String)(using getValue: GetValueByLabel[T]): T

Gets column value in current row.

Gets column value in current row.

Type Params
T

type of value to return

Value Params
label

column label

def getColumnCount(): Int

Gets column count.

Gets column count.

def getColumnLabels(): Seq[String]

Gets column labels.

Gets column labels.

def getInstant(index: Int): Instant

Gets column value as Instant.

Gets column value as Instant.

def getInstant(label: String): Instant

Gets column value as Instant.

Gets column value as Instant.

def getLocalDate(index: Int): LocalDate

Gets column value as LocalDate.

Gets column value as LocalDate.

def getLocalDate(label: String): LocalDate

Gets column value as LocalDate.

Gets column value as LocalDate.

def getLocalDateTime(index: Int): LocalDateTime

Gets column value as LocalDateTime.

Gets column value as LocalDateTime.

def getLocalDateTime(label: String): LocalDateTime

Gets column value as LocalDateTime.

Gets column value as LocalDateTime.

def getLocalTime(index: Int): LocalTime

Gets column value as LocalTime.

Gets column value as LocalTime.

def getLocalTime(label: String): LocalTime

Gets column value as LocalTime.

Gets column value as LocalTime.

def getOption[T](index: Int)(using getValue: GetValueByIndex[T]): Option[T]

Gets column value in current row if value is not null.

Gets column value in current row if value is not null.

Type Params
T

type of value to return

Value Params
index

column index

def getOption[T](label: String)(using getValue: GetValueByLabel[T]): Option[T]

Gets column value in current row if value is not null.

Gets column value in current row if value is not null.

Type Params
T

type of value to return

Value Params
label

column label

def getOrElse[T](index: Int, default: => T)(using getValue: GetValueByIndex[T]): T

Gets column value in current row, or returns default if value is null.

Gets column value in current row, or returns default if value is null.

Type Params
T

type of value to return

Value Params
default

default value

index

column index

def getOrElse[T](label: String, default: => T)(using getValue: GetValueByLabel[T]): T

Gets column value in current row, or returns default if value is null.

Gets column value in current row, or returns default if value is null.

Type Params
T

type of value to return

Value Params
default

default value

label

column label

def map[T](f: ResultSet => T): Seq[T]

Maps remaining rows of ResultSet using supplied function.

Maps remaining rows of ResultSet using supplied function.

Value Params
f

map function

def next[T](f: ResultSet => T): Option[T]

Maps next row of ResultSet using supplied function.

Maps next row of ResultSet using supplied function.

If the result set has another row, and if the supplied function's return value is not null, then Some value is returned; otherwise, None is returned.

Value Params
f

map function