Method functions

mycli/sqlexecute.py:463–471

Yields tuples of (schema_name, function_name) for *schema*.

(self, schema: str | None = None)

            return [x[0] for x in cur.fetchall()]

    def functions(self, schema: str | None = None) -> Generator[tuple[str, str], None, None]:
        """Yields tuples of (schema_name, function_name) for *schema*."""

        target = schema if schema is not None else self.dbname
        assert isinstance(self.conn, Connection)
        with self.conn.cursor() as cur:
            _logger.debug("Functions Query. sql: %r schema: %r", self.functions_query, target)
            cur.execute(self.functions_query, (target,))
            yield from cur

    def procedures(self, schema: str | None = None) -> Generator[tuple, None, None]:
        """Yields tuples of (procedure_name, ) for *schema*."""