DatabaseStratum / py-stratum-pgsql

        return ret

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

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

        """

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

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

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

        :rtype: 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:

            ret = rows[0][0]

        else:

            ret = None  # Keep our IDE happy.

        portal.close()

        cursor.close()

        if len(rows) != 1:

            raise ResultException('1', row_count, sql)

        return ret

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

    def execute_sp_table(self, sql: str, *params) -> int:

        return ret

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

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

        """

        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 call the the stored procedure.

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

        :rtype: 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:

            ret = rows[0][0]

        else:

            ret = None  # Keep our IDE happy.

        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_singleton1(self, sql: str, *params) -> object: