Row (Vert.x Stack - Docs 4.1.8 API)

All Superinterfaces:

Tuple
```
public interface Row
extends Tuple
```
A single row of the execution result rowset.

Field Summary
- Fields inherited from interface io.vertx.sqlclient.Tuple
  JSON_NULL

Method Summary

All Methods Instance Methods Abstract Methods Default Methods
Modifier and Type	Method and Description
`default <T> T`	`get(Class<T> type, String column)` Like `Tuple.get(Class, int)` but specifying the `column` instead of the position.
`default BigDecimal[]`	`getArrayOfBigDecimals(String column)` Get an array of `BigDecimal` value for the given `column`.
`default Boolean[]`	`getArrayOfBooleans(String column)` Get an array of `Boolean` value for the given `column`.
`default Buffer[]`	`getArrayOfBuffers(String column)` Get an array of `Buffer` value for the given `column`.
`default Double[]`	`getArrayOfDoubles(String column)` Get an array of `Double` value for the given `column`.
`default Float[]`	`getArrayOfFloats(String column)` Get an array of `Float` value for the given `column`.
`default Integer[]`	`getArrayOfIntegers(String column)` Get an array of `Integer` value for the given `column`.
`default JsonArray[]`	`getArrayOfJsonArrays(String column)` Get an array of `JsonArray` value for the given `column`.
`default JsonObject[]`	`getArrayOfJsonObjects(String column)` Get an array of `JsonObject` value for the given `column`.
`default Object[]`	`getArrayOfJsons(String column)` Get an array of JSON elements for the given `column`, the element might be `null` or one of the following types: String Number JsonObject JsonArray Boolean
`default java.time.LocalDate[]`	`getArrayOfLocalDates(String column)` Get an array of `LocalDate` value for the given `column`.
`default java.time.LocalDateTime[]`	`getArrayOfLocalDateTimes(String column)` Get an array of `LocalDateTime` value for the given `column`.
`default java.time.LocalTime[]`	`getArrayOfLocalTimes(String column)` Get an array of `LocalTime` value for the given `column`.
`default Long[]`	`getArrayOfLongs(String column)` Get an array of `Long` value for the given `column`.
`default Numeric[]`	`getArrayOfNumerics(String column)` Get an array of `Numeric` value for the given `column`.
`default java.time.OffsetDateTime[]`	`getArrayOfOffsetDateTimes(String column)` Get an array of `OffsetDateTime` value for the given `column`.
`default java.time.OffsetTime[]`	`getArrayOfOffsetTimes(String column)` Get an array of `OffsetTime` value for the given `column`.
`default Short[]`	`getArrayOfShorts(String column)` Get an array of `Short` value for the given `column`.
`default String[]`	`getArrayOfStrings(String column)` Get an array of `String` value for the given `column`.
`default java.time.temporal.Temporal[]`	`getArrayOfTemporals(String column)` Get an array of `Temporal` value for the given `column`.
`default UUID[]`	`getArrayOfUUIDs(String column)` Get an array of `UUID` value for the given `column`.
`default BigDecimal`	`getBigDecimal(String column)` Get `BigDecimal` value for the given `column`.
`default Boolean`	`getBoolean(String column)` Get a boolean value for the given `column`.
`default Buffer`	`getBuffer(String column)` Get a buffer value for the given `column`.
`int`	`getColumnIndex(String column)` Get a column position for the given @code column}.
`String`	`getColumnName(int pos)` Get a column name at `pos`.
`default Double`	`getDouble(String column)` Get a double value for the given `column`.
`default Float`	`getFloat(String column)` Get a float value for the given `column`.
`default Integer`	`getInteger(String column)` Get an integer value for the given `column`.
`default Object`	`getJson(String column)` Get a JSON element for the given `column`, the element might be `null` or one of the following types: String Number JsonObject JsonArray Boolean
`default JsonArray`	`getJsonArray(String column)` Get a `JsonArray` value for the given `column`.
`default JsonObject`	`getJsonObject(String column)` Get a `JsonObject` value for the given `column`.
`default java.time.LocalDate`	`getLocalDate(String column)` Get `LocalDate` value for the given `column`.
`default java.time.LocalDateTime`	`getLocalDateTime(String column)` Get `LocalDateTime` value for the given `column`.
`default java.time.LocalTime`	`getLocalTime(String column)` Get `LocalTime` value for the given `column`.
`default Long`	`getLong(String column)` Get a long value for the given `column`.
`default Numeric`	`getNumeric(String column)` Get `Numeric` value for the given `column`.
`default java.time.OffsetDateTime`	`getOffsetDateTime(String column)` Get `OffsetDateTime` value for the given `column`.
`default java.time.OffsetTime`	`getOffsetTime(String column)` Get `OffsetTime` value for the given `column`.
`default Short`	`getShort(String column)` Get a short value for the given `column`.
`default String`	`getString(String column)` Get a string value for the given `column`.
`default java.time.temporal.Temporal`	`getTemporal(String column)` Get a temporal value for the given `column`.
`default UUID`	`getUUID(String column)` Get `UUID` value for the given `column`.
`default Object`	`getValue(String column)` Get a value for the given `column`.
`default JsonObject`	`toJson()` Return a JSON object representation of the row.

Methods inherited from interface io.vertx.sqlclient.Tuple
addArrayOfBigDecimal, addArrayOfBoolean, addArrayOfBuffer, addArrayOfDouble, addArrayOfFloat, addArrayOfInteger, addArrayOfJsonArray, addArrayOfJsonObject, addArrayOfLocalDate, addArrayOfLocalDateTime, addArrayOfLocalTime, addArrayOfLong, addArrayOfOffsetDateTime, addArrayOfOffsetTime, addArrayOfShort, addArrayOfString, addArrayOfTemporal, addArrayOfUUID, addBigDecimal, addBoolean, addBuffer, addDouble, addFloat, addInteger, addJsonArray, addJsonObject, addLocalDate, addLocalDateTime, addLocalTime, addLong, addOffsetDateTime, addOffsetTime, addShort, addString, addTemporal, addUUID, addValue, clear, deepToString, from, from, get, getArrayOfBigDecimals, getArrayOfBooleans, getArrayOfBuffers, getArrayOfDoubles, getArrayOfFloats, getArrayOfIntegers, getArrayOfJsonArrays, getArrayOfJsonObjects, getArrayOfJsons, getArrayOfLocalDates, getArrayOfLocalDateTimes, getArrayOfLocalTimes, getArrayOfLongs, getArrayOfNumerics, getArrayOfOffsetDateTimes, getArrayOfOffsetTimes, getArrayOfShorts, getArrayOfStrings, getArrayOfTemporals, getArrayOfUUIDs, getBigDecimal, getBoolean, getBuffer, getDouble, getFloat, getInteger, getJson, getJsonArray, getJsonObject, getLocalDate, getLocalDateTime, getLocalTime, getLong, getNumeric, getOffsetDateTime, getOffsetTime, getShort, getString, getTemporal, getUUID, getValue, of, of, of, of, of, of, of, size, tuple, tuple, types, wrap, wrap

- Method Detail
  - getColumnName
```
String getColumnName(int pos)
```
    Get a column name at pos.
    
    Parameters:
    
    pos - the column position
    
    Returns:
    
    the column name or null
  - getColumnIndex
```
int getColumnIndex(String column)
```
    Get a column position for the given @code column}.
    
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column name or -1 if not found
  - getValue
```
default Object getValue(String column)
```
    Get a value for the given column.
    
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getBoolean
```
default Boolean getBoolean(String column)
```
    Get a boolean value for the given column.
    
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getShort
```
default Short getShort(String column)
```
    Get a short value for the given column.
    
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getInteger
```
default Integer getInteger(String column)
```
    Get an integer value for the given column.
    
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getLong
```
default Long getLong(String column)
```
    Get a long value for the given column.
    
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getFloat
```
default Float getFloat(String column)
```
    Get a float value for the given column.
    
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getDouble
```
default Double getDouble(String column)
```
    Get a double value for the given column.
    
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getNumeric
```
default Numeric getNumeric(String column)
```
    Get Numeric value for the given column.
    
    Parameters:
    
    column - the column
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getString
```
default String getString(String column)
```
    Get a string value for the given column.
    
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getJson
```
default Object getJson(String column)
```
    Get a JSON element for the given column, the element might be null or one of the following types:
    - String
    - Number
    - JsonObject
    - JsonArray
    - Boolean
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getJsonObject
```
default JsonObject getJsonObject(String column)
```
    Get a JsonObject value for the given column.
    
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getJsonArray
```
default JsonArray getJsonArray(String column)
```
    Get a JsonArray value for the given column.
    
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getTemporal
```
default java.time.temporal.Temporal getTemporal(String column)
```
    Get a temporal value for the given column.
    
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getLocalDate
```
default java.time.LocalDate getLocalDate(String column)
```
    Get LocalDate value for the given column.
    
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getLocalTime
```
default java.time.LocalTime getLocalTime(String column)
```
    Get LocalTime value for the given column.
    
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getLocalDateTime
```
default java.time.LocalDateTime getLocalDateTime(String column)
```
    Get LocalDateTime value for the given column.
    
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getOffsetTime
```
default java.time.OffsetTime getOffsetTime(String column)
```
    Get OffsetTime value for the given column.
    
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getOffsetDateTime
```
default java.time.OffsetDateTime getOffsetDateTime(String column)
```
    Get OffsetDateTime value for the given column.
    
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getBuffer
```
default Buffer getBuffer(String column)
```
    Get a buffer value for the given column.
    
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getUUID
```
default UUID getUUID(String column)
```
    Get UUID value for the given column.
    
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getBigDecimal
```
default BigDecimal getBigDecimal(String column)
```
    Get BigDecimal value for the given column.
    
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getArrayOfBooleans
```
default Boolean[] getArrayOfBooleans(String column)
```
    Get an array of Boolean value for the given column.
    
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getArrayOfShorts
```
default Short[] getArrayOfShorts(String column)
```
    Get an array of Short value for the given column.
    
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getArrayOfIntegers
```
default Integer[] getArrayOfIntegers(String column)
```
    Get an array of Integer value for the given column.
    
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getArrayOfLongs
```
default Long[] getArrayOfLongs(String column)
```
    Get an array of Long value for the given column.
    
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getArrayOfFloats
```
default Float[] getArrayOfFloats(String column)
```
    Get an array of Float value for the given column.
    
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getArrayOfDoubles
```
default Double[] getArrayOfDoubles(String column)
```
    Get an array of Double value for the given column.
    
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getArrayOfNumerics
```
default Numeric[] getArrayOfNumerics(String column)
```
    Get an array of Numeric value for the given column.
    
    Parameters:
    
    column - the column
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getArrayOfStrings
```
default String[] getArrayOfStrings(String column)
```
    Get an array of String value for the given column.
    
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getArrayOfJsonObjects
```
default JsonObject[] getArrayOfJsonObjects(String column)
```
    Get an array of JsonObject value for the given column.
    
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getArrayOfJsonArrays
```
default JsonArray[] getArrayOfJsonArrays(String column)
```
    Get an array of JsonArray value for the given column.
    
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getArrayOfTemporals
```
default java.time.temporal.Temporal[] getArrayOfTemporals(String column)
```
    Get an array of Temporal value for the given column.
    
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getArrayOfLocalDates
```
default java.time.LocalDate[] getArrayOfLocalDates(String column)
```
    Get an array of LocalDate value for the given column.
    
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getArrayOfLocalTimes
```
default java.time.LocalTime[] getArrayOfLocalTimes(String column)
```
    Get an array of LocalTime value for the given column.
    
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getArrayOfLocalDateTimes
```
default java.time.LocalDateTime[] getArrayOfLocalDateTimes(String column)
```
    Get an array of LocalDateTime value for the given column.
    
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getArrayOfOffsetTimes
```
default java.time.OffsetTime[] getArrayOfOffsetTimes(String column)
```
    Get an array of OffsetTime value for the given column.
    
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getArrayOfOffsetDateTimes
```
default java.time.OffsetDateTime[] getArrayOfOffsetDateTimes(String column)
```
    Get an array of OffsetDateTime value for the given column.
    
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getArrayOfBuffers
```
default Buffer[] getArrayOfBuffers(String column)
```
    Get an array of Buffer value for the given column.
    
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getArrayOfUUIDs
```
default UUID[] getArrayOfUUIDs(String column)
```
    Get an array of UUID value for the given column.
    
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getArrayOfBigDecimals
```
default BigDecimal[] getArrayOfBigDecimals(String column)
```
    Get an array of BigDecimal value for the given column.
    
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - getArrayOfJsons
```
default Object[] getArrayOfJsons(String column)
```
    Get an array of JSON elements for the given column, the element might be null or one of the following types:
    - String
    - Number
    - JsonObject
    - JsonArray
    - Boolean
    Parameters:
    
    column - the column name
    
    Returns:
    
    the column value
    
    Throws:
    
    NoSuchElementException - when the column does not exist
  - get
```
default <T> T get(Class<T> type,
                  String column)
```
    Like Tuple.get(Class, int) but specifying the column instead of the position.
  - toJson
```
default JsonObject toJson()
```
    Return a JSON object representation of the row.
    Column names are mapped to JSON keys.
    The following rules are applied for the column values:
    - number, boolean and string are preserved
    - the null value is preserved
    - JSON elements are preserved
    - Buffer are converted to base64 encoded strings
    - array is mapped JsonArray
    - otherwise the type converted to a string
    Returns:
    
    the json representation

Interface Row

Field Summary

Fields inherited from interface io.vertx.sqlclient.Tuple

Method Summary

Methods inherited from interface io.vertx.sqlclient.Tuple

Method Detail

getColumnName

getColumnIndex

getValue

getBoolean

getShort

getInteger

getLong

getFloat

getDouble

getNumeric

getString

getJson

getJsonObject

getJsonArray

getTemporal

getLocalDate

getLocalTime

getLocalDateTime

getOffsetTime

getOffsetDateTime

getBuffer

getUUID

getBigDecimal

getArrayOfBooleans

getArrayOfShorts

getArrayOfIntegers

getArrayOfLongs

getArrayOfFloats

getArrayOfDoubles

getArrayOfNumerics

getArrayOfStrings

getArrayOfJsonObjects

getArrayOfJsonArrays

getArrayOfTemporals

getArrayOfLocalDates

getArrayOfLocalTimes

getArrayOfLocalDateTimes

getArrayOfOffsetTimes

getArrayOfOffsetDateTimes

getArrayOfBuffers

getArrayOfUUIDs

getArrayOfBigDecimals

getArrayOfJsons

get

toJson