Represents the results of a SQL query.

It contains a list for the column names of the results, and a list of JsonArray - one for each row of the results.

  • ResultSet
    • BaseDataObject
    • Basic
      • Identifiable
      • Object
        • Anything

no subtypes hierarchy

Initializer
ResultSet({String*}? columnNames = null, Integer? numColumns = null, Integer? numRows = null, JsonArray? output = null, {JsonArray*}? results = null, {JsonObject*}? rows = null)
Parameters:
  • columnNames = null

    Get the column names

  • numColumns = null

    Return the number of columns in the result set

  • numRows = null

    Return the number of rows in the result set

  • output = null

    Get the registered outputs

  • results = null

    Get the results

  • rows = null

    Get the rows - each row represented as a JsonObject where the keys are the column names and the values are the column values.

    Beware that it's legal for a query result in SQL to contain duplicate column names, in which case one will overwrite the other if using this method. If that's the case use getResults instead.

Attributes
columnNamesshared {String*}? columnNames

Get the column names

numColumnsshared Integer? numColumns

Return the number of columns in the result set

numRowsshared Integer? numRows

Return the number of rows in the result set

outputshared JsonArray? output

Get the registered outputs

resultsshared {JsonArray*}? results

Get the results

rowsshared {JsonObject*}? rows

Get the rows - each row represented as a JsonObject where the keys are the column names and the values are the column values.

Beware that it's legal for a query result in SQL to contain duplicate column names, in which case one will overwrite the other if using this method. If that's the case use getResults instead.

Inherited Attributes
Attributes inherited from: Object
hash, string
Methods
toJsonshared actual default JsonObject toJson()
Refines BaseDataObject.toJson
Inherited Methods
Methods inherited from: Object
equals
Methods inherited from: BaseDataObject
toJson