DatabaseStratum / py-stratum-mysql

        return ret

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

    def execute_sp_row1(self, sql: str, *params) -> Dict[str, Any]:

        """

        Executes a stored procedure that selects 1 row. Returns the selected row.

        :param sql: The SQL code to execute the stored procedure.

        :param params: The arguments for the stored procedure.

        """

        self._last_sql = sql

        cursor = MySQLCursorBufferedDict(self._connection)

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

        result = itr.__next__()

        rowcount = result.rowcount

        if rowcount == 1:

            ret = result.fetchone()

        else:

            ret = None  # Keep our IDE happy.

        itr.__next__()

        cursor.close()

        if rowcount != 1:

            raise ResultException('1', rowcount, sql)

        return ret

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

    def execute_sp_rows(self, sql: str, *params) -> List[Dict[str, Any]]:

        """

        Executes a stored procedure that selects 0 or more rows. Returns the selected rows (an empty list if no rows

        return rowcount

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

    def execute_sp_row0(self, sql: str, *params) -> Optional[Dict[str, Any]]:

        """

        Executes a stored procedure that selects 0 or 1 row. Returns the selected row or None.

        :param sql: The SQL code to execute the stored procedure.

        :param params: The arguments for the stored procedure.

        """

        self._last_sql = sql

        cursor = MySQLCursorBufferedDict(self._connection)

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

        result = itr.__next__()

        rowcount = result.rowcount

        if rowcount == 1:

            ret = result.fetchone()

        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_row1(self, sql: str, *params) -> Dict[str, Any]:

        """

        Executes a stored procedure that selects 1 row. Returns the selected row.