MCPcopy
hub / github.com/sqlalchemy/sqlalchemy / one_or_none

Method one_or_none

lib/sqlalchemy/engine/result.py:1028–1051  ·  view source on GitHub ↗

Return at most one result or raise an exception. Returns ``None`` if the result has no rows. Raises :class:`.MultipleResultsFound` if multiple rows are returned. .. versionadded:: 1.4 :return: The first :class:`_engine.Row` or ``None`` if no row is

(self)

Source from the content-addressed store, hash-verified

1026 )
1027
1028 def one_or_none(self) -> Optional[Row[Unpack[_Ts]]]:
1029 """Return at most one result or raise an exception.
1030
1031 Returns ``None`` if the result has no rows.
1032 Raises :class:`.MultipleResultsFound`
1033 if multiple rows are returned.
1034
1035 .. versionadded:: 1.4
1036
1037 :return: The first :class:`_engine.Row` or ``None`` if no row
1038 is available.
1039
1040 :raises: :class:`.MultipleResultsFound`
1041
1042 .. seealso::
1043
1044 :meth:`_engine.Result.first`
1045
1046 :meth:`_engine.Result.one`
1047
1048 """
1049 return self._only_one_row(
1050 raise_for_second_row=True, raise_for_none=False, scalar=False
1051 )
1052
1053 def scalar_one(self: Result[_T, Unpack[TupleAny]]) -> _T:
1054 """Return exactly one scalar result or raise an exception.

Callers

nothing calls this directly

Calls 1

_only_one_rowMethod · 0.80

Tested by

no test coverage detected