Converts this query result as T
, using parser.
Converts this query result as T
, using parser.
the result parser
#asTry
Converts this query result as T
, using parser.
Converts this query result as T
, using parser.
the result parser
the column aliaser
Aggregates over all rows using the specified operator.
Aggregates over all rows using the specified operator.
the start value
the column aliaser
Aggregate operator
Either list of failures at left, or aggregated value
#withResult
#foldWhile
Aggregates over part of or the while row stream, using the specified operator.
Aggregates over part of or the while row stream, using the specified operator.
the start value
the column aliaser
Aggregate operator. Returns aggregated value along with true if aggregation must process next value, or false to stop with current value.
Either list of failures at left, or aggregated value
#withResult
Returns underlying result set
Returns underlying result set
Result set from executed query
ResultSet is initialized on first row (JDBC degraded)
ResultSet is initialized on first row (JDBC degraded)
Query statement already executed
Returns statement warning if there is some for this result.
Returns statement warning if there is some for this result.
val res = SQL("EXEC stored_proc {p}").on("p" -> paramVal).executeQuery() res.statementWarning match { case Some(warning) => warning.printStackTrace() None case None => // go on with row parsing ... res.as(scalar[String].singleOpt) }
Processes all or some rows from current result.
Processes all or some rows from current result.
Operation applied with row cursor
@annotation.tailrec def go(c: Option[Cursor], l: List[Row]): List[Row] = c match { case Some(cursor) => go(cursor.next, l :+ cursor.row) case _ => l } val l: Either[List[Throwable], List[Row]] = SQL"SELECT * FROM Test".withResult(go)
Processes all or some rows from current result.
Processes all or some rows from current result.
Operation applied with row cursor
Aggregates over all rows using the specified operator.
Aggregates over all rows using the specified operator.
the start value
Aggregate operator
Either list of failures at left, or aggregated value
(Since version 2.5.1) Use fold
with empty ColumnAliaser
#withResult
#foldWhile
Aggregates over part of or the while row stream, using the specified operator.
Aggregates over part of or the while row stream, using the specified operator.
the start value
Aggregate operator. Returns aggregated value along with true if aggregation must process next value, or false to stop with current value.
Either list of failures at left, or aggregated value
(Since version 2.5.1) Use foldWhile
with empty ColumnAliaser
#withResult
A result from execution of an SQL query, row data and context (e.g. statement warnings).
Result set from executed query