Method fetchmany

lib/sqlalchemy/engine/result.py:947–968

Fetch many rows. When all rows are exhausted, returns an empty sequence. This method is provided for backwards compatibility with SQLAlchemy 1.x.x. To fetch rows in groups, use the :meth:`_engine.Result.partitions` method. :return: a sequence of :c

(
        self, size: Optional[int] = None
    )

            return row

    def fetchmany(
        self, size: Optional[int] = None
    ) -> Sequence[Row[Unpack[_Ts]]]:
        """Fetch many rows.

        When all rows are exhausted, returns an empty sequence.

        This method is provided for backwards compatibility with
        SQLAlchemy 1.x.x.

        To fetch rows in groups, use the :meth:`_engine.Result.partitions`
        method.

        :return: a sequence of :class:`_engine.Row` objects.

        .. seealso::

            :meth:`_engine.Result.partitions`

        """

        return self._manyrow_getter(self, size)

    def all(self) -> Sequence[Row[Unpack[_Ts]]]:
        """Return all rows in a sequence.