Method scalar_one_or_none

lib/sqlalchemy/engine/result.py:1070–1085

Return exactly one scalar result or ``None``. This is equivalent to calling :meth:`_engine.Result.scalars` and then :meth:`_engine.ScalarResult.one_or_none`. .. seealso:: :meth:`_engine.ScalarResult.one_or_none` :meth:`_engine.Result.scalars`

(self: Result[_T, Unpack[TupleAny]])

        )

    def scalar_one_or_none(self: Result[_T, Unpack[TupleAny]]) -> Optional[_T]:
        """Return exactly one scalar result or ``None``.

        This is equivalent to calling :meth:`_engine.Result.scalars` and
        then :meth:`_engine.ScalarResult.one_or_none`.

        .. seealso::

            :meth:`_engine.ScalarResult.one_or_none`

            :meth:`_engine.Result.scalars`

        """
        return self._only_one_row(
            raise_for_second_row=True, raise_for_none=False, scalar=True
        )

    def one(self) -> Row[Unpack[_Ts]]:
        """Return exactly one row or raise an exception.