final case class SqlQueryResult(resultSet: ManagedResource[ResultSet], resultSetOnFirstRow: Boolean = false) extends WithResult with Product with Serializable
A result from execution of an SQL query, row data and context (e.g. statement warnings).
- resultSet
Result set from executed query
- Source
- SqlQueryResult.scala
- Alphabetic
- By Inheritance
- SqlQueryResult
- Serializable
- Serializable
- Product
- Equals
- WithResult
- AnyRef
- Any
- Hide All
- Show All
- Public
- All
Instance Constructors
-
new
SqlQueryResult(resultSet: ManagedResource[ResultSet], resultSetOnFirstRow: Boolean = false)
create a result with a result set
create a result with a result set
- resultSet
Result set from executed query
Value Members
-
final
def
!=(arg0: Any): Boolean
- Definition Classes
- AnyRef → Any
-
final
def
##(): Int
- Definition Classes
- AnyRef → Any
-
final
def
==(arg0: Any): Boolean
- Definition Classes
- AnyRef → Any
-
def
as[T](parser: ResultSetParser[T])(implicit connection: Connection): T
Converts this query result as
T, using parser.Converts this query result as
T, using parser.- parser
the result parser
- Definition Classes
- WithResult
- See also
#asTry
-
final
def
asInstanceOf[T0]: T0
- Definition Classes
- Any
-
def
asTry[T](parser: ResultSetParser[T], aliaser: ColumnAliaser = ColumnAliaser.empty)(implicit connection: Connection): Try[T]
Converts this query result as
T, using parser.Converts this query result as
T, using parser.- parser
the result parser
- aliaser
the column aliaser
- Definition Classes
- WithResult
-
def
clone(): AnyRef
- Attributes
- protected[java.lang]
- Definition Classes
- AnyRef
- Annotations
- @native() @throws( ... )
-
final
def
eq(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef
-
def
finalize(): Unit
- Attributes
- protected[java.lang]
- Definition Classes
- AnyRef
- Annotations
- @throws( classOf[java.lang.Throwable] )
-
def
fold[T](z: ⇒ T, aliaser: ColumnAliaser)(op: (T, Row) ⇒ T)(implicit connection: Connection): Either[List[Throwable], T]
Aggregates over all rows using the specified operator.
Aggregates over all rows using the specified operator.
- z
the start value
- aliaser
the column aliaser
- op
Aggregate operator
- returns
Either list of failures at left, or aggregated value
- Definition Classes
- WithResult
- See also
#foldWhile
#withResult
-
def
foldWhile[T](z: ⇒ T, aliaser: ColumnAliaser)(op: (T, Row) ⇒ (T, Boolean))(implicit connection: Connection): Either[List[Throwable], T]
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.
- z
the start value
- aliaser
the column aliaser
- op
Aggregate operator. Returns aggregated value along with true if aggregation must process next value, or false to stop with current value.
- returns
Either list of failures at left, or aggregated value
- Definition Classes
- WithResult
- See also
#withResult
-
final
def
getClass(): Class[_]
- Definition Classes
- AnyRef → Any
- Annotations
- @native()
-
final
def
isInstanceOf[T0]: Boolean
- Definition Classes
- Any
-
final
def
ne(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef
-
final
def
notify(): Unit
- Definition Classes
- AnyRef
- Annotations
- @native()
-
final
def
notifyAll(): Unit
- Definition Classes
- AnyRef
- Annotations
- @native()
-
def
resultSet(c: Connection): ManagedResource[ResultSet]
- Attributes
- protected
- Definition Classes
- SqlQueryResult → WithResult
- val resultSet: ManagedResource[ResultSet]
-
val
resultSetOnFirstRow: Boolean
ResultSet is initialized on first row (JDBC degraded)
ResultSet is initialized on first row (JDBC degraded)
- Definition Classes
- SqlQueryResult → WithResult
-
val
statement: ManagedResource[Statement]
Query statement already executed
-
def
statementWarning: Option[SQLWarning]
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) }
-
final
def
synchronized[T0](arg0: ⇒ T0): T0
- Definition Classes
- AnyRef
-
final
def
wait(): Unit
- Definition Classes
- AnyRef
- Annotations
- @throws( ... )
-
final
def
wait(arg0: Long, arg1: Int): Unit
- Definition Classes
- AnyRef
- Annotations
- @throws( ... )
-
final
def
wait(arg0: Long): Unit
- Definition Classes
- AnyRef
- Annotations
- @native() @throws( ... )
-
def
withResult[T](op: (Option[Cursor]) ⇒ T, aliaser: ColumnAliaser)(implicit connection: Connection): Either[List[Throwable], T]
Processes all or some rows from current result.
Processes all or some rows from current result.
- op
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)
- Definition Classes
- WithResult
-
def
withResult[T](op: (Option[Cursor]) ⇒ T)(implicit connection: Connection): Either[List[Throwable], T]
Processes all or some rows from current result.
Processes all or some rows from current result.
- op
Operation applied with row cursor
- Definition Classes
- WithResult
Deprecated Value Members
-
def
fold[T](z: ⇒ T)(op: (T, Row) ⇒ T)(implicit connection: Connection): Either[List[Throwable], T]
Aggregates over all rows using the specified operator.
Aggregates over all rows using the specified operator.
- z
the start value
- op
Aggregate operator
- returns
Either list of failures at left, or aggregated value
- Definition Classes
- WithResult
- Annotations
- @deprecated
- Deprecated
(Since version 2.5.1) Use
foldwith empty ColumnAliaser- See also
#foldWhile
#withResult
-
def
foldWhile[T](z: ⇒ T)(op: (T, Row) ⇒ (T, Boolean))(implicit connection: Connection): Either[List[Throwable], T]
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.
- z
the start value
- op
Aggregate operator. Returns aggregated value along with true if aggregation must process next value, or false to stop with current value.
- returns
Either list of failures at left, or aggregated value
- Definition Classes
- WithResult
- Annotations
- @deprecated
- Deprecated
(Since version 2.5.1) Use
foldWhilewith empty ColumnAliaser- See also
#withResult