anorm

SqlQueryResult

final case class SqlQueryResult(resultSet: ManagedResource[ResultSet]) extends 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
Linear Supertypes
Serializable, Serializable, Product, Equals, AnyRef, Any
Ordering
  1. Alphabetic
  2. By inheritance
Inherited
  1. SqlQueryResult
  2. Serializable
  3. Serializable
  4. Product
  5. Equals
  6. AnyRef
  7. Any
  1. Hide All
  2. Show all
Learn more about member selection
Visibility
  1. Public
  2. All

Instance Constructors

  1. new SqlQueryResult(resultSet: ManagedResource[ResultSet])

    create a result with a result set

    create a result with a result set

    resultSet

    Result set from executed query

Value Members

  1. final def !=(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef
  2. final def !=(arg0: Any): Boolean

    Definition Classes
    Any
  3. final def ##(): Int

    Definition Classes
    AnyRef → Any
  4. final def ==(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef
  5. final def ==(arg0: Any): Boolean

    Definition Classes
    Any
  6. def as[T](parser: ResultSetParser[T])(implicit connection: Connection): T

    Converts this query result as T, using parser.

  7. final def asInstanceOf[T0]: T0

    Definition Classes
    Any
  8. def clone(): AnyRef

    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  9. final def eq(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef
  10. def finalize(): Unit

    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( classOf[java.lang.Throwable] )
  11. 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

    See also

    #withIterator

    #foldWhile

  12. 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

    See also

    #withIterator

  13. final def getClass(): Class[_]

    Definition Classes
    AnyRef → Any
  14. final def isInstanceOf[T0]: Boolean

    Definition Classes
    Any
  15. def list[A](rowParser: RowParser[A])(implicit connection: Connection): Seq[A]

  16. final def ne(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef
  17. final def notify(): Unit

    Definition Classes
    AnyRef
  18. final def notifyAll(): Unit

    Definition Classes
    AnyRef
  19. val resultSet: ManagedResource[ResultSet]

    Result set from executed query

  20. def single[A](rowParser: RowParser[A])(implicit connection: Connection): A

  21. def singleOpt[A](rowParser: RowParser[A])(implicit connection: Connection): Option[A]

  22. val statement: ManagedResource[Statement]

    Query statement already executed

  23. 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)
    }
  24. final def synchronized[T0](arg0: ⇒ T0): T0

    Definition Classes
    AnyRef
  25. final def wait(): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  26. final def wait(arg0: Long, arg1: Int): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  27. final def wait(arg0: Long): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  28. def withIterator[T](op: (Iterator[Row]) ⇒ T)(implicit connection: Connection): Either[List[Throwable], T]

    Processes all or some rows through iterator for current results.

    Processes all or some rows through iterator for current results.

    op

    Operation applied with row iterator

    val l: Either[List[Throwable], List[Row]] = SQL"SELECT * FROM Test".
    withIterator(_.toList)

Deprecated Value Members

  1. def apply()(implicit connection: Connection): Stream[Row]

    Returns stream of row from query result.

    Returns stream of row from query result.

    Annotations
    @deprecated
    Deprecated

    (Since version 2.4) Use fold, foldWhile or withIterator instead, which manages resources and memory

  2. def parse[T](parser: ResultSetParser[T])(implicit connection: Connection): T

    Annotations
    @deprecated
    Deprecated

    (Since version 2.3.2) Use as

Inherited from Serializable

Inherited from Serializable

Inherited from Product

Inherited from Equals

Inherited from AnyRef

Inherited from Any

Ungrouped