Class

anorm

SqlQueryResult

Related Doc: package anorm

Permalink

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
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
Visibility
  1. Public
  2. All

Instance Constructors

  1. new SqlQueryResult(resultSet: ManagedResource[ResultSet], resultSetOnFirstRow: Boolean = false)

    Permalink

    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

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

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

    Permalink
    Definition Classes
    AnyRef → Any
  4. def as[T](parser: ResultSetParser[T])(implicit connection: Connection): T

    Permalink

    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

  5. final def asInstanceOf[T0]: T0

    Permalink
    Definition Classes
    Any
  6. def asTry[T](parser: ResultSetParser[T], aliaser: ColumnAliaser = ColumnAliaser.empty)(implicit connection: Connection): Try[T]

    Permalink

    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
  7. def clone(): AnyRef

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

    Permalink
    Definition Classes
    AnyRef
  9. def finalize(): Unit

    Permalink
    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( classOf[java.lang.Throwable] )
  10. def fold[T](z: ⇒ T, aliaser: ColumnAliaser)(op: (T, Row) ⇒ T)(implicit connection: Connection): Either[List[Throwable], T]

    Permalink

    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

    #withResult

    #foldWhile

  11. def foldWhile[T](z: ⇒ T, aliaser: ColumnAliaser)(op: (T, Row) ⇒ (T, Boolean))(implicit connection: Connection): Either[List[Throwable], T]

    Permalink

    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

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

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

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

    Permalink
    Definition Classes
    AnyRef
  15. final def notify(): Unit

    Permalink
    Definition Classes
    AnyRef
  16. final def notifyAll(): Unit

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

    Permalink

    Returns underlying result set

    Returns underlying result set

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

    Permalink

    Result set from executed query

  19. val resultSetOnFirstRow: Boolean

    Permalink

    ResultSet is initialized on first row (JDBC degraded)

    ResultSet is initialized on first row (JDBC degraded)

    Definition Classes
    SqlQueryResult → WithResult
  20. val statement: ManagedResource[Statement]

    Permalink

    Query statement already executed

  21. def statementWarning: Option[SQLWarning]

    Permalink

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

    Permalink
    Definition Classes
    AnyRef
  23. final def wait(): Unit

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

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

    Permalink
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  26. def withResult[T](op: (Option[Cursor]) ⇒ T, aliaser: ColumnAliaser)(implicit connection: Connection): Either[List[Throwable], T]

    Permalink

    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
  27. def withResult[T](op: (Option[Cursor]) ⇒ T)(implicit connection: Connection): Either[List[Throwable], T]

    Permalink

    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

  1. def fold[T](z: ⇒ T)(op: (T, Row) ⇒ T)(implicit connection: Connection): Either[List[Throwable], T]

    Permalink

    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 fold with empty ColumnAliaser

    See also

    #withResult

    #foldWhile

  2. def foldWhile[T](z: ⇒ T)(op: (T, Row) ⇒ (T, Boolean))(implicit connection: Connection): Either[List[Throwable], T]

    Permalink

    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 foldWhile with empty ColumnAliaser

    See also

    #withResult

Inherited from Serializable

Inherited from Serializable

Inherited from Product

Inherited from Equals

Inherited from WithResult

Inherited from AnyRef

Inherited from Any

Ungrouped