Class/Object

com.lucidchart.open.relate

SqlResult

Related Docs: object SqlResult | package relate

Permalink

class SqlResult extends AnyRef

The SqlResult class is a wrapper around Java's ResultSet class.

It provides methods to allows users to retrieve specific columns by name and datatype, but also provides methods that can, given a RowParser, parse the entire result set as a collection of records returned by the parser. These methods are also defined in the Sql trait, and are most conveniently used when chained with parameter insertion. For how to do this, see the Sql trait documentation.

The extraction methods (int, string, long, etc.) also have "strict" counterparts. The "strict" methods are slightly faster, but do not do type checking or handle null values.

Linear Supertypes
AnyRef, Any
Ordering
  1. Alphabetic
  2. By inheritance
Inherited
  1. SqlResult
  2. AnyRef
  3. Any
  1. Hide All
  2. Show all
Visibility
  1. Public
  2. All

Instance Constructors

  1. new SqlResult(resultSet: ResultSet)

    Permalink

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[A]()(implicit arg0: Parseable[A]): A

    Permalink
  5. def asCollection[U, T[_]](parser: (SqlResult) ⇒ U, maxRows: Long)(implicit cbf: CanBuildFrom[T[U], U, T[U]]): T[U]

    Permalink
    Attributes
    protected
  6. def asCollection[U, T[_]](maxRows: Long)(implicit arg0: Parseable[U], cbf: CanBuildFrom[T[U], U, T[U]]): T[U]

    Permalink
    Attributes
    protected
  7. def asCollection[U, T[_]]()(implicit arg0: Parseable[U], cbf: CanBuildFrom[T[U], U, T[U]]): T[U]

    Permalink
  8. def asCollection[U, T[_]](parser: (SqlResult) ⇒ U)(implicit cbf: CanBuildFrom[T[U], U, T[U]]): T[U]

    Permalink
  9. final def asInstanceOf[T0]: T0

    Permalink
    Definition Classes
    Any
  10. def asIterable[A](parser: (SqlResult) ⇒ A): Iterable[A]

    Permalink
  11. def asIterable[A]()(implicit arg0: Parseable[A]): Iterable[A]

    Permalink
  12. def asList[A](parser: (SqlResult) ⇒ A): List[A]

    Permalink
  13. def asList[A]()(implicit arg0: Parseable[A]): List[A]

    Permalink
  14. def asMap[U, V](parser: (SqlResult) ⇒ (U, V)): Map[U, V]

    Permalink
  15. def asMap[U, V]()(implicit p: Parseable[(U, V)]): Map[U, V]

    Permalink
  16. def asMultiMap[U, V](parser: (SqlResult) ⇒ (U, V)): Map[U, Set[V]]

    Permalink
  17. def asMultiMap[U, V]()(implicit p: Parseable[(U, V)]): Map[U, Set[V]]

    Permalink
  18. def asPairCollection[U, V, T[_, _]](parser: (SqlResult) ⇒ (U, V), maxRows: Long)(implicit cbf: CanBuildFrom[T[U, V], (U, V), T[U, V]]): T[U, V]

    Permalink
    Attributes
    protected
  19. def asPairCollection[U, V, T[_, _]](maxRows: Long)(implicit p: Parseable[(U, V)], cbf: CanBuildFrom[T[U, V], (U, V), T[U, V]]): T[U, V]

    Permalink
    Attributes
    protected
  20. def asPairCollection[U, V, T[_, _]](parser: (SqlResult) ⇒ (U, V))(implicit cbf: CanBuildFrom[T[U, V], (U, V), T[U, V]]): T[U, V]

    Permalink
  21. def asPairCollection[U, V, T[_, _]]()(implicit p: Parseable[(U, V)], cbf: CanBuildFrom[T[U, V], (U, V), T[U, V]]): T[U, V]

    Permalink
  22. def asScalar[A](): A

    Permalink
  23. def asScalarOption[A](): Option[A]

    Permalink
  24. def asSeq[A](parser: (SqlResult) ⇒ A): Seq[A]

    Permalink
  25. def asSeq[A]()(implicit arg0: Parseable[A]): Seq[A]

    Permalink
  26. def asSet[A](parser: (SqlResult) ⇒ A): Set[A]

    Permalink
  27. def asSet[A]()(implicit arg0: Parseable[A]): Set[A]

    Permalink
  28. def asSingle[A](parser: (SqlResult) ⇒ A): A

    Permalink
  29. def asSingle[A]()(implicit arg0: Parseable[A]): A

    Permalink
  30. def asSingleOption[A](parser: (SqlResult) ⇒ A): Option[A]

    Permalink
  31. def asSingleOption[A]()(implicit arg0: Parseable[A]): Option[A]

    Permalink
  32. def bigDecimal(column: String): BigDecimal

    Permalink
  33. def bigDecimalOption(column: String): Option[BigDecimal]

    Permalink
  34. def bigInt(column: String): BigInt

    Permalink
  35. def bigIntOption(column: String): Option[BigInt]

    Permalink
  36. def bool(column: String): Boolean

    Permalink
  37. def boolOption(column: String): Option[Boolean]

    Permalink
  38. def byte(column: String): Byte

    Permalink
  39. def byteArray(column: String): Array[Byte]

    Permalink
  40. def byteArrayOption(column: String): Option[Array[Byte]]

    Permalink
  41. def byteOption(column: String): Option[Byte]

    Permalink
  42. def clone(): AnyRef

    Permalink
    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  43. def date(column: String): Date

    Permalink
  44. def dateOption(column: String): Option[Date]

    Permalink
  45. def double(column: String): Double

    Permalink
  46. def doubleOption(column: String): Option[Double]

    Permalink
  47. def enum(column: String, e: Enumeration): Value

    Permalink
  48. def enumOption(column: String, e: Enumeration): Option[Value]

    Permalink
  49. final def eq(arg0: AnyRef): Boolean

    Permalink
    Definition Classes
    AnyRef
  50. def equals(arg0: Any): Boolean

    Permalink
    Definition Classes
    AnyRef → Any
  51. def extractOption[A](column: String)(f: (Any) ⇒ A): Option[A]

    Permalink
    Attributes
    protected[com.lucidchart.open.relate]
  52. def finalize(): Unit

    Permalink
    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( classOf[java.lang.Throwable] )
  53. final def getClass(): Class[_]

    Permalink
    Definition Classes
    AnyRef → Any
  54. def getMetaData(): ResultSetMetaData

    Permalink

    Get the metadata for the java.sql.ResultSet that underlies this SqlResult

    Get the metadata for the java.sql.ResultSet that underlies this SqlResult

    returns

    the metadata

  55. def getResultSetOption[A](f: ⇒ A): Option[A]

    Permalink
    Attributes
    protected
  56. def getRow(): Int

    Permalink

    Get the number of the row the SqlResult is currently on

    Get the number of the row the SqlResult is currently on

    returns

    the current row number

  57. def hasColumn(column: String): Boolean

    Permalink

    Determine if the result set contains the given column name

    Determine if the result set contains the given column name

    column

    the column name to check

    returns

    whether or not the result set contains that column name

  58. def hashCode(): Int

    Permalink
    Definition Classes
    AnyRef → Any
  59. def int(column: String): Int

    Permalink
  60. def intOption(column: String): Option[Int]

    Permalink
  61. final def isInstanceOf[T0]: Boolean

    Permalink
    Definition Classes
    Any
  62. def javaBigDecimal(column: String): BigDecimal

    Permalink
  63. def javaBigDecimalOption(column: String): Option[BigDecimal]

    Permalink
  64. def javaBigInteger(column: String): BigInteger

    Permalink
  65. def javaBigIntegerOption(column: String): Option[BigInteger]

    Permalink
  66. def long(column: String): Long

    Permalink
  67. def longOption(column: String): Option[Long]

    Permalink
  68. final def ne(arg0: AnyRef): Boolean

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

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

    Permalink
    Definition Classes
    AnyRef
  71. val resultSet: ResultSet

    Permalink
  72. def short(column: String): Short

    Permalink
  73. def shortOption(column: String): Option[Short]

    Permalink
  74. def strictArray(column: String): Array

    Permalink
  75. def strictArrayOption(column: String): Option[Array]

    Permalink
  76. def strictAsciiStream(column: String): InputStream

    Permalink
  77. def strictAsciiStreamOption(column: String): Option[InputStream]

    Permalink
  78. def strictBigDecimal(column: String): BigDecimal

    Permalink
  79. def strictBigDecimalOption(column: String): Option[BigDecimal]

    Permalink
  80. def strictBinaryStream(column: String): InputStream

    Permalink
  81. def strictBinaryStreamOption(column: String): Option[InputStream]

    Permalink
  82. def strictBlob(column: String): Blob

    Permalink
  83. def strictBlobOption(column: String): Option[Blob]

    Permalink
  84. def strictBoolean(column: String): Boolean

    Permalink
  85. def strictBooleanOption(column: String): Option[Boolean]

    Permalink
  86. def strictByte(column: String): Byte

    Permalink
  87. def strictByteOption(column: String): Option[Byte]

    Permalink
  88. def strictBytes(column: String): Array[Byte]

    Permalink
  89. def strictBytesOption(column: String): Option[Array[Byte]]

    Permalink
  90. def strictCharacterStream(column: String): Reader

    Permalink
  91. def strictCharacterStreamOption(column: String): Option[Reader]

    Permalink
  92. def strictClob(column: String): Clob

    Permalink
  93. def strictClobOption(column: String): Option[Clob]

    Permalink
  94. def strictDate(column: String, cal: Calendar): Date

    Permalink
  95. def strictDate(column: String): Date

    Permalink
  96. def strictDateOption(column: String, cal: Calendar): Option[Date]

    Permalink
  97. def strictDateOption(column: String): Option[Date]

    Permalink
  98. def strictDouble(column: String): Double

    Permalink
  99. def strictDoubleOption(column: String): Option[Double]

    Permalink
  100. def strictFloat(column: String): Float

    Permalink
  101. def strictFloatOption(column: String): Option[Float]

    Permalink
  102. def strictInt(column: String): Int

    Permalink
  103. def strictInt(index: Int): Int

    Permalink
  104. def strictIntOption(column: String): Option[Int]

    Permalink
  105. def strictLong(column: String): Long

    Permalink
  106. def strictLong(index: Int): Long

    Permalink
  107. def strictLongOption(column: String): Option[Long]

    Permalink
  108. def strictNCharacterStream(column: String): Reader

    Permalink
  109. def strictNCharacterStreamOption(column: String): Option[Reader]

    Permalink
  110. def strictNClob(column: String): NClob

    Permalink
  111. def strictNClobOption(column: String): Option[NClob]

    Permalink
  112. def strictNString(column: String): String

    Permalink
  113. def strictNStringOption(column: String): Option[String]

    Permalink
  114. def strictObject(column: String, map: Map[String, Class[_]]): AnyRef

    Permalink
  115. def strictObject(column: String): AnyRef

    Permalink
  116. def strictObjectOption(column: String, map: Map[String, Class[_]]): Option[AnyRef]

    Permalink
  117. def strictObjectOption(column: String): Option[AnyRef]

    Permalink
  118. def strictRef(column: String): Ref

    Permalink
  119. def strictRefOption(column: String): Option[Ref]

    Permalink
  120. def strictRowId(column: String): RowId

    Permalink
  121. def strictRowIdOption(column: String): Option[RowId]

    Permalink
  122. def strictSQLXML(column: String): SQLXML

    Permalink
  123. def strictSQLXMLOption(column: String): Option[SQLXML]

    Permalink
  124. def strictShort(column: String): Short

    Permalink
  125. def strictShortOption(column: String): Option[Short]

    Permalink
  126. def strictString(column: String): String

    Permalink
  127. def strictStringOption(column: String): Option[String]

    Permalink
  128. def strictTime(column: String, cal: Calendar): Time

    Permalink
  129. def strictTime(column: String): Time

    Permalink
  130. def strictTimeOption(column: String, cal: Calendar): Option[Time]

    Permalink
  131. def strictTimeOption(column: String): Option[Time]

    Permalink
  132. def strictTimestamp(column: String, cal: Calendar): Timestamp

    Permalink
  133. def strictTimestamp(column: String): Timestamp

    Permalink
  134. def strictTimestampOption(column: String, cal: Calendar): Option[Timestamp]

    Permalink
  135. def strictTimestampOption(column: String): Option[Timestamp]

    Permalink
  136. def strictURL(column: String): URL

    Permalink
  137. def strictURLOption(column: String): Option[URL]

    Permalink
  138. def string(column: String): String

    Permalink
  139. def stringOption(column: String): Option[String]

    Permalink
  140. final def synchronized[T0](arg0: ⇒ T0): T0

    Permalink
    Definition Classes
    AnyRef
  141. def toString(): String

    Permalink
    Definition Classes
    AnyRef → Any
  142. def uuid(column: String): UUID

    Permalink
  143. def uuidFromString(column: String): UUID

    Permalink
  144. def uuidFromStringOption(column: String): Option[UUID]

    Permalink
  145. def uuidOption(column: String): Option[UUID]

    Permalink
  146. final def wait(): Unit

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

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

    Permalink
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  149. def wasNull(): Boolean

    Permalink

    Determine if the last value extracted from the result set was null

    Determine if the last value extracted from the result set was null

    returns

    whether the last value was null

  150. def withResultSet[A](f: (ResultSet) ⇒ A): A

    Permalink
    Attributes
    protected[com.lucidchart.open.relate]

Inherited from AnyRef

Inherited from Any

Ungrouped