com.lucidchart.open.relate

SqlResult

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
Learn more about member selection
Visibility
  1. Public
  2. All

Instance Constructors

  1. new SqlResult(resultSet: ResultSet)

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 asCollection[U, T[_]](parser: RowParser[U], maxRows: Long)(implicit cbf: CanBuildFrom[T[U], U, T[U]]): T[U]

    Attributes
    protected

  7. def asCollection[U, T[_]](parser: RowParser[U])(implicit cbf: CanBuildFrom[T[U], U, T[U]]): T[U]

  8. final def asInstanceOf[T0]: T0

    Definition Classes
    Any

  9. def asIterable[A](parser: RowParser[A]): Iterable[A]

  10. def asList[A](parser: RowParser[A]): List[A]

  11. def asMap[U, V](parser: RowParser[(U, V)]): Map[U, V]

  12. def asPairCollection[U, V, T[_, _]](parser: RowParser[(U, V)], maxRows: Long)(implicit cbf: CanBuildFrom[T[U, V], (U, V), T[U, V]]): T[U, V]

    Attributes
    protected

  13. def asPairCollection[U, V, T[_, _]](parser: RowParser[(U, V)])(implicit cbf: CanBuildFrom[T[U, V], (U, V), T[U, V]]): T[U, V]

  14. def asScalar[A](): A

  15. def asScalarOption[A](): Option[A]

  16. def asSeq[A](parser: RowParser[A]): Seq[A]

  17. def asSet[A](parser: RowParser[A]): Set[A]

  18. def asSingle[A](parser: RowParser[A]): A

  19. def asSingleOption[A](parser: RowParser[A]): Option[A]

  20. def bigDecimal(column: String): BigDecimal

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

  22. def bigInt(column: String): BigInt

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

  24. def bool(column: String): Boolean

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

  26. def byte(column: String): Byte

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

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

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

  30. def clone(): AnyRef

    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

  31. def date(column: String): Date

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

  33. def double(column: String): Double

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

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

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

  37. final def eq(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef

  38. def equals(arg0: Any): Boolean

    Definition Classes
    AnyRef → Any

  39. def extractOption[A](column: String)(f: (Any) ⇒ A): Option[A]

    Attributes
    protected[com.lucidchart.open.relate]

  40. def finalize(): Unit

    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( classOf[java.lang.Throwable] )

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

    Definition Classes
    AnyRef → Any

  42. def getMetaData(): ResultSetMetaData

    Get the metadata for the java.

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

    returns

    the metadata

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

    Attributes
    protected

  44. def getRow(): Int

    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

  45. def hasColumn(column: String): Boolean

    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

  46. def hashCode(): Int

    Definition Classes
    AnyRef → Any

  47. def int(column: String): Int

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

  49. final def isInstanceOf[T0]: Boolean

    Definition Classes
    Any

  50. def javaBigDecimal(column: String): BigDecimal

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

  52. def javaBigInteger(column: String): BigInteger

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

  54. def long(column: String): Long

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

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

    Definition Classes
    AnyRef

  57. final def notify(): Unit

    Definition Classes
    AnyRef

  58. final def notifyAll(): Unit

    Definition Classes
    AnyRef

  59. val resultSet: ResultSet

  60. def short(column: String): Short

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

  62. def strictArray(column: String): Array

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

  64. def strictAsciiStream(column: String): InputStream

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

  66. def strictBigDecimal(column: String): BigDecimal

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

  68. def strictBinaryStream(column: String): InputStream

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

  70. def strictBlob(column: String): Blob

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

  72. def strictBoolean(column: String): Boolean

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

  74. def strictByte(column: String): Byte

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

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

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

  78. def strictCharacterStream(column: String): Reader

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

  80. def strictClob(column: String): Clob

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

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

  83. def strictDate(column: String): Date

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

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

  86. def strictDouble(column: String): Double

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

  88. def strictFloat(column: String): Float

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

  90. def strictInt(column: String): Int

  91. def strictInt(index: Int): Int

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

  93. def strictLong(column: String): Long

  94. def strictLong(index: Int): Long

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

  96. def strictNCharacterStream(column: String): Reader

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

  98. def strictNClob(column: String): NClob

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

  100. def strictNString(column: String): String

  101. def strictNStringOption(column: String): Option[String]

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

  103. def strictObject(column: String): AnyRef

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

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

  106. def strictRef(column: String): Ref

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

  108. def strictRowId(column: String): RowId

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

  110. def strictSQLXML(column: String): SQLXML

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

  112. def strictShort(column: String): Short

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

  114. def strictString(column: String): String

  115. def strictStringOption(column: String): Option[String]

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

  117. def strictTime(column: String): Time

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

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

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

  121. def strictTimestamp(column: String): Timestamp

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

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

  124. def strictURL(column: String): URL

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

  126. def string(column: String): String

  127. def stringOption(column: String): Option[String]

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

    Definition Classes
    AnyRef

  129. def toString(): String

    Definition Classes
    AnyRef → Any

  130. def uuid(column: String): UUID

  131. def uuidFromString(column: String): UUID

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

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

  134. final def wait(): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

  135. final def wait(arg0: Long, arg1: Int): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

  136. final def wait(arg0: Long): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

  137. def wasNull(): Boolean

    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

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

    Attributes
    protected

Inherited from AnyRef

Inherited from Any

Ungrouped