anorm

SqlQueryResult

final case class SqlQueryResult(resultSet: ManagedResource[ResultSet]) 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
Linear Supertypes
Serializable, Serializable, Product, Equals, WithResult, AnyRef, Any
Ordering
  1. Alphabetic
  2. By inheritance
Inherited
  1. SqlQueryResult
  2. Serializable
  3. Serializable
  4. Product
  5. Equals
  6. WithResult
  7. AnyRef
  8. 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: Any): Boolean

    Definition Classes
    AnyRef → Any
  2. final def ##(): Int

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

    Definition Classes
    AnyRef → Any
  4. 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.

    Definition Classes
    WithResult
  5. final def asInstanceOf[T0]: T0

    Definition Classes
    Any
  6. def clone(): AnyRef

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

    Definition Classes
    AnyRef
  8. def finalize(): Unit

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

    #withResult

    #foldWhile

  10. 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
    See also

    #withResult

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

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

    Definition Classes
    Any
  13. final def ne(arg0: AnyRef): Boolean

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

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

    Definition Classes
    AnyRef
  16. def resultSet(c: Connection): ManagedResource[ResultSet]

    Returns underlying result set

    Returns underlying result set

    Attributes
    protected
    Definition Classes
    SqlQueryResult → WithResult
  17. val resultSet: ManagedResource[ResultSet]

    Result set from executed query

  18. val statement: ManagedResource[Statement]

    Query statement already executed

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

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

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

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

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  24. 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

    @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

Deprecated Value Members

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

    Executes this SQL statement as query, returns result as Row stream.

    Executes this SQL statement as query, returns result as Row stream.

    Definition Classes
    WithResult
    Annotations
    @deprecated
    Deprecated

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

  2. def list[A](rowParser: RowParser[A])(implicit connection: Connection): Seq[A]

    Applies current parser with optionnal list of rows (0..n).

    Applies current parser with optionnal list of rows (0..n).

    Annotations
    @deprecated
    Deprecated

    (Since version 2.3.5) Use SQL("...").executeQuery().as(parser.*)

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

    Annotations
    @deprecated
    Deprecated

    (Since version 2.3.2) Use as

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

    Applies current parser to exactly on row.

    Applies current parser to exactly on row.

    Annotations
    @deprecated
    Deprecated

    (Since version 2.3.5) Use SQL("...").executeQuery().as(parser.single)

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

    Applies current parser to one optional row.

    Applies current parser to one optional row.

    Annotations
    @deprecated
    Deprecated

    (Since version 2.3.5) Use SQL("...").executeQuery().as(parser.singleOpt)

Inherited from Serializable

Inherited from Serializable

Inherited from Product

Inherited from Equals

Inherited from WithResult

Inherited from AnyRef

Inherited from Any

Ungrouped