Method executemany

asyncpg/prepared_stmt.py:236–252

Execute the statement for each sequence of arguments in *args*. :param args: An iterable containing sequences of arguments. :param float timeout: Optional timeout value in seconds. :return None: This method discards the results of the operations. .. versionadded:: 0

(self, args, *, timeout: typing.Optional[float]=None)

    @connresource.guarded
    async def executemany(self, args, *, timeout: typing.Optional[float]=None):
        """Execute the statement for each sequence of arguments in *args*.

        :param args: An iterable containing sequences of arguments.
        :param float timeout: Optional timeout value in seconds.
        :return None: This method discards the results of the operations.

        .. versionadded:: 0.22.0
        """
        return await self.__do_execute(
            lambda protocol: protocol.bind_execute_many(
                self._state,
                args,
                portal_name='',
                timeout=timeout,
                return_rows=False,
            ))

    async def __do_execute(self, executor):
        protocol = self._connection._protocol