DatabaseStratum / py-stratum-mysql

        return ret

    # ------------------------------------------------------------------------------------------------------------------

    def execute_sp_singleton1(self, sql: str, *params) -> Any:

        """

        Executes a stored routine with designation type "table", i.e a stored routine that is expected to select 1 row

        with 1 column.

        :param str sql: The SQL calling the the stored procedure.

        :param iterable params: The arguments for the stored procedure.

        :rtype: * The value of the selected column.

        """

        self._last_sql = sql

        cursor = MySQLCursorBuffered(self._connection)

        itr = cursor.execute(sql, params, multi=True)

        result = itr.__next__()

        rowcount = result.rowcount

        if rowcount == 1:

            ret = result.fetchone()[0]

        else:

            ret = None  # Keep our IDE happy.

        itr.__next__()

        cursor.close()

        if rowcount != 1:

            raise ResultException('1', rowcount, sql)

        return ret

    # ------------------------------------------------------------------------------------------------------------------

    def last_sql(self) -> str:

        return ret

    # ------------------------------------------------------------------------------------------------------------------

    def execute_sp_singleton0(self, sql: str, *params) -> Any:

        """

        Executes a stored procedure that selects 0 or 1 row with 1 column. Returns the value of selected column or None.

        :param str sql: The SQL calling the stored procedure.

        :param iterable params: The arguments for the stored procedure.

        :rtype: *

        """

        self._last_sql = sql

        cursor = MySQLCursorBuffered(self._connection)

        itr = cursor.execute(sql, params, multi=True)

        result = itr.__next__()

        rowcount = result.rowcount

        if rowcount == 1:

            ret = result.fetchone()[0]

        else:

            ret = None

        itr.__next__()

        cursor.close()

        if not (rowcount == 0 or rowcount == 1):

            raise ResultException('0 or 1', rowcount, sql)

        return ret

    # ------------------------------------------------------------------------------------------------------------------

    def execute_sp_singleton1(self, sql: str, *params) -> Any: