Row

Abstract Value Members

abstract val fields: IndexedSeq[Field]

Contains a Field object for each column in the Row.
Contains a Field object for each column in the Row. The data is 0-indexed so fields(0) contains the column metadata for the first column in the Row.
abstract def indexOf(columnName: String): Option[Int]

Retrieves the 0-indexed index of the column with the given name.
Retrieves the 0-indexed index of the column with the given name.
columnName
the case sensitive name of the column.
returns
Some(Int) if the column exists with the given name. Otherwise, None.
abstract val values: IndexedSeq[Value]

The values for this Row.
The values for this Row. The data is 0-indexed so values(0) contains the value for the first column in the Row.

Concrete Value Members

final def !=(arg0: Any): Boolean

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

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

Definition Classes
AnyRef → Any
def apply(columnIndex: Option[Int]): Option[Value]

Attributes
protected
def apply(columnName: String): Option[Value]

Retrieves the Value in the column with the given name.
Retrieves the Value in the column with the given name.
columnName
the case sensitive name of the column.
returns
Some(Value) if the column exists with the given name. Otherwise, None.
final def asInstanceOf[T0]: T0

Definition Classes
Any
def bigDecimalOrNull(columnName: String): BigDecimal

Returns a BigDecimal for the given column name, or null if the SQL value is NULL.
Returns a BigDecimal for the given column name, or null if the SQL value is NULL.
This can be used for MySQL columns that are NewDecimal, float, or double.
columnName
the case sensitive name of the column.

Exceptions thrown
ColumnNotFoundException if the column is not found in the row.
UnsupportedTypeException if the MySQL column is not a supported type.
See also
getBigDecimal
def bigIntOrNull(columnName: String): BigInt

Returns a BigInt for the given column name, or null if the SQL value is NULL.
Returns a BigInt for the given column name, or null if the SQL value is NULL.
This can be used for MySQL columns that are tiny, short, int24, long, or longlong.
columnName
the case sensitive name of the column.

Exceptions thrown
ColumnNotFoundException if the column is not found in the row.
UnsupportedTypeException if the MySQL column is not a supported type.
See also
getBigInt
def booleanOrFalse(columnName: String): Boolean

Returns a Java primitive boolean for the given column name, or false if the SQL value is NULL.
Returns a Java primitive boolean for the given column name, or false if the SQL value is NULL.
This is used for MySQL columns that are tiny as boolean is a synonym for that type.
columnName
the case sensitive name of the column.

Exceptions thrown
ColumnNotFoundException if the column is not found in the row.
UnsupportedTypeException if the MySQL column is not that type.
See also
https://dev.mysql.com/doc/refman/5.5/en/numeric-type-overview.html
getBoolean
def byteOrZero(columnName: String): Byte

Returns a Java primitive byte for the given column name, or 0 if the SQL value is NULL.
Returns a Java primitive byte for the given column name, or 0 if the SQL value is NULL.
This is used for MySQL columns that are tiny and signed.
columnName
the case sensitive name of the column.

Exceptions thrown
ColumnNotFoundException if the column is not found in the row.
UnsupportedTypeException if the MySQL column is not that type.
See also
getByte
def bytesOrNull(columnName: String): Array[Byte]

Returns a Array[Byte] for the given column name, or null if the SQL value is NULL.
Returns a Array[Byte] for the given column name, or null if the SQL value is NULL.
This can be used for MySQL columns that are tinyblob, mediumblob, blob, binary, or varbinary.
columnName
the case sensitive name of the column.

Exceptions thrown
ColumnNotFoundException if the column is not found in the row.
UnsupportedTypeException if the MySQL column is not that type.
See also
getBytes
def clone(): AnyRef

Attributes
protected[java.lang]
Definition Classes
AnyRef
Annotations
@throws( ... )
def doubleOrZero(columnName: String): Double

Returns a Java primitive double for the given column name, or 0 if the SQL value is NULL.
Returns a Java primitive double for the given column name, or 0 if the SQL value is NULL.
This can be used for MySQL columns that are float or double.
columnName
the case sensitive name of the column.

Exceptions thrown
ColumnNotFoundException if the column is not found in the row.
UnsupportedTypeException if the MySQL column is not a supported type.
See also
getDouble
final def eq(arg0: AnyRef): Boolean

Definition Classes
AnyRef
def equals(arg0: Any): Boolean

Definition Classes
AnyRef → Any
def finalize(): Unit

Attributes
protected[java.lang]
Definition Classes
AnyRef
Annotations
@throws( classOf[java.lang.Throwable] )
def floatOrZero(columnName: String): Float

Returns a Java primitive float for the given column name, or 0 if the SQL value is NULL.
Returns a Java primitive float for the given column name, or 0 if the SQL value is NULL.
This is used for MySQL columns that are float.
columnName
the case sensitive name of the column.

Exceptions thrown
ColumnNotFoundException if the column is not found in the row.
UnsupportedTypeException if the MySQL column is not a supported type.
See also
getFloat
def getBigDecimal(columnName: String): Option[BigDecimal]

Returns Some of a BigDecimal for the given column name, or None if the SQL value is NULL.
Returns Some of a BigDecimal for the given column name, or None if the SQL value is NULL.
This can be used for MySQL columns that are NewDecimal, float, or double.
columnName
the case sensitive name of the column.

Exceptions thrown
ColumnNotFoundException if the column is not found in the row.
UnsupportedTypeException if the MySQL column is not a supported type.
See also
bigDecimalOrNull
def getBigInt(columnName: String): Option[BigInt]

Returns Some of a BigInt for the given column name, or None if the SQL value is NULL.
Returns Some of a BigInt for the given column name, or None if the SQL value is NULL.
This can be used for MySQL columns that are tiny, short, int24, long, or longlong.
columnName
the case sensitive name of the column.

Exceptions thrown
ColumnNotFoundException if the column is not found in the row.
UnsupportedTypeException if the MySQL column is not a supported type.
See also
bigIntOrNull
def getBoolean(columnName: String): Option[Boolean]

Returns Some of a boxed Java Boolean for the given column name, or None if the SQL value is NULL.
Returns Some of a boxed Java Boolean for the given column name, or None if the SQL value is NULL.
This is used for MySQL columns that are tiny as boolean is a synonym for that type.
columnName
the case sensitive name of the column.

Exceptions thrown
ColumnNotFoundException if the column is not found in the row.
UnsupportedTypeException if the MySQL column is not that type.
See also
https://dev.mysql.com/doc/refman/5.5/en/numeric-type-overview.html
booleanOrFalse
def getByte(columnName: String): Option[Byte]

Returns Some of a boxed Java Byte for the given column name, or None if the SQL value is NULL.
Returns Some of a boxed Java Byte for the given column name, or None if the SQL value is NULL.
This is used for MySQL columns that are signed and tiny.
columnName
the case sensitive name of the column.

Exceptions thrown
ColumnNotFoundException if the column is not found in the row.
UnsupportedTypeException if the MySQL column is not that type.
See also
byteOrZero
def getBytes(columnName: String): Option[Array[Byte]]

Returns Some of an Array[Byte] for the given column name, or None if the SQL value is NULL.
Returns Some of an Array[Byte] for the given column name, or None if the SQL value is NULL.
This can be used for MySQL columns that are tinyblob, mediumblob, blob, binary, or varbinary.
columnName
the case sensitive name of the column.

Exceptions thrown
ColumnNotFoundException if the column is not found in the row.
UnsupportedTypeException if the MySQL column is not that type.
See also
bytesOrNull
final def getClass(): Class[_]

Definition Classes
AnyRef → Any
def getDouble(columnName: String): Option[Double]

Returns Some of a boxed Java Double for the given column name, or None if the SQL value is NULL.
Returns Some of a boxed Java Double for the given column name, or None if the SQL value is NULL.
This can be used for MySQL columns that are float or double.
columnName
the case sensitive name of the column.

Exceptions thrown
ColumnNotFoundException if the column is not found in the row.
UnsupportedTypeException if the MySQL column is not a supported type.
See also
doubleOrZero(
def getFloat(columnName: String): Option[Float]

Returns Some of a boxed Java Float for the given column name, or None if the SQL value is NULL.
Returns Some of a boxed Java Float for the given column name, or None if the SQL value is NULL.
This is used for MySQL columns that are float.
columnName
the case sensitive name of the column.

Exceptions thrown
ColumnNotFoundException if the column is not found in the row.
UnsupportedTypeException if the MySQL column is not a supported type.
See also
floatOrZero
def getInteger(columnName: String): Option[Integer]

Returns Some of a boxed Java Integer for the given column name, or None if the SQL value is NULL.
Returns Some of a boxed Java Integer for the given column name, or None if the SQL value is NULL.
This can be used for MySQL columns that are tiny, short, int24, or signed and long.
columnName
the case sensitive name of the column.

Exceptions thrown
ColumnNotFoundException if the column is not found in the row.
UnsupportedTypeException if the MySQL column is not a supported type.
See also
intOrZero
def getJavaSqlDate(columnName: String): Option[Date]

Returns Some of a java.sql.Date for the given column name, or None if the SQL value is NULL.
Returns Some of a java.sql.Date for the given column name, or None if the SQL value is NULL.
This can be used for MySQL columns that are date.
columnName
the case sensitive name of the column.

Exceptions thrown
ColumnNotFoundException if the column is not found in the row.
UnsupportedTypeException if the MySQL column is not a supported type.
See also
javaSqlDateOrNull(
def getJsonAsObject[T](columnName: String, objMapper: Serializer)(implicit m: Manifest[T]): Option[T]

Read the value of MySQL json column as Some(T) or None if the SQL value is NULL.
Read the value of MySQL json column as Some(T) or None if the SQL value is NULL.
columnName
the case sensitive name of the column.
objMapper
the objMapper used to parse the json column value into type T.

Exceptions thrown
ColumnNotFoundException if the column is not found in the row.
UnsupportedTypeException if the MySQL column is not MySQL json type.
ValueSerializationException if the MySQL json column value cannot be serialized as T.
See also
jsonAsObjectOrNull
def getLong(columnName: String): Option[Long]

Returns Some of a boxed Java Long for the given column name, or None if the SQL value is NULL.
Returns Some of a boxed Java Long for the given column name, or None if the SQL value is NULL.
This can be used for MySQL columns that are tiny, short, int24, long, or signed and longlong
columnName
the case sensitive name of the column.

Exceptions thrown
ColumnNotFoundException if the column is not found in the row.
UnsupportedTypeException if the MySQL column is not a supported type.
See also
longOrZero
def getShort(columnName: String): Option[Short]

Returns Some of a boxed Java Short for the given column name, or None if the SQL value is NULL.
Returns Some of a boxed Java Short for the given column name, or None if the SQL value is NULL.
This can be used for MySQL columns that are tiny, or signed and short.
columnName
the case sensitive name of the column.

Exceptions thrown
ColumnNotFoundException if the column is not found in the row.
UnsupportedTypeException if the MySQL column is not a supported type.
See also
shortOrZero
def getString(columnName: String): Option[String]

Returns Some of a String for the given column name, or None if the SQL value is NULL.
Returns Some of a String for the given column name, or None if the SQL value is NULL.
This can be used for MySQL columns that are varchar, string, or varstring, Also supports tinyblob, blob, and mediumblob if the field's charset is not the binary charset.
columnName
the case sensitive name of the column.

Exceptions thrown
ColumnNotFoundException if the column is not found in the row.
UnsupportedTypeException if the MySQL column is not a supported type.
See also
stringOrNull
def getTimestamp(columnName: String, timeZone: TimeZone): Option[Timestamp]

Returns Some of an java.sql.Timestamp for the given column name, or None if the SQL value is NULL.
Returns Some of an java.sql.Timestamp for the given column name, or None if the SQL value is NULL.
This can be used for MySQL columns that are timestamp or datetime.
columnName
the case sensitive name of the column.
timeZone
the TimeZone used to parse the data.

Exceptions thrown
ColumnNotFoundException if the column is not found in the row.
UnsupportedTypeException if the MySQL column is not that type.
See also
timestampOrNull
def hashCode(): Int

Definition Classes
AnyRef → Any
def indexOfOrSentinel(columnName: String): Int

Retrieves the 0-indexed index of the column with the given name.
Retrieves the 0-indexed index of the column with the given name.
columnName
the case sensitive name of the column.
returns
-1 if the column does not exist, otherwise the index of the column.

Attributes
protected
def intOrZero(columnName: String): Int

Returns a Java primitive int for the given column name, or 0 if the SQL value is NULL.
Returns a Java primitive int for the given column name, or 0 if the SQL value is NULL.
This can be used for MySQL columns that are tiny, short, int24, or signed and long.
columnName
the case sensitive name of the column.

Exceptions thrown
ColumnNotFoundException if the column is not found in the row.
UnsupportedTypeException if the MySQL column is not a supported type.
See also
getInteger
final def isInstanceOf[T0]: Boolean

Definition Classes
Any
def javaSqlDateOrNull(columnName: String): Date

Returns a java.sql.Date for the given column name, or null if the SQL value is NULL.
Returns a java.sql.Date for the given column name, or null if the SQL value is NULL.
This can be used for MySQL columns that are date.
columnName
the case sensitive name of the column.

Exceptions thrown
ColumnNotFoundException if the column is not found in the row.
UnsupportedTypeException if the MySQL column is not a supported type.
See also
getJavaSqlDate
def jsonAsObjectOrNull[T >: Null](columnName: String, objMapper: Serializer)(implicit m: Manifest[T]): T

Read the value of MySQL json column as type T or null if the SQL value is NULL.
Read the value of MySQL json column as type T or null if the SQL value is NULL.
columnName
the case sensitive name of the column.
objMapper
the objMapper used to parse the json column value into type T.

Exceptions thrown
ColumnNotFoundException if the column is not found in the row.
UnsupportedTypeException if the MySQL column is not MySQL json type.
ValueSerializationException if the MySQL json column value cannot be serialized as T.
See also
getJsonAsObject
def jsonBytesOrNull(columnName: String): Array[Byte]

Read the Array[Byte] value of MySQL json column or null if the SQL value is NULL.
Read the Array[Byte] value of MySQL json column or null if the SQL value is NULL.
columnName
the case sensitive name of the column.

Exceptions thrown
ColumnNotFoundException if the column is not found in the row.
UnsupportedTypeException if the MySQL column is not MySQL json type.
See also
jsonAsObjectOrNull
def longOrZero(columnName: String): Long

Returns a Java primitive long for the given column name, or 0 if the SQL value is NULL.
Returns a Java primitive long for the given column name, or 0 if the SQL value is NULL.
This can be used for MySQL columns that are tiny, short, int24, long, or signed and longlong
columnName
the case sensitive name of the column.

Exceptions thrown
ColumnNotFoundException if the column is not found in the row.
UnsupportedTypeException if the MySQL column is not a supported type.
See also
getLong
final def ne(arg0: AnyRef): Boolean

Definition Classes
AnyRef
final def notify(): Unit

Definition Classes
AnyRef
final def notifyAll(): Unit

Definition Classes
AnyRef
def shortOrZero(columnName: String): Short

Returns a Java primitive short for the given column name, or 0 if the SQL value is NULL.
Returns a Java primitive short for the given column name, or 0 if the SQL value is NULL.
This can be used for MySQL columns that are tiny, or signed and short.
columnName
the case sensitive name of the column.

Exceptions thrown
ColumnNotFoundException if the column is not found in the row.
UnsupportedTypeException if the MySQL column is not a supported type.
See also
getShort
def stringOrNull(columnName: String): String

Returns a Java String for the given column name, or null if the SQL value is NULL.
Returns a Java String for the given column name, or null if the SQL value is NULL.
This can be used for MySQL columns that are varchar, string, or varstring, Also supports tinyblob, blob, and mediumblob if the field's charset is not the binary charset.
columnName
the case sensitive name of the column.

Exceptions thrown
ColumnNotFoundException if the column is not found in the row.
UnsupportedTypeException if the MySQL column is not a supported type.
See also
getString
final def synchronized[T0](arg0: ⇒ T0): T0

Definition Classes
AnyRef
def timestampOrNull(columnName: String, timeZone: TimeZone): Timestamp

Returns a java.sql.Timestamp for the given column name, or null if the SQL value is NULL.
Returns a java.sql.Timestamp for the given column name, or null if the SQL value is NULL.
This can be used for MySQL columns that are timestamp or datetime.
columnName
the case sensitive name of the column.
timeZone
the TimeZone used to parse the data.

Exceptions thrown
ColumnNotFoundException if the column is not found in the row.
UnsupportedTypeException if the MySQL column is not that type.
See also
getTimestamp
def toString(): String

Definition Classes
Row → AnyRef → Any
final def wait(): Unit

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

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

Definition Classes
AnyRef
Annotations
@throws( ... )

Related Doc: package mysql

trait Row extends AnyRef

Abstract Value Members

abstract val fields: IndexedSeq[Field]

abstract def indexOf(columnName: String): Option[Int]

abstract val values: IndexedSeq[Value]

Concrete Value Members

final def !=(arg0: Any): Boolean

final def ##(): Int

final def ==(arg0: Any): Boolean

def apply(columnIndex: Option[Int]): Option[Value]

def apply(columnName: String): Option[Value]

final def asInstanceOf[T0]: T0

def bigDecimalOrNull(columnName: String): BigDecimal

def bigIntOrNull(columnName: String): BigInt

def booleanOrFalse(columnName: String): Boolean

def byteOrZero(columnName: String): Byte

def bytesOrNull(columnName: String): Array[Byte]

def clone(): AnyRef

def doubleOrZero(columnName: String): Double

final def eq(arg0: AnyRef): Boolean

def equals(arg0: Any): Boolean

def finalize(): Unit

def floatOrZero(columnName: String): Float

def getBigDecimal(columnName: String): Option[BigDecimal]

def getBigInt(columnName: String): Option[BigInt]

def getBoolean(columnName: String): Option[Boolean]

def getByte(columnName: String): Option[Byte]

def getBytes(columnName: String): Option[Array[Byte]]

final def getClass(): Class[_]

def getDouble(columnName: String): Option[Double]

def getFloat(columnName: String): Option[Float]

def getInteger(columnName: String): Option[Integer]

def getJavaSqlDate(columnName: String): Option[Date]

def getJsonAsObject[T](columnName: String, objMapper: Serializer)(implicit m: Manifest[T]): Option[T]

def getLong(columnName: String): Option[Long]

def getShort(columnName: String): Option[Short]

def getString(columnName: String): Option[String]

def getTimestamp(columnName: String, timeZone: TimeZone): Option[Timestamp]

def hashCode(): Int

def indexOfOrSentinel(columnName: String): Int

def intOrZero(columnName: String): Int

final def isInstanceOf[T0]: Boolean

def javaSqlDateOrNull(columnName: String): Date

def jsonAsObjectOrNull[T >: Null](columnName: String, objMapper: Serializer)(implicit m: Manifest[T]): T

def jsonBytesOrNull(columnName: String): Array[Byte]

def longOrZero(columnName: String): Long

final def ne(arg0: AnyRef): Boolean

final def notify(): Unit

final def notifyAll(): Unit

def shortOrZero(columnName: String): Short

def stringOrNull(columnName: String): String

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

def timestampOrNull(columnName: String, timeZone: TimeZone): Timestamp

def toString(): String

final def wait(): Unit

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

final def wait(arg0: Long): Unit

Inherited from AnyRef

Inherited from Any

Ungrouped