DatabaseStratum / py-stratum-pgsql

        return ret

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

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

        """

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

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

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

        :rtype: dict[str,object]

        """

        cursor = self._connection.cursor()

        if params:

            cursor.execute(sql, params)

        else:

            cursor.execute(sql)

        portal = self._connection.cursor(cursor.fetchone()[0])

        rows = portal.fetchall()

        self._get_column_names(portal)

        row_count = len(rows)

        if row_count == 1:

            column_names = self._get_column_names(portal)

            ret = dict(zip(column_names, rows[0]))

        else:

            ret = None  # Keep our IDE happy.

        portal.close()

        cursor.close()

        if row_count != 1:

            raise ResultException('1', row_count, sql)

        return ret

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

    def execute_sp_rows(self, sql: str, *params) -> List:

        cursor.close()

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

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

        """

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

        :param str sql: The SQL statement.

        :param iterable params: The arguments for the statement.

        :rtype: None|dict[str,object]

        """

        cursor = self._connection.cursor()

        if params:

            cursor.execute(sql, params)

        else:

            cursor.execute(sql)

        portal = self._connection.cursor(cursor.fetchone()[0])

        rows = portal.fetchall()

        row_count = len(rows)

        if row_count == 1:

            column_names = self._get_column_names(portal)

            ret = dict(zip(column_names, rows[0]))

        else:

            ret = None

        portal.close()

        cursor.close()

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

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

        return ret

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

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