Method procedures

mycli/sqlexecute.py:473–486

Yields tuples of (procedure_name, ) for *schema*.

(self, schema: str | None = None)

            yield from cur

    def procedures(self, schema: str | None = None) -> Generator[tuple, None, None]:
        """Yields tuples of (procedure_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("Procedures Query. sql: %r schema: %r", self.procedures_query, target)
            try:
                cur.execute(self.procedures_query, (target,))
            except pymysql.DatabaseError as e:
                _logger.error('No procedure completions due to %r', e)
                yield ()
            else:
                yield from cur

    def character_sets(self) -> Generator[tuple, None, None]:
        """Yields tuples of (character_set_name, )"""