MySQL Shell API 9.0.0
Unified development interface for MySQL Products
|
Allows traversing the Row objects returned by a Table.select operation. More...
Methods | |
Row | fetch_one () |
Retrieves the next Row on the RowResult. More... | |
dict | fetch_one_object () |
Retrieves the next Row on the result and returns it as an object. More... | |
list | fetch_all () |
Returns a list of DbDoc objects which contains an element for every unread document. More... | |
int | get_column_count () |
Retrieves the number of columns on the current result. More... | |
list | get_column_names () |
Gets the columns on the current result. More... | |
list | get_columns () |
Gets the column metadata for the columns on the active result. More... | |
Methods inherited from BaseResult | |
int | get_affected_items_count () |
The the number of affected items for the last operation. More... | |
int | get_warnings_count () |
The number of warnings produced by the last statement execution. More... | |
list | get_warnings () |
Retrieves the warnings generated by the executed operation. More... | |
str | get_execution_time () |
Retrieves a string value indicating the execution time of the executed operation. | |
Properties | |
int | column_count |
Same as get_column_count() | |
list | column_names |
Same as get_column_names() | |
list | columns |
Same as get_columns() | |
Properties inherited from BaseResult | |
int | affected_items_count |
Same as get_affected_items_count() | |
int | warnings_count |
Same as get_warnings_count() | |
list | warnings |
Same as get_warnings() | |
str | execution_time |
Same as get_execution_time() | |
Allows traversing the Row objects returned by a Table.select operation.
Row fetch_one | ( | ) |
dict fetch_one_object | ( | ) |
Retrieves the next Row on the result and returns it as an object.
The column names will be used as keys in the returned dictionary and the column data will be used as the key values.
If a column is a valid identifier it will be accessible as an object attribute as <dict>.<column>.
If a column is not a valid identifier, it will be accessible as a dictionary key as <dict>[<column>].
list fetch_all | ( | ) |
Returns a list of DbDoc objects which contains an element for every unread document.
int get_column_count | ( | ) |
Retrieves the number of columns on the current result.
list get_column_names | ( | ) |
Gets the columns on the current result.
list get_columns | ( | ) |
Gets the column metadata for the columns on the active result.