sqlalchemy.engine.result.MappingResult

class documentation

class MappingResult(_WithKeys, FilterResult[RowMapping]): (source)

A wrapper for a :class:`_engine.Result` that returns dictionary values rather than :class:`_engine.Row` values. The :class:`_engine.MappingResult` object is acquired by calling the :meth:`_engine.Result.mappings` method.

Method	`__init__`	Undocumented
Method	`__iter__`	Undocumented
Method	`__next__`	Undocumented
Method	`all`	Return all scalar values in a list.
Method	`columns`	Establish the columns that should be returned in each row.
Method	`fetchall`	A synonym for the :meth:`_engine.MappingResult.all` method.
Method	`fetchmany`	Fetch many objects.
Method	`fetchone`	Fetch one object.
Method	`first`	Fetch the first object or ``None`` if no object is present.
Method	`one`	Return exactly one object or raise an exception.
Method	`one_or_none`	Return at most one object or raise an exception.
Method	`partitions`	Iterate through sub-lists of elements of the size given.
Method	`unique`	Apply unique filtering to the objects returned by this :class:`_engine.MappingResult`.
Class Variable	`__slots__`	Undocumented
Class Variable	`_generate_rows`	Undocumented
Class Variable	`_post_creational_filter`	Undocumented
Instance Variable	`_metadata`	Undocumented
Instance Variable	`_real_result`	Undocumented
Instance Variable	`_unique_filter_state`	Undocumented

Inherited from _WithKeys:

Method keys Return an iterable view which yields the string keys that would be represented by each :class:`_engine.Row`.

Inherited from FilterResult (via _WithKeys):

Method	`__enter__`	Undocumented
Method	`__exit__`	Undocumented
Method	`close`	Close this :class:`_engine.FilterResult`.
Method	`yield_per`	Configure the row-fetching strategy to fetch ``num`` rows at a time.
Property	`closed`	Return ``True`` if the underlying :class:`_engine.Result` reports closed
Method	`_fetchall_impl`	Undocumented
Method	`_fetchiter_impl`	Undocumented
Method	`_fetchmany_impl`	Undocumented
Method	`_fetchone_impl`	Undocumented
Method	`_soft_close`	Undocumented
Property	`_attributes`	Undocumented
Property	`_soft_closed`	Undocumented

Inherited from ResultInternal (via _WithKeys, FilterResult):

Method	`_allrows`	Undocumented
Method	`_column_slices`	Undocumented
Method	`_iter_impl`	Undocumented
Method	`_iterator_getter`	Undocumented
Method	`_manyrow_getter`	Undocumented
Method	`_next_impl`	Undocumented
Method	`_onerow_getter`	Undocumented
Method	`_only_one_row`	Undocumented
Method	`_raw_all_rows`	Undocumented
Method	`_row_getter`	Undocumented
Method	`_unique_strategy`	Undocumented
Class Variable	`_is_cursor`	Undocumented
Class Variable	`_row_logging_fn`	Undocumented
Class Variable	`_source_supports_scalars`	Undocumented

Inherited from InPlaceGenerative (via _WithKeys, FilterResult, ResultInternal):

Method _generate Undocumented

def __init__(self, result: Result[Any]): (source) ¶

Undocumented

def __iter__(self) -> Iterator[RowMapping]: (source) ¶

Undocumented

def __next__(self) -> RowMapping: (source) ¶

Undocumented

def all(self) -> Sequence[RowMapping]: (source) ¶

Return all scalar values in a list. Equivalent to :meth:`_engine.Result.all` except that :class:`_engine.RowMapping` values, rather than :class:`_engine.Row` objects, are returned.

def columns(self, *col_expressions: _KeyIndexType) -> Self: (source) ¶

Establish the columns that should be returned in each row.

def fetchall(self) -> Sequence[RowMapping]: (source) ¶

A synonym for the :meth:`_engine.MappingResult.all` method.

def fetchmany(self, size: Optional[int] = None) -> Sequence[RowMapping]: (source) ¶

Fetch many objects. Equivalent to :meth:`_engine.Result.fetchmany` except that :class:`_engine.RowMapping` values, rather than :class:`_engine.Row` objects, are returned.

def fetchone(self) -> Optional[RowMapping]: (source) ¶

Fetch one object. Equivalent to :meth:`_engine.Result.fetchone` except that :class:`_engine.RowMapping` values, rather than :class:`_engine.Row` objects, are returned.

def first(self) -> Optional[RowMapping]: (source) ¶

Fetch the first object or ``None`` if no object is present. Equivalent to :meth:`_engine.Result.first` except that :class:`_engine.RowMapping` values, rather than :class:`_engine.Row` objects, are returned.

def one(self) -> RowMapping: (source) ¶

Return exactly one object or raise an exception. Equivalent to :meth:`_engine.Result.one` except that :class:`_engine.RowMapping` values, rather than :class:`_engine.Row` objects, are returned.

def one_or_none(self) -> Optional[RowMapping]: (source) ¶

Return at most one object or raise an exception. Equivalent to :meth:`_engine.Result.one_or_none` except that :class:`_engine.RowMapping` values, rather than :class:`_engine.Row` objects, are returned.

def partitions(self, size: Optional[int] = None) -> Iterator[Sequence[RowMapping]]: (source) ¶

Iterate through sub-lists of elements of the size given. Equivalent to :meth:`_engine.Result.partitions` except that :class:`_engine.RowMapping` values, rather than :class:`_engine.Row` objects, are returned.