Result class abstract final Query

A single row in a ResultSet.

The name of a column is determined by the first applicable rule of the following rules:

  1. The alias name of an aliased column.
  2. The last component of a property expression. Functions for example, are not property expressions.
  3. A generated key of the format $1, $2, $3, ... The number after $ corresponds to the position of the column among the rest of the unnamed columns and starts at 1.
Implemented types

Properties

first → String
The first element.
no setterinherited
hashCode → int
The hash code for this object.
no setterinherited
isEmpty → bool
Whether this collection has no elements.
no setterinherited
isNotEmpty → bool
Whether this collection has at least one element.
no setterinherited
iterator → Iterator<String>
A new Iterator that allows iterating the elements of this Iterable.
no setterinherited
keys → List<String>
The names of the columns in this result.
no setteroverride
last → String
The last element.
no setterinherited
length → int
The number of column in this result.
no setteroverride
runtimeType → Type
A representation of the runtime type of the object.
no setterinherited
single → String
Checks that this iterable has only one element, and returns that element.
no setterinherited

Methods

any(bool test(String element)) → bool
Checks whether any element of this iterable satisfies test.
inherited
array(Object nameOrIndex) → Array?
Returns the column at the given nameOrIndex as an Array.
override
blob(Object nameOrIndex) → Blob?
Returns the column at the given nameOrIndex as a Blob.
override
boolean(Object nameOrIndex) → bool
Returns the column at the given nameOrIndex as a bool.
override
cast<R>() → Iterable<R>
A view of this iterable as an iterable of R instances.
inherited
contains(Object? nameOrIndex) → bool
Returns whether a column with the given nameOrIndex exists in this result.
override
date(Object nameOrIndex) → DateTime?
Returns the column at the given nameOrIndex as a DateTime.
override
dictionary(Object nameOrIndex) → Dictionary?
Returns the column at the given nameOrIndex as a Dictionary.
override
elementAt(int index) → String
Returns the indexth element.
inherited
every(bool test(String element)) → bool
Checks whether every element of this iterable satisfies test.
inherited
expand<T>(Iterable<T> toElements(String element)) → Iterable<T>
Expands each element of this Iterable into zero or more elements.
inherited
firstWhere(bool test(String element), {String orElse()?}) → String
The first element that satisfies the given predicate test.
inherited
float(Object nameOrIndex) → double
Returns the column at the given nameOrIndex as an floating point number.
override
fold<T>(T initialValue, T combine(T previousValue, String element)) → T
Reduces a collection to a single value by iteratively combining each element of the collection with an existing value
inherited
followedBy(Iterable<String> other) → Iterable<String>
Creates the lazy concatenation of this iterable and other.
inherited
forEach(void action(String element)) → void
Invokes action on each element of this iterable in iteration order.
inherited
integer(Object nameOrIndex) → int
Returns the column at the given nameOrIndex as an integer number.
override
join([String separator = ""]) → String
Converts each element to a String and concatenates the strings.
inherited
lastWhere(bool test(String element), {String orElse()?}) → String
The last element that satisfies the given predicate test.
inherited
map<T>(T toElement(String e)) → Iterable<T>
The current elements of this iterable modified by toElement.
inherited
noSuchMethod(Invocation invocation) → dynamic
Invoked when a nonexistent method or property is accessed.
inherited
number(Object nameOrIndex) → num?
Returns the column at the given nameOrIndex as a num.
override
reduce(String combine(String value, String element)) → String
Reduces a collection to a single value by iteratively combining elements of the collection using the provided function.
inherited
singleWhere(bool test(String element), {String orElse()?}) → String
The single element that satisfies test.
inherited
skip(int count) → Iterable<String>
Creates an Iterable that provides all but the first count elements.
inherited
skipWhile(bool test(String value)) → Iterable<String>
Creates an Iterable that skips leading elements while test is satisfied.
inherited
string(Object nameOrIndex) → String?
Returns the column at the given nameOrIndex as a String.
override
take(int count) → Iterable<String>
Creates a lazy iterable of the count first elements of this iterable.
inherited
takeWhile(bool test(String value)) → Iterable<String>
Creates a lazy iterable of the leading elements satisfying test.
inherited
toJson() → String
Returns a JSON string which contains a dictionary of the named columns of this result.
toList({bool growable = true}) → List<String>
Creates a List containing the elements of this Iterable.
inherited
toPlainList() → List<Object?>
Deeply converts this array into a representation of plain Dart objects and returns it.
inherited
toPlainMap() → Map<String, Object?>
Deeply converts this dictionary into a representation of plain Dart objects and returns it.
inherited
toSet() → Set<String>
Creates a Set containing the same elements as this iterable.
inherited
toString() → String
A string representation of this object.
inherited
value<T extends Object>(Object nameOrIndex) → T?
Returns the column at the given nameOrIndex.
override
where(bool test(String element)) → Iterable<String>
Creates a new lazy Iterable with all elements that satisfy the predicate test.
inherited
whereType<T>() → Iterable<T>
Creates a new lazy Iterable with all elements that have type T.
inherited

Operators

operator ==(Object other) → bool
The equality operator.
inherited
operator [](Object nameOrIndex) → Fragment
Returns a Fragment for the column at the given nameOrIndex.
override